How to Easily Show or Hide Formulas in Microsoft Excel (3+ Ways)

How to Easily Show or Hide Formulas in Microsoft Excel (3+ Ways)

Show or Hide Formulas in Excel Using a Keyboard Shortcut, Button or Formulaby Avantix Learning Team | Updated April 27, 2019Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows)You can easily show or hide formulas in a number of ways in Microsoft Excel. You...
How to Create 3D References in Microsoft Excel

How to Create 3D References in Microsoft Excel

Summarize Multiple Excel Worksheets Using 3D References in Formulasby Avantix Learning Team | Updated March 2, 2019Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)You can use 3D references in Excel formulas to calculate across multiple worksheets...
How to Freeze Row and Column Headings in Microsoft Excel

How to Freeze Row and Column Headings in Microsoft Excel

Easily Freeze Titles in Excel by Avantix Learning Team | Updated: November 8, 2018 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they...
10 Excel Tips for Working with the Subtotal Feature

10 Excel Tips for Working with the Subtotal Feature

10 Useful Tips for Summarizing Data Using Excel’s Subtotal Feature by Avantix Learning Team | Updated: September 9, 2018 Applies to: Microsoft® Excel® 2010, 2013, 2016 and 365 (Windows) You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal...
10 Timesaving Excel Tricks and Shortcuts for Copying and Pasting

10 Timesaving Excel Tricks and Shortcuts for Copying and Pasting

Speed Up Copying and Pasting Using Simple Tricks and Shortcuts in Microsoft Excel by Avantix Learning Team | Updated June 12, 2018 Applies to: Microsoft® Excel® 2010, 2013 and 2016 (Windows) It’s surprising how much time you can save with a few tricks and shortcuts...

Pin It on Pinterest