Microsoft Excel for Mac: A Tutorial for Beginners

Name: Microsoft Excel for Mac: A Tutorial for Beginners
Rating: 4.3 (33 reviews)

Create intelligent spreadsheets and organize all of your data in Microsoft Excel for Mac.

Created byDan Wassink

Last updated 6/2016

English

What you'll learn

Understand the user interface for Microsoft Excel for Mac.
Create spreadsheets in Microsoft Excel for the Mac.
Use Microsoft Excel for Mac to organize your data both at work and at home.
Share data you have collected and organized using Microsoft Excel for Mac.

Course content

9 sections • 41 lectures • 3h 38m total length

Introduction2:12
This first lecture is an introduction and overview to what we are going to cover in Tutor for Microsoft Excel.
Interface Overview5:07
In this lecture we look at the interface to Microsoft Excel. We show you where the quick access toolbar is, how the ribbon tabs work including contextual tabs, we also show you where the search bar and share options are, where you can change your view of your workbook, and where your worksheets are.
Managing Windows and Full Screen Mode8:11
In this lecture we look at how we can view our workbook in full screen mode as well as maximize the window while still showing the menu bar and dock. We then take a look at how we can open and manage multiple windows while working with a single document or workbook.

Creating Workbooks and Templates6:16
In this lecture we look at the different ways to create documents or workbooks in Excel. We also look at how to create a workbook from a template as well as save a document as a template in Excel.
Page Layout, Themes, and View Options5:11
In this lecture we look at at the Page Layout options we have in Excel. This includes setting the page orientation, page margins, as well as how we can print the gridlines in a worksheet. We also show you how you can change the theme of a workbook in Microsoft Excel.
Adding Headers and Footers5:09
In this lecture we look at how we can modify the headers and footers of a workbook. This includes adding the date and page numbers to the top of bottom of our spreadsheet.
Adding Security to a Workbook4:23
In this lecture we look at how you can add protection or security to both your workbooks and worksheets in Microsoft Excel.
Working with Worksheets4:50
In this lecture we take a closer look at worksheets including how to create new worksheets, rename worksheets, and copy worksheets.
Splitting and Freezing Panes in a Worksheet4:24
In this lecture we look at how we can split and freeze our panes in Microsoft Excel. When we split or freeze panes we can keep specific rows and columns on the screen as we work with our workbook in Microsoft Excel.

Adding Text and Formulas to Cells5:56
In this lecture we look at how you enter text, numbers, and formulas into a cell in Microsoft Excel.
Selecting, Styling, and Formatting Cells5:10
In this lecture we look at how we select, style, and format our cells in Microsoft Excel.
Adding Borders and Fills to Cells4:10
In this lecture we look at how we add borders and fills to our cells in Microsoft Excel.
Using the Format Painter3:32
In this lecture we look at how we can copy the look and format of a cell or cells and apply that same look and format to other cells using the Format Painter in Microsoft Excel.
Adding Conditional Formatting to Cells6:45
In this lecture we look at how we can add conditional formatting to our cells. With conditional formatting, the cells format or look will change depending on what is in that cell.
Clearing and Autofilling Cells6:06
In this lecture we look at how we can clear our cells including clearing just the contents of a cell or the formatting of our cells. We also look at how we can autofill adjacent cells with patterns in Microsoft Excel.
Merging Multiple Cells into One Cell3:46
In this lecture we look at how we can merge multiple cells into a single cell in Microsoft Excel.
Moving, Inserting, and Deleting Cells3:53
In this lecture we look at how we can move, insert, and delete cells in Microsoft Excel.

Moving and Resizing Rows and Columns6:10
In this lecture we look at how we can move and resize our rows and columns in Microsoft Excel.
Adding and Hiding Rows and Columns4:27
In this lecture we look at how we add and hide rows and columns in Microsoft Excel.
Sorting and Filtering Columns7:30
In this lecture we look at how we sort and filter our data in Microsoft Excel.
Grouping Rows and Columns3:13
In this lecture we look at how we can group our rows and columns together in Microsoft Excel.

Creating and Formatting Tables6:31
In this lecture we look at how we convert cells into tables. With tables we can easily format, sort, and filter our data in Microsoft Excel.
Working with PivotTables5:12
In this lecture we look at how we can create reports using pivot tables in Microsoft Excel.
Working with Pictures9:56
In this lecture we look at the different ways we can add pictures to our workbook. We also look at how we can modify a picture once it is added to our Microsoft Excel document.
Working with Text Boxes and Shapes6:11
In this lecture we look at how we add shapes, including text boxes, to a Microsoft Excel worksheet. We also take a look at the different options we for modifying shapes in Excel.
Working with SmartArt5:13
In this lecture we look at how we add SmartArt to a Microsoft Excel worksheet.
Working with Charts6:46
In this lecture we look at how we add and format charts in a Microsoft Excel workbook.

Creating Data Connections7:49
In this lecture we look at how we create data connections in Microsoft Excel including creating a connection to a Filemaker Pro solution and to a CSV file.
Converting Text to Columns2:53
In this lecture we look at how we can convert text into columns in Microsoft Excel.
Highlighting and Removing Duplicates3:11
In this lecture we look at how we can highlight duplicates as well as remove duplicates in a Microsoft Excel worksheet.
Validating Data6:06
In this lecture we look at how we can validate data in cells in a Microsoft Excel worksheet.
Consolidating Data6:03
In this lecture we look at how we can consolidate date from several worksheets in Microsoft Excel.

Printing Options7:48
In this lecture we look at how we set the print area and insert page breaks in a Microsoft Excel workbook.
Sharing Documents8:06
In this lecture we look at how we share our Microsoft Excel workbooks including how we can share them online and have multiple people work on a workbook at the same time.
Exporting Documents3:06
In this lecture we look at how we export our Microsoft Excel workbooks including converting them to different file types including CSV files and PDFs.

Cut, Copy, and Past Options4:46
In this video we look at how we cut, copy, and paste in Microsoft Excel. We also look at how we can paste only the format or value of a cell using Paste Special.
Undo and Redo Changes3:57
In this lecture we look at how we can undo and redo recent changes in Microsoft Excel.
Excel Preferences2:57
In this lecture we show you where you can change Microsoft Excel’s default behaviors with Excel preferences.

Requirements

Download and install Microsoft Excel for Mac to your Mac prior to starting this course.
Follow along and try each step outlined in the course as it is explained before moving on to the next lecture.

Description

Learn how to use Microsoft Excel for the Mac to create, format, review, and share spreadsheets.. Understand the user interface of Microsoft Excel for the Mac to efficiently navigate and utilize all the features of the application.

Understand the Features and Functions of Microsoft Excel for Mac to Make the Most of Your Spreadsheet Creation Experience.

Learn the Microsoft Excel for Mac Interface
Understand How to Get Around Microsoft Excel for Mac
Create Workbooks and Worksheets
Create Workbook Templates
Formatting Page Layout, Themes, and View Options
Adding Headers and Footers
Splitting and Freezing Panes
Working with Cells
Adding Text or Formulas to Cells
Selecting, Styling, and Formatting Cells
Adding Borders and Fills to Cells
Adding Conditional Formatting to Cells
Merging, Moving, Inserting and Deleting Cells
Moving and Resizing Rows and Columns
Adding and Hiding Rows and Columns
Sorting and Filtering Columns
Grouping Rows and Columns
Work with Tables, Text Boxes, Shapes, Pictures, Smart Art, and Charts
Creating Data Connections
Converting Text to Columns
Highlighting and Removing Duplicates
Validating and Consolidating Data
Utilize Review Features for Accuracy and Collaboration
Printing, Sharing, and Exporting Workbooks
Learn Time-Saving Shortcuts and Preference Settings

Content and Overview Noteboom Productions designed this course for beginners who are new to the Mac or an existing Mac user who may not be familiar with Microsoft Excel for Mac. Knowing how to use a spreadsheet application effectively will result in increased productivity. We'll guide you through 41 videos in just over 3 hours, teaching you the basics of creating spreadsheets using Microsoft Excel for Mac. We demonstrate how to get started by creating a spreadsheet, change formatting and styles, how to work with cells and rows, how to create formulas, insert objects, use review features and add security to workbooks. You are encouraged to have Microsoft Excel for Mac installed on your Mac or MacBook so you can follow along and try it yourself at the end of each lecture.

This course starts with the basics by introducing you to the User Interface for Microsoft Excel for Mac. From there we look at working with Workbooks and worksheets including how we can add headers a footers to a workbook, add security, and freeze panes in a worksheet. We then take a look at working with cells including selecting and formatting cells, adding and deleting cells, autofilling cells, and merging multiple cells into a single cell. From there we look at how we work with rows and columns including inserting and deleting rows and columns, sorting and filtering columns, and grouping rows and columns. We also look at inserting tables, charts, pictures, and SmartArt into a worksheet. From there we look at working with data including validating data, highlighting duplicates, and creating data connections. We also look at our review options including adding comments and trading changes in Excel. From here we look at our different printing and sharing options as well as looking at Excel shortcuts.

If you need to learn Excel for the Mac – our tutorial is for you!

Students completing this course will have the basic knowledge to comfortably create, format, review, and share Workbooks and Worksheets in Microsoft Excel for Mac.

Who this course is for:

Students wanting to learn the basics of Excel to manage lists and create simple formulas will benefit from this course.
No prior knowledge of Excel is needed. This course covers the user interface of Microsoft Excel for Mac.
Students looking to learn how to use more advanced calculations, create scripts, or work with advanced statistical data should not take this course.

Microsoft Excel for Mac: A Tutorial for Beginners

What you'll learn

Explore related topics

Course content

Introduction to Microsoft Excel for Mac3 lectures • 16min

Working with Workbooks and Worksheets6 lectures • 30min

Working with Cells8 lectures • 39min

Working with Rows and Columns4 lectures • 21min

Tables, Pictures, Shapes, and Charts6 lectures • 40min

Working with Data5 lectures • 26min

Review Options3 lectures • 15min

Printing and Sharing Options3 lectures • 19min

Excel Shortcuts and Preferences3 lectures • 12min

Requirements

Description

Who this course is for: