Welcome to the Excel 2013 Essential Skills video course.
Our Excel video courses are used by large corporations, schools, colleges and universities. Absolutely anybody can master Excel 2013 using this course. And several million Excel users, all over the world, have done just that.
The courses are based upon our world best-selling Excel books and are undoubtedly the most comprehensive and easiest to use Excel video courses available. By the end of this Essential Skills course, your Excel skills will be better than most office workers (even those with many years of Excel experience).
This five-minute preview is designed to enable you to quickly review all of the skills you're going to master in Session 1. If you already have some Excel experience, this five-minute preview may enable you to skip over some, or all, of the lessons in this session.
So let's start the clock ticking and begin the preview. In the first lesson I'm going to teach you how to start Excel and open a new workbook.
For Windows 8 users I'll show you how to add a tile and then pin it to the start menu.
You're then going to open a new blank workbook from a template (the only way to open a blank workbook in Excel 2013). And you'll learn a little about templates along the way.
You'll then open Excel and close Excel.
In the second lesson, I'll teach you about Office updates and why it's important that your version of Excel is up to date. If you've got a buggy, out-of-date version of Excel you'll find many of the lessons presented in this course won't work properly.
In the third lesson you'll learn how to change the Office Theme. This is a brand new feature for Excel 2013.
Many users find the standard White theme is difficult to work with and gives them eye strain. I'll show you how you can change this to the Light Gray theme, or the Dark Gray theme, which you'll find a lot easier on your eyes.
In the fourth lesson we'll talk about maximizing, minimizing, re-sizing, moving and closing the Excel window. And I'll also show you how to re-size the window.
In the fifth lesson I'll walk you through the process of downloading the extensive sample file set you'll need to work through this course. And I'll show you how to very quickly navigate through a workbook.
One of the things I'll teach you is a very little-known Excel skill: how to scroll through a million rows in less than a second. Let me preview this from the course. Let's start now… and there's a million rows.
In lesson 1-6 you'll save a workbook to your local hard drive.
And in Lesson 1-7, you'll discover that there are many file formats in which you can save an Excel workbook. I'll teach you which are the most important ones and when you should use them.
In lesson 1-8 you'll pin a workbook so that it always floats to the top of the Recent Workbooks list. This is very useful when you have a workbook you use often. I'll also show you how to implement a logical system for organizing your files, so you'll never lose a workbook in the future.
The ninth lesson is all about worksheet tabs. I'll show you how to add a new worksheet tab, and how to delete a worksheet tab. I'll also show you how to navigate through your worksheet tabs when you have a large number of worksheets within a workbook.
In the tenth lesson I'll teach you all about the versions feature. I'll show you how to set it up so that Excel is constantly saving backup files automatically in the background and then you'll never lose a workbook ever again if there's a power cut or simply if you forget to save a file.
In lesson 1-12 I'll introduce the Ribbon.
And in lesson 1-13 I'll introduce the Ribbon Components one by one. Components such as the command group, the drop-down list, the rich menu, the gallery and the dialog launcher: the key to accessing many of Excel's advanced features.
The fourteenth lesson introduces the Quick Access toolbar, and you can see the default toolbar only has four options. But by the end of Lesson 14 you'll construct a feature-rich Quick Access Toolbar that will greatly improve your efficiency when working with Excel.
Lesson 15 introduces the mini-toolbar: a new way to quickly format text. Also, key tips, a way of quickly finding keyboard shortcuts.
In lesson 1-16 I'll introduce views. There's three views in Excel: the Normal view, the Page Layout view, and the Page Break Preview view. Each view is designed to make it easy to complete certain tasks.
In Lesson 17, I'll show you how to hide and show the Formula Bar and the Ribbon. In this example I've hidden the Formula Bar. And in this example I've hidden both the Formula Bar and the Ribbon. And in this final example, I've hidden everything to give you the maximum number of cells visible on screen.
In the eighteenth and final lesson, I'll show you how to use the help system. Not just Microsoft's help system (that some users find confusing), but also the ExcelCentral.com search facility, where you can quickly find a video lesson to solve any Excel problem.
And at the end of Session 1 (as at the end of every session), there's an exercise to complete, to confirm your understanding of the skills presented.
Well you've now listened to the introduction to Session 1 and you're ready to begin the Excel 2013 Essential Skills video course.