Intermediate Microsoft Excel Training
Date/Time
Date(s) - Aug 16,2018 - Aug 17,2018
9:00 am - 5:00 pm
Location
Online via Zoom, from the Philippines - Makati
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.