A Beginner’s Guide to Data Handling and Management in Excel
Posted 2 years ago by Packt
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.
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.
- 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.