98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Advance Course
Advance Course
Resolved · Low Priority · Version 2007
Karina has attended:
Excel Intermediate course
Advance Course
what is included in the Excel advanced course
RE: Advance Course
Hi Karina
Thanks for your question and welcome to the forum and 12 months support, we hope you found todays course useful.
Here are a list of topics from the 2003 Excel Advanced course -
ourse Syllabus
Working with Advanced Formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions
Lookups and Data Tables
Working with lookup functions
Creating data tables
Advanced List Management
Creating subtotals
Validating cell entries
Exploring database functions
Working with PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts
Exporting and Importing
Exporting and importing text files
Querying external databases
Using Analytical Options
Working with Goal Seek and Solver
Working with scenarios
Working with views
Working with Macros
Running and recording a macro
Viewing VBA code
Function procedures
Interactive Web Pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web
regards
Best Team
Tue 23 Jun 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |