Microsoft Copilot for Data Analysis in Excel is a practical training course that demonstrates how to utilize Copilot to explore, clean, and interpret data. Get ready to turn raw rows into answers you can trust and share. You will see how Copilot speeds up everyday work in Excel so you can focus on insight, not…
- 0h 35m
- 9 Videos
- Beginner
In this training course, ” Excel Formulas: Beginner Level, ” you will learn the art of using Excel to streamline your data analysis and calculations. You will explore essential Excel functions such as SUM, AVERAGE, COUNT, MIN, and MAX and discover how to manipulate and analyze data efficiently. This course will guide you through understanding…
- 0h 49m
- 8 Videos
- Beginner
In this training course, “Using Excel for Data Forecasting and Insights, ” equip yourself with the skills to harness historical data for future insights.” The course demonstrates how to utilize Excel’s built-in tools, such as the Forecast Sheet, Goal Seek, and Scenario Manager, to predict future trends based on existing data, emphasizing the practicality of…
- 0h 45m
- 8 Videos
- Intermediate
Learn how to improve your documents in this training, Professional and Consistent Documents in Microsoft Word: Mastering Styles. This course introduces how to use and customize Word’s built-in styles to bring consistency, clarity, and structure to your documents. Discover how predefined formatting can save time, improve readability, and allow for quick updates across large files….
- 0h 42m
- 8 Videos
- Beginner
This comprehensive training course, Filter and Sort Data in Excel: FILTER, SORT, and SORTBY, helps you organize and analyze data easily. It provides step-by-step instructions on essential Excel features like sorting columns, applying filters, and using advanced tools like custom filters and conditional formatting. Learn how to group data, create multi-level sorts, and leverage powerful…
- 0h 42m
- 11 Videos
- Beginner
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
Unlock the potential of form controls for efficient data management and user-friendly interfaces in this course, Interactive Spreadsheet in Excel. In this course, you will delve into utilizing form controls in Excel to enhance user interaction, streamline data entry, and display dynamic content. Empower your spreadsheets with buttons, checkboxes, combo boxes, and more. Create combo…
- 0h 52m
- 11 Videos
- Intermediate
Discover the strategies to identify, understand, and resolve common Excel errors in this comprehensive training course, How to Fix Errors in Excel. Learn how to tackle errors like #VALUE, #NAME, and #DIV by understanding their causes and applying appropriate solutions. Understand how to validate your data and protect cells from unwanted changes. Explore formula auditing…
- 0h 40m
- 12 Videos
- Beginner
Unlock the full potential of Microsoft Copilot to enhance your productivity in this comprehensive course, “Introduction to Microsoft Copilot for Excel, Word, and PowerPoint.” Copilot, a powerful AI tool, assists you in drafting documents, generating ideas, and streamlining your workflow. Explore Copilot’s capabilities in Word, learning how to navigate and utilize its features efficiently. Witness…
- 0h 35m
- 8 Videos
- Beginner
Unlock the full potential of PowerPoint and take your presentations to the next level with our training course, PowerPoint Tips to Maximize Your Efficiency and Impact. In this course, you will learn how to craft compelling and professional presentations that leave a lasting impression. Harness the power of visual storytelling to effectively communicate your ideas…
- 0h 51m
- 17 Videos
- Beginner
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
LEVEL-UP YOUR BUSINESS FOR LESS
Simon Sez IT is also available for teams and organizations.
We understand that businesses need flexibility. You don’t want long, expensive contracts that may not work for your business in the future. With Simon Sez IT, you pay one, low monthly or annual fee to access the courses your business needs to succeed.
No lengthy contract and you can cancel at any point. It’s software made simple for less.
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
