Microsoft Excel 2013 From Beginner To Advanced And Beyond

Tags: Excel

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

Last updated 2022-01-10 | 4.6

- 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

What you'll 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

* Requirements

* No Prior Excel Knowledge Required
* Microsoft Excel 2007
* 2010
* 2013
* 2013
* 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

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

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/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 a Microsoft Certified Trainer I will use my 20+ 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

What's Included?

  • 18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)

  • Downloadable Exercise Files to follow along and practice with

  • Additional Exercise Files are provided at the end of each major section (101, 102, 103 and VBA) that you can download and practice the skills you've learned

  • Section Quizzes to Test Your Knowledge on the Lecture Topics

  • QA board where you can post questions, screenshots of your progress and communicate with the instructor and fellow students in the course.

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Who this course is for:

  • 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.

Course content

42 sections • 230 lectures

Launching Excel Preview 01:41

Microsoft Excel Startup Screen Preview 03:15

Introduction to the Excel Interface Preview 07:10

Customizing the Excel Quick Access Toolbar Preview 02:56

More on the Excel Interface Preview 03:34

Understanding the Structure of an Excel Workbook Preview 03:58

Saving an Excel Document Preview 04:00

Opening an Existing Excel Document Preview 01:36

Common Excel Shortcut Keys Preview 02:47

Excel Fundamentals Quiz

Entering Text to Create Spreadsheet Titles Preview 08:15

Working with Numeric Data in Excel Preview 08:26

Entering Date Values in Excel Preview 08:37

Working with Cell References Preview 06:00

Creating Basic Formulas in Excel Preview 08:32

Relative Versus Absolute Cell References in Formulas Preview 12:33

Understanding the Order of Operation (DOWNLOAD EXERCISE FILE) Preview 10:36

Entering and Editing Text and Formulas Quiz

The structure of an Excel Function Preview 10:16

Working with the SUM() Function Preview 07:00

Working with the MIN() and MAX() Functions Preview 06:18

Working with the AVERAGE() Function Preview 02:51

Working with the COUNT() Function Preview 02:51

Adjacent Cells Error in Excel Calculations Preview 03:39

Using the AutoSum Command Preview 06:48

Excel's AutoSum Shortcut Key Preview 02:12

Using the AutoFill Command to Copy Formulas Preview 04:24

Basic Excel Functions Quiz

Moving and Copying Data in an Excel Worksheet Preview 06:33

Inserting and Deleting Rows and Columns Preview 07:13

Changing the Width and Height of Cells Preview 05:17

Hiding and Unhiding Excel Rows and Columns Preview 05:07

Renaming an Excel Worksheet Preview 02:51

Deleting an Excel Worksheet Preview 04:33

Moving and Copying an Excel Worksheet Preview 05:11

Modifying Worksheets Quiz

Working with Font Formatting Commands Preview 07:20

Changing the Background Color of a Cell Preview 03:09

Adding Borders to Cells Preview 02:24

Excel Cell Borders Continued Preview 03:13

Formatting Data as Currency Values Preview 04:28

Formatting Percentages Preview 02:52

Using Excel's Format Painter Preview 04:01

Creating Styles to Format Data Preview 07:10

Merging and Centering Cells Preview 03:16

Using Conditional Formatting Preview 04:23

Editing Excel Conditional Formatting Preview 02:25

Formatting Data Quiz

Inserting Images Preview 04:01

Inserting Excel Shapes Preview 02:29

Formatting Excel Shapes Preview 03:38

Working with Excel SmartArt Preview 08:24

Creating an Excel Column Chart Preview 03:22

Working with the Excel Chart Ribbon Preview 02:42

Adding and Modifying Data on an Excel Chart Preview 05:21

Formatting an Excel Chart Preview 06:36

Moving a Chart to another Worksheet Preview 03:34

Working with Excel Pie Charts Preview 07:08

Working with Excel Charts Quiz

Viewing your Document in Print Preview Preview 03:51

Changing the Margins, Scaling and Orientation Preview 08:12

Excel Worksheet Margins Preview 03:02

Working with Page Layout View Preview 03:23

Adding Header and Footer Content Preview 05:38

Printing a Specific Range of Cells Preview 03:01

Printing an Excel Worksheet Quiz

Intro to Excel Templates Preview 03:13

Opening an Existing Template Preview 08:43

Creating a Custom Template Preview 06:18

Excel Templates Quiz

Understanding Excel List Structure Preview 05:39

Sorting a List Using Single Level Sort Preview 03:47

Sorting a List Using Multi-Level Sorts Preview 03:46

Using Custom Sorts in an Excel List Preview 04:33

Filter an Excel List Using the AutoFilter Tool Preview 04:56

Creating Subtotals in a List Preview 06:36

Format a List as a Table Preview 07:30

Using Conditional Formatting to Find Duplicates Preview 03:53

Removing Duplicates Preview 04:10

Excel List Quiz

Introduction to Excels Function: DSUM() Preview 05:30

Excel DSUM Function Single Criteria Continued Preview 04:47

Excel DSUM Function with OR Criteria Preview 02:33

Excel DSUM Function with AND Criteria Preview 05:34

Excel Function: DAVERAGE() Preview 04:55

Excel Function: DCOUNT() Preview 06:29

Excel Function: SUBTOTAL() Preview 07:45

List Functions :Quiz

Understanding the Need for Excel Data Validation Preview 05:00

Creating an Excel Data Validation List Preview 05:24

Excel Decimal Data Validation Preview 04:15

Adding a Custom Excel Data Validation Error Preview 04:51

Dynamic Formulas by Using Excel Data Validation Techniques Preview 04:43

Data Validation Quiz

Importing Data Into Microsoft Excel Preview 01:42

Importing Data from Text Files Preview 05:34

Importing Data from Microsoft Access Preview 04:14

NEW VERSION -- Import Data From Text Files into Excel Preview 07:55

NEW VERSION -- Import Data From a Database into Excel Preview 06:19

Microsoft Excel Legacy Import Options for New Excel Versions Preview 01:59

Exporting Data to a Text File Preview 06:25

Importing and Exporting Data Quiz

Understanding Excel PivotTables Preview 03:52

Creating an Excel PivotTable Preview 06:31

Modifying Excel PivotTable Calculations Preview 05:36

Grouping PivotTable Data Preview 07:49

Formatting PivotTable Data Preview 04:09

Modifying PivotTable Calculations Preview 09:00

Drilling Down into PivotTable Data Preview 04:11

Creating PivotCharts Preview 04:02

Filtering PivotTable Data Preview 02:56

Filtering with the Slicer Tool Preview 02:58

Introduction to Excel Power Pivot Preview 04:36

Why PowerPivot? Preview 07:47

Activating the Excel PowerPivot AddIn Preview 03:18

Creating Data Models with PowerPivot Preview 04:54

Excel Power Pivot Data Model Relationships Preview 04:46

Creating PivotTables based on Data Models Preview 05:58

Excel Power Pivot KPIs Preview 11:00

Using the Freeze Panes Tool Preview 03:39

Grouping Data (Columns and/or Rows) Preview 04:17

Print Options for Large Sets of Data Preview 07:32

Linking Worksheets (3D Formulas) Preview 04:08

Consolidating Data from Multiple Worksheets Preview 05:30

Excel 102 - Practice What You've Learned (DOWNLOAD) Preview 00:09

Working with Excel Name Ranges Preview 04:22

Advantages and Disadvantages of Excel Name Ranges Preview 05:34

Editing an Excel Name Range Preview 02:33

Using Excel's IF() Function Preview 05:09

Excel's IF() Function with a Name Range Preview 05:23

Nesting Functions with Excel Preview 08:57

Nesting Excels AND() Function within the IF() Function Preview 04:38

Using Excel's COUNTIF() Function Preview 02:30

Using Excel's SUMIF() Function Preview 06:44

Using Excel's IFERROR() Function Preview 05:08

Microsoft Excel VLOOKUP() Function Preview 09:36

Microsoft Excel HLOOKUP() Function Preview 05:25

Microsoft Excel INDEX() Function Preview 09:25

Microsoft Excel MATCH() Function Preview 04:40

Microsoft Excel INDEX() and MATCH() Function Combined Preview 06:41

Microsoft Excel INDEX() and MATCH() Function Combined Continued Preview 08:44

Creating a Dynamic HLOOKUP() with the MATCH() Function Preview 07:16

Using Excel's LEFT(), RIGHT() and MID() Functions Preview 06:18

Using Excel's LEN() Function Preview 06:15

Using Excel's SEARCH() Function Preview 12:19

Using Excel's CONCATENATE() Function Preview 03:10

Tracing Precedents in Excel Formulas Preview 04:01

Tracing Dependents in Excel Formulas Preview 02:52

Working with the Watch Window Preview 04:19

Showing Formulas Preview 02:46

Protecting Specific Cells in a Worksheet Preview 08:05

Protecting the Structure of a Workbook Preview 04:13

Adding a Workbook Password Preview 03:15

Working with Excel's Goal Seek Tool Preview 07:41

Working with Excel's Solver Tool Preview 10:45

Building Effective Data Tables in Excel Preview 06:17

Creating Scenarios in Excel Preview 07:51

Understanding Excel Macros Preview 03:50

Activating the Developer Tab in Excel Preview 01:42

Creating a Macro with the Macro Recorder Preview 07:39

Editing a Macro with VBA Preview 05:16

Creating Buttons to Run Macros Preview 03:11

Excel 103 - Practice What You've Learned (DOWNLOAD) Preview 00:09

Congratulations on Completing the Microsoft Excel 103 Preview 01:39

Welcome to the Course Preview 05:50

Understanding the Why and How Behind Excel Macros Preview 05:15

Course Exercise Files - Download these First! Preview 00:16

Introduction to Project #1: Inserting and Formatting Text Preview 02:01

Project #1: Start Recording! Preview 07:40

Running A Macro Preview 02:43

Project #1: Running a Macro with a Button Preview 03:35

Project #1: Oops! I Need to Edit My Macro Preview 04:27

Practical Uses of Excel Macros Preview 02:16

Excel VBA Concepts Preview 03:32

The Visual Basic Editor (VBE) Preview 03:25

Excel VBA Modules Preview 02:01

Creating an Excel VBA Procedure Preview 08:17

Adding Code to a VBA Procedure Preview 04:04

Understanding Excel VBA Variables Preview 07:01

Building Logic with an IF Statement Preview 06:18

Working with Excel VBA Loops to Repeat Blocks of Code Preview 09:42

Introduction to Project #2: Interacting with the User Preview 02:56

Project #2: Breaking Down the VBA Code Preview 03:34

Project #2: Prompting the User for Information Preview 06:54

Continue Excel VBA InputBox Preview 07:20

Project #2: Building Logic into Your Macros Preview 04:31

Project #2: Alerting the User of Errors Preview 10:29

Other Practical Uses of Message and Input Boxes Preview 03:17

Introduction to Project #3: Cleaning Up and Formatting Data Preview 03:06

Project #3: Preparing to the Use the Macro Recorder Preview 02:54

Project #3: Inserting the Headers Preview 03:26

Project #3: Formatting the Headers Preview 02:21

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

Running the Loop Preview 02:54

Introduction to Project #4: Automate Excel Formulas Preview 02:10

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

Continue Automate SUM Function Preview 06:28

Test the SUM Function Preview 03:45

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

Introduction to Project #5: Creating the Final Report Preview 02:59

Project #5: Creating the Final Report Loop Preview 07:45

Project #5 - Copying and Pasting Data with VBA Preview 09:26

Project #5 - Running the Final Report Procedure Preview 03:14

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

Project #6: Creating an Excel User Form Preview 05:05

Project #6: Adding Controls to the Form Preview 04:01

Project #6: Adding VBA Code to the Initialize Event Preview 08:49

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

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

Change Worksheet Name Preview 03:58

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

Project #6: Showing the Form Preview 04:02

Project #7: Opening a Text File for Import Preview 02:42

Project #7: Opening a Text File for Import Preview 06:45

Project #7: Get Data from Text File Preview 05:30

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

Project #7: Creating a Loop to Read Each File Preview 07:26

Project #7: Adding a New Sheet for Imported Data Preview 02:36

Project #7: Clear the Clipboard Preview 03:38

Project #7: Working with the ScreenUpdating Property Preview 03:16

Project #7: Creating Reusable Code with a VBA Function Preview 07:44

Congratulations! You're an Excel Macro/VBA Master Preview 01:02