Contents:
| Creating & Using Templates |
Excel Functions |
| · About Templates |
· Formulas v Functions |
| · Create Workbooks from existing files |
· Screen Tips for Functions |
| · Tips and tricks for designing Templates |
· Conditional Functions SumIF(), CountIF() |
| · Cell, Worksheet and File Protection |
· Nesting Functions such as IF() |
|
· Search for Values within a list VLOOKUP(), HLOOKUP() |
| Working with Multi-Sheet Files |
· AutoFill Formulas & Functions |
| · View workbook with Split Panes |
|
| · Navigate with Freeze Panes |
Charting |
| · Group Sheets to work on several at once |
· Creating Quick Charts |
| · Create Links between Workbooks |
· Tips and Tricks |
| · Multi-sheet Formulas and Functions |
· Formatting Charts |
| · Performing Special Pastes |
|
| · Retaining Formats when Pasting |
Custom Formatting |
| · Name and Colour Sheet Tabs |
· Create Custom Number Formats |
| · Move and Copy Sheets to New Files |
· Formatting of Text, Blanks and Zeroes |
|
· Conditional Formatting |
| Naming and Labelling Ranges |
|
| · Relative v Absolute Addressing |
Database Lists |
| · Apply Range Names to Cells |
· What is a Database List |
| · Simplify Formulae with Range Names |
· Sort Data and apply Auto Subtotals |
| · Naming of Grouped Cells across sheets |
· Using AutoFilters |
| · Using the Range Navigator and F5 |
· Extracting Data with Advanced Filter |
| · Use Auditing to control and track data |
· Database Functions |
Target Audience: Users of Excel 2007 that wish to increase their depth of knowledge and for anyone who has mastered the fundamentals and is ready to get the tools, tips and techniques required to become a power user.
Assumed Knowledge: A basic working experience of Excel or prior attendance of our Excel Essentials course.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: MS Excel 2007 Specialist