How to Get Excel for Mac Pre-Release Versions – Office Insiders Program
Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.
6
Pivot Charts for Excel 2016 for Mac
Bottom line: Pivot Charts are now available on Excel 2016 for Mac (Office 365).
Skill level: Beginner
12
New VB Editor for Excel 2016 for Mac
Bottom line: A new updated VB Editor has just been released for Excel 2016 for Mac to make it easier to write VBA Macros.
Skill level: Beginner
37
3 Ways to Delete Entire Blank Rows + Video Tutorial
Bottom line: Learn a few ways to delete entire blank rows from a data set or table in this article and video.
Skill level: Beginner
9
5 Reasons to Use an Excel Table as the Source of a Pivot Table
Bottom line: Learn why using an Excel Table as the source of a pivot table can save time and prevent errors.
Skill level: Beginner
35
How to Stop Pivot Table Columns from Resizing on Change or Refresh
Bottom line: Learn how to prevent or disable the columns in a pivot table from resizing when the pivot table is updated, refreshed, changed, or filtered.
Skill level: Beginner
12
2 Keyboard Shortcuts to Select a Column with Blank Cells
Bottom line: Learn a few keyboard shortcuts to select all the cells in a column of the used range. This is a solution for when the Ctrl+Shift+Down Arrow or Ctrl+Shift+End shortcuts don’t work.
Skill level: Intermediate
14
Create SUBTOTAL Formulas with the AutoSum Button or Keyboard Shortcut
Bottom line: Learn how to use the AutoSum feature and keyboard shortcut to create SUBTOTAL formulas.
Skill level: Beginner
37
The For Next and For Each Loops Explained for VBA & Excel
Bottom line: The For Next Loops are some of the most powerful VBA macro coding techniques for automating common tasks in Excel. This article explains how the loop works to repeat actions on a collection of items, which saves us a ton of time with our jobs.
Skill level: Intermediate
23
Automatic Default Number Formatting in Excel Pivot Tables
Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with a VBA macro. Number formatting is automatically applied when you drag a field into the Values area in one single step.
Skill level: Intermediate
