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
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.