UpcomingExcel 2007 Level 3


Price Qty*
June 28, 2017 show details + $267.75 (CAD)  

  • June 28, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)

Course length: 1 day

You are training in and use of Microsoft® Office Excel® 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Excel® 2007. You have used Microsoft® Office Excel® 2007 to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Course Objective: You will automate some common Excel tasks; apply advanced analysis techniques to more complex data sets, and using external data in Excel.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Prerequisites: To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

  • Microsoft® Office Excel® 2007 Level 1
  • Microsoft® Office Excel® 2007 Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • use PivotTables
  • increase productivity and improve efficiency by streamlining your workflow with Macros.
  • analyze and organize data.
  • import data.
  • use Excel with the web.
  • working with objects

Course Content

Lesson 1: Working with PivotTables

  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart

Lesson 2: Analyzing & Organizing Data

  • Creating Scenarios
  • Creating a Scenario Report
  • Working with Data Tables
  • Using Goal Seek and Solver
  • Using Data Validation
  • Using Text to Columns
  • Removing Duplicates
  • Grouping and Outlining Data
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas

Lesson 3: Working with the Web and External Data

  • Inserting a Hyperlink
  • Creating a Web Page from a Workbook
  • Importing Data from Access or Text Files
  • Importing Data from the Web or Other Sources
  • Displaying and Managing Connections

Lesson 4: Working with Macros

  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar
  • Editing a Macro’s Visual Basic Code
  • Inserting Copied Code in a Macro

Lesson 5: Working with Objects

  • Inserting Clip Art, Pictures and Graphics Files
  • Formatting Pictures and Graphics
  • Inserting and Formatting Shapes
  • Resize, Move, Copy and Delete Objects
  • Grouping Objects
  • Aligning, Flipping, Rotating, and Laying Objects
  • Inserting and Formatting SmartArt
  • Using WordArt
  • Inserting an Embedded Object
  • Inserting Symbols

Lesson 6: Advanced Topics

  • Customizing the Quick Access Toolbar
  • Changing Excel’s Default Options
  • Recovering your Documents
  • Viewing Documents Properties and Finding a File
  • Saving as a PDF or XPS
  • Adding and Digital Signature
  • Preparing a Workbook for Publishing and Distribution
  • Publishing a Workbook to a Workspace
  • Creating a Custom AutoFill List
  • Creating a Custom Number Format
adminUpcomingExcel 2007 Level 3