Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts.
Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly. The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time?
Make sure to check out the '10 Tiny Tips' chapter for a quick productivity boost. Instructor. Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities.
He lives in Boulder, Colorado. By: Dennis Taylor course. 3h 29m 14s. 31,602 viewers. Course Transcript - Voiceover We're looking at a worksheet called Employees. There's a formula in cell L-2, it's calculating new compensation for the number in cell K-2. And we wanna copy this formula down the column.
Notice there's an absolute reference here to cell N-1, that's the percent of increase that everybody's going to get. We wanna copy this down the column. Trying to do this by way of copy and paste is gonna be very lengthy and probably inaccurate too. Dragging from the lower right-hand corner is fine. If we had only eight or 10 entries that would work beautifully. But we've got about 600 or so.
![Excel Excel](https://cdn.extendoffice.com/images/stories/doc-excel/ttw-modules/ad-add-text/xad-add-text-prefix-suffix.png.pagespeed.ic.OZl00hdxF4.png)
I'll click on the cell to the left, double-click the bottom edge there, down to row 742. So how do we copy this quickly down the column? Simply double-click that fill handle in the lower right-hand corner where we see the formula.
It gets copied all the way down the column. But are you sure? Then press Ctrl + period. Takes you down to the bottom.
If you're not sure that's the bottom, scroll a little bit beyond it, you'll see. Ctrl + period, brings us right back up top. So, double-clicking the lower right-hand corner allows us to copy a formula downward, and, as we would hope, it adjusts the cell references properly. It's up to you, of course, to recognize that we did need to have an absolute address here so on creating the formula, you would make sure that that cell, N-1, is an absolute reference, by typing in the dollar signs or pressing the Function key F4.
Now, we can also use this fill-in feature for data. And sometimes, in an unusual way.
What we really need to have filled in here are the months of the year. So I'm simply going to type January.
I won't press Enter, I'll press Ctrl + Enter so the act of cell doesn't move, and I'll simply double-click the lower right-hand corner. Now, if this were normal text, it would simply repeat January over and over and over again.
I'll just double-click. If we need to fill in a rate, maybe it's not sure yet, we might type in a word. Could be any word. If it's not a special word that's recognized by way of special custom lists, we could make an entry here, double click, and it just says pending. We'll fill it in later maybe.
Same thing with tax rate over here, maybe it's a number, everybody except for a few are going to have a 5% tax rate here. For the moment we'll just fill that in with that number, 5%, Ctrl + Enter. Double-click simply repeats it down the column. And once again, if you're not sure about how deep that column is, Ctrl + period, Excel figures out the extent of your adjacent data, only copies it down that far.
Ctrl + period. So, an indispensable shortcut in Excel, double-clicking the lower right-hand corner. Primarily of value with formulas, but as we see, you can also use this with pure numbers, you can use it with special entries like days of the week and months of the year, or we can use it with simple text. It really helps us fill in data quickly and easily. Practice while you learn with exercise files. Watch this course anytime, anywhere. Course Contents.
Introduction Introduction. 1. Top 10 Shortcuts 1. Top 10 Shortcuts. 2. Ribbon and Quick Access Toolbar Tips 2.
Ribbon and Quick Access Toolbar Tips. 3. Display Shortcuts 3.
Display Shortcuts. 4. Navigation Shortcuts 4. Navigation Shortcuts. 5. Selection Shortcuts 5. Selection Shortcuts.
6. Data Entry and Editing Shortcuts 6. Data Entry and Editing Shortcuts. 7.
Drag and Drop Techniques 7. Drag and Drop Techniques. 8.
Formula Shortcuts 8. Formula Shortcuts. 9.
Operational Shortcuts 9. Operational Shortcuts. 10. Formatting Shortcuts 10. Formatting Shortcuts. 11.
Data Management Techniques 11. Data Management Techniques.
12. Charting and Visual Object Tips 12. Charting and Visual Object Tips. 13.
Ten Tiny Tips 13. Ten Tiny Tips. Conclusion Conclusion.