Excel for Mac Basics

Name: Excel for Mac Basics
Rating: 4.1 (3 reviews)

Learn how to use this office power tool on your Mac

Created byBigger Brains

Last updated 6/2024

English

What you'll learn

Enter Data
Use Formulas and Functions
Create and Use Relative, Absolute, and Worksheet references
Modify Cells, Columns, and Rows
Use Find and Replace
Apply Text Formatting and Number Formats
Use Styles and Themes
Apply Conditional Formatting
Create Templates
Setup Page Layout
Use Custom Views

Course content

1 section • 17 lectures • 1h 59m total length

Getting Started with Excel10:56
Learn the mac Excel basics by navigating the interface, ribbons, and key terms, then create and save a workbook, enter data in cells, and use formulas.
Excel for Mac VS Excel for PC2:50
Compare excel for mac and excel for pc, highlighting the mac menu bar, file menu, backstage view differences, ribbon variations, live preview absence, and command key usage.
Data Entry Shortcuts7:18
Master Mac-friendly Excel shortcuts, navigate with function keys, delete, and copy-paste; understand auto fill and alignment to streamline data entry while avoiding errors.
Using Formulas and Functions10:37
Learn to build formulas in Excel for Mac, apply the order of operations (PEMDAS), and use auto sum and common functions like average, max, and min with range selection.
Relative, Absolute, and Worksheet References7:33
Learn to use relative and absolute references in Excel for Mac, troubleshoot common formula errors, and pull data between sheets with sheet names and exclamation syntax.
Modifying Cells, Columns, and Rows6:54
Insert and delete columns and rows, use the right-click menu to manage cells, hide and unhide columns, auto-fit width and adjust row height, and save as a new file.
Search and Replace and Spellcheck5:57
Discover how to find, replace, and go to cells in Excel for Mac, using the Edit menu and the ribbon search box, plus spell check in Review.
Applying Text Formatting12:50
Learn to adjust fonts, sizes, colors, bold and underline, borders, and format cells in Excel for Mac basics, using format painter and hyperlinks to enhance readability and navigation.
Number Formats and Cell Alignment11:00
format numbers as money and choose currency or accounting to control dollar placement, then adjust alignment, wrap text, and merge headers for a print-ready Mac spreadsheet.
Styles and Themes3:26
Learn how to apply and customize styles and themes in Excel for Mac, including overall themes, color themes, and font themes, to adjust fonts, colors, and appearance across a workbook.
Applying Conditional Formatting6:31
Learn to use conditional formatting in Excel for Mac to highlight cells greater than 250,000, identify top and bottom performers, and visualize data bars and two-color scales via manage rules.
Creating a Template3:51
Create and save a customized Excel template by removing data, saving as an .xltx file, sharing the formatted layout with colleagues, and reuse formulas and data bars.
Preview a Workbook5:09
Discover how to find and use print preview in Excel for Mac, view printouts as a PDF, and balance page breaks with page break preview and page layout options.
Page Layout and Printing, Part 15:34
Explore Excel for Mac page layout options to control margins, orientation, and paper size, and learn to set a print area, repeat titles, and insert page breaks.
Page Layout and Printing, Part 29:10
Learn to use the page setup options in Excel for Mac basics to adjust margins, centering, headers and footers, print areas, page order, scaling, and print settings for polished outputs.
Working with Worksheets5:05
Rename sheet tabs to identify contents, such as US, Canada, and Mexico. Color tabs to distinguish regions, add sheets with the plus sign, and hide or unhide tabs.
Using Custom Views5:04
Keep headers visible with split and freeze panes, then compare data across quarters using two side-by-side windows in the same workbook.

Requirements

A copy of Microsoft Excel

Description

Get started with Microsoft Excel – a must-have for business users

If you have worked in Excel before but not on a Mac, this is the perfect course for you. If you have never used Excel before and you’re starting with the Mac version, this course is also the right choice for you.

In the Excel for Mac Basics course, we’ll show you how to get started and use Excel’s most popular features. Learn the anatomy of a spreadsheet and how to insert data and make your data appealing and easy to read. You can do almost anything with Excel – crunch numbers, create lists, store data, edit budgets, and more. Join Microsoft Office expert Barbara Evers as she walks you through the most common components of Excel.

Learn how to make, view, edit, and share spreadsheets easily. Get quick access to tools and commands and use the ribbon tabs to explore all Excel can do for you. Use a variety of formulas and functions and learn how to use them efficiently. Learn to switch between different view options and use the zoom slider to enlarge the page to match your preference. After finishing this course, Excel for Mac will become your go-to software for creating and managing spreadsheets.

Whether you’re a first-time Excel user, or if you just want to re-learn the fundamentals, this course is for you!

Topics covered include:

Entering data
Using and copying formulas and functions
Creating and using relative, absolute, and worksheet references
Modifying cells, columns, and rows
Using find and replace
Applying text and number formatting
Using styles and themes
Applying conditional formatting
Creating templates
Using custom views

Over two hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Who this course is for:

Mac users who are new to Microsoft Excel