Skip to main content
Lincs Logo

You will need a 2aspire account before enrolling onto a course. Click here to see the guide.

Advanced Spreadsheets (Using Excel)  

 

Visual of the course

Course Summary

Code: 232407  

Starting: Tuesday 30 April 2024 

Duration: 1 sessions over 1 week(s)

Start Time: 09:00 

Provider: Skills 365  

Telephone: 01522 275033  

Email: hello@newskills365.com  

Location: Fixed Distance Learning/E-Learning  

Cost: Free  

Enrol

 

Description

Course length 3 hours - at a time, place and pace to suit you (within 2 weeks) with tutor support 6 days a week.

In our advanced Microsoft Excel course, we will build on your knowledge and teach you how to construct a clear, concise, and informative expert spreadsheet that can be used in any business, club, or personal-use situation. Follow our step-by-step instructions as we produce a multi-sheet workbook that will be used to record a real-life activity before we look at performing a range of complex analysis actions on the results. Upon completion of this course, you obtain a certificate of completion which looks great on your CV for employers or to show your family.

- Worksheet and workbook setup and styles
- Creating headers and footers
- Advanced formula and functions including Count, CountIF, and CountA
- Understand and using Vlookup
- Introducing pivot tables.
- Use multiple worksheets in a spreadsheet workbook
- Use graphs to present your data in a visually appealing way.

Including exercises to practice your new skills and aid understanding.

To enrol please click here  

 


Back
 
 

 

 

© 2024 Lincolnshire County Council | Terms and Conditions | Privacy Notice | Accessibility Statement