Intermediate Microsoft Excel Training

Loading Map....

Date/Time
Date(s) - Aug 16,2018 - Aug 17,2018
9:00 am - 5:00 pm

Location
I’m Hotel

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

Bookings

Bookings are closed for this event.