Excel is a powerful piece of software that makes data analysis and visualisation quick to do, but by learning how to use Excel in a faster, more efficient way, you can further increase your productivity when working with data. This Excel class will help you do just that.

What will I know at the end of this class?

At the end of this class, you’ll know a range of keyboard shortcuts that allow you to:

Format cells
Select cells
Navigate worksheets
Edit cells
And more…

You’ll also know how to use a range of other Excel efficiency tips and best practices including:

Transposing data
Filling formatting
Splitting up data with text to columns
Removing blank cells quickly
And more…

Why should you learn keyboard shortcuts and other efficiency tips in Excel?

There’s a range of reasons why you should learn to be more efficient when using Microsoft Excel:

Save time (more than you might think!)
Make using Excel less tiresome and more enjoyable!
Impress your co-workers and further your career!

Who’s teaching the class?

I’m Julian, a digital marketing consultant with 10+ years of experience in using and teaching Microsoft Excel. Although Excel can seem like a daunting piece of software, I believe it can be taught in a simple and straightforward way, and that’s what I aim to do in all my classes

Interested in learning more about Excel or not sure this is the right Excel class for you? Check out my other classes:

Excel for Beginners: Learn The Essentials in 50 Minutes
Excel Formulas You Need to Know in 30 Minutes
Excel Pivot Tables for Beginners: Learn them in 20 Minutes
Excel Text Functions: Learn them in 30 Minutes
Excel Lookup & Reference Functions: Learn them in 35 minutes!

You will learn

Class Project Part 1

Download the ‘Excel Efficiency Class’ file and go to the first tab named ‘Practice Data’. Using only keyboard shortcuts, complete the following tasks with the ‘Practice Data – Part 1’ data:

Make the column titles (‘Sales Rep’ and ‘2019 Sales Value’) bold
Select all the cells in the range (including the column titles), and cut the data
Paste the cut data so the Sales Rep column starts in cell D3 of the spreadsheet
Create a filter on the data range in its new location
Navigate back to cell A1

Class Project Part 2

Head to the ‘Practice Data – Part 2’ data. Using Text to Columns, split the first names and surnames up so the first names are between cell B14:B19, and the surnames are between cell C14:C19.

Class Project Part 3

Have a think about which keyboard shortcuts (e.g. the top 20) that you didn’t know about before the class that are going to be most useful to you. Create a new tab in the spreadsheet and name it ‘Top Keyboard Shortcuts’. Copy the keyboard shortcuts you’ve picked from the other tabs into this tab and practice using them.

If you have any questions about any of the steps above, just let me know!