This course is for people who are already familiar with the basic functions of Microsoft Excel and would like to find out more. It is delivered over two sessions of 3.5 hours, using segmented lessons that are backed up by short exercises that the tutor takes you through.
Reviewing the basics: a reminder on the ribbon, formatting, simple formulas etc
Using dates in Excel
Formulas vs functions: types of functions and how to use them
The Formula Dialogue Box
Absolute and Relative References: locking formulas to specific data
The IF function: using one of Excel's most useful tools
Using VLOOKUP; why vertical lookups can make your working life so much easier
Charts and other display options: making your data look good – and more intelligible
Pulling it together: use your new learning to build a spreadsheet, step by step
The course is delivered using our purpose-built Excel workbook, which is yours to keep.
All attendees also have free access to an online Excel helpdesk for six months, where we will be happy to provide online refreshers, or help with any issue you have.
This Excel training can be delivered as an in-house session.
We will be happy to arrange an online session of either course for up to 12 of your staff, at a time that suits best for you.
Making Progress in Microsoft Excel - Level Two ,,
"Fantastic session, really engaging and learned plenty.”
“This has been the best course that I've ever done. Really clear, well explained and lots of opportunities to 'have a go'. "
“Learned loads today. Will definitely have impact on my work. Fab”
Robertson House, 152 Bath Street, Glasgow G2 4TB
Thursday, 11 July 2024
09.30 - 16.30
Public Relations and Communication
Civicos has thirty years experience of public relations and communication work and we are available to help your organisation to polish your image and get your message across.
Web Design and Social Media
Civicos can help you to write all of the 'copy' for your new website, and then build the actual site for you. We'll also help you to maintain your new site, and train your staff in its different functions, if needed.
Training Needs Analysis
FREE from Civicos: A Training Needs Analysis report for your organisation
Find out your staff training needs – and save £££s on cost. We will be delighted to perform a FREE, absolutely no-commitment Training Needs Analysis for your organisation.