Microsoft Excel Training Northern Ireland

Advanced Level

Our standard course outline for this course is shown below, however, we are able to adapt the contents to suit your specific needs as required. Please contact us for more details

• Importing Data
  • Importing Data From External Sources
  • Importing Text Files
  • Using Microsoft Query
  • Querying Data From The Web
  • Refreshing Data

• Templates and Styles
  • Working With Templates
  • Working With Styles

• Analysing Data
  • What-If Analysis
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Solver
  • Using Pivot Tables

• Macros and Custom Controls
  • Working With Macros
  • Running Macros
  • Adding Custom Controls

• Security and Proofing
  • Security Features
  • Protecting Excel Files
  • Worksheet Protection
  • Working With Digital Signatures
  • Checking Spelling
  • Using Data Validation
  • Using Text To Speech
  • Documentation

• Customising Excel 2003/2007
  • Configuring Excel 2003/2007 Options
  • Customising The Excel Environment
  • Working With Workspaces

• Collaboration and Consolidation
  • Sharing Workbooks
  • Sending Workbooks
  • Consolidation

• Editing Spreadsheets
  • Cutting, Copying, And Pasting
  • Inserting And Deleting
  • Using Find And Replace
  • Using Undo And Redo

• Formulas and Functions
  • Entering Formulas
  • Entering Functions
  • Using Named Cells And Ranges In Formulas

• Printing
  • Using Page Setup
  • Margins
  • Headers And Footers
  • Printing A Spreadsheet
  

<- Back to Courses