Manipulating Data in Excel: Mini Excel Masterclass Series

Overview

In this course, you will learn how to assign meaningful names to cell ranges and tables and understand how to use names in formulas and navigation. As well as practice using text functions to manipulate data and use flash fill to auto-complete data.

Knowing how to manipulate data in Excel offers numerous benefits in today's data-driven world. It enables efficient organisational analysis, and presentation of information, leading to data-driven decision-making. 

Excel proficiency enhances employability, as businesses value individuals who can harness its power for tasks like financial modelling, data visualisation, and trend analysis. 

Learning Outcomes

• Assign a meaningful name to cell ranges and tables in a worksheet.
• Understand how to use names in formulas and navigation.
• Practice using a range of text functions in a formula to manipulate a data string in a cell.
• Use the Flash Fill command to efficiently auto-complete a series of data in a column.

Audience

Anyone looking to explore the basics of Excel.