• Packt logo
  • FutureLearn logo

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

Gain a solid understanding of Excel functions to help you master beginner concepts and analyse data with ease.

A woman sits at her desk, in a office, smiling.

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.

Download video: standard or HD

Skip to 0 minutes and 1 second SPEAKER: Just getting started with data handling in Excel? Need some help? Look no further, as this course is your chance to exceed your Excel expectations in just three weeks. Follow Microsoft Excel expert Cindy McGuckin from Simon Sez IT, as she shows you how to put the Excel back in excellence. This course will help you create, navigate, and print workbooks in Excel, apply formulas and visual enhancements, design workbooks to display specific data, and identify features, shortcuts, and tips to work more efficiently in Excel. And you can learn all this at any time, at any pace, and from anywhere you want. Step into your future with A Beginner’s Guide to Data Handling and Management in Excel from Packt and FutureLearn.

Syllabus

  • Week 1

    Creating your workbook

    • Introduction to the course

      Welcome to A Beginner’s Guide to Data Handling and Management in Excel and the start of your learning journey, brought to you by Packt.

    • Excel 2019 Introduction

      In this activity , we will explore the new features of Excel 2019, learn more about the Excel window mouse features and the backstage view.

    • Creating Workbooks

      In this activity, we will enter text and numbers, create basic formulas, learn about relative references and the order of operations.

    • Saving and navigating workbooks

      In this activity, we will learn about saving commands and explore navigation within the workbook.

    • Page setup and print options

      In this activity, we will discuss headers and footers, print titles, comments, page setup options, and printing settings.

    • Working with rows, columns, and cells and moving data

      In this activity, we will explore working with rows, columns and cells and demonstrate how to move data.

    • Wrap up

      You have reached the end of Week 1. In this activity, you'll reflect on what you have learned.

  • Week 2

    Setting up your workbook

    • Introduction to Week 2

      Welcome to Week 2. In this activity we'll highlight the main topics that will be covered this week.

    • Formulas and functions

      In this activity, we will discuss formulas, create formulas using functions, learn about absolute values and complete a practice exercise.

    • Working with and formatting sheets

      In this activity, we will discuss adding, deleting, and renaming sheets, additional sheet tab options and 3D formulas.

    • Formatting worksheets

      In this activity, we will discuss borders and shading, formatting cells as a table and using the format painter tool.

    • Charts

      In this activity, we will describe how to create charts, how to edit charts, how to use graphics to enhance charts, and how to link chart titles.

    • Wrap up

      You have reached the end of Week 2. In this activity, you'll reflect on what you have learned.

  • Week 3

    Working with your workbook

    • Introduction to Week 3

      Welcome to Week 3. In this activity we'll highlight the main topics that will be covered this week.

    • Working with names; sorting and filtering

      In this activity, we will create and manage range names, use range names in formulas and learn how to remove duplicates, sort data and filter data.

    • Outlining and subtotaling, and working with views

      In this activity, we will describe the process of creating an outline and subtotaling. You will also learn about arranging files, the new window option, and custom views.

    • Linking files and advanced formula creation

      In this activity, we will create formulas between files, work with links, and consolidate data. We’ll also look at if statements, VLOOKUPs, data validation and formula auditing.

    • Pivot tables, additional Excel features, shortcuts and closing

      In this activity, we will discuss additional features such as pivot tables and charts, slicers, goal seeker, changing text to columns, the watch window, ribbon and tab customisation and shortcuts.

    • Wrap up

      You have reached the end of Week 3. In this activity, you'll reflect on what you have learned.

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

  • 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.

Who is the course for?

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.

Who developed the course?

Packt

Founded in 2004 in Birmingham, UK, Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.

FutureLearn

FutureLearn is owned by Global University Systems and has been providing online courses for learners around the world over the last ten years.

What's included?

This is a premium course. These courses are designed for professionals from specific industries looking to learn with a smaller group of like-minded individuals.

  • Unlimited access to this course
  • Includes any articles, videos, peer reviews and quizzes
  • Certificate of Achievement to prove your success when you're eligible
  • Download and print your Certificate of Achievement anytime

Still want to know more? Check out our FAQs

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps to help you keep track of your learning
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Do you know someone who'd love this course? Tell them about it...