Excel 2007 Intermediate
Course Information
This one day course is designed to build on the basic skills in Excel gained from the Excel Essential Skills course.
Delegates will learn to control their worksheets through navigation techniques, calculate using more advanced logical functions and increase presentation impact using charts, graphs and maps.
Pre-requisites
Delegates should have previously attended the ‘Essential Skills’ course or have equivalent knowledge through their own usage of the product.
Course Objectives
By the end of the course delegates will be able to:
- Apply freeze panes in large worksheets to control navigation
- Define and apply range names to speed navigation and calculation within the worksheet
- Attach printable comments to cells in the worksheet
- Arrange worksheet and workbook windows to compare two sheet or two books on screen
- Calculate using functions
- Create charts, graphs & maps using Excel data
- Insert pictures and graphics into the worksheet
What you will learn:
Lesson 1 – Finding your way around a spreadsheet
Spreadsheet Views
Worksheet navigation
Freezing panes
Splitting the screen
Arranging Windows
Scrolling two spreadsheets side by side
Lesson 2 – Using Named Ranges
Creating named ranges
The Name Manager
Using range names within formulae
Using named range with the GoTo command
Lesson 3 – Adding Comments
Creating, editing and deleting cell comments
Navigating Comments
Displaying comments permanently on screen
Printing and formatting cell content
Lesson 4 – Building Formulae and using Functions
The Function Libarary
Insert Function
Create formulae containing the function
SUMIF, IF, COUNTIF
Create formulae using nested IF statements
Create formulae using the AND OR functions
Conditional SUM
Conditional Formatting
Create a table and use the HLOOKUP & VLOOKUP to find additional information
Lesson 5 – Using text & date functions
Use the concatenate function to join text from multiple columns into a single column
Use the text to columns feature to separate text into columns
Use the date fuction to calculate the time between two dates
Lesson 6 – Charts and Graphs
Insert Charts
Create a Bar Chart from data within your spreadsheet
Create a Pie Chart from data within your spreadsheet
Change the type of chart within your workbook
Change the look and colours within the chart; apply a gradient to the shading
Chart templates
Lesson 7 – Pictures
Add a picture into a worksheet
Inserting SmartArt
