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.
Weekly study3 hours
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.
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.
Do you know someone who'd love this course? Tell them about it...
Learners who joined this course have also enjoyed these courses.