Part Two – Excel - Getting the most out of Excel 

Man studying from home on laptop with house plant
Tuition fees per individual £120*
Delivered online

Online:  

Two parts: 07 & 14 Mar, 5pm - 8pm 

 Book course

*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 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

Part 1  

  • 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 & Reference a named range & across worksheet  
  • Create Excel tables  

 

Part 2  

  • 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 Abbot headshot
Matthew Abbot

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.