MS Excel - Mastering tables and charts

COURSE OUTCOMES

 

We have designed our MS Excel training to take your skills to next level. Learn about Logical Functions, Advanced List Management, master Pivot Tables, as well as the “What if analysis” and Macros. Business Intelligence Reporting begins with Excel.

By attending this course, delegates will be able to:

  • Use Excel to produce professional looking charts
  • Produce charts quickly and efficiently using Excel tools
  • Produce meaningful Charts that give the correct information
  • Understand the different types of Charts and when to use them

COURSE OUTLINE 

  • Charting tools and menus
  • Using Chart Gallery controls
  • Creating a Chart
  • Working with Charts
  • Customising Charts using the Design Ribbon
  • Creating your own theme
  • Identifying Chart Elements
  • Chart Analysis Elements
  • Formatting Chart Elements
  • Creating charts to show trends
  • Creating charts to show differences
  • Using SmartArt Graphics and Shapes
  • Exporting Charts
  • Sparklines
  • Chart templates
  • Printing Charts
Contact Details

Contact Person: 

Bianca van Wyk
Course Details

Course Delivery Method: 

In Class In Class

Presented Presented Courses

In House In-House

On Demand On Demand

Course Duration: 

0.5 day

Cost: 

R875.00

Course fee Includes: 

Refreshments