Microsoft Excel 2003 Advanced
Aims for this course
At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
Course Agenda
Getting The Most Form Your Data
Outlining And Grouping Your Data
Using Automatic Outlining
Displaying And Collapsing Levels
Grouping Data Manually
Creating Subtotals
Pivot Tables
What Is A Pivot Table?
Creating A Pivot Table Frame
Specifying Data In A Pivot Table
Rearranging Pivot Table Data
More On Pivot Tables
Modifying Pivot Table Calculations
Formatting A Pivot Table
Refreshing A Pivot Table
Charting A Pivot Table
Creating A Pivot Table Based On Data From An External Database
Exploring Scenarios
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report
Saving Multiple Scenarios
What If Analysis
Using A One And Two Input Data Table
Using Goal Seek
Using Solver
Excel And The Internet
Excel And Hyperlinks
Hyperlinks And The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using The Web Toolbar
Browsing Hyperlinks In Excel
Excel Workbooks As Web Pages
Interactive And Non-Interactive Web Pages
Saving A Workbook As A Web Page
Saving A Worksheet As A Web Page
Saving A Chart As A Web Page
Saving A Range As A Web Page
Getting Data From The Internet
Importing From An External Data Source
Creating A Web Query
Saving A Web Query
Refreshing A Web Query
Advanced Excel Tasks
Creating And Using Shared Workbooks
Sharing A Workbook
Requesting Reviews
Reviewing A Workbook
Tracking Changes
Merging And Revising A Shared Workbook
Visual Basic And Macros
Adding Code To Your Macro
Adding Comments To VBA Code
Declaring Variables
Prompting For User Input
Iteration Over A Range
Using If Then Else Statements
Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings
Excel Security
Digital Signatures
Macro Security
Protecting Your Workbook With A Password
Custom And Advanced Features In Excel
Customizing Excel By Changing Options
Using Custom Auto-Fill Lists
What Is Text To Speech?
Using Detect And Repair
Course Title
Microsoft Excel 2003 Advanced
Cost per delegate
£145 +vat
Who is this course for?
Experienced MS Excel 2003 users or people who have attended the MS Excel 2003 Intermediate course
Related courses
> MS Excel 2003 Foundation
> MS Excel 2003 Intermediate
When is this course running?
Click here to view the latest course schedule
