The Microsoft Training Bundle: ZERO to ADVANCED

6 Courses & 25 Hours

$36.99 CAD$78.00 CAD

You save 53%

What's Included

$13.00 CAD Value

Microsoft Excel: From ZERO to ADVANCED

LearningWhilePracticing

42 Lessons (7h)

Lifetime

Experience level required: Beginner
Access 42 lectures & 7 hours of content 24/7
Length of time users can access this course: Lifetime

Course Curriculum

42 Lessons (7h)

Your First Program
Preview

Section I: Getting Started with Excel

Chapter 1: Introducing Excel4:16
Chapter 2: Entering and Editing Worksheet Data9:28
Chapter 3: Performing Basic Worksheet Operations8:10
Chapter 4: Working with Excel Ranges and Tables4:08
Chapter 5: Formatting Worksheets11:34
Chapter 6: Understanding Excel Files and Templates3:37
Chapter 7: Printing Your Work7:13
Chapter 8: Customizing the Excel User Interface1:47
Section II: Working with Formulas and Functions

Chapter 9: Introducing Formulas and Functions5:26
Chapter 10: Using Formulas for Common Mathematical Operations7:41
Chapter 11: Using Formulas to Manipulate Text10:13
Chapter 12: Using Formulas with Dates and Times6:33
Chapter 13: Using Formulas for Conditional Analysis16:58
Chapter 14: Using Formulas for Matching and Lookups12:14
Chapter 15: Using Formulas for Financial Analysis11:56
Chapter 16: Using Formulas for Statistical Analysis11:44
Chapter 17: Understanding and Using Array Formulas7:47
Chapter 18: Making your Formulas Error-Free8:41
Section III: Creating Charts and Other Visualizations

Chapter 19: Getting Started with Excel Charts15:27
Chapter 20: Using Advanced Charting Techniques36:46
Chapter 21: Creating Sparkline Graphics5:50
Chapter 22: Visualizing with Customer Number Formats and Shapes20:02
Chapter 23: Implementing Excel Dashboarding Best Practices31:33
Section IV: Managing and Analyzing Data

Chapter 24: Importing and Cleaning Data10:08
Chapter 25: Using Data Validation9:47
Chapter 26: Worksheet Outlines3:47
Chapter 27: Linking and Consolidating5:55
Chapter 28: PivotTables16:38
Chapter 29: What-If Analysis15:11
Chapter 30: Goal Seek and Solver15:10
Chapter 31: ToolPak6:22
Chapter 32: Protecting Data3:56
Section V: Understanding PowerPivot and PowerQuery

Chapter 33: Introducing Power Pivot3:42
Chapter 34: Data Model7:57
Chapter 35: Adding Formulas to Power Pivot12:42
Chapter 36: Power Query10:52
Section VI: Automating Excel

Chapter 37: VBA14:45
Chapter 38: User Defined Functions6:32
Chapter 39: UserForm6:12
Chapter 40: UserForm Example12:19
Chapter 41: Excel Events4:15
Chapter 42: Add in6:49

Microsoft Excel: From ZERO to ADVANCED

LearningWhilePracticingLearningWhilePracticing 4.5/5 Instructor Rating: ★ ★ ★ ★ ★ ★

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

Description

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance, accounting, or administration, Microsoft Excel has the tools and libraries that will make your project come to life. If you have no knowledge whatsoever of this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

4.9/5 average rating: ★ ★ ★ ★ ★ ★

Access 42 lectures & 7 hours of content 24/7
Learn to create workbooks & spreadsheets
Acquire critical Excel knowledge including keyboard shortcuts
Learn how to add formulas to power pivot
Create custom Excel add-ins
Discover how to customize the Excel user interface
Learn how to work with Excel ranges & templates

NOTE: Software NOT included

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop & mobile
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner
Have questions on how digital purchases work? Learn more here

Requirements

Any version of Excel including Excel in Microsoft Office 365

$13.00 CAD Value

Microsoft Word: from ZERO to ADVANCED

LearningWhilePracticing

28 Lessons (9h)

Lifetime

$13.00 CAD Value

Microsoft Access: from ZERO to ADVANCED

LearningWhilePracticing

17 Lessons (3h)

Lifetime

$13.00 CAD Value

Microsoft PowerPoint: From ZERO to ADVANCED

LearningWhilePracticing

13 Lessons (4h)

Lifetime

$13.00 CAD Value

VLOOKUP & XLOOKUP in Excel

Kathryn Tilley

20 Lessons (1h)

Lifetime

$13.00 CAD Value

Conditional Formatting in Excel

Kathryn Tilley

8 Lessons (1h)

Lifetime

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...