Its Offic(e)ial! Free Excel Spreadsheet has upgraded to the newest version of excel from Office 13. Excel has a fresh new look and features.
Office users that have not upgraded do not fret! We will still provide how to guides tailored for you as well. While we are still getting used to some of the new tools excel offers, check out some of the new features we are looking forward to using:
This tool lets a user convert their data into a chart or table in two steps or less. Preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click.
This incredible feature will detect patterns based upon what you are doing, and enter the rest of your data for you.
Presenting data can be difficult. It is a cinch with the new chart recommendation tool. It will recommend the chart that will best represent what you want to convey.
Introduced in Excel 2010 as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other data tables. Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at.
This new version of excel offers several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories.
Who’s excited about Office 13? We certainly are and you should be to! Excel is the best business tool out there and with our guidance you’ll know all the tricks of the new office in no time.
Want to check out Office 13 on some free excel spreadsheet templates? Check out our Free Excel Templates.
Did you like this post? We would love to hear from you, just head over to our contact page.
Learning how to a lock a cell in excel will make copying formulas much easier. If you don’t lock down or fix your cell reference, the referenced cell will move by exactly the same number of columns and rows from your original cell.
To lock a cell in excel, just follow these simple steps:
Type a simple formula.
To lock a reference to a cell, simply add dollar signs ($) next to the cell reference. Adding one before the letter will lock the column. Adding one before the number will lock the row.
If a cell is locked, copying or dragging the formula will not move the referenced cell.
* You can use the F4 key to expedite this process. Simply click a cell you want locked in the formula bar and press F4:
Printing in excel can often times be frustrating. Hitting Control+P and then Enter sometimes does the trick, but often times you want to print your entire workbook on one page. Our easy to use guide will show you how to print in excel
To print in excel, just follow these simple steps:
In Excel, you can use a picture as a sheet background for display purposes only. A sheet background is not printed and is not retained in an individual worksheet or in an item that you save as a Web page. It is retained only when you publish an entire workbook as a Web page. Check out our easy to use guide to insert and delete backgrounds in Excel.
Here’s how to Insert and Delete Backgrounds in Excel:
Click the Background button in Page Setup group under Page Layout tab.
Select the proper image and click the Insert button.
The image is then placed as the background
To remove a background,click the Delete Background button in Page Setup group under Page Layout tab.