Basic Navigation and Editing in Excel

Overview

In this course, you will learn the basics of navigation and editing in Microsoft Excel. You'll utilise the Find and Replace function, develop your understanding of finding specific cells in your spreadsheet, and discover how to apply basic formatting in Excel.

You will gain insights into working with multiple worksheets and understanding cell references, setting the stage for more advanced Excel functionalities. By the end of the course, you'll have a solid foundation in Excel navigation and editing and be equipped to navigate spreadsheets easily, make data adjustments efficiently, and lay the groundwork for more advanced Excel capabilities.

Learning Outcomes

• Navigate around the workbook using keystrokes.
• Utilise the Find and Replace functionality to locate a piece of data quickly and make a replacement.
• Apply basic formatting to the spreadsheet, such as changing the font colour and adding borders and shading.
• Explore how to adjust the column width to ensure that data is displayed in a clear and engaging manner.
• Create and rename new worksheets.
• Navigate efficiently between multiple worksheets in a single workbook.

Audience

Individuals looking to further their knowledge of Excel.