Data Analysis
Video

Excel Productivity Hacks

2 Modules 22 Lessons

About this course

Save time and work faster with these Excel productivity tips

Course Structure

12 Lessons

Excel Hacks

Simple tricks in Excel to make you faster

Get faster with keyboard shortcuts

Copy formula down

ONLY FOR LOGGED-IN USERS

Quickly sum the data

ONLY FOR LOGGED-IN USERS

Remove duplicates

ONLY FOR LOGGED-IN USERS

Paste values really fast

ONLY FOR LOGGED-IN USERS

Add leading zeroes with formula

ONLY FOR LOGGED-IN USERS

Print Header Row on every page

ONLY FOR LOGGED-IN USERS

Quickly create named ranges

ONLY FOR LOGGED-IN USERS

Import data from the web

ONLY FOR LOGGED-IN USERS

Looking up related values with VLOOKUP

ONLY FOR LOGGED-IN USERS

Convert values to ranges with VLOOKUP

ONLY FOR LOGGED-IN USERS

Separating data with Text to Columns

ONLY FOR LOGGED-IN USERS
10 Lessons

Get even faster with this add-in

As the title says, get even faster with this add-in!

Delete empty rows

Color every nth row

Split ranges to multiple sheets

Freeze panes on multiple sheets

Quickly add leading zeroes

Create a master/index sheet

Export multiple sheets as separate files

Remove spaces from text

Convert formulas to values

Count unique values in a range

Pen
>