Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
If this is a brand-new workbook, the name at the top of the screen is likely to be Book1, Book2 something like that. We do need to save our work from time to time. Keep in mind that the entries you might have made here, although they are being stored in RAM--that's working memory--they're really not being stored permanently and you certainly do want to save this information as a file; but the question will surely come up as you click the File Tab in the ribbon, "Should I do a Save or Save As, what's the difference"? Save As is always safer, it's a bit longer.
It does give you a choice as to where you will save the file, what name you will give it, and whether you need to save it in a different format. Now, you might want to save it on the SkyDrive if you're using that capability; you might want to save it on this computer; and your computer right now might have your Flash drive plugged into it. Let's go to Browse here. Maybe in my case here, I simply want to save this file--which was already created-- I really want to save it in its current location.
Now, if this were a brand-new file and this says Book1, I'd probably want to give it a different name, or even now, if I want to use a different name here, I can type in a different name as I choose--up to 255 characters. Do stay away from many of the special characters, you know hyphens and underscores work okay, but a lot of other symbols such as asterisks and slashes, you probably don't want to use. If you want to change the name or if it's a brand-new file, you want to give it a name. That's certainly important. If it's a second, third time, fourth time, often you're not changing the name at all, you just give it a quick look that looks great.
Where are you saving it? If you're using Windows 8, you're screen is likely to look the way it is here. Windows 7, probably fairly similar, but a little different. But you'll have choices on the desktop possibly; some other location; on this computer; on the hard drive; or if you've got Flash drive plugged in--certainly other places to save it--you'll make that choice when necessary. A third choice, occasionally necessary and sometimes really important, "Save As Type". If the file you're saving is likely to be used by some other people who don't have one of the more recent versions of Excel, maybe you want to send this to a friend who is using Excel 2003, you want to be sure that this workbook is saved in the format that that person can use it in.
By clicking the drop arrow here in the panel next to Save As Type, you might want to make the choice Excel 97-2003 Workbook. There are certainly some other choices out here that from time to time you may want to explore. In this case let's say, we don't really need that, but we certainly could in some cases. Choosing Excel Workbook, simply reaffirming what the choice is here, is likely to be your more common choice. In fact, you won't even think of it as a choice, you'll simply ignore it, eventually just click Save or click OK here as we complete this.
Anytime, there's any doubt about where a file needs to be saved or what its name is or what file type you want to store it in, go to Save As. Now, as we go back into Excel, imagine if we've made some more changes, maybe we're going to put in some formulas here. Imagine if we've done that, we've made some more changes. What do we need to do from time to time? We need to save our workbook all over again, but it certainly doesn't have to be that extended series of commands. The "File Save" button--likely to be that first button here in your Quick Access Toolbar--although it means update, doesn't say that, Save simply means--if we were to click this right now--update this workbook to include our most recent changes.
So, you want to do that from time to time just to make sure that what you're seeing on the screen and what you've got saved match up. If there's any doubt about saving files, you're not sure exactly with regard to the file name, its location, or its file type, choose the command by way of the File Tab-- Save As.
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.