Skip to main content
Excel Essentials

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
Start Today

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.

Start Today

Learning Outcomes

  • 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
3. Adding, Editing and Deleting Data
4. Essential Shortcuts for Excel Navigation
5. Essential Shortcuts for Cell Selection
6. Navigating With Hyperlinks

Read More

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
Learning Certificates

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.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world