Shift+delete On Excel 2011 For Mac
This course features tons of tips to make Excel for Mac 2011 users more proficient and productive with the popular spreadsheet program. Learn the top shortcuts, find out how to most efficiently navigate and control the display, and discover the best ways to select, enter, and format data. The course also includes ways to leverage drag-and-drop features, shortcuts for formulas and operations, data management efficiency techniques, guidelines for working with charts efficiently, and a selection of quick tips. 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 • 25h 12m 36s • 1,374,447 viewers • Course Transcript - We're looking at a worksheet called profits. Word for mac, comobo box. And in the top rows here we see Sales, Expenses, Profits, and farther down, in rows 8 through 11, it might strike you as a little strange to see what, Sales, Profits, Expenses? Not in the same order as this, perhaps an oversight. We need to change this. Now, a standard approach, and certainly not wrong is to insert a new row above row 10, and then move this data upward, and then possibly get rid of the empty row that we created. But we can do this in one fluid motion. Sometimes when we're doing this with an entire row, sometimes just with text.
What we want to do here really is simply to drag this upward and put it between what are now rows in 9 and 10. And we can do this by dragging with the shift key. So, the data is selected, remember in some cases it could be an entire row. I'm going to drag the upper edge, but also have the shift key held down. Now, sometimes when we do this we drag a little bit leftward, a little bit • Practice while you learn with exercise files. Watch this course anytime, anywhere. Course Contents • Introduction Introduction • • • • 1.