One of the key ways to become more efficient using excel, is to use short cuts (commands)

Refer to the handout for a list of many common shortcuts

Keep a printed copy of the handout close to your work station for ease of reference

We will walk through some of the commonly used shortcuts

Qs: What are some of the common commands or shortcuts you use on a daily basis?

Qs:  Is there something you wish you could do using a shortcut?

Using commands is one of the best ways to become faster in excel

There are some that we all know – copy, paste, cut, undo

It takes practice to become proficient at using shortcuts in everyday use. We will not become experts after today’s session. You will want to refer to the handout while using excel and introducing one or two shortcuts at a time until they become engrained.

There are many that we aren’t aware of, that may become more engrained than the basic

CTRL+B: Bold all highlighted cells

CTRL+U: Underline all highlighted cells

CTRL+I: Puts italic on all highlight cells

CTRL+C: Copy all highlighted cells

CTRL+V: Paste all highlighted cells (previously copied)

https://www.computerhope.com/shortcut/excel.htm

CTRL+Z: Undo the last entry

CTRL+Y: Repeats the last entry

CTRL+P: Print the current sheet

CTRL+F: Search the current sheet

CTRL+A: Select all contents of a sheet

These shortcuts are the same across all Microsoft products (Word, Powerpoint)

These shortcuts are unique to Excel:

CTRL+SHIFT+=: Insert a new row (above the selected row) or column (to the left of the selected column)

CTRL+-: Deletes the selected row(s) or column(s)

SHIFT+Arrows: Extends the highlighted area to adjoining cells

• There are so many shortcuts it is impossible to memorize them all
•  
• Use your cheat sheet!

◦And any other resources you can find

•  
• Continue practicing until these become second nature

Even though we took some time to review, its not possible to know all the functions or shortcuts available.

The key is to use the materials available to you – keep the cheat sheet near your screen and refer back to it.

Make a habit of picking a couple shortcuts each week that you’d like to try using more.

Once you’ve become proficient in these, use other resources available (there are hundreds on the internet) to add more to your repertoire