Excel Online Training
We provide leading-edge online training in Microsoft® Excel
Excel 101 – Basic
18 Course Hours | Course Fee: $180 + Tax
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
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