Learn the essential Excel tools needed for efficient data analysis in this training course, Transform Data with Data Models, PivotTables, and Power Query in Excel. This course introduces you to advanced data analysis techniques by combining the power of PivotTables, data models, and Power Query. Learn how to summarize and analyze large data sets using…
- 0h 46m
- 10 Videos
- Advanced
Explore the powerful capabilities of LAMBDA functions in this comprehensive course, Using LAMBDA to Create Your Own Excel Functions. Discover how to leverage LAMBDA to design and implement custom functions tailored precisely to your unique requirements. Throughout the course, you will explore the core concepts of LAMBDA functions, learning how to define variables, structure formulas,…
- 0h 35m
- 10 Videos
- Advanced
Organize data with unprecedented efficiency using game-changing functions in this training course, “New Dynamic Array Functions in Excel (to Maximize Your Efficiency and Impact).” In this course, you will delve into advanced techniques using the newly released dynamic array functions by Microsoft 365. Discover the power of TOCOL and TOROW to combine and manipulate data…
- 0h 40m
- 8 Videos
- Advanced
Harness the art of data retrieval using powerful Excel functions in this training course, “Mastering Excel Lookup Functions (to Maximize Your Efficiency and Impact).” This course will explore the essential Excel lookup functions—VLOOKUP, XLOOKUP, INDEX, and MATCH. Gain a profound understanding of VLOOKUP and explore its advantages and disadvantages. Discover how to efficiently locate information…
- 0h 54m
- 10 Videos
- Intermediate
Leverage the power of dynamic array functions to streamline your data processing in this training course, “Dynamic Array Functions in Excel to Maximize Your Efficiency and Impact.” Dynamic arrays are resizable arrays that automatically calculate and distribute values across multiple cells based on a single formula entry. This course explores powerful dynamic array functions designed…
- 0h 40m
- 10 Videos
- Intermediate
Conquer your fear of complex Excel formulas and functions in this training course, “15 Essential Advanced Excel Formulas (to Maximize Your Efficiency and Impact).” This course will help break down the barriers of seemingly intimidating functions like VLOOKUP, INDEX, MATCH, FILTER, and even the cutting-edge LAMBDA function, making them accessible and understandable. Explore the limitations…
- 0h 53m
- 9 Videos
- Advanced
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
