Sort by

Skills Targeting

Transform Data with Data Models, PivotTables, and Power Query in Excel

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

Skills Targeting

Using LAMBDA to Create Your Own Excel Functions

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

Skills Targeting

New Dynamic Array Functions in Excel (to Maximize Your Efficiency and Impact)

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

Skills Targeting

Mastering Excel Lookup Functions (to Maximize Your Efficiency and Impact)

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

Skills Targeting

Dynamic Array Functions in Excel to Maximize Your Efficiency and Impact

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

Skills Targeting

15 Essential Advanced Excel Formulas (to Maximize Your Efficiency and Impact)

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 about our courses

“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.”

Ann Lauzau

“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 with my projects.”

Patrick Loyola

“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 PMPs.”

Frank Uchegbu

“I enjoyed the logical structure of course. It helps beginners to follow easily.”

Charlenee Huynh

“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 lot thanks to this course.”

Blanca Esteban

“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 amazing experience would recommend to anyone who wishes to get onboard with Microsoft Project. I would also advise that some primary knowledge of project management will make the course a lot easier to grasp.

The lecturer is experienced and knowledgeable in project management, and as a result, his explanations are very good. I enjoyed the course and will recommend it to my friends.

In summary a well worth course so glad to have enrolled.
”

Haroon Riaz

“I enrolled in Simon Sez IT to use the Microsoft Excel for beginners course. I enjoyed every bit of the course and easy to understand and the pattern of teaching was top-notch. I will recommend this course to others including my colleagues.

This course has also made me more confident at work because most of our work is usually done in an Excel spreadsheet.”

Umar Abdulqadir

Frequently Asked Questions

Memberships pricing plans

	Monthly $30/month	Annual $240/year	Annual Pro $297/year
Unlimited Access to 200+ Training Courses
1,200+ Hours of Content, 10,000+ Videos
New Courses Added
Certificates for Each Course
Unlimited Tests and Quizzes
Member-Only Live Training Sessions
5 Soft Skills Essentials Video Courses
20+ Soft Skills Video Courses
Printable Keyboard Shortcuts
Course Transcripts
50+ Skill Short Audio Courses
15+ Pro Exclusive Skills Targeting Courses
	Join	Join	Join