CANCELLED: – FALL ACCESS CPE – TIMONIUM: Excel Charts, Graphs and (1FALL4-14)
Description
Professionals who work with Excel every day will benefit from these
advanced topics. This fast-paced program covers: range naming,
decision-making IF and VLOOKUP functions, financial functions, Pivot
Table reporting, controlling calculation inputs, securing files, formula
auditing, external formula linking, many multiple worksheet tips and
time-saving usage of the macro recorder. The content of this
presentation applies to Excel 2007 or 2010. (Format choices: “Lecture
only with live demo” or “hands-on, participants bring laptops or
tablets”)
Learning Objectives
Learn to use advanced functions for IF testing and Lookup
Understand
how to use the Excel Pivot Table feature to report data summaries in
seconds
Be able to incorporate a variety of multiple worksheet tips
and external formulas linking
Understand range naming, formula
auditing, conditional formatting and protecting features
Learn how the
macro recorder can save time with repetitive tasks
Major Topics
Range names
New Name Manager dialog box for quick cell/range
identification and formula building
IF testing, nested function rules,
decision making functions and lookup
Date and text functions
Conditional Formatting to identify data patterns in color
Suppress the
display of Excel error messages in cells
Use formula auditing tools to
trace formula dependencies across sheets
Use the watch window to track
calculations on a sheet
Use the Data Validation feature to control
user input
Group and outline according to formula structure
Create
and repair external formula links
Control calculation of external
links with new user prompt controls
Link from Excel to Word
Group
worksheets to take action on more than one worksheet at the same time
Use 3-dimensional functions across sheets
Copy sheets in the same file
or to a new file
Understand list design rules and the new Table
feature
Use Pivot Tables to analyze data by category with subtotals
Learn Pivot Table tips for recalculation and duplicating Pivot Tables
Create a Pivot Table report of unique values, codes or categories from
data
Create a calculated field in a Pivot Table
Use Excel commands
to create multiple Pivot Tables automatically
Use Pivot Table options
for automatic recalculation
Create a Pivot Table of multiple
consolidated ranges
Record macro examples for printing and formatting
and data cleanup
Understand the variety of ways to run macros
Take
away templates and references for after class use
Provider
SCG Training & Consulting
Course Level
Update
CPE Field of Study
Communications*
4
Prerequisites
Intermediate/Advanced knowledge of Microsoft Excel
Location
Loyola Graduate Center
2034 Greenspring Dr Lutherville-Timonium, MD21093US
