Microsoft Excel – from Beginner to Advanced
This course created using Microsoft Excel 2016 but the same principles applies for Microsoft Excel 2010, 2013, 2019 and Office 365.
What you will learn
- Master Microsoft Excel from Beginner to Advanced
- Learn the most common Excel functions used in the Office
- Maintain large sets of Excel data in a list or table
- Unlock dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Build a solid understanding on the Basics of Microsoft Excel
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Access to a Professional Trainer with 12+ years of Excel Training experience
Requirements
This course was created with Microsoft Excel 2016. But the features will work in Excel 2010, 2013, 2019, Office 365, and most will work in 2007.
Description
This Microsoft Excel course combines 4 different courses into an all in One Package
- Microsoft Excel 201 – An Introduction to Excel
- Microsoft Excel 202 – Intermediate Level Excel
- Microsoft Excel 203 – Advance Level Excel
- Master Microsoft Excel Macros and VBA
Achievement
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more …)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day to day Excel tasks by mastering the power of Macros and VBA
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!
Who this course is for:
- If you want to learn Microsoft Excel from scratch, then this course if for you
- If you want to take your Excel skills from beginner to advanced level and beyond, then this course is for you
- This Microsoft Excel all in one course will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA)
Course Features
- Lectures 31
- Quizzes 1
- Duration 50 hours
- Skill level All levels
- Language English
- Students 2
- Certificate Yes
- Assessments Yes
-
Excel Basics
Get to know the Excel 2016 menus, how to create and open documents, as well as saving and sharing documents.
-
Working with Cells and Sheets
- Excel2016 – 05 – Cell Basics
- Excel2016 – 06 – Modifying Columns, Rows and Cells
- Excel2016 – 07 – Formatting Cells
- Excel2016 – 08 – Understanding Number Formats
- Excel2016 – 09 – Working with Multiple Worksheets
- Excel2016 – 10 – Using Find and Replace
- Excel2016 – 11 – Checking Spelling
- Excel2016 – 12 – Page Layout and Printing
-
Formulas and Functions
-
Working with Data
-
Doing More with Excel
-
Extras
-
Quiz
Test your knowledge of Excel by taking this Quiz