Objectives of the training
To provide the knowledge and skills required to use the different Microsoft Excel graphics and dynamic pivot table features.Targeted audience
Any audience.Prerequisite
Basic knowledge of Excel.Trainers
Course architecture
- Why and when to use a DCT
- Data sources that can be used to design a DCT
- Choosing and preparing the data source
- Designing, modifying and embellishing
- Filtering and grouping data
- Creating copies
- Refreshing your data
- Performing calculations in a DCT
- Protection of information
- Creating a dynamic cross tabbed chart
- Appropriate chart types
- Preparing source data to create charts
- Formatting
- The chart area
- Axes
- Number Formats
- Legend and title
- Data series
- Adding data to an existing graph
- Adding a curve to a histogram chart
- Modifying data axes
- Resizing
- Creating various types of charts
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote