Advanced Microsoft Excel 2007 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 Exchanging Data between Excel and Other Applications Lean How to Sort to Maximize the Data's Usability Auditing: A Visual Map of your Excel Formulas How to Build & Manage an Advanced Excel Pivot Chart for Everything Management Wants The Best Way to Analyze Equations with Scenario Manager 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