RMD Training - Hull

 

RMD Business Excel 2003 Advanced Syllabus

 

This course is designed for delegates who have strong experience of using Microsoft Excel 2003 and want to learn the advanced features to allow them to work even more efficiently.

 

If the course syllabus does not entirely match your requirements, please contact us as we are able to customise it to your needs.

 

This course has a duration of 1 day.

 

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

     

     

    •