Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This 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.

Download Outline (PDF)

Data List Revision
  • Data List Essential Skills
  • Sorting Data Lists
  • Filtering Data & Custom Filters
  • Naming Cells & Ranges
Introducing PivotTables
  • 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
Automating Spreadsheets with Macros
  • 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.