Excel Tips, Tricks and Shortcuts

Microsoft Excel Blog | Avantix Learning

Check out our Excel training courses >

How to Create 3D References in Microsoft Excel

How to Create 3D References in Microsoft Excel

You can use 3D references in Excel formulas to calculate across multiple worksheets that are structured in the same way. A 3D reference refers to the same cell or range of cells on multiple worksheets.

How to Freeze Row and Column Headings in Microsoft Excel

How to Freeze Row and Column Headings in Microsoft Excel

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

How to Enter Data in an Excel Filtered List into Visible Cells [2 Ways]

How to Enter Data in an Excel Filtered List into Visible Cells [2 Ways]

It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …

10 Excel Tips for Working with the Subtotal Feature

10 Excel Tips for Working with the Subtotal Feature

You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …

5 Awesome Excel Chart Shortcuts

5 Awesome Excel Chart Shortcuts

If you create a lot of charts in Excel, you’re probably looking for shortcuts to speed up creation and formatting. Here are 5 useful shortcuts you can use with your Excel charts.

10 More Excel Pivot Table Shortcuts

10 More Excel Pivot Table Shortcuts

Since pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data, we’ve compiled a list of 10 more keyboard shortcuts for pivot table users.

8 Excel Tips for Entering Formulas

8 Excel Tips for Entering Formulas

Check out these 8 Excel tips and tricks for entering formulas. You’ll save a lot of time and even help reduce errors in your formulas.

10 Great Excel Pivot Table Shortcuts

10 Great Excel Pivot Table Shortcuts

Check out these 10 great Excel pivot table keyboard shortcuts. You can use standard shortcuts using the Control key or use Alt to access the Ribbon and create pivot tables in different ways.

10 Ways to Save Time Selecting in Excel using the Name Box

10 Ways to Save Time Selecting in Excel using the Name Box

You can save a lot of time selecting in Microsoft Excel using the Name Box. The Name Box is located to the left of the Formula Bar in Microsoft Excel. You can enter directly in the Name Box to quickly select cells or even objects.

10 Microsoft Excel Magic Tricks with Flash Fill

10 Microsoft Excel Magic Tricks with Flash Fill

Flash Fill is a great new tool that you can use to quickly clean or format data in your Excel workbooks. It can automatically extract, combine and format data without using a formula. It does seem like magic.

How to Access the Free Online Version of Microsoft Excel

How to Access the Free Online Version of Microsoft Excel

Like PowerPoint and Word, you can access a free online version of Microsoft Excel and create simple workbooks online or open workbooks you or a colleague has created in the desktop version of Microsoft Excel in the online version.

How to Watch Cells for Real Time Updates in Microsoft Excel

How to Watch Cells for Real Time Updates in Microsoft Excel

Keep an Eye on Important Changes using Excel's Watch Window Posted by: Avantix Learning Team Posted: March 24, 2016 Applies to: Microsoft® Excel® 2007, 2010, 2013 and 2016 The Watch Window is an awesome tool that you can use in Excel to view changes to cells that are...

Extracting Data with Excel’s Amazing Flash Fill

Extracting Data with Excel’s Amazing Flash Fill

Flash Fill is a tool you can use to automatically fill in values in a column in Microsoft Excel. It is available in Excel 2013 and later versions. Flash Fill is able to extract, format and string together data from another column or columns.

Zoom In and Out in Excel using a Mouse or Keyboard Shortcuts

Zoom In and Out in Excel using a Mouse or Keyboard Shortcuts

Save Time in Microsoft Excel using Zoom Shortcuts by Avantix Learning Team | Updated July 12, 2017 Applies to: Microsoft® Excel® 2010 , 2013 and 2016 (Windows) One common thing that many Excel users want to be able to do quickly is zoom in and out in their Excel...

How to Lock and Protect an Excel Workbook with a Password

How to Lock and Protect an Excel Workbook with a Password

You can lock an an Excel workbook with a password so that other users cannot open or edit it. You can use password protection to add security and prevent other users from opening a workbook, changing a worksheet or altering workbook structure.

10 Tips for Printing Excel Worksheets Efficiently

10 Tips for Printing Excel Worksheets Efficiently

Helpful Strategies for Printing Your Excel Data (and Saving Time and Paper) by Avantix Learning Team | Updated August 9, 2015 Applies to: Microsoft® Excel® 2010, 2013 and 2016 (Windows) Most users at one time or another have printed an Excel worksheet and been less...

Hiding Notes in Microsoft Excel (Writing Notes within a Formula)

Hiding Notes in Microsoft Excel (Writing Notes within a Formula)

In addition to adding comments in Excel, there is a relatively obscure function called the N function that you can use to enter notes directly within a formula. The N function converts a value to a number and has been around for a long while so you can use it in older versions of Excel as well.

Discover the Hidden Power of Excel’s Custom Views

Discover the Hidden Power of Excel’s Custom Views

Quickly Run Reports with Different Settings using Custom Views by Avantix Learning | Updated May 17, 2015 Applies to: Microsoft Excel 2010 and 2013 You can display several variations of the same Excel worksheet with different print settings, filters and hidden columns...

To request this page in an alternate format, email our staff at info@avantixlearning.ca

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest