Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 +VAT
Client site, max 10 individuals

Duration

1 Day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

15/03/2019 Mansfield
27/03/2019 Doncaster
07/06/2019 Mansfield
10/06/2019 Doncaster

Book course

This 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.

Download Outline (PDF)

Practical Functions
  • Logical Functions (IF, AND & OR)
  • Statistical Functions (COUNTIF & SUMIF)
  • Lookup & Reference Functions (VLOOKUP & H LOOKUP)
  • Text Functions
Data Validation
  • Different Types of Validation
  • Input Messages
  • Error Alerts
  • Locating Invalid Data
Introducing Pivot Tables
  • Creating a Pivot Table
  • Sorting, Grouping & Filtering Pivot Data
  • Drill Down on Pivot Data
  • Summarise Value Fields
Automating Spreadsheets with Macros
  • Recording & Running Macros
  • Deleting a Macro
  • Macro Virus Protection

Book a course

Fill in your information to book this course. The information you provide on this booking 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.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here