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

 

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: 

Advance Excel 

You can also contact us at:

Phone: 011 21 21 44 

Mail: info.clpd@aupp.edu.kh

    Book a seat today for this class





    Hello! Sign up to our CLPD Newsletter to not miss out on our upcoming courses and events!

    Sign up to the CLPD Newsletter!