Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 28 Minute(s)
Language
English
Taught by
Andries Nienaber
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Improve your skills an get the job or promotion you want with this A-Z Microsoft Excel Course.
The complete Microsoft Excel 2019 Beginner, Intermediate, and Advanced course. This course includes automation using Excel Macros
Enroll now and start with our course. Either take your time to complete the course or dive in and complete the course boot camp style. Chat to me in the forum and I will gladly help you. As your instructor, I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level.
Whether you have little or no experience with Excel. Start with Excel Beginner then move onto Excel Intermediate and complete the course with Excel Advanced.
Once you have completed this course you will have mastered the most popular Excel tools. You will be confident in your new ability to complete any Excel tasks with efficiency and style. Below are just a few of the topics that you will master:
Create spreadsheets
Work with DataBase functions
VLookUp and Advanced VLookUps.
Index and Match and Advanced Index and Match
CountIFs
SumIFs
Be a master with Pivot Tables
Track workbooks between teams
So, what are you waiting for, enroll now, and take the next step in upskilling your Excel skills.
Who this course is for:
This Microsoft Excel course will take you from Beginner to Advanced.
If you looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
Course Content
- 30 section(s)
- 123 lecture(s)
- Section 1 EXCEL - BEGINNER
- Section 2 Excel Fundamentals
- Section 3 Entering and Editing Text
- Section 4 Basic Excel Functions
- Section 5 Modifying an Excel Worksheet
- Section 6 Formatting Data
- Section 7 Images, Shapes and Smart Art
- Section 8 Printing in Excel
- Section 9 Templates
- Section 10 Excel Beginner - Conclusion
- Section 11 Excel - Intermediate
- Section 12 Lists
- Section 13 DataBase Functions
- Section 14 Data Validation
- Section 15 Importing and Exporting
- Section 16 Creating Basic Charts
- Section 17 Pivot Tables
- Section 18 Working with Large Data
- Section 19 LookUp Functions
- Section 20 Advanced Functions
- Section 21 Excel Intermediate - Conclusion
- Section 22 Excel - Advanced
- Section 23 Working with Multiple Workbooks
- Section 24 Protecting Worksheets and Workbooks
- Section 25 Conditional Formulas
- Section 26 Advanced Functions
- Section 27 Text Based Functions
- Section 28 What IF Tools
- Section 29 Excel Advanced - Conclusion
- Section 30 Bonus # 1 - Advanced Pivot Tables
What You’ll Learn
- The complete guide to Excel 2019 - Beginner, Intermediate and Advanced
- Learn Microsoft Excel from Beginner to Advanced
- From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
- Master all the basics of Excel, even if you've never seen a spreadsheet before!
- Learn To Use Excel Like The Professionals
- Automate, streamline, and completely revolutionize your workflow with Excel
- Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros
Skills covered in this course
Reviews
-
DDarren Fauni
Section 4 parts 20 and 21 are repeats
-
RRacquel5
I found your instructions clear and quite easy to follow.
-
AAnjali
Fabulous
