TOIT Training

Beginner

Excel for Mac Basics

Overview
Curriculum

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.

Curriculum

  • 18 Sections
  • 2h 5m Duration
Expand All
Getting Started with Excel
    Excel for Mac VS Excel for PC
      Data Entry Shortcuts
        Using Formulas and Functions
          Copying Formulas and Functions
            Using Relative Absolute, and Worksheet Reference Formulas
              Modifying Cells, Columns, and Rows
                Search and Replace and Spellcheck
                  Applying Text Formatting
                    Number Formats and Cell Alignment
                      Styles and Themes
                        Applying Conditional Formatting
                          Creating a Template
                            Preview a Workbook
                              Setting Page Layout and Printing a Workbook, Part 1
                                Setting Page Layout and Printing a Workbook, Part 2
                                  Working with Worksheets
                                    Using Custom Views

                                      Deleting Course Review

                                      Are you sure? You can't restore this back

                                      Course Access

                                      This course is password protected. To access it please enter your password below:

                                      Buy for group

                                      Excel for Mac Basics
                                      No groups Found

                                      You don't have any groups yet

                                      Create a group and add group members. Sync Group(s)