Excel 2007/2010/2013/2016 Intermediate
Short course
In Cambridge
Description
-
Type
Short course
-
Level
Beginner
-
Location
Cambridge
-
Duration
1 Day
The aim of this course is to have the participant `up and running' immediately following a one day intermediate programme based upon their existing skills and future needs. At the end of the course the participant should be able to create a good selection of spreadsheets and graphs. This course will assist users to prepare for the Excel 2007 Core Microsoft Office User Specialist Exam. Suitable for: Designed for existing users. If required courses may be tailored. Please call to discuss content.
Important information
Documents
- Outline
Facilities
Location
Start date
Start date
About this course
Attendance of the Introduction course or equivalent knowledge
Reviews
Subjects
- Create spreadsheets
- Create graphs
- Excel
- MS Excel
- Accounts
- Excel 2010
- Excel 2007
- Excel 2013
- Formula referencing
- Excel 2016
Teachers and trainers (1)
TBA TBA
Trainer
Course programme
Excel Intermediate
Refresher of the Basics
Tips for Creating Spreadsheets
Basic Formulae/Functions/Absolute references
Tips for Working with Large Spreadsheets
Freezing Screen Titles
Splitting Windows
Displaying Multiple Sheets/Files on Screen
Page Setup Options
Margins
Headers and Footers
Printing Titles
Sheet Options
Scaling
Page Break Preview
Setting Print Areas
Sheet Background
Worksheet and File Linking
Creating simple links
Multiple sheet formulae
Ranges
Creating and naming ranges
Clearing and formatting ranges
Copying and moving ranges
List Data
Sorting a list
Filters
AutoComplete
Formatting Tables with Filters (Format Tables)
Charts and Shapes
Charts
Creating, formatting and editing a chart
Printing Charts
Sparklines
Creating and modifying lines and shapes
Additional information
Excel 2007/2010/2013/2016 Intermediate