Category
ICT
Course Type
Microsoft
Price Per Course
£595 for any two half day courses +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
Half day
Full/Part Time
Part Time
Provider
Dates and Locations
Contact us for the latest course dates.
Book courseThis course is intended for users who need to automate commands with macros; and analyse, summarise and present large volumes of data using PivotTables and PivotCharts.
Objectives:
By the end of the course users will be able to create PivotTables and PivotChart reports of varying complexities. Users will also be able to automate commands by recording simple macros and assigning them to shortcuts and buttons.
Prerequisites:
A thorough grounding in building spreadsheets which include functions such as Min, Max, and Average.
- Data List Essential Skills
- Sorting Data Lists
- Filtering Data & Custom Filters
- Naming Cells & Ranges
- Creating a PivotTable
- Adding, Moving & Removing Fields
- Sorting & Filtering Pivot Data
- Grouping & Ungrouping Pivot Data
- Drill Down & Extract Data
- Summary Functions
- Formatting PivotTables
- Creating PivotChart Reports
- Introducing Macros
- Recording & Running Macros
- Assigning Macros to Shortcuts
- Adding Macros to the Quick Access Toolbar
- Editing & Deleting Macros
- Macro Virus Protection
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
