Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course Type


Price Per Delegate

£195 +VAT
Public Scheduled Course

Price Per Course

£695 +VAT
On-Site at Customer Premises, Max 10 Delegates


1 Day

Full/Part Time

Part Time


SmartStyle Training

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