Part Two – Excel - Getting the most out of Excel
|Tuition fees per individual
Two parts: 07 & 14 Mar, 5pm - 8pm
Who's the course for?
This course is ideal for those wanting to build on the knowledge gained during the ‘Learning to navigate the Excel world part one’ course. This course is in two parts. You will explore and cover the following topics: Conditional formatting, importing data from text files, formatting tables, adding slicers and sparklines and finally how to visualise your data with charts. This course follows the Microsoft Office Specialist in Excel Certification (MOS) curriculum, if you would like to attain this certification, you can purchase a discounted exam package from Digital Skills after attending and passing all three Excel courses.
What you'll learn
- 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
- Define a named range & Reference a named range & across worksheet
- Create Excel tables
- 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 data series to charts & add and modify chart elements
- 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