Master Spreadsheets with a COO and Microsoft MVP

The 1.5 hour video covers the basics. Then the workbook also covers them with a 2nd set of examples. Learn math, freezing panes, flash fill, data validation, find and replace, all the basics.

Sorting & filtering can get advanced. Learn how to sort, autosort as you type, custom sort for non alpha, and filter with text strings and on images.

Learn autosum, sumif, countif, budget math, how to get running totals, how to calculate payments, use goal seek, and time functions.

Make your spreadsheet presentable. Rename columns headings, change colors, alignment, split or join text, and fix up capitalization and spacing issues.

Xlookup, Vlookup, advanced Vlookup, Hlookup or just lookup. Which do you use, how and when? Practice here.

Compare and contrast lists, identify duplicates, add search boxes, and assign values from available lists. Create project and job tracking tools.

These are the most useful function Excel offers, yet they can feel complex. Learn everything there is to know, including calculated fields.

Learn how to change cell color based on results using if statements, and use up down arrows or thumbs up and down to indicate results.

Learn or use the dashboard templates, create progress, Gantt, Likert, milestone, speedometer, donut, bullet, tree map, timeline, butterfly, bubble charts, and more.

Use Excel for barcodes, QR codes, signatures, and even Bingo. Create org charts and calendars, and use the camera to take data snapshots.

Add your own custom functions, highlight active cells and auto fit rows and columns automatically when you know the code for Excel.

Developer tab in Excel lets you use button spinners, check boxes, radio buttons, & macros to automate your work.