Go at your own pace with a Microsoft MVP
Start with the 90 minute video class to cover the essentials in Excel, and then move into the 200+ lesson workbook and follow along with videos and see first hand how the functions and formulas work together.
These 80 lessons transition you from Excel or teach you if you're brand new to spreadsheets how to use Google Sheets effectively. Lessons go in order and include the essentials as well as intermediate to advanced.
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.
Choose Excel, Google Sheets, or both, and when you make the purchase, Excel gives you a 1.5 hour class teaching you Excel basics, two useful PDFs, and the workbook that includes nearly 200 lessons and the video instructions so you can work along side me to practice.
Google Sheets gives you a workbook with over 80 functions and formulas to practice and know.
This is a video course that lets you start at any time and take as long as you need. You will have the workbook forever so you may reference it any time you need to.
Most lessons are a minute or less, and with the workbook, you don't have to spend time recreating spreadsheets. You could be a complete Excel wizard in one long weekend or go at your pace in minutes a day over a month or more.
The lessons are shown step by step on screen and with them being shorter in length, it's super easy to master concepts.
Copyright © 2024 XecuteTheVision™ - All Rights Reserved.
xecutethevision@gmail.com | Macomb, MI