Excel Tips, Tricks and Shortcuts
Microsoft Excel Blog | Avantix Learning
How to Fill Blank Cells in Excel (with Zeros, Dashes or Other Values)
You can quickly fill blank cells in a range of data in Excel with dashes, zeros or other number or text values. Blank cells can be problematic if you want to use a data set as the source for a pivot table.
How to Convert Cm to Inches in Excel (or Inches to Cm)
You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.
How to Hide Comments or Notes in Excel Workbooks
You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.
How to Delete Blank Rows in Excel (5 Ways)
You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to remove multiple blank rows quickly. Check out 5 different ways to easily delete blank rows in your data.
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 Hide Rows and Columns in Excel (including Unused Rows and Columns)
You can hide rows and columns in Excel using the context menu, using a keyboard shortcut or by using the Format command on the Home tab in the Ribbon. If you have hidden rows or columns, you can unhide them as well.
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)
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
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 Break, Update or Change Links to Excel Charts or Worksheets in Microsoft Word
If you want to break, update or change links to Excel charts or worksheets in Microsoft Word, you’ll need to use the Edit Links to Files command. Unfortunately, this command is difficult to find. To make it easier to access, you can add Edit Links to Files to the Quick Access Toolbar.
How to Convert Seconds to Minutes and Seconds in Excel
You can convert seconds to minutes and seconds in Excel by combining calculations and custom number formatting …
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 …
7 Timesaving Microsoft Excel Shortcuts for Selecting in Tables
There are many different shortcuts for selecting elements in Microsoft Excel tables. You can use shortcuts to select an entire table, an entire row, an entire column or ranges in tables.
How to Increase or Decrease Decimal Places in Microsoft Excel Using Keyboard Shortcuts
You can use keyboard shortcuts to increase or decrease decimal places. Press Alt to access the Ribbon …
Show or Hide Formulas in Microsoft Excel (3+ Easy Ways)
You can easily show or hide formulas in a number of ways in Microsoft Excel. You can use a keyboard shortcut, click a button and even use a formula to show formulas …
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