Call us on 01732 897511
01732 897511
Wednesday 8th September 2010
Microsoft Excel Advanced
Description
Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. A very sound background of designing Excel spreadsheets through attendance of the Microsoft Excel Introduction and Intermediate courses or equivalent experience is essential.
What will you learn?
- To create powerful spreadsheets through the use of advanced functions
- To analyse data held as a database
- To understand Excel’s capabilities beyond this course
Course content
Naming Cells
- Individual Cells or Ranges
- The Name Box
- Creating Names
- Assigning a Name to a value
- Using Names in Formulas
- Applying Names
- Selecting Named Cells
- Book level v Sheet level Names
Advanced Functions
- Date and Time
- Logical
- Lookup
- Text
Further Database Features
- Advanced Filters
- Database Functions
- Subtotals
- Pivot Tables
Scenarios
- Adding Scenarios to a Workbook
- Showing different Scenarios
- Creating a Scenario Summary
Further Charting Features
- Adding Data to a Chart
- Creating Combination Charts
- Adding Graphics to Charts
Data Consolidation
- By Position and Category
- Creating Links
- Outlines
Where to go from here?
- More Functions
- Other features and Add-Ins
- Macros/Visual Basic for Applications (VBA)
Dates for this course
Please contact the team for dates of this course
