Excel Level 2 - Intermediate Excel: working with data, conditional formatting to charts
Tuition fees per individual | £150* |
---|---|
Delivered online |
Online: Two parts: 13 Jun 1pm - 4pm and 14 Jun 9am - 12pm |
*If you're a student or staff different fees apply. Please visit our dedicated student and staff areas for specific information.
Who's the course for?
This two-part course, will teach you the intermediate skills needed to use Excel. This course is the second in a series of three courses and can also be attended as a standalone course. In this course, you will build on your knowledge learning intermediate level skills within Excel. This will include conditional formatting, importing data from text files, formatting tables, adding slicers and sparklines and finally how to visualise your data with charts. After completing all three courses in this Excel series you will receive an overall digital badge showing your mastery of the software and have the opportunity to take the MOS Excel exam.
What you'll learn
Session One
- Apply number formats
- Apply cell formats
- Cell styles & Clear cell formatting
- Conditional formatting
- Display formulas
- Import data from text files
- Insert and delete multiple columns or rows & insert and delete cells
- Merge and unmerge cells - for accessibility
- Format multiple worksheets
- Sparklines
- Define a named range and reference a named range across a worksheet or worksheets
- Create tables
Session Two
- Add or remove table rows and columns.
- Apply table styles
- Configure table style options & insert and configure total rows
- Filter records & Sort data by multiple columns
- Using slicers
- Pivot tables
- Perform calculations by using formula functions
- Create Charts & create chart sheets
- Add/remove data series and chart elements to charts
- Add alternative text to charts for accessibility
Matthew Abbott - Course Lead
Matthew is a digital skills trainer at Falmouth, specialising in Microsoft Office 365 and Adobe Premiere Pro. He delivers a range of Adobe and Microsoft Courses including Microsoft Office Specialist (MOS) and Adobe Certified Professional (ACP) courses. He holds a degree in sustainable product design and a PCET teaching certificate and have taught as a Senior Technician at Falmouth University for over 20 years.
Read our short course terms & conditions