Microsoft Excel 2007 Intermediate
Short course
In Liverpool, Manchester and Chorley
Description
-
Type
Short course
-
Level
Advanced
-
Location
-
Duration
1 Day
Suitable for: Those who have attended out Introduction course or equivalent.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Reviews
Course programme
Review of Excel Basics
Functions
Database tools
•IF functions
•Sorting data – ascending, descending, left to right
•VLOOKUP and HLOOKUP
•Sorting data in custom sequences
•Function to combine data from multiple cells
•Filtering data with AutoFilter
•Date functions
•Creating customised and advanced filters
•Nested functions
•Using data forms to enter, delete and search for data
•Using Subtotals to calculate sub sets of data Tools
•Naming cells and ranges
•Protecting cells
•Linking workbooks
•Linking applications (Excel with Word or PowerPoint)
Formatting
•Hiding columns, rows and formulas
•Grouping columns and rows
•Applying conditional number formatting
Microsoft Excel 2007 Intermediate