Course not currently available
Microsoft Excel Intermediate 2007
Short course
In Horsham ()
Description
-
Type
Short course
-
Level
Intermediate
-
Duration
1 Day
This course complements the Excel Primary course, and covers some of the more advanced features Excel has to offer. These include managing and filtering lists of data, grouping worksheets and data consolidation, using the "IF" and "Lookup" functions and conditional formatting. Course objectives: This course will enable delegates to enhance their knowledge. Suitable for: All Microsoft Excel users who have either attended the Excel Primary course or who have a good basic knowledge of Excel, and now need to improve their productivity and knowledge.
Reviews
Course programme
This course complements the Excel Primary course, and covers some of the more advanced features Excel has to offer. These include managing and filtering lists of data, grouping worksheets and data consolidation, using the "IF" and "Lookup" functions and conditional formatting.
Course objectives
This course will enable delegates to enhance their knowledge of Excel and develop their skills to produce professional and well-presented spreadsheets.
By the end of this course you will have learned
- How to create a formula using absolute referencing
- How to link one worksheet to another
- How to work with "IF", "SumIF", "CountIF" and "VLOOKUP" functions
- How to consolidate data from multiple worksheets
- Sorting, filtering and creating subtotals in datalists
- How to use conditional formatting and paste special options
All Microsoft Excel users who have either attended the Excel Primary course or who have a good basic knowledge of Excel, and now need to improve their productivity and knowledge.
Pre-requisites
Delegates should have a good understanding of the Windows environment and it is advisable that they have attended the Excel Primary course.
Course synopsis
- Absolute referencing
What is absolute referencing; when to use absolute referencing - Linking data
- Grouping worksheets
Grouping worksheets; using functions in grouped sheets; group calculations - Data consolidation
Consolidate within a single worksheet; consolidate in multiple worksheets; link source data; viewing outlines - Functions
The "IF" function; nested "IF" functions; "SumIF" function; "CountIF" function; "Lookup" functions - Conditional formatting
Formats cells providing certain conditions are met - Paste special
Basic paste functions; paste operators; transpose data; paste link - Working with data lists
Sorting and filtering data; subtotals - Naming cells and ranges
Using named ranges to navigate in Excel; creating formulae and functions using named ranges
Microsoft Excel Intermediate 2007