
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
Course Details
Dates & Location
AUPP Campus
The CLPD Experience
Joining a CLPD class means getting an access to numerous unique advantages that only our center can provide in Cambodia:
- State of the art training facilities with modern lecture halls and equipment
- Expert Western instructors with decades of experience in senior positions. 100% of them hold a post-graduate degree.
- International quality standards at every step, from the curriculum creation to the delivery and follow-up
- Certificates of completion recognized by the American University of Phnom Penh and valued by employers
Want More Information?
Check our Course Outlines (PDF) here:
You can also contact us at:
Phone: 011 21 21 44
Mail: info.clpd@aupp.edu.kh