You updated your password.

JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.

Reset Password

Enter the email address you used to create your account. We will email you instructions on how to reset your password.

Forgot Your Email Address? Contact Us

Reset Your Password

SHOW

Rated 3 out of 5 by Tavo from Excel Essentials I purchased the course about a month ago and found it very helpful. Unfortunately, I did not finish the course in one time, and when I tried to go back to where I left off, I have yet to be able to find that place, and I have not been able to finish this course.

Date published: 2022-03-17

Rated 2 out of 5 by Witz from Good basic course, unprofessional instructors This is a good course if you really have no understanding of how to use excel. However the instructor and host banter back and forth over ridiculous nonsense. Very unprofessional. I’m shocked that the Great Courses would even have this as a course. Well you get what you pay for. I read the reviews from others and still purchased it.

Date published: 2022-03-16

Rated 3 out of 5 by billparzy from Old version of Excel is used I wish it was using a newer version of Excel. It was pretty basic stuff. A more advanced version would be nice. For a new user it is fine. I would recommend to a new user but not an experienced one.

Date published: 2022-03-15

Rated 1 out of 5 by Rory Muldoon from Overall level of presentation is unprofessional A lot of the teaching time is spent on frivolous banter and irrelevant conversation. Actual course length could be significantly reduced if presenter could stay on subject.

Date published: 2022-03-04

Rated 4 out of 5 by Rothtow from Excel Course Needs More The Excel course is an excellent course if you know nothing about the program. It’s a great start but needs more information on formulas.

Date published: 2022-03-04

Rated 1 out of 5 by MA Anderson from Excel Essentials I recently purchased this course. I am glad to have it, however, it is not up to the usual standard of The Great Courses (TGC). The presenters are not as professional in general as the usual TGC teachers. The sound quality is really bad. At first I thought it was my DVD player, so I tried listening to it online. The sound was no better.

Date published: 2022-03-01

Rated 5 out of 5 by bigcontender from Sure made a believer out of me When I got the "Excell Essentials" I was going to return it as the courses seemed very basic and calculations were not included. Fortunately I started watching the lessons and wow what an excellent review of Excell. I have been somewhat of a power Excell user for years. I've leaned so many tricks about mouse pointers, formats, and numerous ways to do the same thing. Can't waite to get home and watch the next lesson. Great Job I'll be looking for the advanced Excell course.

Date published: 2022-02-28

Rated 5 out of 5 by iuliana from Microsoft Excel Essentials Lecture 16 is IDENTICAL to lecture 18 and Lecture 17 is IDENTICAL to lecture 19 These are duplicate lectures Please correct

Date published: 2022-02-01

Trailer

01: Overview

Excel 2016 is the powerful spreadsheet application in the Office suite. It seems every organization, large and small, uses Excel to organize and analyze data. However, many users are intimidated by Excel and confused by how it behaves as an application. The Excel 2016 Essentials series strives to empower users by learning the foundations to conquer this program. We begin with basic skills such as navigating the interface, identifying items in a spreadsheet, selecting cells, and inputting data. The series also covers formatting text and numbers, modifying a worksheet layout, printing and page layout, and managing worksheets in a workbook. While this series is designed for beginner users, it has lots of great tips and tricks for experienced users as well.

9 min

02: Introduction to Excel

In this episode, Daniel and Vonne kick off the Microsoft Excel 2016 Essentials series. They define a spreadsheet, discuss the history of Excel and file types, and introduce other foundational concepts for this course.

27 min

03: Excel Basics

In this episode, Daniel and Vonne cover the basics of working with Excel in Windows operating system. They review foundational skills and items such as starting Excel, the title bar, minimize and maximize, full screen mode, create a blank workbook, open an existing workbook, save vs. save as, and keyboard shortcuts.

28 min

04: Excel Interface

In this episode, Daniel and Vonne examine the Excel user interface (UI). Here you will learn about the title bar, the ribbon, quick access toolbar, formula bar, name box, status bar, and help.

25 min

05: Navigate a Workbook

Daniel and Vonne demonstrate how to navigate a workbook . They will explain the different mouse cursors icons, scrolling, keyboard navigation, navigating with the name box, zooming, and choosing worksheets.

30 min

06: Select Cells

In this episode, Daniel and Vonne explore the multiple ways that you can select and work with cells in Excel. They demonstrate click/hold/drag, deselecting, range selecting, selecting with shift and arrow keys, select all, select multiple worksheets, select text in multiple worksheets, named ranges, and how to use find and replace.

27 min

07: Insert Data

In this episode, Daniel and Vonne explore the variety of ways that you can insert data into your Excel worksheet. Here they cover: entering data into a cell, editing data in a cell, controlling data and cell overflow, autocorrect options, moving data to new cell, copy/paste, and clear cell data.

31 min

08: Fill Series and Flash Fill

In this episode, Daniel and Vonne explore how to fill series data and use the flash fill functions of Microsoft Excel 2016. These features expand the way you copy and paste data and will predict ranges like dates and common item lists.

30 min

09: Export and File Types

In this episode, Daniel and Vonne go through the common file types supported by Excel 2016. Here they explain .xlsx files, Comma Separated Value(.csv) files, OpenDocument Spreadsheet(.ods) files, and Excel Templates(.xltx) files.

27 min

10: Modify a Worksheet

In this episode, Daniel and Vonne explore modifying a worksheet in Excel 2016. They demonstrate how to select columns and rows, change column height and row width, insert and delete rows/columns, hide columns and rows, merge cells, and apply word wrap to cells.

30 min

11: Format a Worksheet, Part 1

In this episode, Daniel and Vonne show how to format a worksheet in Excel 2016. Here they talk about selecting fonts, adding borders and shading, and copying formats with the format painter.

23 min

12: Format a Worksheet, Part 2

Daniel and Vonne continue with formatting a worksheet. In this episode, they cover aligning data in cells, cell styles, and themes.

23 min

13: Number Formats: Introduction

Vonne and Justin start a small mini series on number formats. In this episode, they introduce number formats and discuss the difference between inputted data vs displayed data.

24 min

14: Number Formats: Common Number Formats

In this episode, Vonne and Justin cover the following number format categories: number, currency, accounting, percentage, fractions, and scientific notation.

30 min

15: Number Formats: Text, Special, Custom

Vonne and Justin continue with number formats, specifically covering the text, special, and custom categories.

31 min

16: Number Formats: Date and Time

Justin and Vonne finish the number format mini series by discussing date and time number formats. They also introduce the DATEVALUE function.

31 min

17: Proof, Print, and Page Layout, Part 1

In this episode, Zach and Vonne demonstrate how to proof and control page layout for printing. They show how to spellcheck a worksheet and the options for ignoring or adding to the dictionary as well as how to use the thesaurus and smart lookup. They also show how to modify page layout from print preview in the backstage view.

29 min

18: Proof, Print, and Page Layout, Part 2

Vonne and Zach continue discussing page layout. In this episode, they show how to modify page layout elements from the page layout view such as headers and footers, page orientation, and margins. They also go over adding print titles, setting a print area, and controlling page breaks.

21 min

19: Manage Sheets and Workbooks

In this episode, Daniel and Vonne finish up the Excel 2016 Essentials series by demonstrating how to manage workbooks and worksheets. Here they show you how to rename worksheet tabs, change tab color, rearrange worksheets, create new and delete worksheets, and copy/hide/move worksheets. They also show how to control view options such as freeze panes, split view, new windows, and arranging windows.

28 min

Overview Course No. 40040

It seems every organization, large and small, uses Microsoft® Excel to organize and analyze data, and many individuals find it useful for organizing household budgets and other personal information. Yet many users can find themselves intimidated by Excel—after all, it is an amazingly detailed and flexible application, full of options that can be difficult to navigate or apply correctly if you don't understand the many functions and menus available to you.

That's where Microsoft Excel Essentials comes in. The 19 lessons of this course strive to empower users by providing the necessary foundation for working in Excel with ease. Brought to you in partnership with ITProTV and taught by Microsoft® Office guru Vonne Smith and her co-hosts Justin Dennison and Daniel Lowrie, these lessons will help you conquer this essential program by introducing you to its interface, guiding you through its many menus and options, identifying crucial elements, and teaching you how to input data, modify worksheets, arrange layouts, and much more. And while this series is designed for beginners, it has lots of great tips and tricks for experienced users as well. These lessons use the 2016 edition of Excel and, as we all know, computer software is constantly changing. But rest assured: Everything that you learn in these lessons can be easily adapted to updated editions of the program, as well as to other versions of the program designed for different computer operating systems. With help from the ITProTV team, you will learn the basics of how to make this versatile tool work for you.

"Right-click (or Ctrl-click on Mac) on the Download button below and select “Save As,” “Save Link,” “Save Target,” or “Download Link As” to download the course resource materials"

Download