The first 500 people to sign up via my link will get two FREE months of Skillshare Premium:

Many thanks to Skillshare for sponsoring this video!

In this tutorial you learn the most useful Excel shortcuts to be able to work faster in Excel. There are many hidden features in Excel that are easily accessible with shortcut keys (you might learn some new features too – check out the bonus tip)

The Excel shortcuts we cover are:

00:00 Intro

00:13 Add / remove Excel Filter

00:40 Create an Excel Table

01:10 Navigate in Large Data Sets

01:27 Select a Range of Cells

01:55 Format Cells in Excel

02:09 Auto Sum

02:40 Paste as Values

03:11 Add a New Line Inside a Cell

03:31 Select All Data in Current Region

03:41 Insert Default Chart

03:48 Excel Flash Fill

04:23 Select Entire Row/Column

04:33 Insert a New Row/Column

05:09 Delete a Row/Column

05:24 Move a Cell/Row

05:54 Hide Column/Row

06:04 Check for Hidden Cells

06:27 Insert Time Stamp

06:43 Find Cells Without Formulas (Constants)

⯆ DOWNLOAD the list of shortcuts here: (It will take you to the blog post. Scroll all the way down to download)

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Get Office 365:

Microsoft Surface:

GEAR

Screen recorder:

Main Camera:

Backup Camera:

Main Lens:

Zoom Lens:

Audio Recorder:

Microphone:

Lights:

More resources on my Amazon page:

Let’s connect on social:

Instagram:

Twitter:

LinkedIn:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

shorcut keys in excel, popular excel shortcuts, Excel shortcuts, ms excel shortcut keys in telugu, excel shortcut sum formula, excel shortcut select to bottom of column, excel shortcut insert chart, excel shortcut filter, excel insert current date and time, Excel Tutorials, excel paste special shortcut, ms excel basics, Leila Gharani, Excel 2016, Excel 2013, Excel 2010, XelplusVis, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts

See other Tips articles

:https://handmadebrigadeofoc.com/tips

Nguồn:https://handmadebrigadeofoc.com/

I wanna ask, whether there is a short cut to get into the cell. I mean, when you want to write something in the cell, you just click on it one time and write; BUT if something is already written, it erases it. Is there someway doing it without double click?

Very simple content, very helpful and useful for people who are getting started with excel and would be using this application regularly.

Hi happy morning madam .i learned with you thank you very much. but can you slowly speed rate your record . 😃😃😃😃

Thank.

Keep it up

Very nice and helpful 👍☺️

Alt d p to insert pivot table annnnnddddd ctrl + tilde to show formulas (tilde key is above tab to the left of 1 (depending on your keyboard))

Thanks for knowledge.

i love you

Alt+M,D to quickly trace dependents (nice in combination with Ctrl+[ and F5 mentioned below). Ctrl+tilde to toggle formula view on or off.

Shift+F10 for a context-sensitive right-click, opening up lots of possibilities with context menus.

I like your tutorial very much. These shortcuts has definitely increased my efficiency with Excel. Thank you very much.

Please make a video on journal entries please please please please 😔

This is a very informative video, I highly recommend it. Most of the short cut keys work . But some shortcut keys of my excel are different. For example, in my excel, the shortcut key of the autosum is "Command+Shift+T". You may need to check your shortcut key or customize one in your excel under "Tools"→"Customize Keyboard".

Your videos are extensive and indepth, thank you very much.

A request: please let me know how to learn Excel Macros easily. I have tried so far it's confusing. Appreciate if you make an exhaustive video.

Thank you

In the video you say, we can print the list of these shortcuts and its below the video. Sorry I could not see it, where can I find that list please?

Paste values

Alt+H+S+V

My laptop got crashed and this gat me so worried 😭 I lost all my documents, when I told my friend he introduced me too KIRYEHACK on Instagram who helped me to recover all my lost documents and also help me too hack into my wife social media’s account, I was so shocked and surprised

Hi Leila, i aways see in the internet shortcuts in VBA but how to assign just a to a comand?

Please advise me how can I delete in excel zero amounts in Grand total when It has more than 100 ..

Thanks a lot for that video!

I wish MS programs had Vim-like Normal and Command modes with easy memorized and meaningful keys instead of that ton of hard-remembering shortcuts!

extremely useful stuff

Hi Good morning……. Is there any way to find hidden tabs in excel?

ctrl + 1 not working in my excel 2019 for windows 10. Can you assist please?

Cntrl+z key to get back every thing and I use this key and it is very helpful🤩 and I hope everyone also try it

Can anybody tell me why "Ctrl + ;" (number 20) doesn't work sometimes?

Number 7 is what i was looking for for a long time. But it starts conditional formating menu, it doesn't "paste with values". And it's too complicated for my old fingers…

Hey mam, Iove from india

I liked the way taught specially eat some vitamins☺️😊

Hi

How can i update YTD formula automatically every month I change name of the month

Thank you very much Leila for your useful tips ❤️❤️ all the best to you ❤️

Hi, Nice video.

What is the short cut key in Excel for alignment of table

Unlock your Excel File which is protected by a complex password, by using the eSoftTools Excel Password Recovery Software which can recover the Excel Workbook Password as well as Excel Spreadsheet password. To use the demo, click on the link mentioned below:

https://www.esofttools.com/excel-password-recovery.html

Crtl + F2 – to see the formula applied in the cell

Ctrl +Shift + L to Add filter

Ctrl+1 for formatting

Alt+= for autosum

Alt+enter to add a line inside a cell

Alt+F1 insert chart

Ctrl + and – add and remove rows

Alt +; for hidden rows and columns

F5 +alt +S O X for checking hidden formulas

Leila This is Really wonderful….Short cuts….!!!! But can I know how to do if we want to copy and paste in visible cells only(not in hidden one) ?

hi 😀 i got an issue i can't seem to find any solution for: in query i can get daily fx rates on investing.com, but i cannot get it for the weekly or monthly, at least not updateable. on the fx rates url when i change on a dropdown to weekly or monthly the url stays the same, and the tables is not shown in the query only the daily is, I really hope you can help.

thanks

Alt+E+S+V Always Extract Some Values

Alt+D+F+S for clearing the filter from all the rows without actually removing the filter. Ctrl+shift+L will remove the entire filter, while Alt+D+F+S just clears it

Alt+O+C+A for auto width column

Alt+H+N+S for converting number to Short Date

Alt+H+K for converting the number into accounting format.

Been using these options frequently. Thank you Leila for the valuable inputs.

Difficult, thousands of tips. Flash fill is very coom 😎

Excellent, thank you short and succinctly

You are very intelligent teacher.Amazirng awesome.u r Wikipedia of excel.lot of love u mam, a bonding between student and teacher

Can you make short cuts for writing formulas in a cell, particularly for copying the formula code of another cell in the current cell, switching back from sheet to sheet etc?. Lot of students have a problem while lengthy formulas in a cell that involve copying the formula of another cell.

does my teacher really think im gna waste 8 minutes watching this shit

Good to watch your random videos to expand my knowledge and also support a growth-mindset

Alt+d+s

To sort the data

Alt + F4

time to lunch

F5 Alt + SOX – I need all of the shotcuts in my past! I wish I knew it all years ago!

Thank you