Further Details
ANALYSING DATA
· What-If Analysis
· Goal Seek
· Data Tables
· Scenario Manager
· Solver
· Consolidation
ADVANCED FORMULAE
· If Functions
· Date Functions
· Concatenation
· Array Formulas
· Lookup Functions
USEFUL FEATURES
· Naming Conventions And Methodologies
· Outlines
· Worksheet And Cell Protection
· Basic Charts
· Filters
· Pivot Tables
· Data Validation
· Conditional Formatting
· Auditing Tools
· Hyperlinks
TEMPLATES AND MACROS
· Creating a Template
· Recording Macros
· Editing Macros
Guide price
£250 |
