Data Manipulation and Formatting
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Getting to Know the User Interface
Getting to Know the User Interface
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
Keyboard Shortcuts
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
Adding, Editing and Deleting Data
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
Essential Shortcuts for Excel Navigation
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
Essential Shortcuts for Cell Selection
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
Navigating With Hyperlinks
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
Inserting Rows and Columns
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
Adjusting Columns and Rows
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
Freeze Panes, Split Boxes and Zoom
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
Formatting Numbers
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
Formatting Numbers Part 2
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
Formatting Cells Part 1
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.
