Excel for Mac Basics (2019)

Do you want to learn how to make, view, edit, and share spreadsheets easily and quickly in Excel? In this course you will learn how to enter data, use formulas and functions, create and use relative, absolute, and worksheet references. You will also learn how to modify Excel's cells, columns, and rows, use find and replace, apply text and number formatting, use styles, themes, and conditional formatting, create templates, and use custom views.

• Excel for Mac Basics 2:05:19

  • 1: Getting Started with Excel 10:56
  • 2: Excel for Max VS Excel for PC 02:50
  • 3: Data Entry Shortcuts 07:18
  • 4: Using Formulas and Functions 10:37
  • 5: Copying Formulas and Functions 05:35
  • 6: Using Relative Absolute, and Worksheet Reference Formulas 07:33
  • 7: Modifying Cells, Columns, and Rows 06:53
  • 8: Search and Replace and Spellcheck 05:57
  • 9: Applying Text Formatting 12:50
  • 10: Number Formats and Cell Alignment 11:00
  • 11: Styles and Themes 03:26
  • 12: Applying Conditional Formatting 06:31
  • 13: Creating a Template 03:51
  • 14: Preview a WorkBook 05:09
  • 15: Setting Page Layout and Printing a Workbook, Part 1 05:34
  • 16: Setting Page Layout and Printing a Workbook, Part 2 09:10
  • 17: Working with WorkSheets 05:05
  • 18: Using Custom Views 05:04

Get started with Microsoft Excel - the most useful software ever created

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 still the right choice.

In the Excel for Mac Basics course, we’ll show you how to get started with Excel and use its most popular features. Learn the anatomy of a spreadsheet, how to insert data and make your data appealing and easy to read. Using Excel, you can do almost anything – 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 and quickly. Get quick access to tools and commands and use the ribbon tabs to explore all that 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 display to match your preference. After finishing this course, Excel for Mac will become your go-to software for working with spreadsheets.

Topics covered include:

• Entering data
• Using 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

Whether you’re a first-time Excel user, or if you just want to re-learn the fundamentals, this course is for you! Over two hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

This course comes equipped with a Bigger Brains Knowledge Check!

Currently there are no Q&As for this course. Be the first to ask a question.

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included