Microsoft Excel for Mac: A Tutorial for Beginners (Udemy.com)

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

( 0 Reviews )

Created by: Dan Wassink

Produced in 2016

What you will 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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

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

Understand the Features and Functions of Microsoft Excel for Macto Make the Most of Your SpreadsheetCreation Experience.

Learn theMicrosoft Excel for Mac InterfaceUnderstand How to Get Around Microsoft Excel for MacCreate Workbooksand WorksheetsCreate Workbook TemplatesFormatting Page Layout, Themes, and View OptionsAdding Headers and FootersSplitting and Freezing PanesWorking with CellsAdding Text or Formulas to CellsSelecting, Styling, and Formatting CellsAdding Borders and Fills to CellsAdding Conditional Formatting to CellsMerging, Moving, Inserting and Deleting CellsMoving and Resizing Rows and ColumnsAdding and Hiding Rows and ColumnsSorting and Filtering ColumnsGrouping Rows and ColumnsWork with Tables, Text Boxes, Shapes, Pictures, Smart Art, and ChartsCreating Data ConnectionsConverting Text to ColumnsHighlighting and Removing DuplicatesValidating and Consolidating DataUtilize Review Features for Accuracy and CollaborationPrinting, Sharing, and Exporting WorkbooksLearn Time-Saving Shortcuts and Preference Settings

Content and Overview

Noteboom Productions designed this course for beginners who are new to the Mac or anexisting Mac user who may not be familiar with Microsoft Excelfor Mac.
Knowing how to use a spreadsheetapplication effectively will result in increased productivity.
We'llguide you through 41videos in just over 3hours, teaching you the basics of creating spreadsheetsusing Microsoft Excelfor Mac. We demonstratehow to get started by creating a spreadsheet, changeformatting and styles, how to work with cells and rows, how to create formulas,insertobjects, usereview features and addsecurity to workbooks. You are encouraged to have Microsoft Excelfor Macinstalled on your Mac or MacBookso 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.

Time: 3.5h

Instructor Details

Dan Wassink

0.0 Rating
0 Reviews

Dan Wassink, of Noteboom Tutorials, has been creating and producing videos on how to use various software for nearly 10 years.
He has been working on Mac's for nearly 30 years and also worked as a Genius at Apple Retail for several years before venturing out on his own creating tutorials and tips. He has over 60 tutorials with over 2,400 lessons and tips available through his Noteboom Tutorials website, App Stores, and iBooks store.
He has helped thousands of people and his tutorials have received hundreds of testimonials andfive-star ratings. They have been recommended by new users, advanced users, and teachers.
He looks forward to helping you learn more about your Mac, iPad, iPhone, Apple Watch, and Apple TV with his tutorials!