.png/:/rs=w:1778,h:1000,cg:true,m/cr=w:1778,h:1000)
Imagine if people were calling YOU the Excel wizard with these nearly 200 tips & tricks made easy
Excel dashboard with navigation
82% of jobs require the Excel skills in the class & workbook
Excel basics to start
Math & advanced functions
Excel basics to start
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 and filtering
Math & advanced functions
Excel basics to start
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.
Math & advanced functions
Math & advanced functions
Math & advanced functions
Learn autosum, sumif, countif, budget math, how to get running totals, how to calculate payments, use goal seek, and time functions.
Formatting and cleaning
Lookup & search functions
Math & advanced functions
Make your spreadsheet presentable. Rename columns headings, change colors, alignment, split or join text, and fix up capitalization and spacing issues.
Lookup & search functions
Lookup & search functions
Lookup & search functions
Xlookup, Vlookup, advanced Vlookup, Hlookup or just lookup. Which do you use, how and when? Practice here.
List functions
Lookup & search functions
Lookup & search functions
Compare and contrast lists, identify duplicates, add search boxes, and assign values from available lists. Create project and job tracking tools.
Pivot tables
Charts & cool ways to summarize data
Pivot tables
These are the most useful function Excel offers, yet they can feel complex. Learn everything there is to know, including calculated fields.
Indicators
Charts & cool ways to summarize data
Pivot tables
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.
Charts & cool ways to summarize data
Charts & cool ways to summarize data
Charts & cool ways to summarize data
Learn or use the dashboard templates, create progress, Gantt, Likert, milestone, speedometer, donut, bullet, tree map, timeline, butterfly, bubble charts, and more.
Random fun things & tips
Random fun things & tips
Charts & cool ways to summarize data
Use Excel for barcodes, QR codes, signatures, and even Bingo. Create org charts and calendars, and use the camera to take data snapshots.
VBA fun
Random fun things & tips
Developer tab fun
Add your own custom functions, highlight active cells and auto fit rows and columns automatically when you know the code.
Developer tab fun
Random fun things & tips
Developer tab fun
Developer tab lets you use button spinners, check boxes, radio buttons, & macros to automate your work.
400,000+ followers are learning Excel & Google Sheets everyday to improve their work life
Frequently Asked Questions
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 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.
Subscribe For The Latest Excel and Business Tips & Tricks
Copyright © 2024 XecuteTheVision™ - All Rights Reserved.
xecutethevision@gmail.com | Macomb, MI