Microsoft Excel 2019
Format
Self-paced
Price
£199
About the course
Develop practical spreadsheet skills through a series of self-paced, hands-on labs aligned with key concepts associated with the Microsoft Excel 2019 and MO-200 certification objectives.
The course introduces essential workbook and worksheet navigation, formatting, customisation, and data management techniques, helping learners work efficiently with spreadsheets and organise information for analysis and reporting.
Learners will explore importing data from text and CSV files, manipulating worksheet data, searching within workbooks, working with hyperlinks, and customising window views.
Practical exercises cover filtering and sorting records, working with cell references, and using mathematical, COUNT, IF, and text functions to perform calculations and transform data.
Additional labs focus on formatting cells and worksheets, creating and formatting Excel tables, summarising data visually, building and modifying charts, and working with sparklines and chart layouts.
Learners will also explore accessibility through alternative text, workbook inspection, workbook properties, formula display, alternative file formats, and print configuration.
The labs connect spreadsheet concepts with practical tasks, helping learners improve data accuracy, organise information, perform calculations, identify trends, and present results clearly.
Activities also reinforce efficient workbook management, professional formatting, accessible data presentation, and preparing spreadsheets for printing and sharing.
By completing the labs, learners will develop foundational skills in worksheet navigation, data import and manipulation, formulas and functions, sorting and filtering, table management, chart creation, visualisation, workbook inspection, file handling, and print settings.
The course provides a practical foundation for further development in spreadsheet analysis, business reporting, data management, and preparation for the Microsoft Excel MO-200 certification.
The course introduces essential workbook and worksheet navigation, formatting, customisation, and data management techniques, helping learners work efficiently with spreadsheets and organise information for analysis and reporting.
Learners will explore importing data from text and CSV files, manipulating worksheet data, searching within workbooks, working with hyperlinks, and customising window views.
Practical exercises cover filtering and sorting records, working with cell references, and using mathematical, COUNT, IF, and text functions to perform calculations and transform data.
Additional labs focus on formatting cells and worksheets, creating and formatting Excel tables, summarising data visually, building and modifying charts, and working with sparklines and chart layouts.
Learners will also explore accessibility through alternative text, workbook inspection, workbook properties, formula display, alternative file formats, and print configuration.
The labs connect spreadsheet concepts with practical tasks, helping learners improve data accuracy, organise information, perform calculations, identify trends, and present results clearly.
Activities also reinforce efficient workbook management, professional formatting, accessible data presentation, and preparing spreadsheets for printing and sharing.
By completing the labs, learners will develop foundational skills in worksheet navigation, data import and manipulation, formulas and functions, sorting and filtering, table management, chart creation, visualisation, workbook inspection, file handling, and print settings.
The course provides a practical foundation for further development in spreadsheet analysis, business reporting, data management, and preparation for the Microsoft Excel MO-200 certification.
Course Lessons
