Microsoft Excel 2007 - Level 3

Progressive Training & Development

Short course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Inhouse

  • Duration

    1 Day

This course looks at preparing a spreadsheet for ease of use. Automatic hiding and displaying of columns, getting statitical information from Pivot Tables, using Excel as a 'What If' analysis tool, using Excel on the Web, sharing a workbook with others, using VLookup, and linking to data.

About this course

You should be confident with the topics covered in Levels 1-2.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
This course looks at preparing a spreadsheet for ease of use. Automatic hiding and displaying of columns, getting statitical information from Pivot Tables, using Excel as a 'What If' analysis tool, using Excel on the Web, sharing a workbook with others, using VLookup, and linking to data.

PREREQUISITES
You should be confident with the topics covered in Levels 1-2.


ADVANCED TOPICS
  • Setting Excel Options
  • Excel and Windows
  • Using the Excel Viewer

GETTING THE MOST FROM YOUR DATA
  • Getting the Most from Your Data
    • Using Automatic Outlining
    • Displaying and Collapsing Levels
    • Grouping Data Manually
    • Creating Subtotals

  • PivotTables
    • What is a PivotTable?
    • Creating a PivotTable
    • Creating a PivotTable Frame
    • Specifying PivotTable Data
    • Rearranging PivotTable Data

  • More About PivotTables
    • Modifying PivotTable Calculations
    • Formatting a PivotTable
    • Refreshing a PivotTable
    • Charting a PivotTable
    • Creating a PivotTable Based on External Data

  • 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
  • Using Hyperlinks in Excel

    • Saving Workbooks as Web Pages
    • HTML and MHTML Files
    • 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

  • Excel and Office Servers

    • Publishing to a Document Server
    • Saving to a Document Management Server
    • Using Excel with Excel Services
ADVANCED EXCEL TASKS
  • Creating and Using Shared Workbooks
    • Sharing a Workbook
    • Opening and Editing a Shared Workbook
    • Tracking Changes
    • Resolving Conflicts in a Shared Workbook

  • Using Custom AutoFill Lists
    • What is an AutoFill List?
    • Creating a Custom AutoFill List
    • Modifying a Custom AutoFill List
    • Using a Custom AutoFill List

  • Using the VLOOKUP Function
    • Using VLOOKUP to Find Data
    • How to Find an Exact Match with VLOOKUP
    • Finding the Closest Match with VLOOKUP

  • Linking, Consolidating, and Combining Workbooks
    • Linking Workbooks
    • Consolidating Workbooks
    • Combining Worksheets

See related categories

Microsoft Excel 2007 - Level 3

Price on request

The best Excel courses

See all

See all