Member Bonuses
Webinars & Discounted Rates
This is where your membership bonuses live.
Log in to view.
Your Instructor
Simon Sez IT makes business and technical software simple to learn.
Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.
This is why more than a million learners have relied on Simon Sez IT since 2008.
Course Curriculum
Webinars and Live Classes
Available in
days
days
after you enroll
Previous Live Classes
Available in
days
days
after you enroll
-
StartSorting and Filtering Data in Excel (46:15)
-
StartDOWNLOAD ME: Sorting and Filtering Data in Excel Demo File
-
StartMastering Excel Lookups (53:59)
-
StartDOWNLOAD ME: Mastering Excel Lookups Demo Files
-
StartData Models, PivotTables, and Power Query in Excel (Aug 2024) (57:22)
-
StartDOWNLOAD ME: Data Models, PivotTables, and Power Query Demo Files
-
StartConditional Formatting in Excel (July 2024) (58:03)
-
StartDOWNLOAD ME: Conditional Formatting in Excel Demo Files
-
StartBusiness Charts in Excel (June 2024) (62:56)
-
StartDOWNLOAD ME: Business Charts in Excel Demo Files
-
StartAdd Interactivity with Form Controls in Excel (May 2024) (64:42)
-
StartDOWNLOAD ME: Add Interactivity with Form Controls in Excel Demo File
-
StartCreate Formulas with LAMBDA (April 2024) (45:19)
-
StartDOWNLOAD ME: Create Formulas with LAMBDA Demo File
-
StartTroubleshooting Errors in Excel Spreadsheets (March 2024) (50:43)
-
StartDOWNLOAD ME: Troubleshooting Errors in Excel Demo File
-
StartMicrosoft CoPilot in Excel, Word and Powerpoint (Feb 2024) (61:59)
-
StartIntroduction to Microsoft Forms (Jan 2024) (67:32)
-
StartCustom Formatting in Excel (Nov 2023) (60:56)
-
StartDOWNLOAD ME: Custom Formatting in Excel Demo Files
-
StartCleaning Data in Power Query (Oct 2023) (54:34)
-
StartDOWNLOAD ME: Cleaning Data in Power Query Demo File
-
StartPractical Uses of Lookup Functions in Excel (Sep 2023) (65:59)
-
StartDOWNLOAD ME: Practical Uses of Lookup Functions Demo File
-
StartPivotTable Tips and Tricks (August 2023) (65:15)
-
StartDOWNLOAD ME: PivotTable Tips and Tricks Demo File
-
StartPractical Uses of Logical Formulas in Excel (July 2023) (54:06)
-
StartDOWNLOAD ME: Practical Uses of Logical Formulas Demo File
-
StartNew Dynamic Array Functions in Excel (June 2023) (51:14)
-
StartDOWNLOAD ME: New Dynamic Array Functions in Excel Demo File
-
StartDynamic Array Functions in Excel (May 2023) (59:37)
-
StartDOWNLOAD ME: Dynamic Array Functions in Excel Demo File
-
StartExcel Chart Formatting Tips and Tricks (April 2023) (67:16)
-
StartDOWNLOAD ME: Excel Chart Formatting Tips and Tricks Demo File
-
StartCool PowerPoint Hacks (March 2023) (66:38)
-
StartExcel Bad Habits (Feb 2023) (71:00)
-
StartDOWNLOAD ME: Excel Bad Habits Demo File
-
StartTop 20 Excel Efficiency Hacks to Improve Productivity (Jan 2023) (67:08)
-
StartDOWNLOAD ME: Excel Efficiency Hacks Demo File
-
StartInteractive Dashboards in Excel (Nov 2022) (75:45)
-
StartDOWNLOAD ME: Interactive Dashboards in Excel Demo File
-
StartCleaning Data in Excel (Oct 2022) (71:09)
-
StartDOWNLOAD ME: Cleaning Data in Excel Demo Files
-
Start10 Tips for Better Outlook Email Management (Sep 2022) (62:17)
-
StartUsing the Data Model to Create PivotTables (Aug 2022) (61:04)
-
StartDOWNLOAD ME: Using the Data Model to Create PivotTables Instructor Files
-
StartGetting to Grips with PivotTables in Excel (July 2022) (59:42)
-
StartDOWNLOAD ME: Getting to Grips with PivotTables in Excel Demo File
-
StartAdvanced Formulas in Excel (May 2022) (79:27)
-
StartDOWNLOAD ME: Advanced Formulas in Excel Instructor File
-
StartGet the Most Out of Microsoft Teams (April 2022) (74:16)
-
StartLookup Functions in Excel (March 2022) (62:10)
-
StartDOWNLOAD ME: Lookup Functions in Excel Demo File
-
StartAdvanced PowerPoint Hacks (February 2022) (67:18)
-
StartDOWNLOAD ME: Advanced PowerPoint Hacks Instructor Files
-
StartLogical Functions in Excel (January 2022) (55:26)
-
StartDOWNLOAD ME: Logical Functions Instructor Files
-
StartIntroduction to Windows 11 (November 2021) (58:21)
-
StartIntroduction to Power BI - Part 1 (September 2021) (68:10)
-
StartIntroduction to Power BI - Part 2 (October 2021) (67:26)
-
StartDOWNLOAD ME: Power BI Instructor Files
-
StartIntroduction to Power Automate (August 2021) (53:24)
-
StartIntroduction to Excel Formula (July 2021) (71:10)
-
StartIntroduction to SharePoint (June 2021) (66:39)
-
StartMacros and VBA in Excel (May 2021) (71:35)
-
StartDOWNLOAD ME: Macros and VBA Instructor Files
-
StartIntroduction to Microsoft Project Part 1 (April 2021) (68:59)
-
StartIntroduction to Microsoft Project Part 2 (76:45)
-
StartProfessional Documents in Word (April 2021) (69:01)
-
StartCleaning Data in Excel (March 2021) (75:00)
-
StartDOWNLOAD ME: Data Cleaning Instructor Files
-
StartInteractive Dashboards (March 2021) (79:20)
-
StartCreating Engaging PowerPoint Presentations (May 2020) (61:45)
-
StartExcel Tutorials - Top Ten Excel Functions You HAVE to Know (May 2019) (71:18)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.