Learning Outcomes

In this free course, you will learn how to:

• Explain how Excel’s spell check system
• Describe how to format cells and the use of multiple styles of border
• Discuss the way numbers behave in Excel and how to change that behaviour
• Outline useful keyboard shortcuts for editing data in Excel
• Summarise how to group multiple worksheets in Excel
• Outline how to make navigation easier by using mouse and keyboard shortcuts
• Explain how to use data validation rules to prevent the inclusion of bad data
• Outline the features of custom data validation errors and alerts
• Describe how to separate text in a column and remove duplicates
• Explain how to split data of a fixed width
• Summarise the features of ‘flash fill’ in Excel data
• Discuss how to use ‘goal seek’ for simple what-if analysis
• Outline different data types and data tables for multiple input data