Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Mac Basics
Rating: 4.1 out of 5(3 ratings)
15 students
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
  • Excel for Mac VS Excel for PC2:50
  • Data Entry Shortcuts7:18
  • Using Formulas and Functions10:37
  • Relative, Absolute, and Worksheet References7:33
  • Modifying Cells, Columns, and Rows6:54
  • Search and Replace and Spellcheck5:57
  • Applying Text Formatting12:50
  • 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
  • Applying Conditional Formatting6:31
  • Creating a Template3:51
  • Preview a Workbook5:09
  • 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
  • Working with Worksheets5:05
  • 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

Report abuse