Digital Essentials

• Develop an understanding of Microsoft Excel to create and format a simple spreadsheet. 
• 2 hours
• Remotely – workshop setting

Objectives

1. Creating and saving an Excel file – understanding the workbook/sheet format and how to manipulate them
2. Understand how to format a sheet to best display the data using collumn size, colour, alignment and borders
3. Completing basic data input – including use of cell formats for text/number/date etc
4. Using basic arithmetic formulas to automate calculations
5. Using Auto functions – SUM, AVERAGE, MIN, MAX