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

Posted 2 years 1 month ago by Packt

Study Method : Online
Duration : 3 weeks
Subject : Business
Overview
Gain a solid understanding of Excel functions to help you master beginner concepts and analyse data with ease.
Course Description

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.

Requirements

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.

Career Path
  • Describe the basics of creating, navigating and printing workbooks in Excel.
  • Apply formulas and visual enhancements to workbooks.
  • Design workbooks to display relevant data.
  • Identify additional features, shortcuts and tips to work more efficiently in Excel.