Excel Tips, Tricks and Shortcuts

Microsoft Excel Blog | Avantix Learning

Check out our Excel training courses >

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

How to Remove Blanks in a Pivot Table in Excel (6 Ways)

How to Remove Blanks in a Pivot Table in Excel (6 Ways)

To remove blanks in pivot tables, you can set pivot table options to display data in empty cells, filter to remove blanks, apply conditional formatting, find and replace blanks or change pivot table design settings …

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.

Excel Flash Fill Tricks to Extract or Clean Data (10 Examples)

Excel Flash Fill Tricks to Extract or Clean Data (10 Examples)

Flash Fill is a great 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. Here are 10 examples where we’ve used Flash Fill to clean up data.

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...

How to Lock and Protect Excel Worksheets and Workbooks

How to Lock and Protect Excel Worksheets and Workbooks

You can lock and protect an Excel workbook by adding a password using your security options. If you want to prevent users from accessing or changing a workbook, password protection can be added to your Excel file in a number of ways.

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 July 31, 2020 Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows) Most users at one time or another have printed an Excel worksheet and been...

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.

Inserting, Editing, Deleting, Showing and Hiding Comments in Excel

Inserting, Editing, Deleting, Showing and Hiding Comments in Excel

You can insert, edit, delete, show and hide comments or notes in Microsoft Excel using Excel’s comments feature. Notes can also be entered directly in a formula. Notes or comments are hidden by default unless you click on a cell. You can quickly delete all comments using the Inspector.

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...

How to Hide Excel Formulas from Other Users

How to Hide Excel Formulas from Other Users

It’s not difficult to hide formulas in Excel worksheets. Perhaps you don’t want a client to see the markup added to the final total or a commission calculation or you simply don’t want others to see your formulas. Simply select the cell(s) with the formulas you want to hide …

Use Excel’s Awesome Go to Special Tool to Find Things in Your Worksheets

Use Excel’s Awesome Go to Special Tool to Find Things in Your Worksheets

Go To Special is one of Excel’s most underused, yet useful features and, it’s not new. It’s been available in Excel for years. Go To Special enables you to quickly select cells of a specific type within your worksheet. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting.

10 Great Excel Navigation Shortcuts to Move Around in Workbooks

10 Great Excel Navigation Shortcuts to Move Around in Workbooks

In Microsoft Excel, you can save lots of time if you can move around quickly in your worksheets and workbooks. You can use keyboard shortcuts to jump to the beginning or end of your worksheet and move up or down by ranges of data. In this article, we’ve put together a great list of navigation shortcuts to help you be more productive with Excel. 

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