|
You Will Learn How To
- Leverage features of Microsoft Excel to
facilitate business decisions
- Develop intelligent worksheets to quickly
identify Key Point Indicators (KPIs)
- Perform "what-if" analysis for developing
budget and project plans
- Consolidate and process multidimensional
worksheets
- Summarize and analyze large amounts of
data using PivotTables and Excel features
- Automate Excel processes and enhance
worksheet models
Course Benefits
In today's fast-paced business climate, it is vital that
decisions are made quickly and accurately. In this course, you
use Excel techniques to build sophisticated spreadsheets. You
learn to perform "what-if" analysis, apply functions, manipulate
PivotTables and present your results to make better decisions
for planning, budgeting and more.
Who Should Attend
Business and technical professionals making decisions based
on data analysis, or anyone who wants to increase their
knowledge of intermediate to advanced features in Excel.
Experience with Excel at an introductory level is assumed.
Hands-On Training
Hands-on exercises provide you with practical experience
using Excel. Exercises include:
- Performing statistical and financial
calculations
- Reducing speculation with "what-if"
analysis
- Summarizing data contained in 3-D
worksheets
- Defining the best combination of values to
solve complex business problems
- Designing formulas that capture errors and
require less maintenance
- Creating interactive data reports with
PivotTables
- Developing macros to simplify data analysis
- Planning effective worksheets and
workbooks to improve workbook maintenance
- Highlighting KPIs and data anomalies
with conditional formatting
- Managing variables in worksheets with
Scenarios
- Comparing and contrasting different
datasets with scenario reports
- Determining the magnitude of a variable
with Goal Seek to achieve an end value
- Calculating the optimum variable values
in a worksheet model with Solver
- Discovering and implementing functions
with the FX tool
- Interpreting calculations with the
Formula Auditing tools
- Identifying the correct statistical
function to aid analysis
- Applying basic financial functions
- Differentiating serial dates and date
presentations
- Calculating the number of working days
using the Analysis Toolpak
- Troubleshooting calculations with the
Function Arguments tool
- Interpreting data variations with the
IF function
- Developing nested functions to cope
with multiple conditions
- Capturing information with lookup
functions
- Handling missing information
- Checking data for uniqueness
- Arranging multiple workbooks with
Workspaces
- Managing external links
- Building 3-D formulas to analyze
worksheet data
- Summarizing multiple sources of Excel
information into one worksheet
- Managing multiple datasets on a single
worksheet with the Table feature
- Defining an Excel list to ensure
appropriate use of built-in list features
- Extracting unique lists of records from
an Excel list
- Analyzing lists with filters and
aggregation
- Calculating subtotals and grand totals
- Creating interactive PivotTables and
PivotCharts for real-time data analysis
- Comparing related totals dynamically
- Extracting and filtering records
- Defining data summaries interactively
- Presenting PivotTable reports
effectively
- Exploiting OLAP cubes as a data source
- Recording and executing macros to
simplify complex tasks
- Invoking macros with Form controls
- Working with the Visual Basic Editor
- Identifying the composition of a macro
- Troubleshooting and interpreting code
in a macro procedure
- Modifying macros in the code window
|
|