What you’ll 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!

Excel Introduction – First Look

  • Excel Introduction – First Look

 

Excel Level 1 – Beginner

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

 

Basics

  • Themes, Save Location, Back Stage & Fonts
  • Quick Access Toolbar
  • Ribbon
  • Navigating Shortcuts, Tips, Tricks & Selecting Cells
  • Data Entry & Basic Worksheet
  • Save, Save As & Backup Copy
  • Convert To 2016
  • Compatibility Checker
  • Tell Me What You Want To Do – The New Help Feature
  • Basics Quiz

 

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

 

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

 

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

 

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

 

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

 

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
  • Single & Multicell Array Formulas
  • Advanced Formulas & Functions Quiz

 

Tables

  • 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

 

Charts

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

 

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

 

Customize Excel

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

 

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

 

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

 

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

 

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

 

Course Wrap Up

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

Leave a Reply

Your email address will not be published.