FutureLearn
FutureLearn Logo

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

  • Offered byFutureLearn

A Beginner's Guide to Data Handling and Management in Excel
 at 
FutureLearn 
Overview

Duration

3 weeks

Total fee

6,584

Mode of learning

Online

Credential

Certificate

A Beginner's Guide to Data Handling and Management in Excel
 at 
FutureLearn 
Highlights

  • Earn a certificate upon completion
Details Icon

A Beginner's Guide to Data Handling and Management in Excel
 at 
FutureLearn 
Course details

Skills you will learn
More about this course
  • On this three-week course, you’ll gain essential skills to help you use Excel for your personal and professional needs
  • This understanding will help you start to explore more advanced Excel topics such as functions and formulas
  • 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
  • You’ll gain an introduction to charts and how to use graphics to enhance the charts you create
  • 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
Read more

A Beginner's Guide to Data Handling and Management in Excel
 at 
FutureLearn 
Curriculum

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

Other courses offered by FutureLearn

1.81 K
2 weeks
– / –
1.32 L
15 weeks
– / –
72.5 K
10 weeks
– / –
89.23 K
12 weeks
– / –
View Other 1956 CoursesRight Arrow Icon
qna

A Beginner's Guide to Data Handling and Management in Excel
 at 
FutureLearn 

Student Forum

chatAnything you would want to ask experts?
Write here...