Excel Charts, Pivots and Macros
This course is aimed at delegates who are using Excel to maintain lists of data and carry out some form of analysis on them. It is designed for people who need to know how to fully understand and manipulate lists to maximum effect.
This will be done by covering data manipulation and filters, the more advanced mathematical and statistical analysis of data and ultimately the use of Pivot Tables, Macros and Charts within Excel.
Type of Course: Computing
Course Reference: HTPP-053
Course duration: One day course
Hosting Mode: Live online or face-to-face
If you are interested in this course, note the course name and reference number, and contact us via the course enquiry form.
Who Should Attend:
Users needing to manipulate and analyse data stored in the form of Excel lists.
Users required to produce in-depth reports that analyse data through the use of complex formulae and/or pivot tables.
Anyone who has to deal with financial (e.g. sales, budgets) or statistical data on a regular basis in their job role.
Prerequisites:
Delegates must be familiar with working in a Microsoft Windows environment i.e. mouse skills, working with multiple windows and screen elements such as scroll bars, menu bars and toolbars.
Delegates are required to have a good working knowledge of Excel – the ability to easily create professional looking workbooks from scratch.
Find out more:
Outcomes
List Management:
Data Forms
AutoFilter
Sorting Data
Creating Sub-Totals:
Creating and Removing
Pivot Tables:
Creating a Pivot Table with the Wizard
Adding & Removing items from the Row & Column areas
Adding Filters with Pages
Summarising numbers in the Data Area
Pivot the Row & Column Headings
Refreshing the Pivot Table
Reducing disk space
Selecting different functions
Format the data & Autoformat
Show data options
Display Grand Totals
Change the sort order of the Rows, Columns or data
Grouping
Multiple Row & Column Items
Drill down in to the Data behind a number
Use Hide & Show Detail
Macros (Recorded):
Record macros
Personal Macro Workbooks
Run macros
Deleting macros
Assign a macro to a command button or a menu item
View VBA Code
Edit a recorded macro
Creating Charts:
Chart Wizard
Chart Types
Customising a Chart
Formatting
Advanced Charts:
Error Bars and Trend lines
Embedding
Dual Y-axis
Beyond Basic Functions – Optional if time:
Basic If Functions
Example Text Function (Left, Right, Mid and Concatenate)
HLookup and VLookup
