logo



Contact Us Get Brochure Home Page

 

Advanced Microsoft Excel 2003
Overview

In this course, you will use Microsoft Office Excel to better understand complicated charts. Tasks which once took hours to compile now will take only minutes to set up and assemble. You'll learn when it makes sense to use a macro, how to debug a macro, and how to create and manage a Pivot Chart. Key code shortcuts you learn will transform multi-step processes into single, simple moves. Even the advanced linking and data exchange operations you once dreaded will become easier.

Who Should Attend

This course is designed for any Excel users who wish to learn more about the advanced features of Excel and improve overall productivity.

Brief Course Outline
Microsoft Excel Set Up and Editing
Advanced Excel Formulas and Functions
Making the Most of Excel Macros
arrow Exchanging Data between Excel and Other Applications
arrow Lean How to Sort to Maximize the Data's Usability
arrow Auditing: A Visual Map of your Excel Formulas
arrow How to Build & Manage an Advanced Excel Pivot Chart for Everything Management Wants
arrow The Best Way to Analyze Equations with Scenario Manager
arrow An Advanced Shortcut for Calculating Trends and Projecting Future Ones

Greene County Industrial Training Consortium & Training Center
Black River Technical College
870-239-0969 • 1 Black River Dr. • Paragould, AR 72450

©2007-2008 ~ All rights reserved

Find an error on this site? Contact Webmaster: Audra Howerton