For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Naming Data in Excel: Mini Excel Masterclass Series

Overview

In this course, you'll learn how to assign meaningful names to cells, ranges, and tables in Excel, making your spreadsheets more organised and user-friendly. You will learn how to present and use the Paste function effectively, saving time and effort. 

Discover the advantages of using named ranges, such as simplifying formulas, improving readability, and reducing errors. Whether you're a business analyst, manager, or data professional, this course empowers you.

Learning Outcomes

  • Use Paste Options to paste information into the worksheet in a variety of different ways. 
  • Assign a meaningful name to cell ranges and tables in a worksheet 
  • Understand how to use names in formulas and navigation.

Audience

Anyone looking to explore the basics of Excel.