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

789 enrolled on this course

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

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

789 enrolled on this course

  • 3 weeks

  • 3 hours per week

  • Digital certificate when eligible

  • Introductory level

Find out more about how to join this course

  • Duration

    3 weeks
  • Weekly study

    3 hours
  • 100% online

    How it works
  • Unlimited subscription

    $244.99 for a whole yearLearn more

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.

What topics will you cover?

Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities.

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.

  • Available now

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 logo

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 logo

FutureLearn

FutureLearn is a leading social learning platform and has been providing high quality online courses for learners around the world over the last ten years.

Ways to learn

Buy this course

Subscribe & save

Limited access

Choose the best way to learn for you!

$54/one-off payment

$244.99 for a whole year

Automatically renews

Free

Fulfill your current learning needDevelop skills to further your careerSample the course materials
Access to this courseticktick

Access expires 25 Feb 2025

Access to 1,000+ coursescrosstickcross
Learn at your own paceticktickcross
Discuss your learning in commentstickticktick
Certificate when you're eligiblePrinted and digitalDigital onlycross
Continue & Upgrade

Cancel for free anytime

Ways to learn

Choose the best way to learn for you!

Subscribe & save

$244.99 for a whole year

Automatically renews

Develop skills to further your career

  • Access to this course
  • Access to 1,000+ courses
  • Learn at your own pace
  • Discuss your learning in comments
  • Digital certificate when you're eligible

Cancel for free anytime

Buy this course

$54/one-off payment

Fulfill your current learning need

  • Access to this course
  • Learn at your own pace
  • Discuss your learning in comments
  • Printed and digital certificate when you’re eligible

Limited access

Free

Sample the course materials

  • Access expires 25 Feb 2025

Find out more about certificates, Unlimited or buying a course (Upgrades)

Sale price available until 3 March 2025 at 23:59 (UTC). T&Cs apply.

Find out more about certificates, Unlimited or buying a course (Upgrades)

Sale price available until 3 March 2025 at 23:59 (UTC). T&Cs apply.

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