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