Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel Keyboard Skills by Drills

Grant Gamble

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Videos (2h 33m)
    • Introduction

      3:19
    • DAY 1 - Drill 1: Excel Cursors

      8:29
    • DAY 1 - Drill 2: Flash Fill

      3:43
    • DAY 1 - Drill 3: Custom Lists

      4:11
    • DAY 1 - Drill 4: AutoFill Dates

      6:32
    • DAY 1 - Drill 5: Changing and Formatting Cell Contents

      4:16
    • DAY 2 - Drill 1: Selecting and Navigation

      8:18
    • DAY 2 - Drill 2: Formatting Cells

      6:54
    • DAY 2 - Drill 3: Changing Cell Alignment

      5:12
    • DAY 2 - Drill 4: Merge Across

      6:01
    • DAY 2 - Drill 5: Inserting Rows vs Inserting Cells

      6:39
    • DAY 3 - Drill 1: Navigation through Worksheets

      4:21
    • DAY 3 - Drill 2: Reverse Sheets

      3:38
    • DAY 3 - Drill 3: Changing Tab Colours

      3:59
    • DAY 3 - Drill 4: Splitting a Workbook

      5:35
    • DAY 3 - Drill 5: Editing Multiple Worksheets

      6:59
    • DAY 4 - Drill 1: Viewing Worksheets Side by Side

      4:44
    • DAY 4 - Drill 2: Freezing and Unfreezing Panes

      4:17
    • DAY 4 - Drill 3: Print Titles

      4:36
    • DAY 4 - Drill 4: Creating Custom Views

      7:44
    • DAY 4 - Drill 5: Headers and Footers

      4:10
    • DAY 5 - Drill 1: Creating Basic Formulas

      8:53
    • DAY 5 - Drill 2: The AutoSum Tool and Relative References

      9:15
    • DAY 5 - Drill 3: Absolute References

      6:39
    • DAY 5 - Drill 4: Mixed References

      7:04
    • DAY 5 - Drill 5: Operator Precedence

      7:58

About This Class

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.

1

Student

--

Projects

0

Reviews (0)

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...

See full profile