Course
|
Excel

Data Manipulation and Formatting

Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.
3 HOURS
Beginner
18 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Learn how to insert, edit, delete, and sort data efficiently in Excel.
Master techniques for rapid navigation to boost productivity.
Apply formatting tools to enhance the clarity and readability of spreadsheets.
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Data Manipulation and Formatting

Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.
3 HOURS
Beginner
18 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Learn how to insert, edit, delete, and sort data efficiently in Excel.
Master techniques for rapid navigation to boost productivity.
Apply formatting tools to enhance the clarity and readability of spreadsheets.
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

18 Lessons
Getting to Know the User Interface
3 MINS
LESSON
Getting to Know the User Interface
Exercise

Take a tour of Excel's user interface so that you can understand how to access commands in the ribbon, change the view setting in the footer and much more.

Keyboard Shortcuts
5 MINS
LESSON
Keyboard Shortcuts
Exercise

Keyboard shortcuts dramatically improve your productivity in Excel. This lesson explains the two types of keyboard shortcuts in Excel and how to use them.

Adding, Editing and Deleting Data
3 MINS
LESSON
Adding, Editing and Deleting Data
Exercise

After a quick tour of the Excel user interface, this lesson will show you how to insert, edit and delete data in a spreadsheet.

Essential Shortcuts for Excel Navigation
6 MINS
LESSON
Essential Shortcuts for Excel Navigation
Exercise

A few keyboard shortcuts can help you navigate in double-quick time. Here I show you how to use these shortcuts on a sample sales datasheet.

Essential Shortcuts for Cell Selection
3 MINS
LESSON
Essential Shortcuts for Cell Selection
Exercise

Selecting cells can be accomplished very quickly with a couple of very useful keyboard shortcuts. Find out how they work in this short lesson.

Navigating With Hyperlinks
5 MINS
LESSON
Navigating With Hyperlinks
Exercise

Hyperlinks let you navigate from one part of a spreadsheet to another, or to external content, quickly. Learn how to set up and use hyperlinks in this lesson.

Inserting Rows and Columns
6 MINS
LESSON
Inserting Rows and Columns
Exercise

The safest way to insert, move and delete Excel data is using rows and columns - which is what I'll be demonstrating in this lesson.

Adjusting Columns and Rows
4 MINS
LESSON
Adjusting Columns and Rows
Exercise

To make your datasets more readable, it's often necessary to change column width and row height. Let's do this with a few straightforward keyboard shortcuts.

Freeze Panes, Split Boxes and Zoom
5 MINS
LESSON
Freeze Panes, Split Boxes and Zoom
Exercise

Large datasets can be hard to navigate but Excel provides a few tools to help us out. Freeze panes keeps the top row visible at all times. Split boxes allow you to view any two parts of a dataset, and zoom, well zooms!

Formatting Numbers
6 MINS
LESSON
Formatting Numbers
Exercise

Formatting numbers can be frustrating unless you understand Excel's different number formats and how to apply them to your data.

Formatting Numbers Part 2
5 MINS
LESSON
Formatting Numbers Part 2
Exercise

Let's apply the different number formats to our dataset columns in this lesson. This will serve to make our dataset much easier to read.

Formatting Cells Part 1
4 MINS
LESSON
Formatting Cells Part 1
Exercise

Everyone wants great-looking spreadsheets, but we often don't know how to create them quickly and effectively. Learn how to do so in this lesson.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo