Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel - Beginner, Intermediate & Advanced
Section 01: Excel from A-Z Course Introduction
Excel from A-Z Course Intro (3:20)
Excel Job Opportunities (2:43)
Excel Job Types (3:51)
Microsoft Excel Marketplace (4:08)
What is Microsoft Excel? (4:16)
What is Microsoft Excel? (3:30)
Section 02: Getting Started With Excel
Finding & Opening Excel (1:04)
Excel’s Start Screen (3:15)
Explaining the Excel Interface (2:43)
Excel Interface Continued (1:26)
Excel Workbook vs. Excel Worksheet (2:12)
Saving an Excel Document (3:33)
Customizing the Quick Access Toolbar (2:15)
Customizing the Excel Ribbon (3:04)
Excel Shortcut Keys (1:43)
Section 03: Values, Referencing and Formulas
Creating Excel Labels (2:32)
Entering Numeric Values in Excel (3:25)
Formatting Date Values in Excel (5:19)
Building Basic Formulas in Excel (4:44)
Order of Operations (6:28)
Relative vs. Absolute Cell References (7:23)
Section 04: Intro to Excel Functions
Excel Functions Explained (2:35)
The SUM() Function (7:31)
The MIN() & MAX() Function (3:44)
The AVERAGE() Function (2:00)
COUNT() Functions (4:57)
Section 05: Adjusting Excel Worksheets
Moving & Copying Data (6:45)
Insert & Delete Rows and Columns (5:04)
Adjusting the Width and Height of Cells (4:34)
Hiding and Unhiding Excel Rows and Columns (4:28)
Renaming, Moving & Deleting Excel Worksheets (5:27)
Adding Protection to Specific Cells (4:23)
Protecting the Structure of a Workbook (2:11)
Adding a Workbook Password to Open File (2:09)
Section 06: Visually Pleasing Cell Formatting
Formatting Fonts and Cell Background Color (4:54)
Adding Cell Borders (4:47)
Formatting Data Appropriately (5:21)
The Magic behind Excel’s Format Painter (3:29)
Creating Styles for Formatting Efficiency (5:55)
Merging Cells for a Cleaner Look (3:27)
The Power of Conditional Formatting (6:09)
Section 07: How to Insert Images and Shapes!
Grab User’s Attention using Illustrations (8:39)
Customizing Icons (4:41)
Create Compelling Graphics with SmartArt (5:36)
Section 08: Visualize Data with Charts
The Commonly Used Column Chart (2:45)
Changing the Chart Design (1:58)
Section 09: Excel’s Printing Options
Print Preview Options (4:25)
Excel’s Page Layout View (6:36)
Printing a Specific Range of Cells (2:38)
Converting Spreadsheets to PDF Files (2:28)
Section 10: Benefits of Using Excel Templates
Why Create an Excel Template (1:22)
How to Create an Excel Template (5:22)
Section 11: Working with Excel Datasets
How to Prepare Data for Analysis (4:01)
How to Sort Data in Excel (2:37)
Multi-Level Sorting (2:33)
Custom Sorting Datasets in Excel (2:26)
Applying Filters to Datasets (4:44)
Creating Subtotals within a Dataset (5:38)
Converting Datasets into Tables (5:55)
Little Slice of Pie Charts (5:11)
Finding & Removing Duplicate Values (7:29)
Section 12: Excel Database Functions
The SUMIF() Function (8:41)
The DSUM() Function (7:47)
The DSUM() Function Cont. (7:06)
The SUBTOTAL() Function (6:28)
Section 13: Excel Data Validation
What is Excel Data Validation? (1:56)
Creating a Drop Down List with Data Validation (7:08)
Different Types of Excel Data Validation (5:39)
Adding Custom Alerts to Data Validation (6:53)
Creating a Dynamic Drop Down List (3:09)
Complex Validation: Dependent Drop Down List! (8:38)
Section 14: Excel PivotTables
Creating an Excel Pivot Table (5:30)
Modifying Excel PivotTables (5:38)
Grouping & Filtering PivotTable Data (6:29)
Drilling Down into PivotTable Data (1:59)
Creating Pivot Charts & Utilizing Slicers (7:59)
Section 15: Excel’s PowerPivot Add-In
What is PowerPivot? (3:45)
Activating the Excel PowerPivot Add-In (1:33)
Creating Relationships between Data Tables (6:22)
Using Data Models to Create PivotTables (4:30)
How to Create PowerPivot KPI’s (8:26)
Section 16: Excel’s Conditional Functions
Excels IF Function (5:17)
IF() Function with AND() Criteria (5:23)
IF() Function with OR() Criteria (5:13)
Nesting Multiple IF() Functions (7:23)
The COUNTIF() Function (4:06)
Key Benefits of Named Ranges (4:10)
Section 17: Excel’s Lookup Function
VLOOKUP() Function (8:59)
The Beauty of Excel’s IFERROR() Function (3:55)
HLOOKUP() Function (6:21)
The INDEX Function (4:42)
MATCH() Function (4:55)
INDEX() and MATCH() Combined (5:08)
Two-Way Lookup with INDEX() and MATCH() (4:10)
Section 18: Text Based Functions in Excel
LEFT(), RIGHT() and MID() Function (7:08)
Extracting Specific Text using LEN() & SEARCH() (12:44)
Combining Text with CONCATENATE() (6:05)
Quick Tips & Other Text Based Functions (5:48)
Section 19: Auditing Formulas and Views in Excel
Tracing Precedents & Dependents in Formulas (4:28)
Showing Formulas (1:53)
Grouping Data (2:42)
3D Referencing in Formulas (5:04)
Utilizing the Watch Window in Excel (2:44)
How to Freeze Panes in Excel (2:55)
Section 20: Excel’s “what If?” Tools
Excel’s Scenario Manager Tool (5:55)
Goal Seek in Excel (6:15)
Compare Results with Excel Data Tables (4:23)
Solver Tool (10:59)
Section 21: Welcome to Excel VBA
The Power Behind Excel VBA (2:35)
A Look Inside the Visual Basic Editor (VBE) (3:56)
Recording a Macro (9:11)
Saving & Opening a Macro-Enabled Workbook (2:13)
Section 22: The VBA Language
Modules and Procedures (6:33)
Using Variables in VBA Code (4:32)
Excel VBA Variables (4:38)
Section 23: Writing VBA Code
Referencing a Range (13:30)
InputBox & MsgBox (5:32)
If Then Else Statement (10:22)
Worksheet Functions inside VBA (7:32)
Creating User Defined Functions (9:19)
User Defined Functions within VBA Scripts (6:08)
Section 24: Important VBA Tools and Logic
Find Last Row of Data (5:45)
Find Last Column of Data (3:12)
With Statement (4:51)
Debugging & Error Handling (6:36)
Debugging & Error Handling Cont. (6:45)
Section 25: Excel VBA Loop
For Next Loop (9:12)
Do Until Loop (6:03)
For Each Loop (3:36)
Section 26: Triggering Macros
Assigning Macros to Shapes (3:33)
Form Controls vs ActiveX Controls (7:50)
Worksheet Events (3:43)
Workbook Events (2:54)
Fun with VBA Events! (6:54)
Section 27: Excel User Forms
Creating an Excel UserForm (3:15)
Adding Controls to UserForms (10:00)
How to Show an UserForm (3:01)
Passing TextBox Values to Desired Cells (6:50)
Passing Option Buttons to Desired Cells (6:36)
UserForm ComboBoxes (8:08)
Clearing Values from UserForm Controls (3:06)
How to Close an UserForm (1:33)
UserForms and Protected Sheets (4:40)
Section 28: Starting a Career in Excel
Getting Started with Freelancing (6:15)
Creating an Excel Resume (4:51)
How to Become an Excel Freelancer (5:12)
Top Freelance Websites (5:12)
How to Get Your First Client (7:45)
Personal Branding (6:47)
Formatting Elements of a Chart (6:23)
Networking Do’s and Don’ts (4:21)
Importance of Having a Website (4:24)
Modifying the Data, Type & Location of a Chart (6:06)
Creating Subtotals within a Dataset
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock