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
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 Business and Trade Union
Start Date 27/07/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