Prerequisite

This course presumes that the user has a strong knowledge of Windows concepts as well as an intermediate knowledge of Excel concepts (such as working formulas and functions).

Details

Click on a date to request further information or to register.

Course Outline

There is no disputing that Microsoft Excel is a powerful tool.  This tool allows users to create spreadsheets that can be formatted to allow for sharing of critical data. Users can make informed decisions by formatting and analyzing data. From basic data entry to creating charts and pivot tables for rich data visualization, students will derive a greater appreciation for the value of the data.

Section 1: Getting the Most From Your Data

• Lesson 1.1: Outlining and Grouping your Data
  • Using Automatic Outlining
  • Displaying and Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals
• Lesson 1.2: PivotTables
  • What is a PivotTable?
  • Creating a PivotTable Frame
  • Specifying Data in a PivotTable
  • Rearranging PivotTable Data
• Lesson 1.3: More on PivotTables
  • Modifying PivotTable Calculations
  • Formatting a PivotTable
  • Refreshing a PivotTable
  • Charting a PivotTable
  • Creating a PivotTable Based on Data from an External Database
• Lesson 1.4: Exploring Scenarios
  • What Is a Scenario?
  • Creating a Scenario
  • Creating a Scenario Summary Report
  • Saving Multiple Scenarios
• Lesson 1.5: What if Analysis
  • Using a One and Two Input Data Table
  • Using Goal Seek
  • Using Solver

Section 2: Excel and the Internet

• Lesson 2.1 Excel and Hyperlinks
  • Hyperlinks and the Internet
  • Inserting Hyperlinks
  • Modifying Hyperlinks
  • Using the Web Toolbar
  • Browsing Hyperlinks in Excel
• Lesson 2.2 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
• Lesson 2.3 Getting Data from the Internet
  • Importing from an External Data Source
  • Creating a Web Query
  • Saving a Web Query
  • Refreshing a Web Query

Section 3: Advanced Excel Tasks

• Lesson 3.1: Creating and Using Shared Workbooks
  • Sharing a Workbook
  • Requesting Reviews
  • Reviewing a Workbook
  • Tracking Changes
  • Merging and Revising a Shared Workbook
• Lesson 3.2: 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
• Lesson 3.3: Advanced File Management
  • Identifying File Properties
  • Searching for Files
  • Protecting Personal Information
  • Creating Back Up Files
  • Changing Auto-Recovery Settings
• Lesson 3.4: Excel Security
  • Digital Signatures
  • Macro Security
  • Protecting your Workbook with a Password
• Lesson 3.5: Custom and Advanced Features in Excel
  • Customizing Excel by Changing Options
  • Using Custom AutoFill Lists
  • What is Text to Speech?
  • Using Detect and Repair