Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts

Provided by:
0/10 stars
based on  1 review
Provided by:
Cost $8/mo
Start Date On demand
Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts

Course Details

Cost

$8/mo

Skillshare offers a wide variety of free and Premium courses on creative skills, marketing and more.

Get One Month Free

Upcoming Schedule

  • On demand

Course Provider

Skillshare online courses
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog h...
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog has grown from 15 to more than 250 online courses that cover creative arts, entrepreneurship, branding and marketing, lifestyle and technology. The School of MakeOurMark, with courses in photography, illustration and tattooing, was launched in October 2013, and the School of Design went live the following month. Among the instructors who have taught courses are Seth Godin, founder of online marketing firm Yoyodyne, who teaches a class on entrepreneurship; DJ Young Guru, who leads a course on mixing and recording; and actor, writer and director James Franco, whose course focuses on screenwriting for short films. You can begin a Skillshare collaboration by taking an introductory course in a particular area to learn, for example, the fundamentals of Photoshop and expand your knowledge with a five-part, in-depth Photoshop series.

Provider Subject Specialization
Arts & Design
Business & Management
32 reviews

Course Description

Keyboard shortcuts are fun and increase your efficiency in Excel.

We pick up from Excel for the Real World I to start using Microsoft Excel as fast as possible. This is the 2nd part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this second class, Excel II, you will learn to use keyboard shortcuts to speed up your data workflow. These will not only be fun, but they will maximize your workflow like you didn't know possible. Excel shortcuts were built for the user to be able to focus on data rather than logistics – and this class will help you learn to do just that!

Learn by doing.

You'll follow along with me in the Excel for the Real World II file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then I want you to upload an Excel file listing out your favorite keyboard shortcuts. Examples of how you use your shortcuts will b...

Keyboard shortcuts are fun and increase your efficiency in Excel.

We pick up from Excel for the Real World I to start using Microsoft Excel as fast as possible. This is the 2nd part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this second class, Excel II, you will learn to use keyboard shortcuts to speed up your data workflow. These will not only be fun, but they will maximize your workflow like you didn't know possible. Excel shortcuts were built for the user to be able to focus on data rather than logistics – and this class will help you learn to do just that!

Learn by doing.

You'll follow along with me in the Excel for the Real World II file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then I want you to upload an Excel file listing out your favorite keyboard shortcuts. Examples of how you use your shortcuts will be even better!

What You'll Learn

  • Getting Started with Shortcuts. Learn how using the keboard makes you 10X faster than using the mouse in Excel.
  • Moving Around. Move around and navigate within Excel efficiently.
  • Selecting Stuff. Select cells and ranges using only the keyboard.
  • Autofiltering & Making Lists. You have a basic data set, how do you drill down to the data you need?
  • Using Paste Special. Paste Special is one of the most powerful operations in Excel
  • Using Formula Fills. We'll learn shortcuts for Fill Formula and Auto-Sum to quickly create formulas on the fly.
  • Formatting. We'll go over quick number formatting, borders, and alignment shortcuts.
  • Using Special Shortcuts. Here are the keyboard shortcuts that will make you truly stand out among your peers and make you even faster such as AutoFit, Re-Do format, and the Quick Access Toolbar.

Also see: Excel for the Real World I: Gain the Basic Skills in 1 Hour & Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.

Note: The version of Excel used in this class is Max Excel 2011, but the concepts apply to both PC and Mac.

Reviews 0/10 stars
1 Review for Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Andrea Collins profile image
Andrea Collins profile image

Andrea Collins

None/10 starsCompleted
4 years, 8 months ago
I learned a lot in this class. Even though it is targeted for Mac users, the workbook provided gives the shortcut instructions for PC users - so I was able to follow along. It will definitely take some practice to use all the keyboard shortcuts - Maybe I'll try unplugging my mouse for a day. Maybe. Nice clear, easy to follow well paced class.
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.