Welcome to “Excel 2021 Intermediate,” a course designed to elevate your spreadsheet skills and empower you with advanced Excel functionalities. In this course, we’ll delve into the intricacies of spreadsheet design, enhancing readability through cell styles, and controlling data input with navigation buttons. Master logical functions such as AND, OR, and IF, progressing to nested…
- 9h 22m
- 84 Videos
- Intermediate
Welcome to “Excel 2021 for Beginners,” a comprehensive course designed to equip you with the essential skills to navigate and utilize Microsoft Excel effectively. In this course, we’ll explore Excel’s features, from understanding the interface to mastering formulas, functions, and data visualization. You will begin by differentiating between Excel 2021 and Excel for Microsoft 365,…
- 11h 10m
- 100 Videos
- Beginner
Welcome to “PivotTables for Beginners,” where you’ll embark on an empowering journey to unravel the immense potential of PivotTables in Excel. In this course, you’ll discover the fundamental concepts behind PivotTables and gain hands-on expertise in preparing, analyzing, and visualizing data with precision. You’ll start by understanding the significance of clean data, learning techniques to…
- 5h 32m
- 64 Videos
- Beginner
Welcome to “Dashboards in Excel,” your gateway to mastering the art of creating impactful and interactive dashboards. In this course, you’ll learn the essential skills to design visually appealing dashboards and gain hands-on experience preparing and analyzing data for dynamic visualizations. You’ll begin by understanding the fundamentals of spreadsheet architecture, drawing inspiration for dashboard design,…
- 9h 40m
- 77 Videos
- Intermediate
Welcome to “Macros and VBA for Beginners,” where you’ll embark on a transformative journey into Excel automation. In this course, you’ll master the art of using Macros to automate repetitive tasks, unravel the intricacies of VBA, and gain the skills to streamline your Excel workflows. You will start by exploring the power of Macros, learning…
- 2h 0m
- 15 Videos
- Advanced
Welcome to “Advanced Formulas in Excel,” a comprehensive course designed to elevate your Excel proficiency to an advanced level. In this course, you will delve into a diverse set of advanced formulas and techniques, empowering you to manipulate data with precision and efficiency. You will start by mastering the art of filtering and sorting datasets…
- 2h 10m
- 12 Videos
- Advanced
Welcome to the comprehensive “Excel for Business Analysts” course, designed to equip you with essential skills for practical data analysis and decision-making in the business world. Throughout this program, you will delve into various Excel features and functions tailored to empower you as a proficient business analyst. Beginning with an introduction to business analysis, you’ll…
- 7h 14m
- 53 Videos
- Intermediate
Welcome to the immersive journey of “Advanced PivotTables,” where you can elevate your data analysis skills to new heights using Microsoft Excel. In this course, you will master the intricacies of PivotTables, unlocking the full potential of Excel for advanced data manipulation and visualization. Start by delving into the essentials with an introduction to Advanced…
- 7h 31m
- 49 Videos
- Intermediate
Welcome to the transformative journey of Power Pivot, Power Query & DAX in Excel. In this course, you’ll unlock the full potential of Excel, enhancing your data manipulation and analysis skills to a professional level. Embark on a comprehensive exploration, starting with an overview of Power Query and Power Pivot. Learn to navigate the Power…
- 3h 44m
- 44 Videos
- Advanced
Welcome to the exciting world of Microsoft Excel 2019 for Beginners on Mac! In this course, you will embark on a journey to master the essential spreadsheet creation and manipulation skills using the powerful Excel software designed specifically for Mac users. You’ll start with an introduction to Excel, exploring the nuances between PC and Mac…
- 5h 14m
- 57 Videos
- Beginner
Welcome to “Excel 2019 for Beginners,” a transformative course tailored to equip you with fundamental Excel skills and empower your data management journey. Throughout this course, you will immerse yourself in Excel, from understanding the basics to mastering some intermediate functionalities. Explore the Excel window, mouse features, and Back Stage View to build a solid…
- 7h 29m
- 95 Videos
- Beginner
Welcome to the Microsoft Excel 2019 Advanced course, where you can elevate your Excel skills to new heights! Throughout this comprehensive program, you’ll delve into many advanced features, empowering you to wield Excel as a dynamic tool for complex data manipulation and analysis. This course is meticulously structured, beginning with an overview of its contents…
- 8h 10m
- 57 Videos
- Advanced
Excel Training
Simon Sez IT has been helping people improve their Excel skills for more than ten years.
With over 20 Excel courses, ranging from beginner to VBA, we have you covered whether you are brand new to Excel or a seasoned pro.
We offer Excel training based on the year of release (Excel, 2013, 2016, 2019/365 and 2021) and specialized Excel training that focuses on particular skills, for example, Excel for Business Analysts or Advanced PivotTables.
Take a look at our free Excel training to get started.
What people are saying
I have always used Excel at work, but because I learned to use it on my own, I had never been able to make use of all the possibilities that the software offers. I have learned a…
Simon Sez IT has trained me how to use Microsoft Project to create and manage my own projects in just 2 days. Exactly the training I was looking for!
Its been an a…
Enrolling in Simon Sez IT’s Microsoft Project for beginner course really helped me become proficient with Microsoft Project and project management. I now think more critically wi…
This has already helped me set up my project better and gives me the confidence that I’ll be able to keep tracking the project using the software.
I actually came to your courses because I want to master the IT aspects of project management. The course was very detailed. I will be recommending this course to other aspiring …
Membership pricing plans
Choose the plan that fits your learning goals and budget. All our plans include unlimited access to our courses and access to our regular live lessons.
Monthly
Flexible monthly access
$30 /month
- Unlimited Access to 200+ Courses
- 1,300+ Hours of Content, 11K+ Videos
- Certificates for Each Course
- Unlimited Testing & Quizzes
- Instant Access to New Courses
- Member-Only Live Training Sessions
- 5+ Soft Skills Video Courses
- 20+ Skills Targeting Courses
- 50+ Skill Shorts Audio Courses
- 20+ Quick Wins Video Lessons
- Printable Keyboard Shortcuts
Annual
Save 33% with yearly billing
$240 /year
$20/month billed annually
- Unlimited Access to 200+ Courses
- 1,300+ Hours of Content, 11K+ Videos
- Certificates for Each Course
- Unlimited Testing & Quizzes
- Instant Access to New Courses
- Member-Only Live Training Sessions
- 5 Soft Skills Video Courses
- 20+ Skills Targeting Courses
- 50+ Skill Shorts Audio Courses
- 20+ Quick Wins Video Lessons
- Printable Keyboard Shortcuts
Annual Pro
Premium features included
$297 /year
$24.75/month billed annually
- Unlimited Access to 200+ Courses
- 1,300+ Hours of Content, 11K+ Videos
- Certificates for Each Course
- Unlimited Testing & Quizzes
- Instant Access to New Courses
- Member-Only Live Training Sessions
- 50+ Soft Skills Video Courses
- 40+ Skills Targeting Courses
- 50+ Skill Shorts Audio Courses
- 20+ Quick Wins Video Lessons
- Printable Keyboard Shortcuts
