Excel Online Training

We provide leading-edge online training in Microsoft® Excel

Excel 1 Course – Basic

20 Course Hours  |  Course Fee: $200 + Tax

Excel 1 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 2 Course – Intermediate

20 Course Hours  |  Course Fee: $200 + Tax

Excel 2 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