Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel Course Introduction
Welcome to the Ultimate Microsoft Excel Course (7:12)
Course Exercise Files (1:09)
Microsoft Excel Fundamentals
Launching Excel (2:34)
Introduction to the Excel Interface (4:50)
Customizing the Excel Quick Access Toolbar (3:53)
Understanding the Structure of an Excel Workbook (5:02)
Saving an Excel Document (2:44)
Opening an Existing Excel Document (2:02)
Entering and Editing Text and Formulas
Entering Text to Create Spreadsheet Titles (5:35)
Working With Numeric Data in Excel (3:31)
Entering Date Values in Excel (4:44)
Working with Cell References (3:55)
Creating Basic Formulas in Excel (7:02)
Relative Versus Absolute Cell References in Formulas (10:38)
Understanding the Order of Operation (3:20)
Working with Basic Excel Funtions
The structure of an Excel Function (3:40)
Working with the SUM() Function (4:50)
Working with the MIN() and MAX() Functions (3:47)
Working with the AVERAGE() Function (2:38)
Working with the COUNT() Function (2:15)
Using the AutoSum Command (4:55)
Using the AutoFill Command to Copy Formulas (3:09)
Modifying an Excel Worksheet
Moving and Copying Data in an Excel Worksheet (4:34)
Inserting and Deleting Rows and Columns (5:27)
Changing the Width and Height of Cells (5:06)
Hiding and Unhiding Excel Rows and Columns (2:51)
Deleting an Excel Worksheet (2:53)
Renaming an Excel Worksheet (1:58)
Moving and Copying and Excel Worksheet (4:12)
Formatting Data in an Excel Worksheet
Working with Font Formatting Commands (3:53)
Changing the Background Color of a Cell (2:50)
Adding Borders to Cells (3:33)
Formatting Data as Currency Values (5:21)
Formatting Percentages (2:17)
Using Excel's Format Painter (2:47)
Creating Styles to Format Data (8:12)
Merging and Centering Cells (2:50)
Using Conditional Formatting (4:34)
Inserting Images and Shapes into an Excel Worksheet
Inserting Images (4:09)
Inserting Excel Shapes (3:55)
Formatting Excel Shapes (4:39)
Working with Excel SmartArt (6:46)
Creating Basic Charts in Excel
Creating an Excel Column Chart (4:53)
Working with the Excel Chart Ribbon (5:23)
Adding and Modifying Data on an Excel Chart (3:08)
Formatting an Excel Chart (4:40)
Moving a Chart to another Worksheet (2:31)
Working with Excel Pie Charts (5:06)
Printing an Excel Worksheet
Viewing your Document in Print Preview (2:11)
Changing the Margins, Scaling and Orientation (8:06)
Working with Page Layout View (3:49)
Adding Header and Footer Content (4:35)
Printing a Specific Range of Cells (2:58)
Working with Excel Templates
Intro to Excel Templates (1:31)
Opening an Existing Template (5:33)
Creating a Custom Template (4:36)
Congratulations! You've Built a Solid Microsoft Excel Foundation
Congratulations! (0:52)
Excel 102 Exercise Files
Download Excel 102 Exercise Files
Working with an Excel List
Understanding Excel List Structure (5:39)
Sorting a List Using Single Level Sort (3:46)
Sorting a List Using Multi-Level Sorts (3:46)
Using Custom Sorts in an Excel List (4:33)
Filter an Excel List Using the AutoFilter Tool (4:56)
Creating Subtotals in a List (6:36)
Format a List as a Table (7:30)
Using Conditional Formatting to Find Duplicates (3:52)
Removing Duplicates (4:10)
Excel List Functions
Excel Function: DSUM() (6:35)
Excel Function: DAVERAGE() (2:47)
Excel Function: DCOUNT() (3:02)
Excel Function: SUBTOTAL() (6:15)
Excel Data Validation
Understanding the Need for Data Validation (5:13)
Creating a Validation List (5:37)
Adding a Custom Validation Error (4:37)
Dynamic Formulas by Using Validation Techniques (4:24)
Importing and Exporting Data
Importing Data from Text Files (5:34)
Importing Data from Microsoft Access (4:14)
Exporting Data to a Text File (4:13)
Excel PivotTables
Understanding Excel PivotTables (3:44)
Creating an Excel PivotTable (6:20)
Modifying Excel PivotTable Calculations (6:37)
Grouping PivotTable Data (4:43)
Formatting PivotTable Data (4:24)
Drilling Down into PivotTable Data (3:31)
Creating PivotCharts (4:40)
Filtering PivotTable Data (3:47)
Filtering with the Slicer Tool (3:44)
Working with Excel's PowerPivot Tools
Why PowerPivot? (4:50)
Activating the Excel PowerPivot AddIn (2:26)
Creating Data Models with PowerPivot (6:37)
Creating PivotTables based on Data Models (3:51)
PowerPivot Calculated Fields (3:51)
PowerPivot KPIs (7:06)
Working with Large Sets of Excel Data
Using the Freeze Panes Tool (3:39)
Grouping Data (Columns and/or Rows) (4:17)
Print Options for Large Sets of Data (7:32)
Linking Worksheets (3D Formulas) (4:08)
Consolidating Data from Multiple Worksheets (5:30)
Congratulations! You're an Intermediate Excel User
Congratulations! (0:42)
Excel 103 Exercise Files
Download Excel 103 Exercise Files
Working with Excel's Conditional Functions
Working with Excel Name Ranges (5:10)
Using Excel's IF() Function (6:09)
Nesting Functions (7:43)
Using Excel's COUNTIF() Function (3:55)
Using Excel's SUMIF() Function (5:40)
Using Excel's IFERROR() Function (6:05)
Working with Excel's Lookup Functions
Using Excel's VLOOKUP() Function (7:39)
Using Excel's HLOOKUP() Function (4:22)
Using Excel's INDEX() and MATCH() Functions (13:20)
Working with Excel's Text Based Functions
Using Excel's LEFT(), RIGHT() and MID() Functions (6:18)
Using Excel's LEN() Function (6:15)
Using Excel's SEARCH() Function (12:19)
Using Excel's CONCATENATE() Function (3:10)
Auditing an Excel Worksheet
Tracing Precendents in Excel Formulas (4:01)
Tracing Dependents in Excel Formuals (2:52)
Working with the Watch Window (4:19)
Showing Formulas (2:46)
Protecting Excel Worksheets and Workbooks
Protecting Specific Cells in a Worksheet (8:05)
Protecting the Structure of a Workbook (4:12)
Adding a Workbook Password (3:15)
Mastering Excel's "What If?" Tools
Working with Excel's Goal Seek Tool (7:41)
Working with Excel's Solver Tool (9:32)
Building Effective Data Tables in Excel (6:17)
Creating Scenarios in Excel (7:51)
Automating Repetitive Tasks in Excel with Macros
Understanding Excel Macros (3:50)
Activating the Developer Tab in Excel (1:42)
Creating a Macro with the Macro Recorder (7:39)
Editing a Macro with VBA (5:16)
Creating Buttons to Run Macros (3:11)
Congratulations!
Congratulations on Competing the Microsoft Excel 103 (0:58)
Microsoft Excel Macros and VBA Course Introduction
Welcome to the Course (5:50)
Understanding the Why and How Behind Excel Macros (5:15)
Course Exercise Files - Download these First!
Project #1: Using Excel's Macro Recorder Tool
Introduction to Project #1: Inserting and Formatting Text (2:01)
Project #1: Start Recording! (7:40)
Running A Macro (2:43)
Project #1: Running a Macro with a Button (3:35)
Project #1: Opps! I Need to Edit My Macro (4:27)
Practical Uses of Excel Macros (2:16)
Excel VBA Concepts
New Lecture
Excel VBA Concepts (3:32)
The Visual Basic Editor (VBE) (3:25)
Excel VBA Modules (2:01)
Creating an Excel VBA Procedure (8:17)
Adding Code to a VBA Procedure (4:04)
Understanding Excel VBA Variables (7:01)
Building Logic with an IF Statement (6:18)
Working with Excel VBA Loops to Repeat Blocks of Code (9:42)
Project #2: Moving Beyond the Basics and into VBA
Introduction to Project #2: Interacting with the User (2:56)
Project #2: Breaking Down the VBA Code (3:34)
Project #2: Prompting the User for Information (6:54)
Continue Excel VBA InputBox (7:20)
Project #2: Building Logic into Your Macros (4:31)
Project #2: Alerting the User of Errors (10:29)
Other Practical Uses of Message and Input Boxes (3:17)
Project #3: Preparing and Cleaning Up Data with a Little VBA
Introduction to Project #3: Cleaning Up and Formatting Data (3:06)
Project #3: Preparing to the Use the Macro Recorder (2:54)
Project #3: Inserting the Headers (3:26)
Project #3: Formatting the Headers (2:21)
Project #3: Putting it all Together with a Little VBA (10:47)
Running the Loop (2:54)
Project #4: Using VBA to Automate Excel Formulas
Introduction to Project #4: Automate Excel Formulas (2:10)
Project #4: Automate the SUM() Function through Code (8:01)
Continue Automate SUM Function (6:28)
Test the SUM Function (3:45)
Project #4: Loop the SUM() Function Over Multiple Worksheets (6:17)
Project #5: Bringing it All Together and a Weekly Report
Introduction to Project #5: Creating the Final Report (2:59)
Project #5: Creating the Final Report Loop (7:45)
Project #5 - Copying and Pasting Data with VBA (9:26)
Project #5 - Running the Final Report Procedure (3:14)
Project #6: Working with Excel VBA User Forms
Introduction to Project #6: Working with Excel VBA User Forms (3:01)
Project #6: Creating an Excel User Form (5:05)
Project #6: Adding Controls to the Form (4:01)
Project #6: Adding VBA Code to the Initialize Event (8:49)
Project #6: Adding VBA Code to the ComboBox Change Event (4:32)
Project #6: Adding VBA Code to the Add Worksheet Button (3:28)
Change Worksheet Name (3:58)
Project #6: Adding VBA Code to the Create Report Button (8:52)
Project #6: Showing the Form (4:02)
Project #7: Importing Data from Text Files
Project #7: Opening a Text File for Import (2:42)
Project #7: Opening a Text File for Import (6:45)
Project #7: Get Data from Text File (5:30)
Project #7: Importing Multiple Text Files with the GetOpenFilename Method (9:32)
Project #7: Creating a Loop to Read Each File (7:26)
Project #7: Adding a New Sheet for Imported Data (2:36)
Project #7: Clear the Clipboard (3:38)
Project #7: Working with the ScreenUpdating Property (3:16)
Project #7: Creating Reusable Code with a VBA Function (7:44)
Course Wrap Up
Congratulations! You're an Excel Macro/VBA Master (1:02)
Using Excel's LEFT(), RIGHT() and MID() Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock