Loading Events

Excel Intermediate – 18th December – Carlisle – Cumbria Chamber of Commerce

Events listing

Join Lorraine Millican of Lake Mill Ltd and Cumbria Chamber of Commerce 9am to 4pm, for a day of training designed to familiarise users with the main features of Microsoft Office Excel.

The delegate rate for either of these one day workshops is £95 + VAT members / £145 +VAT non-members.

To book a place on this workshop, you will be directed to our third party event booking site. The information you provide remains the property of Cumbria Chamber of Commerce and will not be used by the third party in any manner. 

BOOK HERE

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 new 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 basic prior experience with Excel is required.

PLEASE NOTE: VERSIONS COVERED This course covers 2010, 2013, 2016 and Office 365 versions

MODULE 1: Advanced File Tasks

Different options when managing and controlling Excel files.

Topics covered: Saving and File Management ; Converting and Encrypting Files ; File Properties and Digital Signatures ; File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered: Formulas with Absolute References ; Autosum Functions (SUM & AVERAGE) ; IF and Nested Functions ; Working with Named Ranges ; Array Functions (SUMIF & AVERAGEIF) ; Formula Auditing ; Text Functions

MODULE 3: Managing Tables

Managing spreadsheet data in table format, useful with large sets of data.

Topics covered: Creating Excel Tables ; Working with Records and Filters ; Advanced Filters

MODULE 4: Data Tools

Features to help save time managing and formatting the data

Topics covered: Text to Columns ; Flash Fill ; Remove Duplicates ; Data Validation ; Consolidate

MODULE 5: Exploring Charts in Excel

Developing your ability to effectively create charts and format them specific to the reader

Topics covered: Trendlines ; Error Bars ; Working with Axis Options ; Advanced Chart Formatting

MODULE 6: Sparklines

Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

Topics covered: Creating Sparklines ; Editing Sparklines

MODULE 7: Using Styles and Themes

Working with Themes ; Creating Custom Styles ; Applying Cell Styles

BOOK HERE

Should you have any questions regarding the above training, please do not hesitate to contact me catherynn@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 catherynn@cumbriachamber.co.uk

© Cumbria Chamber of Commerce
Book this event now