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