How to use a spreadsheet to record, layout, analyse, graph and report on data using a spreadsheet application.
Make numbers work for you by learning how to use spreadsheets to record and analyse data.
Format numbers and text, and use functions to create mathematical and logical formulas.
Manage multiple workbooks, and save time with built-in templates and auto-complete features.
Illustrate data patterns and gain insights with stylish, high-impact charts and graphs.
What you will learn
Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.
Work with spreadsheets and save them in different file formats
Choose built-in options such as the Help function within the application to enhance productivity
Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
Format numbers and text content in a spreadsheet
Choose, create and format charts to communicate information meaningfully
Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets