Office 13

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:

Quick Analysis:

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.

Office 13 Excel Quick Analysis

Flash Fill:

This incredible feature will detect patterns based upon what you are doing, and enter the rest of your data for you.

Excel Flash Fill

Chart recommendations:

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.

Excel Recommended Charts

Slicers:

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.

Excel Slicers

Functions:

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.

Excel New Functions

 

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.

How to Lock a Cell in Excel

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:

Step 1

Type a simple formula.

Lock a cell in Excel

 

Step 2

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.

Lock a cell in Excel

Step 3

If a cell is locked, copying or dragging the formula will not move the referenced cell.

Lock a cell in Excel

* You can use the F4 key to expedite this process. Simply click a cell you want locked in the formula bar and press F4:

Once to lock the entire cell,

Twice to lock only the row, or

Three times to lock only the column

 

Want to practice on some excel spreadsheets? 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.

How to Print in Excel

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:

Step 1

Go to File.

Free Excel Templates

Step 2

Select Print

Free Excel Templates

Step 3

Under Settings, Click on No Scaling

How to Print in Excel

Step 4

Change No Scaling to Fit Sheet on One Page

How to Print in Excel

 

Want to practice 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.

How to Insert and Delete Backgrounds in Excel

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:

Step 1:

Click the Background button in Page Setup group under Page Layout tab.

Insert and Delete Backgrounds in Excel

Step 2:

Select the proper image and click the Insert button.

Insert and Delete Backgrounds in Excel

Step 3

The image is then placed as the background

Insert and Delete Backgrounds in Excel

Step 4

To remove a background,click the Delete Background button in Page Setup group under Page Layout tab.

Insert and Delete Backgrounds in Excel

Want to practice 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.