Excel for Mac Basics

Excel for Mac Basics

Part of our online library flat rate.

  • By
  • Triple Tech LLC dba Bigger Brains

Flatrate 12 month

19 USD per month

  • 12 Months
  • Single License
  • 19 USD 228 USD per year
  • 850+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

  • 10+ Users
  • For departments or complete companies
  • Premium analytics

Language

English

Level

Beginner

Release

2021

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.

Lesson

  1. Getting started with Excel
  2. Excel for MAC vs Excel for PC
  3. Data Entry Shortcuts
  4. Using Formulas and Functions
  5. Copying Formulas and Functions
  6. Using Relative, Absolute and Worksheet References in Formulas
  7. Modifying Cells, Columns and Rows
  8. Search and Replace and Spellcheck
  9. Applying Text Formatting
  10. Number Formats and Cell Alignment
  11. Styles and Themes
  12. Applying Conditional Formatting
  13. Creating a Template
  14. Preview a Workbook
  15. Setting Page Layout and Printing a Workbook
  16. Working with Worksheets
  17. Using Custom Views