A Beginner’s Guide to Data Handling and Management in Excel

Develop your Excel skills

Millions of people use Microsoft Excel worldwide. That’s because when its full potential is unlocked, it can drastically improve productivity and workflow.

On this three-week course, you’ll gain essential skills to help you use Excel for your personal and professional needs.

Following along with interactive activities and practical exercises, you’ll learn how to use Excel to handle and analyse data efficiently.

Learn how to navigate an Excel workbook

Starting with the basics, you’ll learn how to create workbooks and enter data before mastering the cut, copy, and paste options.

This understanding will help you start to explore more advanced Excel topics such as functions and formulas.

Unpack key Excel functions

Delving further into workbooks, you’ll explore the page setup and print options to ensure your formatting is correct.

You’ll understand how to navigate rows, columns, and cells and start to work with sheets. You’ll learn how to add, delete, rename, and format sheets, which will be your starting point for handling data.

Understand how to use pivot tables

You’ll gain an introduction to charts and how to use graphics to enhance the charts you create.

Next, you’ll delve into pivot tables to help you quickly summarise large groups of data with ease.

By the end of the course, you’ll have the skills and confidence to start using Excel to handle and analyse data. You’ll have a solid foundation of knowledge to build on with more advanced Excel functions in the future.

This course is designed for anyone who wants to learn how to use Excel and its different functions.

You don’t need any prior knowledge as this course will start from the very basics.

• Creating your workbook
• Introduction to the course
• Excel 2019 Introduction
• Creating Workbooks
• Saving and navigating workbooks
• Page setup and print options
• Working with rows, columns, and cells and moving data
• Wrap up
• Setting up your workbook
• Introduction to Week 2
• Formulas and functions
• Working with and formatting sheets
• Formatting worksheets
• Charts
• Wrap up
• Working with your workbook
• Introduction to Week 3
• Working with names; sorting and filtering
• Outlining and subtotaling, and working with views
• Linking files and advanced formula creation
• Pivot tables, additional Excel features, shortcuts and closing
• Wrap up