Microsoft Excel

Online Excel Training Course: Microsoft Excel from Beginner to Advanced

Microsoft Excel Online Training: Excel from Beginner to Advanced
Enroll into Microsoft Excel Training Course and become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, Excel 2013, Excel 2016, 365)

 4.5 (43 ratings)

What Will I Learn?

  • Build a solid understanding on the Basics of Microsoft Excel
  • Master Microsoft Excel from Beginner to Advanced
  • Writing Formulas and performing Calculations
  • Create charts with Trend Lines, and Dual Axis
  • Use Excel as a Database with Sort and Filter options
  • How to avoid the most common Database Design flaws
  • Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more...
  • Taught by Certified Microsoft Office Excel 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist and Expert with over 17 years of Excel training!

Course Requirements

  • You will need Microsoft Excel installed on your computer to follow along and complete the exercise files
  • This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016, 365 and most in 2007

Course Description

All-In-One Microsoft Excel Training

This Microsoft Excel course includes all three Levels from Beginner to Advanced

  • Microsoft Excel Level 1 – Excel Training for Beginner
  • Microsoft Excel Level 2 – Excel Training for Intermediate
  • Microsoft Excel Level 3 – Excel Training for Advanced

Material recorded with Excel 2016 but works in 2010, 2013, 2016 and 365.

As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.

At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft's Excel Core and Excel Expert Exams and become certified, like me.  Below are just a few of the topics that you will master:

  • Creating effective worksheets
  • Writing and editing formulas and calculations
  • Use sorting and filtering options
  • Build a database right the first time and avoid common design flaws
  • Creating informative and captivating Charts
  • Eliminate repetitive tasks instantly using Macros
  • Create many scenarios with varying groups of data
  • Manage large ranges of data in a List or Table
  • Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH and much more...

Who is the target audience?

This Microsoft Excel course contains all three levels of learning for the: Beginner, Intermediate and Advanced users

  • Includes all the training you need to help you pass both the Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified!

Curriculum For This Course (158 Lectures)

Excel Introduction - First Look

  • Excel Introduction - First Look

 

Excel Level 1 - Beginner

  • Exercise Files, Instructor's Notes, Quiz and Answers

Excel Basics

Excel Functions & Formulas

  • Basic Formulas 
  • SUM & AVERAGE
  • MIN & MAX
  • COUNT & COUNTA
  • Move, Copy, Cut, & Paste Data into Cells
  • Absolute & Relative References
  • Mixed References
  • AutoFill
  • FlashFill
  • Converting Text into Columns
  • Functions & Formulas Quiz - 10 questions

Editing Worksheets

  • Editing Cell Data
  • Insert & Delete Cells, Columns and Rows
  • Find & Replace Data
  • GoTo
  • Transpose or Flip a Range of Data
  • Change Height, Width, & Hide Rows and Columns
  • Check Worksheet or Workbook Spelling with Spell Check
  • Smart Lookup & Thesaurus
  • Editing Worksheets Quiz - 5 questions

Formatting

  • Formatting Text
  • Basic Number Formats
  • Basic Custom Number Format
  • Adding Borders & Colors to Cells
  • Formatting Shortcuts
  • Adding Background
  • Align, Merge & Wrap Cell Data
  • Cell Styles
  • AutoFormat
  • Applying Themes
  • Basic Conditional Formatting
  • Conditional Formatting Manager
  • Formatting Quiz - 11 questions

Print

  • Print Page Breaks, Grildines & Headlines
  • Page Orientation
  • Print Rows at the Top of Each Page - Repeat Column Headers
  • Headers & Footers
  • Editing Page Margins & Center on Page
  • Page Breaks
  • Setting Print Range & Scaling
  • Print Quiz - 7 questions

 

Modifying Worksheet Appearance

  • Name, Move, Copy, Color, Link Worksheets in Workbook
  • Hide Worksheets & Workbooks
  • Split Worksheet
  • Freeze Panes
  • New Windows - Multiple Workbook Views
  • Customize Formula Options
  • Speak Cells
  • Modifying Worksheet Appearance Quiz - 5 questions

 

Excel Level 2 - Intermediate

  • Exercise Files, Instructor's Notes, Quiz & Answers

Advanced Formulas & Functions

  • Named Ranges
  • Auto-Save Version Control
  • Linking Data From One Cell, or Range into Another
  • Convert Text to Upper, Lower, or Proper Case using Formulas
  • CONCATENATE
  • LEFT, SEARCH & FIND Functions
  • RIGHT, FIND & LEN Functions
  • MID
  • AND & OR
  • IF
  • Combining & Nesting Functions AND & IF
  • IFERROR
  • PMT or Payment
  • Display & Print Formulas
  • SUMIFS, COUNTIFS & AVERAGEIFS
  • CONVERT
  • MATCH & INDEX
  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • Advanced Formulas & Functions Quiz - 20 questions

 

Excel Tables

  • Single & Multicell Array Formulas
  • Create Tables
  • Modifying Tables
  • Format Table
  • Custom Table Styles
  • Table Sorting & Filtering
  • DSUM, DAVERAGE & DCOUNT
  • Date & Time Functions
  • Sort Records In Database
  • AutoFilter
  • Advanced Filter & Macros
  • Subtotals
  • Tables Quiz - 9 questions
 

Charts

  • Creating Charts
  • Modifying Charts
  • Trendlines
  • Chart & Axis Titles
  • Format Chart
  • Dual Axis Chart
  • Chart Templates
  • Chart Sharing & Embedding
  • Charts Quiz - 8 questions

 

PivotTables & PivotCharts

  • Create PivotTables
  • Customize PivotTable
  • PivotTable Slicers
  • Create PivotCharts
  • PivotTables & PivotCharts Quiz

 

Graphics

  • Adding & Modifying Pictures
  • Drawing & Modifying Shapes
  • SmartArt Graphics
  • Layering & Grouping Objects
  • Graphics Quiz - 3 questions

 

Customize Excel

  • Insert Cell Comments
  • Using Hyperlinks
  • Create Watermarks
  • Customize Themes
  • Conditional Formatting Rules
  • Free Excel Custom Templates
  • Customize Excel Quiz - 4 questions

 

Excel Level 3 - Advanced

  • Exercise Files, Instructor's Notes, Quiz & Answers

Workbook

  • Workbook Properties
  • Custom Views
  • Record & Copy Macros
  • Edit Macros
  • Macros: Absolute & Relative Referencing
  • Conditional Formatting Using Formulas
  • Quick Analysis Tool
  • Workbook Quiz - 6 questions

 

Collaborating

  • Data Validation
  • Password Protect Worksheets
  • Password Protect Selected Cells
  • Document Inspector
  • Protect Workbook Structure
  • Password to Open & or Modify
  • Always Create Backup
  • Share Workbook
  • OneDrive
  • Track Changes
  • Protect & Share Workbook
  • Merge Workbooks
  • Digital Signatures or Digital ID
  • Mark As Final
  • Collaborating Quiz - 13 questions

 

Audit Worksheets

  • Trace Dependents, Precedents & Errors
  • Troubleshoot Invalid Data
  • Watch Window & Evaluate Formulas
  • Outline & Group Data
  • Audit Worksheets Quiz
 

Analyzing Data

  • Sparklines
  • 3D Map
  • Data Table
  • Scenario Manager
  • Forecast Sheet
  • Goal Seek
  • Solver
  • Random Samples
  • RAND
  • Descriptive Statistics
  • Power View
  • Analyzing Data Quiz - 10 questions

 

Import & Export Data

  • Consolidating Data
  • Link Workbooks
  • Form Data
  • Export Data
  • Import Text File
  • Power Pivot
  • Publish to Web
  • XML Extensible Markup Language
  • Advanced Custom Number Formats
  • Camera
  • Import & Export Data Quiz - 10 questions

 

Course Wrap Up

  • BONUS! - Special Offer! Discount on ANY of my Courses!