Loading Events
  • This event has passed.

In-person training – Excel Training with Cumbria Chamber of Commerce – Advanced Excel – Monday, 6th June 2022 – Penrith

Cumbria Chamber of Commerce with Lake Mill Consulting Services are holding 3 in-person Excel training sessions- Introduction to Excel (Monday 11th April) – Intermediate Excel (Monday 9th May) and Advanced Excel training (Monday 6th June). The course will be held at The George Hotel, Penrith.

Each workshop is £120+VAT for Chamber members, or £170+VAT for non-members.  Lunch is included in this cost.

If you want to book all 3 courses use code EXCEL to save £20+VAT per course, a total of £60+VAT saving!

BOOK HERE

See Introduction to Excel here, or Intermediate Excel here.

Excel Advanced
Duration
This is a one-day training course structured into 7 modules. Commencing 9.00am We will have an introduction then the course will commence at 9.30. We aim to be finished for 4.00pm.

Course Aims
This training course is designed to familiarise users with the main features of Microsoft Office Excel. It is entirely ‘hands on’, so those attending will get practice in creating and modifying actual spreadsheets.

Computers/laptops are NOT provided, please bring your own device to work on.

Target Audience
The course is intended for more competent users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be familiar with using a PC with the Microsoft Windows operating system, and prior experience with Excel is required.

Versions Covered:
This course covers 2010, 2013, 2016 and Office 365 versions

MODULE 1: Subtotals, Groups and Outlines
Outcome:
Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
Topics:

  • Outlining and Grouping Data
  • Using Subtotals Function

MODULE 2: What-If Analysis
Outcome:
Forecasting and solving complicated problems involving your spreadsheet’s data and formulas.
Topics:

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

MODULE 3: PivotTables
Outcomes:
Creating Pivot Tables in order to display and summarise large quantities of data effectively.
Topics:

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

MODULE 4: Creating charts with Pivoted Data
Outcomes:
Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
Topics:

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

MODULE 5: Creating HLOOKUP and VLOOKUP Functions
Outcomes:
Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.
Topics:

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

MODULE 6: Introduction to Macros in Excel
Outcomes:
Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
Topics:

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

MODULE 7: Advanced Excel Tools
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

BOOK HERE

Should you have any questions regarding the above training, please do not hesitate to contact training@cumbriachamber.co.uk.

Any cancellations must be received at least three working days before the event, otherwise you will be charged for non-attendance.

Chamber Business Solutions is also able to deliver bespoke and in-house training – with our highly experienced team of trainers and subject matter experts we are committed to assisting you get the business results you need to achieve. For further information on how we can help your business please contact training@cumbriachamber.co.uk.

If you have a disability or long term health condition, would you like any information or any adjustments that would help the training work better for you? We’ll do what we can! Please email training@cumbriachamber.co.uk. or call Tracey Telford, Training Coordinator on 0845-226-0040 to let us know or to talk about what would be helpful.

© Cumbria Chamber of Commerce
Book this event now