Excel shortcuts Master- start with 0 experience
3.3 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,902 students enrolled

Excel shortcuts Master- start with 0 experience

Using Excel Keyboard shortcuts to make life better
3.3 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,902 students enrolled
Created by Derek Gao
Last updated 3/2019
English
English
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Master easy memory shortcuts, functions, and formulas to save time speed up you skills
  • Master 17 most popular functions: Vlookup, Hlookup, Index, Match, Choose, Offset, IF Statement, Indirect, Address, Sumif/Sumifs, Average/Averageifs, Round Functions, Counta/Countif, Concatenate, etc

  • Know basic knowledge of recording Macros and create Pivot Table

  • Stand out in an interview or move up the ladder by dramatically boosting your Excel skills and confidence at work
  • Create Report in a fast pace and give your boss a shock
Requirements
  • Excel 2010, Excel 2013 or 2016 loaded on your computer.
Description
  • This course is design for beginner. Excel expert will also benefit from this course since almost everything can be done with keyboard shortcuts with quicker speed compare with using mouse.

  • Learning keyboard shortcuts and more advanced functions in excel will greatly improve the efficiency and save your job.

  • Disconnect the mouse from your computer and using only the keyboard is the most efficient way to learn shortcuts.

  • Through practice and master all the excel keyboard shortcuts, you will be shocked by your own efficiency.

  • By applying those shortcut, you could stand out in your team and be the best.

Who this course is for:
  • This course started by assuming you have never use Excel before and quickly processes through Excel's most useful and powerful feature.
  • If beginning chapters to be too basic for you, you can skip to the next chapter.
  • Disconnect the mouse with your computer and use keyboard only is the most efficient way to learn shortcuts
  • Through practice and master all the shortcuts, you will shock by your own efficiency.
Course content
Expand all 40 lectures 03:34:53
+ Welcome to Excel
2 lectures 16:20

Shortcuts for add new spreadsheet, move back and forth between spreadsheets, open new file, save file, print file, open a file.

Preview 07:05

Excel Settings about how many worksheets to open when create new workbook,  Calculation opens, and advanced setting.

Excel Setting
09:15
+ Excel Basics
4 lectures 18:59

Basic Excel Shortcuts like Auto Fit Width of Column, Set Column Width, Set Row Height, Select Column or Row, Undo and Select range of Columns.

Basic Excel Shortcuts
03:51

Basic Excel Shortcuts like Format Cells, Go into Tab, Go back to the main tab area and check or uncheck.

Preview 07:05

Excel shortcuts for Move back and forth between worksheets in a workbook and Open Paste Special.

Referencing Cells
05:36

Excel shortcuts like Open a new workbook, Move Between Workbook, and Zoom In.

Move Between Workbooks and Zoom In
02:27
+ Most Popular Excel Shortcuts
15 lectures 01:16:00

Shortcuts for Freeze and Split, and how to move around Split Area

Freezing & Splitting
03:53

Excel shortcuts about inside Formula, and Clear shortcuts.

Shortcuts inside formula and clear
05:32

Basic Excel shortcuts for Highlight, Add or Delete Rows or Columns

Highlight, Add, Delete Rows and Columns
03:08

Excel Shortcuts for Open Paste Special, Paste Special Formula, Paste Special Formats, Paste Special Multiply, Paste Special Subtract, Paste Special Divide and Paste Special Transpose

List of Paste Special shortcuts
06:01

Excel shortcuts for Bold, Italicize, Underline, Cut Cells, Remove all the border, % Format with no decimal place, Date format with the day-month-year, Two Decimal place with dollar Sign,  and Two Decimal place with 1000 seperator

Ctrl and Ctrl Shift Shortcuts
04:01

Excel shortcuts for Move between worksheets, Add Worksheets, delete worksheets and Naming worksheets.

Add Worksheets, delete worksheets and Naming worksheets
02:05

Excel shortcut for fix Cells (F4), Open Name Manager and Create New Name.   

Using $ to fix cells and How to give cell a name
07:12

Excel shortcuts for Select Column, Hide Column, Unhide Column, Select Row, Hide Row, Unhide Row, Create Group, Remove Group, Hide Group and Unhide Group.

Hiding Columns or Rows vs Grouping
06:57

Excel Shortcuts for Select All, Open Find and Replace, and Change name of spreadsheet.

Find and Replace
02:15

Excel shortcuts for Go to Special, Select Special, Open or Add comments and Auto fit width of columns.

Go to Special
07:29

Excel functions about Format cells with Custom, how to use & in formulas and how to use text to solve date problems

Format Cells – Custom, use of & in formulas, and Text Function
06:01

Excel function for Conditional formatting and Rules Manager in Conditional Formatting.

Conditional Formatting and Conditional Formatting Manager
06:27

Excel shortcuts for Merger and Center.

Merge & Center
02:55

Print smartly in Excel by learning how to adjust the Page, Margins, Header/Footer and Sheet

Printing Master_Page layout
09:34

Excel shortcut for group selected worksheets which allow you to edit one spreadsheets and change all other grouped worksheets at the same time.

Group selected worksheets
02:30
+ Advanced Excel Function for data management
5 lectures 36:29

Advanced Excel Functions like HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX.

HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
07:49

Learn Excel Shortcuts for Data Validation-Create Drop down Box and Open Drop down Box. Learn how to use match function to tell you the relative position of something.

Match Function
03:06

Learn how to use Excel Advanced function HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX with Match to make dynamic cells.

Match with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
11:32

Combine Indirect Address & Match to solve issues.

Indirect, Address & Match
07:00

Excel Data Table function for 1 and 2 Variables.

One Variable and Two Variable Data Table
07:02
+ IF Statement
2 lectures 10:18

Learn how to use If Function to build basic logical statement.

How to Use IF Function
03:49

Learn how to use If statement with And & Or

IF Function with And & Or
06:29
+ Math Function
5 lectures 31:29

Learn Average ,Sum, Max and Min Function

Average, Sum, Max & Min
02:09

Learn Excel SUMPRODUCT Function.

SUMPRODUCT
03:16

Learn how to use Sumproduct with 1 or more Criteria.

Sumproduct with Criteria
13:02

Excel functions for Sumif/Sumifs & Averageif/Averageifs

SUMIF/S & AVERAGEIF/S
06:22

Learn how to use COUNT/A & COUNTIF/S to solve issue.

COUNT/A & COUNTIF/S
06:40
+ Data Management
7 lectures 25:18

Learn how to use concatenate to connect text together.

Concatenate
02:04

Learn How to Remove duplicate data.

Remove Duplicate
01:07

Learn how to Add a filter on the header with a shortcut.

Filter
01:26

Learn how to separate data with Text to Columns: Delimited and Fixed Width     

Text to Columns
03:55

Learn how to sort by multiple criteria and how to add subtotal.

Sort and Subtotal
05:34

Learn how to use Pivot Table and make arrangement in Pivot Table.

Pivot Table
05:17

Learn how to use Macro to make life easier.

Macro
05:55