advance course

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advance Course

Advance Course

resolvedResolved · 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.


 

Excel tip:

Toggle Formulas and Results

Ctrl + 'The key above Tab with the

View all Excel hints and tips


Server loaded in 0.08 secs.