Microsoft Excel Essentials for Mac

  • bvseo_sdk, p_sdk, 3.2.1
  • CLOUD, getReviews, 3.63ms
  • REVIEWS, PRODUCT
  • bvseo-msg: HTTP status code of 404 was returned; HTTP status code of 404 was returned;
Microsoft Excel Essentials for Mac
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 for Mac 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.

6 min
Introduction to Excel
2: Introduction to Excel

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

32 min
Excel Basics
3: Excel Basics

In this episode, Justin and Vonne cover the basics of working with Excel in the Macintosh 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.

25 min
Excel Interface
4: Excel Interface

In this episode, Justin 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, and status bar.

33 min
Navigate a Workbook
5: Navigate a Workbook

Justin 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.

22 min
Select Cells
6: Select Cells

In this episode, Justin 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.

30 min
Insert Data
7: Insert Data

In this episode, Justin 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, data and cell overflow, autocorrect options, move data to new cell, and clear cell data.

26 min
Cut, Copy, Paste
8: Cut, Copy, Paste

Justin and Vonne review cut, copy, and paste in Excel. While this might seem like a straight forward topic, there are a few caveats with these functions that can cause a user stress if not aware. They also cover undo and redo commands.

34 min
Fill Series
9: Fill Series

In this episode, Justin and Vonne explore how to fill series of data. This feature expands the way you copy and paste data and will predict ranges like dates and common item lists.

34 min
Fill Series: Custom Lists
10: Fill Series: Custom Lists

Vonne and Justin take a closer look at fill series, specifically covering how to create a custom list series and how to edit existing lists.

30 min
Export and File Types
11: Export and File Types

In this episode, Justin 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.

18 min
Modify a Worksheet
12: Modify a Worksheet

In this episode, Justin 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.

35 min
Format a Worksheet
13: Format a Worksheet

In this episode, Justin and Vonne show how to format a worksheet in Excel 2016. They cover selecting fonts, aligning cell content, adding borders and shading, and copying formats with the format painter.

33 min
Styles and Themes
14: Styles and Themes

Justin and Vonne continue to discuss cell formatting, specifically covering cell styles. They show how to apply styles, modify and update styles, and create custom styles. They also demonstrate how themes are connected to styles and the overall formatting of a workbook.

31 min
Number Formats: Introduction
15: 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.

25 min
Number Formats: Common Number Formats
16: 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
17: 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
18: 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
19: Proof, Print, and Page Layout, Part 1

In this episode, Justin 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 cover print preview and introduce page layout view to add and modify page elements.

26 min
Proof, Print, and Page Layout, Part 2
20: Proof, Print, and Page Layout, Part 2

ustin and Vonne 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.

34 min
Manage Worksheets and Workbooks
21: Manage Worksheets and Workbooks

In this episode, Justin and Vonne finish up the 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.

33 min