Excel Basic Keyboard Shortcuts (Skills by Drills)
4.8 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,015 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Basic Keyboard Shortcuts (Skills by Drills) to your Wishlist.

Add to Wishlist

Excel Basic Keyboard Shortcuts (Skills by Drills)

Microsoft Excel Keyboard shortcuts and drills designed to increase your Excel skill level and speed
4.8 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,015 students enrolled
Created by Grant Gamble
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $45 Discount: 78% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Increased fluency in using Excel and especially essential Excel keyboard shortcuts.
View Curriculum
Requirements
  • Excel 2016, 2013, 2010 or 2007 running under Windows. Mac users will also benefit from this course, but there are a few differences between versions.
Description

Are you an Excel user who would like to become more fluent and skillful in your use of Excel and, in particular, be able to use Excel shortcuts to increase your productivity and enhance your profile as an Excel user? If so, then this is the course you have been looking for.

Microsoft Excel Essential Skills by Drills consists of a five day cycle of Excel keyboard drills which you perform regularly (not just once), meaning that you are sure to remember these key Excel techniques. As an incentive to improve, each time you perform a drill, you will be given a confirmation of the time taken and you will be shown a leaderboard with your fastest five times.

Understanding Excel key concepts is one thing; but by constantly doing these drills, you will not only understand these key Excel features, you will become fluent in using them; and, more importantly, you will never forget them.

Who is the target audience?
  • Anyone using Excel at a basic level
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
02:33:28
+
Getting Started
1 Lecture 03:21

Download all the files required for the drills. (Don't forget to unZip the downloaded files.)

Preview 03:21
+
DAY 1 - Entering and Editing Data
5 Lectures 27:11

This drill provides practice on recognizing Excel's three worksheet cursors: selection, drag-and-drop and AutoFill.

Preview 08:29

This drill provides practice on the use of Excel's Flash Fill feature. And this is something that every Excel user needs to master: the ability to automatically enter data by simply giving Excel an example of what you want.

Preview 03:43

This drill provides practice on the creation of Excel custom lists to speed up data entry.

Drill 3: Custom lists
04:11

This drill provides practice on entering date sequences using Excel's AutoFill feature and then using AutoFill Options to modify the way that the date sequence is built.

Drill 4: AutoFill dates
06:32

This is a keyboard only drill and provides practice on changing cell contents and number and date formats using Excel's keyboard shortcuts.

Drill 5: Changing and formatting cell contents
04:16
+
DAY 2 - Formatting Cells, Columns and Rows
5 Lectures 33:04

This keyboard only drill provides practice on rapid keyboard navigation, selection of data and transferring data between different worksheets.

Preview 08:18

This drill provides practice on formatting cells and repeating operations. The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 2: Formatting cells
06:54

This drill provides practice on horizontal and vertical cell orientation. The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 3: Changing cell alignment
05:12

This drill provides practice on the use of Excel's Merge Across feature.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 4: Merge across
06:01

This drill is all about inserting space in a worksheet; it focuses on the distinction between inserting entire rows and inserting cells.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 5: Inserting rows vs inserting cells
06:39
+
DAY 3: Manipulating Sheets and Workbooks
5 Lectures 24:32

This drill provides you with practice on the quickest methods of navigating a workbook which contains a large number of worksheets and the quickest method of updating individual sheets.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Preview 04:21

This drill tests your Excel dexterity. How quickly can you reverse the order of sheets in a workbook?  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 2: Reverse sheets
03:38

In this drill you practice selecting multiple worksheet tabs and changing their attributes; in this case the tab colour.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 3: Change tab colours
03:59

In this drill, you will practice the quickest method of taking a worksheet with a large number of worksheets and splitting it into several smaller workbooks.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 4: Split workbook
05:35

In this drill, you practice working in group mode; an Excel feature which allows you to edit multiple worksheets simultaneously.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 5: Editing multiple worksheets
06:59
+
DAY 4: Viewing, Page Setup and Output
5 Lectures 25:31

This drill practices Excel's Compare Side by Side feature; but uses it to compare two worksheets from the same document.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 1: Viewing worksheets side by side
04:44

This drill reminds you of the three variations available with Excel's Freeze Panes command.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 2: Freezing and unfreezing panes
04:17

This drill complements the skills practiced in the previous drill. This time, we look at the fastest way of reproducing key row and column titles on every page when you print a document.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 3: Print Titles
04:36

This drill allows you to become fluent in the use of Excel's useful and under-used custom views feature. Practice this drill and you will be able to transform the appearance of large worksheets with just a few deft keystrokes.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 4: Creating custom views
07:44

The final drill in this section reminds you of the quickest method of adding headers and footers to an Excel document.

Drill 5: Headers and footers
04:10
+
DAY 5: Building Excel Formulas
5 Lectures 39:49

The first drill in this section provides practice in creating formulas using all the key components of Excel formulas: functions, cell references and operators.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Preview 08:53

This drill provides practice on the use of Excel's handy AutoSum tool and the keyboard equivalents. It also highlights the usefulness of being able to create a single formula and then copy it quickly into adjacent cells.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 2: AutoSum Tool: Relative references
09:15

This drill allows you to constantly remind yourself of the distinction between relative and absolute references when building Excel formulas.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 3: Absolute references
06:39

This drill provides practice on building formulas that contain Excel's hybrid mixed cell references.  The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 4: Mixed references
07:04

The final drill in our cycle provides further practice on building Excel formulas and then focuses on the use of parentheses to override operator precedence.   The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse.

Drill 5: Operator precedence
07:58
About the Instructor
Grant Gamble
4.5 Average rating
424 Reviews
13,104 Students
7 Courses
Developer, trainer and author

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.

His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.