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.
As you work with Excel, many times you'll be using a mouse or a trackpad, and of course, the keyboard too. The mouse pointer, as we currently see it, is probably in its most common appearance; that of a three-dimensional plus sign, but the mouse pointer is context-sensitive. If we are about to make a change, for example, the width of a column, we're going to be positioning the mouse perhaps in the column itself, notice how the pointer now is a black down arrow or if we put on a column boundary, it's a double left right arrow. If we position it on a row boundary, it's a double up-down arrow.
As we point into the menu, the mouse generally is an arrow. Also, notice that if you put the mouse pointer in the lower right-hand corner of the active cell, it becomes a different kind of plus--very thin--so we get used to the idea that the mouse pointer changes as we work with Excel. Now, in working with different workbooks, I currently have opened a workbook called 01-Getting Started. I also have another workbook open as well. On the View Tab in the ribbon, if you point to the choice called Switch Windows-- click that icon--you will, if you have more than one file open, see the other filename; you can easily get back and forth by switching the commands here.
It's not uncommon to be working with multiple workbooks at the same time. In a workbook like this that has five or six sheets, if you want to switch sheets, more often than not you're likely to use the mouse. In other words, I'm looking at the 2014 Budget right now, maybe I want to look at the Employees worksheet, so with the mouse I'll point to the Employees sheet and click and now we're looking at that sheet. If you do have a workbook that's January, February, March et cetera, if you're on the March sheet, you don't have to stop and think that April's next.
So as an alternate way, you can press Ctrl+Page Down to move one sheet to the right or Ctrl+Page Up to move one sheet to the left. In working with different workbooks or in workbooks that have many worksheets, you do want to feel comfortable in navigating back and forth between them. Although, you can do these with commands, there are also as we suggested here, Keystroke Shortcuts. You want to have a sense that you're in control of where your data resides and how to get to it quickly.
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.