Microsoft Excel from Beginner to Advanced Course Lifetime Deal

190 Lessons (15h)

• Microsoft Excel Course Introduction
• Microsoft Excel Fundamentals
• Entering and Editing Text and Formulas
• Working with Basic Excel Funtions
• Modifying an Excel Worksheet
• Formatting Data in an Excel Worksheet
• Inserting Images and Shapes into an Excel Worksheet
• Creating Basic Charts in Excel
• Printing an Excel Worksheet
• Working with Excel Templates
• Congratulations! You’ve Built a Solid Microsoft Excel Foundation
• Working with an Excel List
• Excel List Functions
• Excel Data Validation
• Importing and Exporting Data
• Excel PivoTables
• Working with Excel’s PowerPivot Tools
• Working with Large Sets of Excel Data
• Congratulations! You’re an Intermediate Excel User
• Working with Excel’s Conditional Functions
• Working with Excel’s Lookup Functions
• Working with Excel’s Text Based Functions
• Auditing an Excel Worksheet
• Protecting Excel Worksheets and Workbooks
• Mastering Excel’s “What If?” Tools
• Automating Repetitive Tasks in Excel with Macros
• Microsoft Excel Macros and VBA Course Introduction
• Project #1: Using Excel’s Macro Recorder Tool
• Excel VBA Concepts
• Project #2: Moving Beyond the Basics and into VBA
• Project #3: Preparing and Cleaning Up Data with a Little VBA
• Project #4: Using VBA to Automate Excel Formulas
• Project #5: Bringing it All Together and a Weekly Report
• Project #6: Working with Excel VBA User Forms
• Project #7: Importing Data from Text Files