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 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for users who need to organise, and manipulate large volumes of data.

Objectives: 

By the end of the course users will be able to manage data lists and create automatic subtotals and grand totals. They will be able to validate data entry, sort & filter data, use conditional formatting to monitor and visualise data, and use table functionality.

Prerequisites: 

A thorough grounding in building basic spreadsheet models including inserting & deleting rows & columns, creating simple calculations, and using statistical functions such as Min, Max & Average.

Download Outline (PDF)

Data List Revision
  • Structuring Data Lists
  • Freezing Worksheet Titles
Naming Cells & Ranges
  • Naming a Cell or Cell Range
  • Changing & Deleting Names
Conditional Formatting
  • Highlight Cells with Formatting Rules
  • Formatting Ranges with Top/Bottom Rules
  • Data Visualisations
  • Creating Custom Formatting Rules
  • Rules Manager
Sorting & Filtering Data
  • Sorting Data by Single/Multiple Columns
  • Filtering List Data
  • Defining Custom Filters
Subtotals & Grouping
  • Adding Subtotals
  • Grouping & Outlining Data
Inserting Tables
  • What are Tables?
  • Converting Ranges into Tables
  • Modifying Tables
Using Data Validation
  • Validating Text, Values & Dates
  • Creating Input Messages
  • Error Alerts

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.