Excel Courses Courses

Most popular
Trending

All Excel Courses Courses

We found 6 courses available for you
Free
Intermediate

Excel MI & Dashboards

This concise course is perfect for getting complete beginners comfortable …

Free

Excel MI & Dashboards

10.5 hours
Intermediate
What you'll learn
Get familiar with Excel
Learn the different kinds of data you can work with
Understand basic formulas
Learn foundation data analysis techniques like sorting and filtering
Learn how to do basic charting
Create conditional formatting for better reporting
Free
Intermediate

Excel Pivot Tables Course

Having worked with Excel for well over a decade in …

Free

Excel Pivot Tables Course

2 hours
41 Lessons
Intermediate
What you'll learn
So I’ve given you five good reasons to learn Pivot Tables and improve the way you deal with summarising your data. Now, I won’t leave you hanging, I’ve spent a few months developing this course on Pivot Tables with top-level financial analysts. The course is both quick to complete (two hours) and not very expensive. Here's what is in the course
Module 1: Introduction & Data Preparation
We will have a no-nonsense start and immediately build a Pivot Table, no theory or overly long explanations, straight into it! Then you go into the key topic of getting your data correct, I’ll briefly dive into Power Query to show how you can fix messy data and create what I call a ‘long boring list’
Module 2: Layout And Formats
Now that you have a basic Pivot, you are going to start to refine it into something increasingly useful and understanding Layouts is the first step to getting different perspectives on your data.
Module 3: Core Pivot Table Analysis
This is the meat of the course, this is where you really turn a Pivot Table in to an analysis engine by digging in to running totals, grouping data, sorting, filtering, multiple subtotals, insights with percentages of column and the perspectives with show value as.
Module 4: Filters And Slicers
Here’s where you will learn best practice on slicing and dicing your data with multiple filter techniques. Including more visual and specific filters like ‘Slicer’ and ‘Timeline’.
Module 5: Advanced Analysis
At this point in the course you will have a great understanding of Pivot Tables, it’s time to step up even more by implementing some of the more advanced Pivot Table analysis techniques such as Calculated fields, where you incorporate your own formulas in to your outputs. You will also learn about the power of connecting multiple data tables to one Pivot Table.
Module 6: Visuals And Reports
Here, you are going to be working conditional formatting in to your Pivot Table, you will look at PivotCharts which turn your data source directly in to a chart and finally you will take everything you have learned and build a Sales dashboard using key components such as Map charts.
Free
All Levels

Excel Tools & Templates Course

In this section we share with you some of the …

Free

Excel Tools & Templates Course

3 hours
28 Lessons
All Levels
What you'll learn
The templates and tools are categorized in two sections. Everyday templates that can be quickly implemented to manage and track finances, projects, personal needs etc.
In section two we have highly sophisticated reporting and project management tools that mostly require some understanding of VBA. The latter group of tools and templates are mostly applicable in companies requiring small to enterprise level solutions.
Free
Expert

Excel VBA Course

If you are regularly producing the same reports, doing the …

Free

Excel VBA Course

15 hours
74 Lessons
Expert
What you'll learn
Our approach to teaching is firmly rooted in the human psychology of quick wins so we have you programming in the first few minutes. Just like each and every one of our students, you will gain massive confidence in your VBA skills right from the start.
1) VBA and Macros Introduction
2) Fundamentals of Automation with loops and logic
3) Automating Charts, Filters, and Formulas to speed up your workflow
4) Automating an entire weekly/monthly reporting process
5) The power of automating PowerPoint and Word
We have had students automating aspects of their work the day after starting! And whilst individual results vary, most of our students develop enough skills to begin saving tremendous amounts of time at work within a few short weeks.
Free
Expert

Excel Expert Course

Excel skills are no longer ‘optional’ at work so if …

Free

Excel Expert Course

8.3 hours
46 Lessons
Expert
What you'll learn
Our course has been carefully crafted by professionals who have spent decades solving hundreds of Excel related problems in dozens of global companies.
From solving hundreds of Excel problems, we have seen that every business scenario needing Excel can be boiled down to three types problems (Storing Data, Analysis and Insights) and four possible ways to solve problems (Finding Information, Using Logic, Manipulating Text and Data Summary) aka our proprietary 4:3 Excel framework.
It’s within this framework that we will teach you the best way to use Formulas, Charts, Conditional Formatting, Pivot Tables, Shortcuts and Other Functions.
No longer will you be scrambling for random tips, ninja tricks and shortcuts. You can say goodbye to googling for answers to Excel questions after everyone else has gone home because your report is due in the morning.
This framework is a strategic Excel system that will guide you in your work and will have you producing outstanding quality analysis and reporting in a quick time frame.
No longer will you be scrambling for random tips, ninja tricks and shortcuts. You can say goodbye to googling for answers to Excel questions after everyone else has gone home because your report is due in the morning.
This framework is a strategic Excel system that will guide you in your work and will have you producing outstanding quality analysis and reporting in a quick time frame.
Free
Intermediate

Excel Beginner To Intermediate Course

This concise course is perfect for getting complete beginners comfortable …

Free
(1)

Excel Beginner To Intermediate Course

5.0/5
(1 rating)
10.5 hours
1 Lesson
Intermediate
What you'll learn
Get familiar with Excel
Learn the different kinds of data you can work with
Understand basic formulas
Learn foundation data analysis techniques like sorting and filtering
Learn how to do basic charting
Create conditional formatting for better reporting