Intermediate Microsoft Excel Training

Date/Time
Date(s) - Mar 19,2018 - Mar 20,2018
9:00 am - 5:00 pm

Location
Online via Zoom, from the Philippines - Makati
Online via Zoom, from the Philippines

Categories


Program Structure and Outline

  • LESSON 1: DATA REFERENCE
    • Introduction to Excel Spreadsheet Intermediate Level
    • Defining Names in Excel
  • LESSON 2: USING FUNCTIONS
    • Functions within Excel
    • Information Functions
    • Using Text to Columns
    • Understanding Date Function
    • Database Functions
  • LESSON 3: CREATING CHARTS AND DASHBOARDS
    • Understand Charts
    • Chart Design Options and Tools
    • Chart Format Tools
    • Combo Charts
  • LESSON 4: DATA CONSOLIDATION
    • Sorting Data
    • Using Excel Tables
    • Filtering Data in Excel
  • LESSON 5: MANAGING EXCEL CONTENT
    • Find and Replace
    • Headers and Footers
    • Adding Comments
    • The Paste Special Function
    • Conditional Formatting
    • Formula Auditing and Error Tracing

Book your seat/s NOW!

Bookings have already been closed for this event.

Fully booked? Click here to get info regarding our future training events.