Information Technology
Excel 2013 – Level 3
Work with advanced formulas and lookup functions. Advanced data filtering & apply advanced chart formatting. PivotTables & Charts, export/ import data and external databases. Analytical features and create scenarios. Run/record macros. Explore VBA code.
1 Day
8 Hrs
8 Lessons
Course Objectives
Upon successful completion of this course, students will have advanced skills in using Excel 2013.
Agenda
- Logical functions
- Conditional functions
- Financial functions
- Text functions
- Date functions
- Array formulas
- Using lookup functions
- Using MATCH and INDEX
- Creating data tables
- Validating cell entries
- Advanced filtering
- Chart formatting options
- Combination charts
- Graphical objects
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
- PivotCharts
- Exporting and importing text files
- Getting external data
- Goal Seek
- Scenarios
- Running and recording a macro
- Working with VBA code
FREE
Interested in course?
Course Type: Instructor Led