Study Learn Grow
Master Microsoft Excel - Excel from Beginner to Advanced

Master Microsoft Excel - Excel from Beginner to Advanced


This course was created with Excel 2016. However, Excel 2007, 2010, 2013, 2016, 2019 and 365 will work with most, or all features

Overview

About this Course
Microsoft Excel All-In-One Training

This Microsoft Excel course includes all three Levels from Beginner to Advanced

Microsoft Excel Level 1 - Beginner
Microsoft Excel Level 2 - Intermediate
Microsoft Excel Level 3 - Advanced
As your instructor I will use my 16+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.

At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both: Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified, like me. Below are just a few of the topics that you will master:

Creating effective worksheets
Writing and editing formulas and calculations
Use sorting and filtering options
Build a database right the first time and avoid common design flaws
Creating informative and captivating Charts
Eliminate repetitive tasks instantly using Macros
Create many scenarios with varying groups of data
Manage large ranges of data in a List or Table
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
Basic knowledge
This course was created with Excel 2016. However, Excel 2007, 2010, or 2013 will work with most, or all features
You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

Course Information

This course was created with Excel 2016. However, Excel 2007, 2010, 2013, 2016, 2019 and 365 will work with most, or all features
You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

What you will learn
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Writing Formulas and performing Calculations
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
Create charts with Trend Lines, and Dual Axis
Use Excel as a Database with Sort and Filter options
How to avoid the most common Database Design flaws
Taught by Certified Microsoft Office Excel 2016 Specialist and Expert with over 16 years of Excel training

This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs