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 work with Excel on a daily basis who need to improve their knowledge and efficiency using some of the shortcuts and features available within the application.

Objectives: 

By the end of the course users will be able to move around and enter data using a range of shortcuts and quickly produce impressive spreadsheets using a number of formatting features.

Prerequisites: 

Delegates attending this course should be existing Excel users who can open, save and close spreadsheet files. The ability to create a simple calculation in Excel is desirable but not essential.

Download Outline (PDF)

Navigating & Data Entry
  • Moving Around & Selecting using Keyboard Shortcuts
  • Shortcuts for Entering Data
  • Using AutoFill & Creating Custom Lists
  • Entering Data with Flash Fill
  • Manipulating Columns & Rows
  • Viewing Multiple Sheets Simultaneously
  • Using Group Editing
Impressive Appearances
  • Enhancing Spreadsheets with Simple Formats
  • Highlighting Cells with Conditional Formatting
  • Quick Analysis Tools
  • Page Setup Options in Layout View
  • Quick Headers & Footers
  • Creating a Quick Chart
Formulae without Fuss
  • Creating Formulae with Relative & Absolute References
  • AutoSum & Statistical Functions
  • Formula Auto Complete
  • Using the Function Library
  • Showing & Hiding Formulas in a Spreadsheet

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.