Cumbria Chamber of Commerce with Lake Mill Consulting Services are holding 3 in-person Excel training sessions- Introduction to Excel (Wednesday 6th October) – Intermediate Excel (Wednesday 3rd November) and Advanced Excel training (Wednesday 1st December). The course will be held at Carlisle Racecourse.
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!
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.
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.
Please bring along your laptop to get the most from the course.
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.
This course covers 2010, 2013, 2016 and Office 365 versions
MODULE 1: Subtotals, Groups and Outlines
Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
- Outlining and Grouping Data
- Using Subtotals Function
MODULE 2: What-If Analysis
Forecasting and solving complicated problems involving your spreadsheet’s data and formulas.
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
MODULE 3: PivotTables
Creating Pivot Tables in order to display and summarise large quantities of data effectively.
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
MODULE 4: Creating charts with Pivoted Data
Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
MODULE 5: Creating HLOOKUP and VLOOKUP Functions
Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.
- Using the VLOOKUP Function
- Using the LOOKUP Function
MODULE 6: Introduction to Macros in Excel
Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros
MODULE 7: Advanced Excel Tools
Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks