Data Manipulation & Formatting
Your journey through Excel begins with the basics. In this course, you will learn how to navigate the core features of manipulating and formatting data to vastly improve your productivity and save valuable time.
Beginner 18 Lessons 150 Minutes CPD Credits
About This Course
Excel can often seem daunting to use at first, thanks to the enormity of features, formulas and functions available. To a beginner, the gap in knowledge can feel overwhelming, but with this course you’ll quickly become comfortable with the basics.
The step-by-step approach will give you a strong understanding of how Excel works at a high level.You’ll learn to navigate the interface with fluency and discover what shortcuts to use to save time.
After completing the 18 lessons, you’ll feel confident in performing basic spreadsheet tasks to manipulate and format data, giving you a solid foundation to build on.
Understand Excel’s user interface
Navigate using keyboard shortcuts
Add, adjust and delete rows and columns
Format cells and their contents
Organize a spreadsheet and its data
1. Getting to Know the User Interface
2. Keyboard Shortcuts
4. Essential Shortcuts for Excel Navigation
5. Essential Shortcuts for Cell Selection
6. Navigating With Hyperlinks
7. Inserting Rows and Columns
8. Adjusting Columns and Rows
9. Freeze Panes, Split Boxes and Zoom
10. Formatting Numbers
11. Formatting Numbers Part 2
12. Formatting Cells
13. Formatting Cells Part 2
14. Grouping and Hiding Cells
15. Paste Special
16. Sorting and Filtering Data
17. Importing Data to Excel
18. Saving and Managing Files
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.