Excel 2007 Advanced
Short course
In London and Birmingham
Description
-
Type
Short course
-
Location
-
Duration
1 Day
This course is designed to familiarise the delegate with the Advanced concepts of Excel. This includes viewing specific worksheet data, using Goal Seek, and working with Databases and PivotTables. You will also learn how to customise the Excel menus and toolbars as well as create your own templates.
Facilities
Location
Start date
Start date
Start date
Reviews
Course programme
Course content
- Utilities
- Using String Formulas
- Amending Number Formats
- Shared Lists
- Auditing
- Scenario Manager
- Goal Seeking
- Solver
- Databases
- Creating A Database
- Using Data Forms
- Adding, Editing And Deleting Records
- Sorting Records
- Searching For Records
- Removing Duplicates
- AutoFilter And Advanced Filter
- Working With Tables
- Database andLOOKUPFunctions
- Data Tables
- PivotTable and PivotChart Reports
- Pivot Table
- Calculating in PivotTables
- PivotCharts
- UsingXML
- UsingXMLdata sources
- Customising Excel
- Customising the Quick Access Toolbar
- Creating Templates
Excel 2007 Advanced