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 individual

£150 +VAT
Public course

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/01/2019 Bradford
04/02/2019 Doncaster
04/02/2019 Bradford
13/02/2019 Bradford
13/02/2019 Liverpool
14/02/2019 Barnsley
22/02/2019 Mansfield
18/04/2019 Barnsley
25/04/2019 Liverpool
30/04/2019 Bradford
07/05/2019 Bradford
08/05/2019 Doncaster
10/05/2019 Mansfield
07/06/2019 Barnsley
24/06/2019 Bradford

Book course

This course is intended for users who already have some experience of using Excel and need to create spreadsheets which include calculations, multiple sheets and charts.

Objectives: By the end of the course users will be able to create multiple sheet Workbooks, use logical functions, sort, filter and subtotal data. Users will also be able to present data in a graphical format.

Prerequisites: Users need to be able to design and create simple spreadsheets which include basic formulae and the use of AutoSum. They should also be able to use simple formatting tools and use cut, copy and paste effectively.

Download Outline (PDF) 

Working with Multiple Worksheets
  • Moving Between Worksheets
  • Inserting, Deleting & Renaming Worksheets
  • Moving & Copying Worksheets
  • Using Group Editing
  • Arranging Multiple Files
  • Entering Formula Across Worksheets & Workbooks
Conditional Formatting
  • Highlighting Cells using Rules & Conditions
  • Identify Trends with Data Visuals & Icon Sets
  • Create New Rules & Manage Existing Rules
More Formulae & Functions
  • Creating Statistical Functions
  • Logical 'IF' Functions
  • Calculating Percentages
Manipulating Data Lists
  • Remove Duplicate Values
  • Automatic Subtotals & Grand Totals
  • Data Grouping & Outlining Tools
  • Inserting Excel Tables
  • Manipulating Data in an Excel Table
Working with Charts
  • Creating Charts & Graphs
  • Quick Analysis Tools
  • Formatting Charts
  • Modifying the Chart Layout
  • Adding & Removing Chart Elements
  • Filtering Chart Data
  • Creating Combination Charts
  • Saving Charts as Templates
  • Creating Sparklines
  • Previewing & Printing Charts

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