Microsoft Excel 2003 Advanced

Level 3. This course provides competency in Outlining and Grouping Data, Pivot Tables, Excel Workbooks as Web Pages, Creating and Using Workbooks, Visual Basic and Macros, Advanced File Management and Security.

Course Outline

This course provides competency in Outlining and Grouping Data, Pivot Tables, Excel Workbooks as Web Pages, Creating and Using Workbooks, Visual Basic and Macros, Advanced File Management and Security...

Getting The Most From 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

Additional Details

Pre-Requisites

Microsoft Excel 2003 Intermediate

Certificates offered

Certificate of completion

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012