Name: high wycombe bucks
Start: 2015-07-27T15:30
Location: high wycombe bucks

Course Type Pubic Training Course Reading

Here is list of all our Upcoming training course in Reading

Course Type

Course Type & location

Course Location

Past & Future Courses

april

2020mon06apr9:15 am4:30 pmReport WritingLearn How to Plan & Write Professional Reports9:15 am - 4:30 pm Reading Greyfriars, 9 Greyfriars Road Reading Berkshire RG1 1NU Training Course Price : 295

2020wed22apr9:15 am4:30 pmExcel Advanced Training9:15 am - 4:30 pm Reading Greyfriars, 9 Greyfriars Road Reading Berkshire RG1 1NU

Training Course Detials

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

MODULE 1: Grouping & Outlining and Subtotals

Learning outcomes:

Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

Outlining and Grouping Data
Using the Subtotals Tool

MODULE 2: What-If Analysis

Learning outcomes:

Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet’s data and formulas.

Topics covered:

Exploring Scenarios
Goal Seek and Data Tables
Using Solver

MODULE 3: PivotTables

Learning outcomes:

Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

Getting Started with PivotTables
Displaying Data in a PivotTable
Formatting a PivotTable
Using the Classic PivotTable Layout
Slicers

MODULE 4: Charting Pivoted Data

Learning outcomes:

Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

Getting Started with PivotCharts
Using the PivotChart Tools Tabs
Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

Learning outcomes:

Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

Excel and Hyperlinks
Using Custom AutoFill Lists
Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

Learning outcomes:

Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.

Topics covered:

Using the VLOOKUP Function
Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

Learning outcomes:

Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

Topics covered:

Recording and Playing Macros
Copying and Deleting Macros
Visual Basic and Macros

Want to see other Excel course at other locations?

Time

wednesday 22 april 2020 9:15 AM - wednesday 22 april 2020 4:30 PM

Location

Reading Greyfriars

9 Greyfriars Road Reading Berkshire RG1 1NU

Reading Greyfriars9 Greyfriars Road Reading Berkshire RG1 1NU

Calendar GoogleCal

2020fri24apr9:15 am4:30 pmRecruitment Interviewing Training CoursesManagers & supervisors improve your Interviewing9:15 am - 4:30 pm Reading Greyfriars, 9 Greyfriars Road Reading Berkshire RG1 1NU Training Course Price : £

Course Type: Pubic Training Course Reading