Course No. XL21
Excel II Intermediate
Description:
This class builds from the foundation laid in Excel I; and introduces the participant to the finer points of the software. Learn how to use Excel for more challenging tasks such as making forecasts and computing with conditional statements. Build and run simple macros to eliminate the drudgery of repetitive tasks. Explore some of the data analysis techniques such as filtering based on pre-determined criteria, and the use of pivot tables. This workshop is a must for those who want to enhance their abilities in data analysis.
Benefits:
- Analyze data with confidence
- Eliminate repetitive tasks by automating the same
- Develop the ability to make forecasts based on available data
Topics Covered:
- Use of formulas in Excel
- Building simple conditional statements using IF and compound IF
- Built in functions in Excel for data analysis
- Macros - creating, assigning to a button, and running
- Graphs and Charts
- Pivot Tables
- Exercise I Creating a forecast
- Exercise II Macro for executing simple commands
- Exercise III Use of pivot tables
NOTE: The above exercises can be customized to suit your company if needed; please contact us 4 weeks ahead of class date
Pre-requisites: Excel I from TEAM 2000
Duration: 1 Day
Suggested Audience: All interested in beginning to harness the power of Excel
Participants: Maximum: 20 participants
Books and Materials: Provided by the instructor / TEAM 2000
Presented By: