This intermediate-level Excel course is designed for professionals who already have basic Excel skills and want to take their spreadsheet expertise to the next level. It builds on foundational knowledge and introduces more advanced tools and techniques to help you work smarter and more efficiently.
You'll learn:
- Review of Core Skills
- basic formulas: +, -, *, /
- displaying formulas
- autosum and autofill
- creating and formatting charts
- exporting worksheets and charts
- freeze panes and printing options
- Functions & Formulae
- statistical functions: MIN, MAX, AVERAGE
- counting functions: COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF
- other formulas: Percentage calculations, date and text functions, absolute cell references, watch window
- Named Ranges
- creating and managing named ranges
- using named ranges in formulas
- Conditional Formatting
- applying built-in styles
- creating custom rules
- Working with Worksheets
- inserting, renaming, deleting, moving, and copying worksheets
- grouping worksheets
- creating calculations between worksheets and across workbooks
- Data Lists
- sorting and filtering
- subtotals and removing duplicates
- creating and formatting tables
- Other Useful Tools
- quick analysis
- flash Fill
- sparklines
- comments and notes
- autosum for subtotals and grand totals
- auto outline
This course is practical, hands-on, and tailored to everyday digital needs.
Who is it for
This course is ideal for:
- professionals who use Excel regularly and want to improve efficiency
- learners who have completed a beginner-level Excel course or have equivalent experience
- anyone looking to enhance their data handling and reporting skills
This course is repeating in September and December.
September
| Session | Date | Time |
|---|---|---|
| Evening 1 | Monday 22 September | 6pm to 8:30pm |
| Evening 2 | Wednesday 24 September | 6pm to 8:30pm |
December
| Session | Date | Time |
|---|---|---|
| Evening 1 | Monday 1 December | 6pm to 8:30pm |
| Evening 2 | Wednesday 3 December | 6pm to 8:30pm |
This course is run at Weymouth Library, Great George Street, DT4 8NN. Please note access to the library is restricted during the evenings. You will need to arrive at least 5 minutes early, and enter from the side entrance. A staff member will be present to ensure you can access the building. If you arrive late for your class, you may be unable to enter.
Materials and Costs
- completely free for all learners
- computers provided at Weymouth Library
- light buffet or packed meal provided
- access to Office 365 included
- optional: bring a pen and notebook for personal notes
- no home computer required - library access is available
Register
You can register with in one of the following ways:
- for September start: Enrol on the course
- for December start: Enrol on the course
- in person: Visit Weymouth Library
- by phone: Call the training provider, Skills and Learning on 01202 123444