You will learn how to use a combination of more complex functions, formulas; nested IF statements, VLOOKUP, HLOOKUP and LOOKUP tables.
Participants will learn how to begin to develop a personalised Interface through the creation of Active worksheet Buttons and Macros.
You will also learn how to manipulate spreadsheets in Excel to present selected data using more Advanced Excel software tools: Pivot Tables, Pivot Charts and What If analysis tools.
About the Course
- Nested IF Functions
- V LOOKUP and H LOOKUP tables.
- Creation of Macros and Active Buttons
- Combining functions and formulas with buttons
- Use of Pivot tables and Pivot Charts
- Data Analysis using Scenarios, Data Tables and Goal Seek.
Courses for Adults 19+,Courses for Business and Trade Union
Start Date 05/11/2018
Select a course you've previously looked at or search for a new one, confirm the details and start your application.
Know what you're looking for?
Or pick from your previously viewed courses