YoVDO

Microsoft Excel: Learn Top 50 Excel Keyboard Shortcuts!

Offered By: Skillshare

Tags

Microsoft Excel Courses Productivity Courses Data Formatting Courses

Course Description

Overview

Last time you opened a spreadsheet and are overwhelmed by the number of things to do. You don't know how to make the best use of your time.

But it doesn't have to be this way!

You Will Walk Away With...

  • MORE TIME!
  • Learn the top 50 Excel keyboard shortcuts!
  • Understand the essence of these shortcuts, and see them in action!
  • See how each of these shortcuts is used with real examples!
  • Get a bonus cheatsheet with all of the keyboard shortcuts in one place!

After this class you will be able to:

  • Actually SMILE when you open a spreadsheet :-)
  • Brag to your friends about how you can use Microsoft Excel shortcuts confidently!

If you're like me, you use Microsoft Excel on a daily basis for important tasks, text processing, or calculations. Whether it's for business or personal related projects, everyone wants to be able to use the Excel spreadsheet program freely and easily.

Here is what we will cover in Excel Shortcuts:

Formatting Shortcuts
- Format Cells
- Time Format
- Date Format
- Currency Format
- Percentage Format
- Scientific Format
- Bold

Table Shortcuts
- Outline Border
- Insert Filter
- Delete Cells/Row/Column
- Insert Cells/Row/Column

Editing Shortcuts
- Edit Cell
- Flash Fill
- Copy Right
- Copy Down
- Redo
- Undo
- Select All
- Save
- Find
- Go To Special
- Replace
- Cut
- Copy
- Paste
- Fill Down

Formula Shortcuts
- Insert Function
- Check Your Math
- Enter Current Date
- Auto Sum 
- Array Formula

Worksheet and Workbook Shortcuts
- Insert New Worksheet
- Close Workbook
- Print
- Next Sheet
- Previous Sheet
- Insert Comment

UI Shortcuts
- Cancel
- Hide/Show Menu
- Repeat Last Action
- Move to Previous Cell
- Delete
- Move Up
- Move Down
- Move Left
- Move Right
- Highlight Upwards
- Highlight Downwards
- Highlight Left
- Highlight Right
- Highlight Data
- Open Macros
- VBA Editor


Syllabus

  • Why You Will Love this Excel Course
  • Formatting Excel Keyboard Shortcuts
  • Table Excel Keyboard Shortcuts
  • Editing Excel Keyboard Shortcuts
  • Formula Excel Keyboard Shortcuts
  • Workbook Excel Keyboard Shortcuts
  • Handy Excel Keyboard Shortcuts
  • Bonus Excel Keyboard Shortcuts Cheatsheet!
  • Thank you and Congratulations!

Taught by

Bash (BizTech Matters)

Related Courses

Economic Issues, Food & You
University of Florida via Coursera
Get Organized: How to be a Together Teacher
Relay Graduate School of Education via Coursera
Work Smarter, Not Harder: Time Management for Personal & Professional Productivity
University of California, Irvine via Coursera
Lean Operations العمليات الرشيقة
Rwaq (رواق)
Realidad Macroeconómica Latinoamericana
Inter-American Development Bank via edX