MS Excel – Level 1

On successful completion of this programme, students will be able to create and develop Excel worksheets and workbooks, and analyse the data that is critical to the success of their organisation.

Target Audience:

This course is for students who need a foundational understanding of Excel to create and work with electronic spreadsheets.

View Brochure


Getting StartedNavigate the Excel user interface
Use Excel commands
Create and save a basic workbook
Enter cell data
Performing CalculationsCreate worksheet formulas
Insert functions
Reuse formulas
Modifying a WorksheetInsert, delete, and adjust cells, columns, and rows
Search for and replace data
Use proofing and research tools
Work with macros
Formatting a WorksheetModify fonts
Add borders and colours to worksheets
Apply number formats
Align cell contents
Apply styles and themes
Apply basic conditional formatting
Create and use templates
Use formulas and functions to apply conditional formatting
Printing WorkbooksPreview and print a workbook
Define the page layout
Managing WorkbooksDetermine potential outcomes using data tables
Manage worksheets
Manage workbook and worksheet views
Manage workbook properties
Appendix: Microsoft Excel common keyboard shortcuts