Microsoft Excel for Mac: A Tutorial for Beginners
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel for Mac: A Tutorial for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel for Mac: A Tutorial for Beginners

Create intelligent spreadsheets and organize all of your data in Microsoft Excel for Mac.
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9 students enrolled
Last updated 5/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Compare to Other Excel Courses
Curriculum For This Course
41 Lectures
03:38:09
+
Introduction to Microsoft Excel for Mac
3 Lectures 15:30

This first lecture is an introduction and overview to what we are going to cover in Tutor for Microsoft Excel.

Preview 02:12

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.

Preview 05:07

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.

Managing Windows and Full Screen Mode
08:11
+
Working with Workbooks and Worksheets
6 Lectures 30:13

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.

Creating Workbooks and Templates
06:16

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.

Preview 05:11

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 Headers and Footers
05:09

In this lecture we look at how you can add protection or security to both your workbooks and worksheets in Microsoft Excel.

Adding Security to a Workbook
04:23

In this lecture we take a closer look at worksheets including how to create new worksheets, rename worksheets, and copy worksheets.

Working with Worksheets
04:50

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.

Splitting and Freezing Panes in a Worksheet
04:24
+
Working with Cells
8 Lectures 39:18

In this lecture we look at how you enter text, numbers, and formulas into a cell in Microsoft Excel.

Adding Text and Formulas to Cells
05:56

In this lecture we look at how we select, style, and format our cells in Microsoft Excel.

Selecting, Styling, and Formatting Cells
05:10

In this lecture we look at how we add borders and fills to our cells in Microsoft Excel.

Adding Borders and Fills to Cells
04:10

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.

Using the Format Painter
03:32

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.

Adding Conditional Formatting to Cells
06:45

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.

Clearing and Autofilling Cells
06:06

In this lecture we look at how we can merge multiple cells into a single cell in Microsoft Excel.

Merging Multiple Cells into One Cell
03:46

In this lecture we look at how we can move, insert, and delete cells in Microsoft Excel.

Moving, Inserting, and Deleting Cells
03:53
+
Working with Rows and Columns
4 Lectures 21:20

In this lecture we look at how we can move and resize our rows and columns in Microsoft Excel.

Moving and Resizing Rows and Columns
06:10

In this lecture we look at how we add and hide rows and columns in Microsoft Excel.

Adding and Hiding Rows and Columns
04:27

In this lecture we look at how we sort and filter our data in Microsoft Excel.

Sorting and Filtering Columns
07:30

In this lecture we look at how we can group our rows and columns together in Microsoft Excel.

Grouping Rows and Columns
03:13
+
Tables, Pictures, Shapes, and Charts
6 Lectures 39:49

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.

Creating and Formatting Tables
06:31

In this lecture we look at how we can create reports using pivot tables in Microsoft Excel.

Working with PivotTables
05:12

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 Pictures
09:56

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 Text Boxes and Shapes
06:11

In this lecture we look at how we add SmartArt to a Microsoft Excel worksheet.

Working with SmartArt
05:13

In this lecture we look at how we add and format charts in a Microsoft Excel workbook.

Working with Charts
06:46
+
Working with Data
5 Lectures 26:02

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.

Creating Data Connections
07:49

In this lecture we look at how we can convert text into columns in Microsoft Excel.

Converting Text to Columns
02:53

In this lecture we look at how we can highlight duplicates as well as remove duplicates in a Microsoft Excel worksheet.

Highlighting and Removing Duplicates
03:11

In this lecture we look at how we can validate data in cells in a Microsoft Excel worksheet.

Validating Data
06:06

In this lecture we look at how we can consolidate date from several worksheets in Microsoft Excel.

Consolidating Data
06:03
+
Review Options
3 Lectures 15:17

In this lecture we look at how we can spellcheck a Microsoft Excel worksheet as well as how we can use a thesaurus and define words in Excel.

Check Spelling
04:16

In this lecture we look at how we can add comments to cells in Microsoft Excel.

Adding Comments to Cells
04:20

In this lecture we look at how we can track and review changes in a Microsoft Excel workbook.

Tracking and Reviewing Changes
06:41
+
Printing and Sharing Options
3 Lectures 19:00

In this lecture we look at how we set the print area and insert page breaks in a Microsoft Excel workbook.

Printing Options
07:48

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.

Sharing Documents
08: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.

Exporting Documents
03:06
+
Excel Shortcuts and Preferences
3 Lectures 11:40

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.

Cut, Copy, and Past Options
04:46

In this lecture we look at how we can undo and redo recent changes in Microsoft Excel.

Undo and Redo Changes
03:57

In this lecture we show you where you can change Microsoft Excel’s default behaviors with Excel preferences.

Excel Preferences
02:57
About the Instructor
Noteboom Productions, Ltd.
4.5 Average rating
110 Reviews
1,042 Students
10 Courses
Producer of Easy-to-Follow Video Tutorials

Dan Wassink of Noteboom Productions and Tutorials has been creating and producing videos on how to use various software for over 6 years. With over 20 tutorials available in the App Stores, his tutorials have received close to 700 five-star ratings and reviews and have been recommended by new users, advanced users, and teachers. He looks forward to helping you learn more with his tutorials!