Advanced Microsoft Excel - Take your skills to a new level!

Explore the course workbook as a gamified learning space, mastering formatting, keyboard shortcuts, and reference solutions, while navigating automatic and manual points and surprise buttons.

Master essential keyboard shortcuts to boost Excel efficiency, focusing on the most useful shortcuts. Expect a slower start, but achieve a 10–15% gain and save 40 hours per year.

Unlock powerful Excel shortcuts by using the Alt key to access the ribbon, toggle grid lines, adjust row height, and apply no fill color with quick keystrokes.

Name entire lookup tables and columns to simplify formulas like sumifs and countifs, then edit or delete named ranges with the name manager, preparing you to use index match.

Learn the match formula to return an item's relative position in a single row or column, use exact match 0, and combine it with index for dynamic lookups.

practice the index match formula to consolidate an income statement from multiple years, locking cells and dates to accurately pull revenue, cost of goods sold, and net income.

Explore how to combine and and or statements with an if statement to power the Excel if formula, using CPA passing scores and house criteria as examples.

Explore the choose function for scenario analysis in Excel, using a drop-down to update revenue across cells for upside, base, and downside scenarios.

Combine min, max, and if to compute year-end bonuses using the three-account and one hundred fifty thousand dollars sales criteria, applying commission and a max of eighty-five hundred dollars.

Explore advanced pivot table techniques by creating a calculated field for gross profit margin (sales minus cost of goods sold, divided by sales) across months and regions.

Explore how pivot charts extend pivot tables with refresh, slicers, and dynamic dashboards, including creating combo charts with secondary axes to visualize the gross profit margin.

Record a macro to automate common spreadsheet tasks without writing VBA code. Save the workbook as a macro enabled file and enable the developer tab.