Microsoft Excel Course
About this course
Are you looking to learn Excel 2019 and quickly?
We have developed a crash course on how to get the best out of Excel 2019 that can be completed in under 7 hours! It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills!
The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. As with all of our courses, we are experienced professionals first and so we can truly empathise with your needs and this shows in the topics we choose and the style in which we teach you.
We will cover all you need to know with Microsoft Excel with the following topics (please use the contents to learn further details of lessons that will be covered):
How to use Excel
Functions, Ranges and Shortcuts
Printing, Formatting and Conditional Formatting
Managing Data: Text,Formulas and Functions
Pivot tables, Power Query and Dashboards
Macros and VBA
Skill level: Beginner to Advanced
Video: 6 hours and 44 minutes
Get a certificate of completion that can be displayed on LinkedIn
What You'll Learn (click for details)
MODULE 1. Starting Excel
MODULE 2. What You Can Enter Into Excel
2.1 Combined What you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers
MODULE 3. Sheets, Rows and Columns
3.1 Copy and Drag
3.2 Working with rows and columns
3.3 Working with sheets
MODULE 4. Functions, Ranges and Shortcuts
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 more basic functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.8 More Shortcuts
MODULE 5. Formatting and Conditional Formatting
5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting PreConfigured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick
MODULE 6. Printing
6.1 Icons Shapes and Formatting
6.2 Printing Page Layout
6.3 Printing Headers Footers
MODULE 7. Managing Data
7.1 Data Sort
7.4 Text to Columns
7.5 Flash Fill
7.6 Data Validation
7.7 Group and Outline
7.8 Freeze Panes
MODULE 8. Managing Text and Working with Formulas and Functions
8.1 Relative and Absolute Referencing
8.3 Index Match
8.5 Nested If
8.6 Countif Countifs
8.7 SUMIF SUMIFS
8.9 RIGHT LEFT MID
8.11 Common Error Types
MODULE 9. Charts
9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
9.5 Composite Charts
MODULE 10. Pivot tables, Power Query and Dashboards
10.1 Power Query Intro
10.2 Power Query Consolidation
10.3 Pivot Tables
10.4 Setting up a Pivot Table
10.5 Pivot Table Field Settings
10.6 Pivot Table Calculated Fields
10.7 Pivot Table Groupings
10.8 Pivot Table Slicers and Timelines
10.9.1 Dashboards Part 1
10.9.2 Dashboards Part 2
MODULE 11. Macros
11.1 What is a macro.
11.2 Recording a Macro
11.3 Relative and Absolute Macros
MODULE 12. Intro to VBE and VBA
12.1 Introduction to VBE
12.2 Object Model
12.3 Module Worksheets Classes
12.4 Variables and Constants
12.5 vba Formatting
12.6a If Statement
12.6b Select Case
12.7a For Loop
12.7b DoWhile DoUntil Loop
12.7c ForEach Loop
We have had the pleasure of helping over 2000 professionals to better their skills and become indispensable to their companies. Here are some encouraging words from just a few:
Investment Banking PMO, London
“This course is excellent. The Skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”
Senior Project Manager, New Zealand
“Sohail’s courses have provided me with the guidance and traction to hugely grow my earnings – in fact trebled my income over the past few weeks upon completion. This was due to the fact there’s a formula that for me clarified core missing pieces. For me this has been a real game changer and a catalyst.”
Senior Financial Analyst, Canada
“I applied many of the skills I learnt through your excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”
Project Manager, US
“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. I also really liked the PowerPoint lesson and the Marketing Your Skills lesson. This course is the complete package, I would recommend this course 100%
Some Of The Companies Our Students Work At
Frequently Asked Questions
HOW DO YOU DELIVER YOUR COURSES?
Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard.All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons.
THERE ARE MANY OPTIONS THESE DAYS TO LEARN, WHY GO WITH YOUR COURSES?
Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.
HOW LONG WILL IT TAKE TO LEARN THESE SKILLS?
It depends on your level of commitment. Our students have seen incredible results from as little as 3o mins a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. One of our most successful students Jayne managed to get up at 4am to do her learning! This paid off massively as it landed her a six figure analyst job in a bank!
CAN MY EMPLOYER PAY FOR MY TRAINING?
Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfer/remittances. Get in touch if you have any specific questions.
DO YOU HAVE A REFUND POLICY?
Yes, we do, we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund.
HOW MUCH DOES IT COST TO TAKE YOUR COURSES?
You can either purchase access to one course or all of our courses, which are listed above. What we have done in a post COVID-19 world is to keep our prices low to accommodate as many ambitious people from all over the world who are looking to upskill through our high level courses without the burden of high expense.
WHY DO YOU SELL IN MULTIPLE CURRENCIES?
We recognise that people prefer to pay in their own currencies and especially when our main product is a recurring membership to all our courses, you can rest assured knowing that fluctuations in currency won't affect your financial commitment.