Excel 2013 - Level 3
E-Learning
Description
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.
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.
Upon successful completion of this course, students will have advanced skills in using Excel 2013.
This course is intended for students who want to further build on the acquired skills from Level 1 and Level 2 Excel 2013 classes.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | Advanced functions and formulas |
Logical functions Conditional functions Financial functions Text functions Date functions Array formulas |
| 2 | Lookups and data tables |
Using lookup functions Using MATCH and INDEX Creating data tables |
| 3 | Advanced data management |
Validating cell entries Advanced filtering |
| 4 | Advanced charting |
Chart formatting options Combination charts Graphical objects |
| 5 | PivotTables and Pivot Charts |
Working with PivotTables Rearranging PivotTables Formatting PivotTables PivotCharts |
| 6 | Exporting and importing data |
Exporting and importing text files Getting external data |
| 7 | Analytical tools |
Goal Seek Scenarios |
| 8 | Macros and Visual Basic |
Running and recording a macro Working with VBA code |
Self-Paced
Free
This course includes: :
Full lifetime access