Course details
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.
Course Outline
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
Target Audience: This course is intended for students who want to further build on the acquired skills from Level 1 and Level 2 Excel 2013 classes.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office Skills and Administration Management NextGen LearningEUR 234Duration: Upto 50 Hours
- Microsoft Office Skills Improvement NextGen LearningEUR 234Duration: Upto 50 Hours
