Microsoft Excel Intermediate

Microsoft Excel Intermediate 1 Day Course Outline and Content
Style of Training
A structured, hands-on, tutor-led session using practical examples and exercises.
Course Aims and Objectives
This course is designed take delegates to the next ability level by providing them with new skills and a more in-depth understanding of Microsoft Excel's capabilities.

Who should attend?
1. Users who have previously attended our introduction / improver course (or a similar level course).
2. Self-taught users who are comfortable with the majority of topics covered on our introduction course.
Prerequisites
Delegates attending this course should have practical experience using Microsoft Excel and a good understanding of the topics covered on our Introduction course.
Course Content
A typical course at this level would cover the following topics:

Working with Text and Numbers		Date and Time Calculations
Using AutoFill to enter data quickly		Entering dates and times correctly
Entering ranges of dates or numbers		Formatting dates and times
Create / edit / delete a Custom List		Calculating with dates and times
		Inserting a dynamic date
Copy, Cut and Paste
Using copy, cut and paste		Working with Rows and Columns
Using paste special & paste link		Inserting multiple rows and columns
		Hiding rows and columns
Using Formulas		Freezing rows and columns
Review of basic formulas + - / *
Performing formulas quickly & correctly		Using Headers and Footers
Replicate a formula using AutoFill		Creating headers and footers
Using MIN, MAX, COUNT & AVERAGE		Entering and formatting text
		Inserting page numbers, date & file info
Formatting Text and Numbers
Format a date		Using Comments
Format cells as a %		Entering / Deleting Comments
Format decimal places		Viewing / Printing Comments
Formatting cells as currency
Adding borders - types of borders		Printing Options
Formatting text colour, size and style		Repeating title rows at top of page
		Print range to fit one or many A4 pages
		Printing gridlines and row /column headings
Aligning Text and Numbers		Using Excel as a Database
Align text to left, right or centre		Setting up a database - database concepts
Aligning text at an angle		Sorting data - multiple options
Apply text wrapping - merging cells		Filtering data - further filtering options
Conditional Formatting		Using IF Statements
Setting up conditional formatting		Using IF statements for True / False results
Multiple conditional formatting options
Removing conditional formatting		Using Graphs and Charts
		Add or remove a chart title / data labels
Working with Worksheets		Moving / Resizing a chart
Naming / re-naming worksheets		Change a chart's colours
Inserting / deleting worksheets		Changing the chart type
Changing the order of worksheets
Quickly duplicating a worksheet		Saving Worksheets
Linking worksheets for data entry		Saving a workbook
Linking worksheets for calculations		Save a workbook as a new name
Linking cells within a workbook		Save as a new file format or template
Moving sheets to new / other workbooks
Use the Zoom facility