Category
ICT
Course Type
Microsoft
Price Per Course
£595 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
1 Day
Full/Part Time
Part Time
Provider
Book courseThis course is intended for users who need to be able to build, analyse and report on a range of spreadsheet models using IF functions, Lookup functions and PivotTables.
Objectives:
By the end of the course users will be able to create sophisticated spreadsheets, which include complex functions. They will be able to utilise analysis tools to summarise and extract data. The use of macros will facilitate the automation of tasks.
Prerequisites:
A thorough grounding in building multiple sheet workbooks which include functions, such as Min, Max, Average and simple IFs.
- Logical Functions (IF, AND & OR)
- Statistical Functions (COUNTIF & SUMIF)
- Lookup & Reference Functions (VLOOKUP & H LOOKUP)
- Text Functions
- Different Types of Validation
- Input Messages
- Error Alerts
- Locating Invalid Data
- Creating a Pivot Table
- Sorting, Grouping & Filtering Pivot Data
- Drill Down on Pivot Data
- Summarise Value Fields
- Recording & Running Macros
- Deleting a Macro
- Macro Virus Protection
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
