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.
There's no question that when you're using Excel at different times, you will need help. Keep in mind again as you slide over one of the many icons in the Ribbon, for example, "Conditional Formatting" here, you do get a quick description of what that feature is about. Sometimes, these are very small, but at other times they're more extensive. For example, on the Data Tab, if you were to click the Data Tab in the ribbon, Text to Columns may not mean a whole a lot, but when you read this, perhaps it means more. Notice also, that you will see, as we see here a choice, "Tell me more" and you will get the Help screen here too.
Sometimes, the Help screens lead you into multiple other choices, you can click there. "Do I want to do this?" Maybe/Maybe not, I'm not sure what that means. This could be very useful you might want to print this. We can see, by way of the ribbon, we can easily get to some Help features. Also, available in the upper right-hand corner of a worksheet, you will see the question mark and recognize also that it has a Keystroke Shortcut--the traditional F1 key meaning Help. Throughout Microsoft products and many, many other software products as well, the F1 key means Help.
It does here, as well as the question mark. This leads us into the Excel Help screen. While you're here, you'll also see a lot of other tips here as well. Maybe we've done some of these searches or maybe we're interested in some of the more popular searches. If it's a completely different feature than the ones we see here, we might want to type in something. For example, we might be saying, "Well, I've heard about charts, let's find out about a chart". "What does that mean exactly and how can I create one?" We can type that in and either press Enter or click the magnifying glass and possibly, this will lead us into online help if we're logged on, or maybe get some information right on our screen, even if we're working while we're not online.
There are a lot of ways to get Help as you work with Excel. Recognize also that the more you work with Excel, the more you become attuned to shortcuts. Particularly, on the Home Tab, recognize that as you slide over certain icons, for example, B for Bold, there's a Keystroke Shortcut listed there, it's Control+ B. There's one for Italics--Control+I-- and Underline--Control+U--and so on. Not every feature has a Keystroke Shortcut, but learn to discover those and make note of them. Here's Find and Select.
What's that one all about? You could click there, there's Find, maybe I want to use that later. Oh yeah, there's a Keystroke Shortcut, Ctrl+F, as we slide over Find or Ctrl+H for Replace. Some of these are not exactly obvious. The Excel Help System is extensive, you can get to it at any time with the F1 key or the question mark in the upper right-hand corner or as we saw with certain features--as on the Data Tab with Text to Columns--the "Tell Me More" option as well; one more way to use the extensive Help system in 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.