Udemy

Platform

English

Language

Microsoft

Category

Microsoft Excel - Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365

4.61 (192785 reviews)

619285

Students

17.5 hours

Content

May 2020

Last Update
$149.99
Regular Price

What you will learn

Master Microsoft Excel from Beginner to Advanced

Build a solid understanding on the Basics of Microsoft Excel

Learn the most common Excel functions used in the Office

Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA

Maintain large sets of Excel data in a list or table

Create dynamic reports by mastering one of the most popular tools, PivotTables

Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Access to a Professional Trainer with 10+ years of Excel Training


Topics

Excel


Description

Microsoft Excel all in One Package

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

Material recorded with Excel 2013 but works in 2010, 2013, 2016, 2019 (Office 365)

Recent Student Review

  • "You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don't doubt it, buy it. I've learned so much in this course. Hope more courses are on the way because I'd buy every single one of them. Thanks again bro. God bless you and your family."

  • "Happy to say that I now "know" excel. I realize there is so much more to learn, but it's a start! Thank you for being such a great instructor... now on to the next class."

  • "Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them."

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

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.

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 Add-In, 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 Newb to Excel Guru!


Screenshots

Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel - Excel from Beginner to Advanced

Content

Microsoft Excel 101 Course Introduction

Ask Questions

Course Exercise Files

Certificate of Completion

Microsoft Excel Fundamentals

Launching Excel

Microsoft Excel Startup Screen

Introduction to the Excel Interface

Customizing the Excel Quick Access Toolbar

More on the Excel Interface

Understanding the Structure of an Excel Workbook

Saving an Excel Document

Opening an Existing Excel Document

Common Excel Shortcut Keys

Excel Fundamentals Quiz

Entering and Editing Text and Formulas

Entering Text to Create Spreadsheet Titles

Working with Numeric Data in Excel

Entering Date Values in Excel

Working with Cell References

Creating Basic Formulas in Excel

Relative Versus Absolute Cell References in Formulas

Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)

Entering and Editing Text and Formulas Quiz

Working with Basic Excel Functions

The structure of an Excel Function

Working with the SUM() Function

Working with the MIN() and MAX() Functions

Working with the AVERAGE() Function

Working with the COUNT() Function

Adjacent Cells Error in Excel Calculations

Using the AutoSum Command

Excel's AutoSum Shortcut Key

Using the AutoFill Command to Copy Formulas

Basic Excel Functions Quiz

Modifying an Excel Worksheet

Moving and Copying Data in an Excel Worksheet

Inserting and Deleting Rows and Columns

Changing the Width and Height of Cells

Hiding and Unhiding Excel Rows and Columns

Renaming an Excel Worksheet

Deleting an Excel Worksheet

Moving and Copying an Excel Worksheet

Modifying Worksheets Quiz

Formatting Data in an Excel Worksheet

Working with Font Formatting Commands

Changing the Background Color of a Cell

Adding Borders to Cells

Formatting Data as Currency Values

Formatting Percentages

Using Excel's Format Painter

Creating Styles to Format Data

Merging and Centering Cells

Using Conditional Formatting

Formatting Data Quiz

Inserting Images and Shapes into an Excel Worksheet

Inserting Images

Inserting Excel Shapes

Formatting Excel Shapes

Working with Excel SmartArt

Creating Basic Charts in Excel

Creating an Excel Column Chart

Working with the Excel Chart Ribbon

Adding and Modifying Data on an Excel Chart

Formatting an Excel Chart

Moving a Chart to another Worksheet

Working with Excel Pie Charts

Working with Excel Charts Quiz

Printing an Excel Worksheet

Viewing your Document in Print Preview

Changing the Margins, Scaling and Orientation

Working with Page Layout View

Adding Header and Footer Content

Printing a Specific Range of Cells

Printing and Excel Worksheet Quiz

Working with Excel Templates

Intro to Excel Templates

Opening an Existing Template

Creating a Custom Template

Congratulations! You've Built a Solid Microsoft Excel Foundation

Congratulations!

Microsoft Excel 102 Course Introduction

Course Exercise Files - Download these First!

Working with an Excel List

Understanding Excel List Structure

Sorting a List Using Single Level Sort

Sorting a List Using Multi-Level Sorts

Using Custom Sorts in an Excel List

Filter an Excel List Using the AutoFilter Tool

Creating Subtotals in a List

Format a List as a Table

Using Conditional Formatting to Find Duplicates

Removing Duplicates

Excel List Functions

Excel Function: DSUM()

Excel Function: DAVERAGE()

Excel Function: DCOUNT()

Excel Function: SUBTOTAL()

Excel Data Validation

Understanding the Need for Data Validation

Creating a Validation List

Adding a Custom Validation Error

Dynamic Formulas by Using Validation Techniques

Importing and Exporting Data

Importing Data from Text Files

Importing Data from Microsoft Access

Exporting Data to a Text File

Excel PivotTables

Understanding Excel PivotTables

Creating an Excel PivotTable

Modifying Excel PivotTable Calculations

Grouping PivotTable Data

Formatting PivotTable Data

Drilling Down into PivotTable Data

Creating PivotCharts

Filtering PivotTable Data

Filtering with the Slicer Tool

Working with Excel's PowerPivot Tools

Why PowerPivot?

Activating the Excel PowerPivot AddIn

Creating Data Models with PowerPivot

Creating PivotTables based on Data Models

PowerPivot Calculated Fields

PowerPivot KPIs

Working with Large Sets of Excel Data

Using the Freeze Panes Tool

Grouping Data (Columns and/or Rows)

Print Options for Large Sets of Data

Linking Worksheets (3D Formulas)

Consolidating Data from Multiple Worksheets

Congratulations! You're an Intermediate Excel User

Congratulations!

Microsoft Excel 103 Course Introduction

Course Excerise Files - Download this Excel File First!

Working with Excel's Conditional Functions

Working with Excel Name Ranges

Using Excel's IF() Function

Nesting Functions

Using Excel's COUNTIF() Function

Using Excel's SUMIF() Function

Using Excel's IFERROR() Function

Working with Excel's Lookup Functions

Using Excel's VLOOKUP() Function

Using Excel's HLOOKUP() Function

Using Excel's INDEX() and MATCH() Functions

Working with Excel's Text Based Functions

Using Excel's LEFT(), RIGHT() and MID() Functions

Using Excel's LEN() Function

Using Excel's SEARCH() Function

Using Excel's CONCATENATE() Function

Auditing an Excel Worksheet

Tracing Precendents in Excel Formulas

Tracing Dependents in Excel Formulas

Working with the Watch Window

Showing Formulas

Protecting Excel Worksheets and Workbooks

Protecting Specific Cells in a Worksheet

Protecting the Structure of a Workbook

Adding a Workbook Password

Mastering Excel's "What If?" Tools

Working with Excel's Goal Seek Tool

Working with Excel's Solver Tool

Building Effective Data Tables in Excel

Creating Scenarios in Excel

Automating Repetitive Tasks in Excel with Macros

Understanding Excel Macros

Activating the Developer Tab in Excel

Creating a Macro with the Macro Recorder

Editing a Macro with VBA

Creating Buttons to Run Macros

Congratulations!

Congratulations on Competing the Microsoft Excel 103

Microsoft Excel Macros and VBA Course Introduction

Welcome to the Course

Understanding the Why and How Behind Excel Macros

Course Exercise Files - Download these First!

Project #1: Using Excel's Macro Recorder Tool

Introduction to Project #1: Inserting and Formatting Text

Project #1: Start Recording!

Running A Macro

Project #1: Running a Macro with a Button

Project #1: Opps! I Need to Edit My Macro

Practical Uses of Excel Macros

Excel VBA Concepts

Excel VBA Concepts

The Visual Basic Editor (VBE)

Excel VBA Modules

Creating an Excel VBA Procedure

Adding Code to a VBA Procedure

Understanding Excel VBA Variables

Building Logic with an IF Statement

Working with Excel VBA Loops to Repeat Blocks of Code

Project #2: Moving Beyond the Basics and into VBA

Introduction to Project #2: Interacting with the User

Project #2: Breaking Down the VBA Code

Project #2: Prompting the User for Information

Continue Excel VBA InputBox

Project #2: Building Logic into Your Macros

Project #2: Alerting the User of Errors

Other Practical Uses of Message and Input Boxes

Project #3: Preparing and Cleaning Up Data with a Little VBA

Introduction to Project #3: Cleaning Up and Formatting Data

Project #3: Preparing to the Use the Macro Recorder

Project #3: Inserting the Headers

Project #3: Formatting the Headers

Project #3: Putting it all Together with a Little VBA

Running the Loop

Project #4: Using VBA to Automate Excel Formulas

Introduction to Project #4: Automate Excel Formulas

Project #4: Automate the SUM() Function through Code

Continue Automate SUM Function

Test the SUM Function

Project #4: Loop the SUM() Function Over Multiple Worksheets

Project #5: Bringing it All Together and a Weekly Report

Introduction to Project #5: Creating the Final Report

Project #5: Creating the Final Report Loop

Project #5 - Copying and Pasting Data with VBA

Project #5 - Running the Final Report Procedure

Project #6: Working with Excel VBA User Forms

Introduction to Project #6: Working with Excel VBA User Forms

Project #6: Creating an Excel User Form

Project #6: Adding Controls to the Form

Project #6: Adding VBA Code to the Initialize Event

Project #6: Adding VBA Code to the ComboBox Change Event

Project #6: Adding VBA Code to the Add Worksheet Button

Change Worksheet Name

Project #6: Adding VBA Code to the Create Report Button

Project #6: Showing the Form

Project #7: Importing Data from Text Files

Project #7: Opening a Text File for Import

Project #7: Opening a Text File for Import

Project #7: Get Data from Text File

Project #7: Importing Multiple Text Files with the GetOpenFilename Method

Project #7: Creating a Loop to Read Each File

Project #7: Adding a New Sheet for Imported Data

Project #7: Clear the Clipboard

Project #7: Working with the ScreenUpdating Property

Project #7: Creating Reusable Code with a VBA Function

Course Wrap Up

Congratulations! You're an Excel Macro/VBA Master

BONUS! - Special Offer! Discount on Any of my Courses!



Reviews

E
Eric8 October 2020

Content is very good. Video is playing faster than downloading causing many buffering pauses. It's not my internet speed.

J
Jennifer8 October 2020

I highly recommend this course. I am on a Mac, so some code did not work for me and the link given to substitute code on a Man was confusing. This was in a later module.

J
John8 October 2020

it will be, I have a decent amount of experience using excel, so all of the information so far is very basic to me

M
Miriam8 October 2020

I was very happy with the course and the instructions were thoughtful and very good to understand. Sadly, since I was using a Mac I thought that sometimes the instructions for mac could have been more precise.

P
Peace8 October 2020

An insightful and helpful course. I learn't a lot. With more practice, I will get a good grasp of the concepts

C
Caitlin26 February 2020

I am a beginner in every sense of the word. When it comes to technology, I need to really slow down and rewatch curriculum before it can totally sink in and for that reason this platform is working great so far! Any time I need to pause, rewind and rewatch I have the power to do so and the best part is, its all in my own timeframe.

S
Sarah26 February 2020

I use excel at work but am aware that there's so much more that I don't know about. So the beginning bit has been a bit slow. That said, I'm learning new snippets, so that's good.

M
Mary26 February 2020

Clear explanations. While most students may not need to know this basic information, it is likely invaluable for true beginners.

Z
Ziyanda26 February 2020

I am not a tech savvy person and I do not know my way around excel but this course is really informative thus far...

O
Oluwatosin26 February 2020

Amazing Teaching. Step-by Step breakdown on how to use Excel from a beginner to an expert user. I strongly recommend.

C
Christina26 February 2020

I was pretty intimidated by taking this course. So far the pace is very gentle and encouraging. Thank you for that.

S
Surendra26 February 2020

i just started my excel course in here and it's going good. need to go further to understand about the concepts & have to see the explanation on tougher concepts (which i don't know like VBA ).

A
Anirudha26 February 2020

A really well compiled course which covers all the aspects of excel.The lectures are delivered in such a way that the topics are made simple to understand.

K
Kendra25 February 2020

Just starting, but this seems to be a good intro to Excel. I have been a stay at home mom for 13 years and starting back into the work force. Excel is being used for EVERYTHING these days and my knowledge would be considered entry level at most. Can't wait to learn more!

F
Frederika25 February 2020

I like the way the course does not make any assumptions as to what the student may already know, and covers all the basics.


Coupons

StatusDateDiscount
Expired4/14/202089% OFF


793796

Udemy ID

3/15/2016

Course created date

3/17/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore