Course Outline

Microsoft Excel Intermediate - Open Schedule

Overview

Who is this course for?

With a little experience of Microsoft Excel or similar software, this course gives you a fast-paced introduction to the power of Excel's core features, giving you the knowledge to design and produce more efficient, better presented spreadsheets.

 

How long is this course?

1 Day 

 

What do I need to know before attending?

Delegates should have attended the Microsoft Excel Introduction course or have the equivalent skills and knowledge to that level. 

 

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

  • Use Excel to structure and analyse your data.
  • Extend the functionality of your spreadsheets by using more complex calculations.
  • Use Conditional Formatting on your worksheets.
  • Understand and apply Data Validation to control input.
  • Create Excel charts and control their formatting.
  • Manipulate database style lists of data with simple Pivot Tables and database functions.

 

Price Band:

 General

Content

Re-capping the Basics
The Excel Screen, the Ribbon and other toolbars.
Basic formula entry and editing.

Standard Formatting
Formatting cells, Format painting, Autofill, copy and paste.
Themes and Styles.
Adding & Deleting Rows & Columns.

Taking Formulae Further
Absolute Cell References.
The IF() Function.
Lookup Functions.
Introducing Text Functions.

Taking Formatting Further
Conditional Formatting.
Extended Formats and Formulas.
Data Validation.
Using Comments.

Useful Tools and Features
Ranges of cells and using range names.
Smart Tags.
Checking Spelling, Find and Replace.

Charts & Graphs
Sparklines
Creating and editing chart.
Saving a chart template.

Printing
Using Page Set-up and Print Preview.
Printing charts separately.
Using page breaks.
Using automatic page numbering, headers and footers.

Database Functionality
Recapping the basics of sorting and filtering data.
Creating Excel Tables.
Introducing Pivot Tables and Pivot Charts.

Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

call us on 01949 212121

www.vtl.co.uk
IIP