Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
In Excel, the Right Mouse button always means "shortcut menu". It's a great feature because it alerts you to some of the commands and features you'd like to be able to use, and I say that based on the idea that Microsoft has done a lot of research about how people use Excel. The Excel Ribbon menu system which is quite extensive, can certainly be intimidating, and particularly, if you think of all the many, many buttons and choices that are available there. Suppose you want to make a formatting change in this worksheet and you click on cell A4, hold down the Left Mouse button and drag across the next three cells.
Now, you'd like to make some formatting changes. You're not quite sure where to find them, so let's right-click here. Now, this doesn't mean that what we're seeing is every possible command available--by no means at all. What we're really seeing here are some potential choices that we're likely we want to get to. Not only do we see this pop-up menu above it, we see a feature referred to as the "mini toolbar". For the most part, this consists of buttons and features that you'll find on the Home Tab, but is the Home Tab always the one that's currently active? Not necessarily.
These buttons, if we wanted to, for example, experiment a little bit with say a yellow background that looks yellow, well we'll click it and now it's yellow. While we're here, I don't think we want to change the font but we might and there's even a drop arrow there. We might want to use maybe a dark blue font and while we're here, we might want to use Bold. This is close to the data we are actually working with. Now, if we click somewhere else, the mini toolbar disappears. If you use the Right Mouse button in different locations, for example, if you were working with the Home Tab and you were to right-click on this button, for example here, you see some choices related to what you might be doing with that button.
This has nothing to do with commands in the worksheet necessarily, but it's again a reminder what the Right Mouse button does. If we right-click a column letter, the choices we see here are different, than if we were to right-click on a cell on the worksheet. For example, I'll right-click now on cell G3 and that's a different set of commands, some of them are the same, but some are different. If you right-click on a sheet tab at the bottom of the screen, as you might expect, a different set of choices there, and of course, these are related to the kinds of manipulation you might want to consider when dealing with sheet tabs.
So the right mouse button is really handy. Here's another idea too. Suppose you want to add a new column here to the left of column B, you might right-click on column B. You don't necessarily know which command it is, but "Insert" sounds like it's the one and so you might use that. At a later time you might say, "well, I don't really need that". "How might we get rid of it?" Well, you might right-click again on column B. By the way, you don't have to select it first. Right now D5 is active. I'm saying to myself, "I don't really want that column B there anymore".
So, I'll point to the B and right-click and there is "Delete". Although, not foolproof, the Right Mouse button is incredibly handy at times, because it pairs down the list of possible options that you're likely to want to use in any given situation. When it comes to formatting issues, that mini toolbar pops-up as well, and both of them are extremely helpful as you work with Excel.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.