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

Creating an Analytical Dataset
Udacity
مهارات برنامج Excel للعمل: المبادئ الأساسية
Macquarie University via Coursera
Everyday Excel, Part 1
University of Colorado Boulder via Coursera
Financial Forecasting in Python
DataCamp
Microsoft Excel Mastery: From Beginner to Pro
Udemy