Building Microsoft Excel Spreadsheets from Scratch
This intermediate, virtual, instructor‑led course is designed for professionals who want to elevate their spreadsheet‑building skills who have a working knowledge of Excel functions that they wish to build on. Delivered through Microsoft Teams, the course blends live demonstrations, guided practice and exercises to help learners build confidence and capability.
This course is delivered virtually via Teams over 1 day from 9.30am to 4.30pm
Topics covered will include:
Building Spreadsheets
- Introduction, Outline & Objectives
- Using Excel
- Ribbon Bar
- Quick Access Toolbar
- Controlling the Screen
- Keyboard Shortcuts
- Help
- Functions and Formulae
- Entering and Copying Formulae
- Planning and testing Formulae
- Searching for Functions
- Copying Formulae
- Naming Ranges
- Creating Named Ranges
- Using Names in Movement
- Inserting Names in Formulae
- Formatting
- Number Formatting
- Font, Borders, Fills
- Cell Styles
- Copying and Clearing formatting
- Simple Conditional Formatting
Printing
- Printing
- Setting Up Print Areas
- Print Settings
- Page Breaks
- Repeating Print Titles
Charting
- Selecting Data
- Non Contiguous Ranges
- Inserting Charts
- Types and Recommended
- Customising Charts
- [Chart Tools] and Icons
- [Design] options
- [Format] options
- Saving Charts as new types
- Adding Graphics to Chart Series
- Enhancing chart series
What if?
- Conditional Formatting
- Adding Rules
- Modifying Rules
- Date Driven Formatting
- Input Cells
- Entering percentage Cells
- Absolute ($) cell references
- IF() Function
- Arguments
- Entering conditions
- Sumif() and Countif() functions
- VLOOKUP() Function
- Looking up numeric values
- Looking up text values in a list
- Selecting Drop Down values to lookup
Lists
- Lists
- Selecting Lists
- Formatting as Table
- [Table Tools]
- Sorting
- Single Column Sorting
- Multi Column Sorting
- Filtering
- Text Filters
- Number Filters
- Date Filters
- Using Slicers in Tables
- Totals
- Inserting Total Row
- Adding Totals
Pivot Tables
- Pivot Tables
- Creating Pivot Table
- Adding Rows, Columns and Values
- Manipulating Elements
- Grouping Date Fields
- Referring to Pivot Table Data
- Charting Pivot Tables
- Filtering and Slicing
- Applying Row & Column Filters
- Adding Slicers
- Connecting Slicers to multiple Pivot Tables
- Adding Sparklines
- Sparkline types
- Sparkline options
Further Information and Booking
If you're interested in this course please contact the Apprenticeship Team:
Apprenticeships, York College, Sim Balk Lane, York, YO23 2BB
Email: apprenticeships@yorkcollege.ac.uk
Tel: 01904 770368 option 1
Programme Delivery and Costs
This course is delivered virtually via Teams over 1 day from 9.30am to 4.30pm
Individual cost: £110.00
Next Course Dates
17/06/2026
