Skip to main content
Western Kentucky University

CWD: Courses: Computer Training

Print this page

Advanced Excel 2010

Introduction

This is an extension of the Intermediate Excel 2010 class and will cover advanced features and student requests. Course content includes various functions, math features, and macros.

Objectives

The participants will be involved in: (1) creating action queries, (2) creating macros, (3) linking to and grouping worksheets to creating a workspace in excel, (4) working with pivot tables and charts, (5) working with goal seeking, and (6) using more advanced formulas.

Content Outline

  • Linking Workbooks and Creating a Workspace with Excel Views

  • Pivot Tables and Pivot Charts

    • Working with Slicers

  • Adding a Hyperlink to a Spreadsheet

  • Macros: Creating and Running Macros

  • More Formulas and Functions

    • Working with Logical Functions

      • i.      And, Or, If, Nested If, V-Lookup

    • Working with Financial Functions

      • i.      Using Goal Seek to find Results

  • Special Number Formats

  • Text to Columns

  • Combination Charts

  • Integration Of Features: Case Study (Time Permitting)

Who Should Attend

This seminar is intended for supervisors, managers, and mid-level managers who create spreadsheets on a regular basis.

(Prerequisite: Intermediate Excel 2010)

SIMPSON Co. Consortium Training

 

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 
 Last Modified 9/25/14