One of the most rapidly developing areas in today’s market is data analytics—it is also an area in which businesses are struggling to find qualified staff. In this Data Analytics in Excel course, we will explore the key features of Microsoft Excel that make it such an essential tool for data analysis. Using the data…
- 4.15 hours
- 36 Videos
- Beginner
In this third course of our Excel 2021 series, students will build on the skills learned in the beginner and intermediate courses and take their functional expertise to new heights. Students will be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyse data with advanced PivotTable skills, create macros…
- 10.1 hours
- 87 Videos
- Advanced
In this second course of our Excel 2021 series, students will build on the skills learned in the beginners’ course and expand their essential Excel toolkit. Students will learn how to create intermediate-level formulas, clean and analyze data using PivotTables and PivotCharts, control data input with validation rules, make decisions with WhatIf analysis tools, and…
- 9.22 hours
- 84 Videos
- Intermediate
Learn the essentials of Microsoft Excel 2021 with this comprehensive beginners’ course! Excel 2021 is the latest stand-alone release from Microsoft and includes many of the features and functionalities currently available only in the subscription-based Excel 365. If you have no Excel experience whatsoever, then this course is the perfect starting point for you. Perhaps…
- 11.3 hours
- 100 Videos
- Beginner
We all need to analyze data these days because we live in a data-driven world. Data is so important for understanding business, looking for trends, or forecasting future needs. There is growing reliance on data analysis, so you must have the relevant skills to organize and represent data effectively. PivotTable is an essential Excel skill…
- 5.32 hours
- 64 Videos
- Beginner
In this advanced Excel Dashboards course, we look at how to create stunning, interactive dashboards in Excel. A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. In this in-depth course, we look at how to prepare your…
- 9.40 hours
- 77 Videos
- Intermediate
In this short, introductory course, we teach you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). We start by giving a basic overview of Marcos and then show you how to create simple and more complex Marcos that could save you time every day….
- 2.0 hours
- 15 Videos
- Advanced
If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, we focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analysis. We start by looking at how to filter a dataset…
- 2.7 hours
- 12 Videos
- Advanced
Microsoft Excel remains one of the best tools for Data Analysis. In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We start by looking at how to take raw data and clean it so it’s in a usable format. After that, we…
- 7.14 hours
- 53 Videos
- Intermediate
In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function. In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few…
- 7.31 hours
- 49 Videos
- Intermediate
In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. We first look at how to bring your data together, merge, and clean it…
- 3.44 hours
- 44 Videos
- Advanced
Learning Excel on a Mac is different from learning Excel on a PC. Luckily, we’ve got you covered. We’ve put together this comprehensive Beginners Excel course, and it’s all recorded using Excel for Mac 2019. In this course, we assume you have zero Excel knowledge and help you grow your confidence with spreadsheets. If you’ve…
- 5.14 hours
- 57 Videos
- Beginner
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 about our courses
Frequently Asked Questions
-
CAN I GET MY MONEY BACK IF I’M NOT SATISFIED?
Absolutely. We are committed to your total satisfaction, so we offer an unconditional, 30-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your membership to Simon Sez IT. With 30 days of risk-free membership, you can test-drive all of our courses and feel completely sure you’re getting just what you’re looking for. If you don’t learn, you don’t pay.
-
IS THE PRICE I SEE LISTED FOR JUST ONE COURSE OR ALL COURSES?
Any monthly or annual membership includes unlimited access to all Simon Sez IT courses, including any new courses that are released while your membership remains active.
-
DO YOU OFFER CERTIFICATES OF COMPLETION FOR ANY OF YOUR COURSES?
Yes, we offer certificates of completion for most of our courses. Certificates are provided when you achieve a passing grade of 70 percent or higher on the online test/quiz that accompanies a specific course. Quizzes are based solely on course content. Online quizzes and certificates of completion are currently available for recent releases of some of our most popular courses, including Office 2010, Office 2013, Office 2016, Office 2019, Office 2021, QuickBooks Pro, Photoshop Elements, various web development courses, and more. Look for the graphic with the text “This course has a certificate of completion.” on the right side of a course page to see if your course has this option.
Memberships pricing plans
| Monthly $25/month |
Annual $197/year |
Platinum Annual $297/year |
|
|---|---|---|---|
| Unlimited Access to 150+ Training Courses | |||
| 1,100+ Hours of Content, 8,500+ Videos | |||
| New Courses Added | |||
| Certificates for Each Course | |||
| Unlimited Tests and Quizzes | |||
| Member-Only Live Training Sessions | |||
| Printable Keyboard Shortcuts | |||
| Course Transcripts | |||
| 4 Courses to Download and Keep from THIS LIST | |||
| Join | Join | Join |
