Microsoft Excel Essentials

Rated 1 out of 5 by from Really unprofessional - even unbearable I don't really know how to say what I think of this course in a polite way that wont cause the review to be censored. The course is really substandard. The lecturers are unfocused and give a nervous and unprofessional impression. There are a lot of irrelevant jibber jabber by the lecturers that make it unbearable to follow the course. If you are a serious learner you will likely just get really annoyed watching this.
Date published: 2021-04-15
Rated 1 out of 5 by from Too simplistic and superfluous to be useful If you are planning to acquire a course on Microsoft Excel to learn how to prepare simple budgets (i.e., simple computations) or simple graphs, this course will not be for you. The focus is mainly on superfluous detail such as formatting, which is more relevant for either Word or PowerPoint. I believe that the instructor is knowledgeable and she could do a much better job. However, she is constantly interrupted by a host, who most of the times made non-sense (stupid comments) interruptions.
Date published: 2021-03-25
Rated 1 out of 5 by from Presentation is difficult to follow as the two presenters spend more time joking with each other than presenting useful information. The instructor often looses her place and talks about Word instead of Excel. The entire course could be presented in half the time and still include some personal references to keep the course from being too dry. I am surprised that The Great Courses includes this program in their catalog. This course is not worth $1.00. There are free videos on You Tube that offer more content.
Date published: 2021-03-09
Rated 3 out of 5 by from Comedy Club I bought the package of three courses: excel, word, and ppt. I started with excel because it is what I need the most help with. I find the hosts annoying with their constant clowning. This makes following the program hard. Also, if they would stick to the lesson material each lesson would be shorter and more beneficial. Vonne also seems a bit disorganized. This is not the professional presentation that I am used to with your programs.
Date published: 2021-02-20
Rated 1 out of 5 by from The bad dish analogy As it pertains to this "show" or product, it is as if you go to a restaurant to order a meal and the entire experience falls flat. Service is horrible and when the meal finally arrives at your table you realize that it is a complete disaster, and you are left to wonder why someone did not inspect the plate before it was brought to your table. Similarly, this is painfully executed. How could it be that someone did not review this content before allowing it to be approved. This is truly a disappointment.
Date published: 2021-02-15
Rated 1 out of 5 by from You've got to be kidding To say that this course is not up to the usual Great Courses standard, is an understatement. I've used Excel for a number of years, have taken a number of courses on using Excel and wanted a refresher. I suffered through two lessons. Lesson one taught me nothing. Lesson two was chock full of inane useless babble and bantering by the hosts (not instructors) about the Excel history, and subscriptions and even a reference to Lotus, which I'm old enough to remember. Things that have nothing to do with using Excel on even a basic level such as entering simple data. The inane banter between the hosts and the paucity of useful information was not to be believed. If you're a beginner, and find these scattershot lessons confusing, take heart, it's not you.
Date published: 2021-02-09
Rated 2 out of 5 by from I felt like I was watching a dating show instead My time is limited, so I need to get the most info in the least amount of time possible. This course is the opposite of that. I honestly thought maybe the instructor and the host were falling for each other, but then Vonn brought up her husband and I thought, ought oh, hope he doesn't watch this or he's probably not going to be real happy. It's great that they got along so well with each other, but I'm here to learn, not to watch dating behavior. Very disappointed.
Date published: 2021-01-16
Rated 1 out of 5 by from Very poor presentation The first one Microsoft Essentials I tried out was “Excel Essentials”. At first, I gave the presenter, Vonne Smith, the “benefit of the doubt” on the first lesson. To be honest it was horrible but assumed that once she got into the course it would improve – not a chance. Two other lessons were equally horrific. What made it worse was she had a “side kick” who was equally inane. As the student, felt I did not belong in their horrible discussions.
Date published: 2021-01-07
  • y_2021, m_4, d_20, h_17
  • bvseo_bulk, prod_bvrr, vn_bulk_3.0.14
  • cp_1, bvpage1
  • co_hasreviews, tv_2, tr_23
  • loc_en_CA, sid_40040, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING)]
  • clientName_teachco
  • bvseo_sdk, p_sdk, 3.2.1
  • CLOUD, getReviews, 5.51ms
  • REVIEWS, PRODUCT
Microsoft Excel Essentials
Course Trailer
Overview
1: 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
Introduction to Excel
2: 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
Excel Basics
3: 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
Excel Interface
4: 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
Navigate a Workbook
5: 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
Select Cells
6: 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
Insert Data
7: 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
Fill Series and Flash Fill
8: 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
Export and File Types
9: 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
Modify a Worksheet
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
Format a Worksheet, Part 1
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
Format a Worksheet, Part 2
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
Number Formats: Introduction
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
Number Formats: Common Number Formats
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
Number Formats: Text, Special, Custom
15: Number Formats: Text, Special, Custom

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

31 min
Number Formats: Date and Time
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
Proof, Print, and Page Layout, Part 1
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
Proof, Print, and Page Layout, Part 2
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
Manage Sheets and Workbooks
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
Vonne Smith

You need to know how to select before you can affect.

INSTITUTION

ITProTV

About Vonne Smith

Vonne Smith is a University of Florida faculty member and has been teaching Microsoft® Office and Adobe® Creative Suite applications to individuals and companies for over 15 years.

Also By This Professor