Talk to a Training Advisor
Request availability by clicking a date.
|
About this class This advanced course is designed for delegates who are already proficient in the basic and intermediate features and now wish to learn the more advanced features of the product. This two-day course will enable the delegate to add more complex functionality to their spreadsheets. On completion of the course, you will be able to quickly analyse raw data and produce reports using Excels built in database functions, consolidation and pivot tables. You will also be able to automate repetitive tasks using recorded macros. Who will the lesson benefit? Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel. What delegates will learn This course will enable delegates to: - Use database functionality.
- Work with analytical tools.
- Create and work with Pivot Tables.
- Import and Export data.
- Record and edit Macros.
- Customise Excel.
Examination details This course, along with Fundamentals and Intermediate, covers the curriculum for the ECDL spreadsheet exam. What prerequisites are required This course is designed for students who have completed the Microsoft Excel 2000 Intermediate [E3M2] course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software. Contents of this class Advanced Formulas - Using Names.
- Decision-making.
- Nesting.
- Financial functions.
Data Tables - MATCH and INDEX.
- Data Tables.
Advanced List Management - Subtotals.
- Data validation.
- Database functions.
- Data Forms.
Analytical Options - Goal Seek and Solver.
- Scenarios.
- Views.
- Reports.
Pivot Tables - Creating a pivot table.
- Rearranging pivot tables.
- Formatting pivot tables.
- Pivot charts.
Templates - Using templates.
- Built-in templates.
- Creating and managing templates.
Importing and Exporting - Importing data.
- Exporting data.
- Querying external databases.
Macros - Recording and running a macro.
- Editing vba code.
Charts - Creating combination charts.
Advanced Web Topics - Creating interactive web spreadsheets.
- Pivot tables on the web.
Optional follow-on classes For those who wish to exploit Excel's full potential by creating interactive user interfaces, or automating repetitive procedures for speed and consistency attend
|
