Advance Excel

Course Modules

Objectives:

• Advance your watch Window skill
• Learn how to use the Evaluate formula dialog box
• Use Trace Precedents features
• Insert complex mathematical equations

Module 1: 

• How to use the Watch Window to watch the values of selected cells as you change values on your worksheet
• How to use the Evaluate Formula dialog box to evaluate each part of your complex formulas individually to locate and correct any errors
• Understanding and using the Trace Precedents and Trace Dependents features
• Objects, charts and sparklines

Module 2: 

• How to quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse
• How to insert complex mathematical equations and symbols into your worksheets
• How to use the new Screenshot feature to quickly insert a screenshot of any open application
• How to quickly select your data and insert a chart into your worksheet

Module 3: 

• Bar chart, pie chart, line chart—how to choose and use the right type of chart to get your point across
• How to use the Chart Tools to create stunning charts that have that professional look
• How to save your finished chart as a template that you can apply to future charts
• Stock, Surface, Doughnut, Bubble and Radar—how using advanced chart types can capture your audience’s attention

Training Methodology

• Instruction by an expert facilitator
• Practical illustrations
• Interactive classes
• Group discussions
• Workshops
• Simulations
• Case studies