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. Learn how to create formulas that use descriptive names to represent cells, ranges of cells, formulas, or constant values. Newer versions Office 2011. Upgrade powerpoint for mac 16.12. 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 26m 12s • 1,386,202 viewers • Course Transcript - In this workbook we're looking at a worksheet called Profits. If you're trying to make formatting changes and the cells you're trying to apply the formatting changes to are not adjacent to one another, you have to select the range, make the change, select another range, make a change. You can certainly do that and there's nothing wrong with it really but it's more efficient if you learn how to select non contiguous ranges, that's a mouthful. I want to change these cells here to be bold, also the ones down here. We can highlight either range first, makes no difference, but after highlighting one range, release the left mouse button and then with the command key held down highlight the other range. I want to make them all bold, just make them bold, or blue or whatever. I want to add some color here to offset the different months here to make it a little bit easier to read so I'm going to highlight the January data this way, letting go of the left mouse button, using the command key to highlight these cells here and these cells. Just a slight change here from the home tab, the fill color bucket, a pale green or some other color, just to offset the data a little bit. Certainly not necessary but just brings out the idea that we sometimes need to highlight non contiguous ranges. We can use this also with formulas at times too. At other times when we're working with data, we're about to make some copies. I'm going to go to a different worksheet here called HR list, it's the first sheet in this workbook. I'm looking at the data here. I need to copy the data for the Admin Training Group. I want to get the titles as well. I don't need the data from the ADC group so I'm going to be hiding columns two through six. Right click and hide. And before copying the data I also realize that I really don't need the Social Security Numbers and phone numbers. So I'm going to hide these two columns dragging across columns D and E, right click and hide. It also turns out that one of the people on our list here, Erik Pratt, has recently left and we don't usually take the name out of the list for a while. We might put strike through or add a color or something but for the moment we're simply going to hide row 14. That's for Erik Pratt.
0 Comments
Leave a Reply. |