Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate
Вставка
- Опубліковано 4 жов 2024
- // Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel...
2. Excel Campus Elevate Program: go.launchexcel...
3. My Online Training Hub Dashboards: go.launchexcel...
4. Coursera Excel Specialisation: go.launchexcel...
5. Coursera Everyday Excel: go.launchexcel...
6. Coursera Excel Data Visualisation: go.launchexcel...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Here are 10 top tips to make Data Entry faster and more accurate in Excel. Read the accompanying article on www.launchexcel.com:
www.launchexcel...
Video Highlights:
-- Simple Data Entry --
0:25 - Data Entry using Tab and Enter
1:00 - Fill down from above using CTRL + D
1:30 - Autocomplete using Tab key
2:10 - Show drop down list using ALT + Down arrow
4:15 - Enter values into multiiple cells using CTRL + Enter
-- Excel Can Speak --
5:19 - Get Excel to speak to you when you enter data!
-- Data Entry Form --
7:02 - Show the data entry form
-- Keep Headers Visible --
9:20 - Freeze Panes (ALT ➜ W ➜ F ➜ F)
10:20 - Split Window (ALT ➜ W ➜ S)
11:14 - Use Excel Table (CTRL + T to add table)
Great video, thanks! One thing to mention: when you enter current year's date, you don't have to type "year", after typing 4/23, the year will auto-appear!
I like Alt+down-arrow function!
Many thanks 4 so much info/tips in just a 12 mins video.
thanks for commenting - yes I try to project a calm soothing voice to help relax into the video. hopefully it makes the video easier to watch and listen to!
Cheers - Victor
excellent video, clearly explained. Good calm voice. Thank you
You ROCK!! Thanks for the tips, and your time, I appreciate it.
by the way your voice is so soothing!
New one I got
Ctrl+D
Alt +⬇️
Alt+D+O
Many thanks to you
Many thanks! I searched a lot on how to make dropdown lists as in 2:47, but all I found was about making it with VB, which I don't know. This was really helpful. (Y)
Thank you very much that was really helpful. I have spreadsheet exam in 3 days. I'm ready after this.
excellent Video .learned a lot from him thanks . Plz Upload more like this
your video was really helpful!! thank you so much!
a vast useful video i ever seen. thank you sir.
Very useful information. Thank you.
Thank you very much . It is very much useful.
Great tips, very helpful
Thanks!! This was so helpful.
Awesome video thank you! I would love it even more if you included the Mac short-cut keys ;-)
Thank you :)
this is amazing....thank u sooooooo much.
This is a very good video. It helps a lot!
This was so Helpful
Hi mr./ms.Launcher,
Perhaps there is something missing your video. So help me out!
1. What key ( or and
Think you for this informations
Cool - thanks for you comment :)
nice thanks very much
thanks a lot.
really very usefulll
Thank you
tks so much!
good performance
Great Video but I'm trying to find a way to enter data into a cell using my one click of my mouse. E.g. I have an excel order sheet and I want to be able to click on a cell and it automatically fill in the number 1. This will then be used in my formula at the end of the row showing me how many of the items were ordered. Do you know of a way to single click a cell for autofill or a place I can find the answer? Thanks.
helpful
Excelent...
how did you get that to work, when pressing enter, it goes to beginning of new row??? Please help, thanks
you could have inserted the buttons which you ar usung in the videoclip
Pressing enter does not bring me to the beginning of the next row.
nice video
Hello. I need a help with a password protected corrupted excel file. Do you think you can show me how can I extract the data from that file? or just how can I fix the file?
What if you don't do it on Excel?
good sir
my excel don't execute the command of ALT+D+O. what u ll recommend us to do ?
That's because it is a custom keyboard shortcut. He created it. Pay attention!
+Dragos C How to do that? Macros won't be able to store Alt shortcuts. Please tell
+Ashay Dwivedi Actually I realized that it isn't a normal shortcut or a macro. You have to press Alt + D + O one after the another, not all at once. It is a Office 2003 shortcut! Try it!
Oh! Excel 2003 Shortcut! I Am 3 Versions Ahead, So I Forgot About It! Thanks! I Think D Is Data, O Is F(O)RM Thanks Again!!
Dragos C
Red Soils
deleted