Excel Online Training

We provide leading-edge online training in Microsoft® Excel

Excel 101 – Basic

18 Course Hours  |  Course Fee: $180 + Tax

Excel 101 Details
Registration
Microsoft Excel 101 Online Training

Topics Covered:

  • Microsoft® Excel Fundamentals
  • Navigating and understanding the structure of Excel
  • Creating Workbooks and Worksheets
  • Saving and naming Excel Documents
  • Entering and editing text, numbers and formulas
  • Creating basic formulas
  • Working with basic Excel Functions
  • Excel AutoSum, Shortcut Keys and AutoFill Command
  • Modifying an Excel Spreadsheet
  • Moving, inserting, changing rows, columns and cells
  • Formatting Data in Excel Worksheets
  • Printing Excel Worksheets
  • Adding and Deleting Worksheets

Excel 102 – Intermediate

18 Course Hours  |  Course Fee: $180 + Tax

Excel 102 Details
Registration
Microsoft Excel 102 Online Training

Topics Covered:

  • Working with Tables
  • Sorting and Filtering Tables
  • Working with Charts
  • Creating column, bar, pie, map and funnel charts
  • Using spark lines
  • Adding pictures, online shapes, icons and 3D models
  • Inserting smart art and organizational charts
  • E-mailing a workbook
  • Converting worksheets into a web page
  • Inserting hyperlinks
  • Using financial functions
  • IF and IFS functions
  • Understanding date and time functions
  • Adding a date and a date interval
  • Subtracting dates
  • Using templates
  • Creating templates
  • Creating a workspace
  • Comparing two workbooks side by side
  • Using data consolidation

Excel 103 – Advance

18 Course Hours  |  Course Fee: $180 + Tax

Excel 103 Details
Registration
Microsoft Excel 103 Online Training

Topics Covered:

  • Import and export data
  • Format numbers
  • Work with ranges
  • Work with macros
  • Use data analysis tools
  • Understand the power of Pivot Tables
  • Summarize data
  • Analyze your data
  • Workgroup collaboration