watching now
4 Students
153 Lessons
Beginner

What Will You Learn?

  • Learn to master Excel from A-Z
  • How to be a better, faster, stronger Excel user
  • How to save hours of time and boost your productivity in Excel
  • How to use math, statistical, logic and text functions
  • How to use VLOOKUP/HLOOKUP in formulas

Curriculum

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