Master Microsoft Excel from Beginner to Advanced

Do you want to build a solid understanding of the Basics of Microsoft Excel, learn the most common Excel functions used in the Office, and harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA?

At the completion of the Udemy course “Microsoft Excel – Excel from Beginner to Advanced” you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. You will be able to create effective spreadsheets, manage large sets of data, use some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…), create dynamic reports with Excel PivotTables, and automate your day to day Excel tasks by mastering the power of Macros and VBA.

Microsoft Excel – Excel from Beginner to Advanced – Course Content

This Microsoft Excel course combines 4 different courses.

Microsoft Excel 101 – An Introduction to Excel
Microsoft Excel 102 – Intermediate Level Excel
Microsoft Excel 103 – Advanced Level Excel
Master Microsoft Excel Macros and VBA in 6 Simple Projects

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

The course comprises 211 lectures organized into the following sections:

Microsoft Excel 101 Course Introduction
Microsoft Excel Fundamentals
Entering and Editing Text and Formulas
Working with Basic Excel Functions
Modifying an Excel Worksheet
Formatting Data in an Excel Worksheet
Inserting Images and Shapes into an Excel Worksheet
Creating Basic Charts in Excel
Printing an Excel Worksheet
Working with Excel Templates
Congratulations! You’ve Built a Solid Microsoft Excel Foundation
Microsoft Excel 102 Course Introduction
Working with an Excel List
Excel List Functions
Excel Data Validation
Importing and Exporting Data
Excel PivotTables
Working with Excel’s PowerPivot Tools
Working with Large Sets of Excel Data
Congratulations! You’re an Intermediate Excel User
Microsoft Excel 103 Course Introduction
Working with Excel’s Conditional Functions
Working with Excel’s Lookup Functions
Working with Excel’s Text-Based Functions
Auditing an Excel Worksheet
Protecting Excel Worksheets and Workbooks
Mastering Excel’s “What If?” Tools
Automating Repetitive Tasks in Excel with Macros
Congratulations!
Microsoft Excel Macros and VBA Course Introduction
Project #1: Using Excel’s Macro Recorder Tool
Excel VBA Concepts
Project #2: Moving Beyond the Basics and into VBA
Project #3: Preparing and Cleaning Up Data with a Little VBA
Project #4: Using VBA to Automate Excel Formulas
Project #5: Bringing it All Together and a Weekly Report
Project #6: Working with Excel VBA User Forms
Project #7: Importing Data from Text Files
Course Wrap Up

Requirements

This course was created with Excel 2013. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.

Summary of Main Course Features

Instructor: Kyle Pew – Microsoft Certified Trainer – 240,000+ Udemy Students
Lectures: 211
On-demand video: 7.5 hours
Articles: 2
Downloadable Resources: 37
Includes:
- 30-Day Money-Back Guarantee
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion