We may earn an affiliate commission when you visit our partners.
Course image
Colin Marks

Microsoft Excel is one of the most popular computer applications in offices over the last 20 years. For years people have struggled with compatibility issues between Microsoft and Apple Mac OS. This is slowly changing, Microsoft Office 365 has brought the two operating systems closer, its now easier than ever to collaborate with other users, its easier than ever to create a file on a Window PC and edit it on your favourite MacBook.

Read more

Microsoft Excel is one of the most popular computer applications in offices over the last 20 years. For years people have struggled with compatibility issues between Microsoft and Apple Mac OS. This is slowly changing, Microsoft Office 365 has brought the two operating systems closer, its now easier than ever to collaborate with other users, its easier than ever to create a file on a Window PC and edit it on your favourite MacBook.

Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about it than you actually do. This course is designed from the bottom up, focusing on the most important elements of Microsoft Excel to give you the skills and confidence to perform everyday spreadsheet tasks in the average office.

Have you used Excel before and now have moved over to Apple Mac OS, we will look at the main differences in the two versions and also show some useful tips so that you can become a competent Microsoft Excel user

Enroll now

What's inside

Learning objectives

  • Use microsoft excel 2016 for mac with confidence in an office environment.
  • Learn how to use the most common excel formulas and functions to carry out day to day spreadsheet tasks.
  • Produce excel spreadsheets to the highest standard
  • Use formulas and functions to carry out tasks
  • Give them the tools to be able to tackle more complex formulas

Syllabus

Introduction

An Introduction to the course, A quick introduction to me just so you can see the type of things to expect from the course.

Read more
At the end of this section you will be able to successfully navigate around the Excel 2013 application

In the first of our sections, we will look at the layout the Excel . We will take a tour of the Excel Program, highlighting all the main places of interest.

We will look at the most important parts of the program to make sure you can navigate it with ease.

In this section we will look at the different ways that we can create a spreadsheet, either from the default "blank" template, or from one of Microsofts pre prepared templates.

In this section we will look at saving spreadsheets, we will look at the process of saving a spreadsheet in the default manor, and also saving spreadsheets in different file types.

We will also talk about the reasons for saving in different file types.

At the end of this section you will understand the make up of a cell and how to work with them.

In this section we will look at the cells that make up an Excel Spreadsheet. We will look at the way we can manipulate cells.

We will look at selecting cells and the different types of information that we can enter into cells.

In this section we will look at searching spreadsheet files to find data and we will also look at replacing data with new content.

We will look at the ways that we can sort data in a spreadsheet. We will look at sorting lists and the different methods that we can use.

We will look at filtering data in a spreadsheet. We will look at the ways we can use filtering to get a better view of only the elements that you wish to see.

In this section we will look at cutting and copying content and pasting it into another area in the same spreadsheet or into a totally different spreadsheet.

We will also look at deleting cell content from cells.

At the end of this section you will be able to customise and personalise worksheets. You will be able to manipulate worksheets to show the most important data.

In this section we will look at the ways we can interact with rows and columns.

We will look at selecting rows and columns, both adjacent and non adjacent.

We will look at inserting and deleting rows and columns and modify the Heights of rows and the widths of columns.

We will also look at freezing and unfreezing columns and rows and the reasons for doing so.

In this section we will look at the way we can use different worksheets in the Microsoft Excel program.

We will look at adding and deleting worksheets, Renaming worksheets.

We will also have a look at moving and copying entire worksheets.

We will also look at giving the worksheet tabs a colour, so that they can be quickly identified.

At the end of this section you will be able to use the most common Excel formulas and functions to create spreadsheets that do the hard work for you.

in this section we will look at creating formulas using cell references and arithmetic operators (addition,subtraction, multiplication, division).

We will look at the good practices that can be used in order to achieve the best results.

Choose the Correct option

In this section we will look at using the auto fill option in Excel, we will look at the situations that you will use it and the way it can be used.

In this section we will look at absolute cell referencing, the process of setting up your formulas and functions to get the best result with minimum effort.

In this section we will look at some of the most common functions that can be used in spreadsheets.

We will look at the SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and ROUND Functions.

In this section we will look at the IF statement and the way it can be used to determine a true or false outcome.

At the end of this section you will be able to format your spreadsheet content so that is is easier to view

In this section we will look at the different types of formatting that we can apply to cells in our Microsoft Excel spreadsheet.

We will look at formatting cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.

We will also look at formatting cells to display a date style, to display a currency symbol and to display numbers as percentages.

In this section we will look at changing the cell content appearance like font sizes and font types.

We will also look at applying formatting to cell contents like bold, italic, underline, double underline.

We will apply different colours to cell content, cell background.

We will look at copying the formatting from a cell and placing it on another cell so that we can keep formatting uniform.

At the end of this section you will be able to create and edit charts to illustrate data in a graphical form

In this section we will cover charts, will look at creating a chart from spreadsheet data. We will create different types of charts like bar chart, column charts and lie charts.

We will look at selecting the charts, moving and resizing a chart, we will also delete a chart.

Another aspect we will do is the option to change the type of chart we are using, i.e from column to bar chart.

This section will cover adding, removing and editing a chart title.

We will add data labels to a chart so that we can see exact values/numbers or percentages.

We will look at changing the chart area background colour and also the colours that make up the "bars" in the charts and change the colour of text used within the chart.

At the end of this section you will be able to prepare your spreadsheet file for output.

In this section we will look at the following:

  • Change worksheet margins: top, bottom, left, right.
  • Change worksheet orientation: portrait, landscape. Change paper size.
  • Adjust page setup to fit worksheet contents on a specified number of pages.
  • Add, edit, delete text in headers, footers in a worksheet.
  • Print Titles on each page
  • Print Gridlines

In this last section we will look at printing our finished spreadsheet. we will look at :

Previewing a worksheet and then printing a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, we will also look at printing the entire spreadsheet and a chart.

The objective of this section is to practice everything that has been learned in the previous sections.
Practice Part one
Practice Part two

This lecture offers discounts to the other courses that I have.

This section will look at conditional formatting, we will look at all the different elements involved in conditional formatting

This lecture will look at the basics of conditional formatting

We will look at the process involved in creating rules for conditional formatting

In this lecture we will look at clearing formatting from cells and sheets.

In this lecture will will look at how to use Microsoft Excel for Mac to use conditional formatting with dates

In this lecture we will look at how to use data bars in Microsoft Excel for Mac

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Suitable for complete beginners looking to gain a foundational understanding of Microsoft Excel
Specifically designed to help users transition from Windows to Mac OS, addressing potential compatibility issues
Structured with a practical focus on performing common spreadsheet tasks in a professional office setting
Covers essential Excel functions such as formulas, sorting, filtering, and data manipulation
Includes guidance on formatting spreadsheets for clarity and visual appeal
Offers insights into advanced features such as conditional formatting, facilitating data analysis and visualization

Save this course

Save Microsoft Excel for Mac - Office 365 on Mac OS to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel for Mac - Office 365 on Mac OS with these activities:
Read 'Excel for Mac: The Missing Manual' by David Pogue
Expand your knowledge of Excel for Mac with this comprehensive guide.
Show steps
  • Purchase or borrow the book
  • Read the book
  • Take notes and highlight important concepts
  • Refer to the book as needed while working on your Excel projects
Join a study group
Join or lead a study group to connect, collaborate, and support a supportive learning environment.
Show steps
  • Find a few classmates who are also taking this course
  • Meet up regularly to discuss the material, work on assignments together, and quiz each other
  • Share your notes and resources with each other
  • Help each other out when you're struggling with a concept
  • Celebrate your successes together
Practice sorting data
Sort data to quickly organize and find patterns in your data.
Browse courses on Sorting
Show steps
  • Select the data you want to sort
  • Click the Data tab
  • Click the Sort button
  • Select the column you want to sort by
  • Select the order you want to sort by
  • Click OK
Six other activities
Expand to see all activities and additional details
Show all nine activities
Watch a tutorial on using conditional formatting
Learn how to use conditional formatting to visually highlight important data in your spreadsheets.
Browse courses on Conditional Formatting
Show steps
  • Search for a tutorial on using conditional formatting in Microsoft Excel for Mac
  • Watch the tutorial
  • Follow the steps in the tutorial to create a conditional formatting rule
Practice typing formulas
Practice creating formulas so that you can use them with confidence.
Show steps
  • Navigate to any cell in a spreadsheet
  • Type in =
  • Enter the cell you want to reference, either by using the keyboard or mouse
  • Type your mathematical operation, e.g. +
  • Enter the next cell you want to reference
  • Hit Enter to see your result
Practice creating and using filters
Filter data to narrow your focus and quickly find the information you need.
Show steps
  • Select the data you want to filter
  • Click the Data tab
  • Click the Filter button
  • Uncheck the boxes for the values you want to filter out
  • Click OK
Create a chart from scratch
Create a visual representation of data to make it easier to interpret.
Show steps
  • Select the data you want to chart
  • Click the Insert tab
  • Click the Charts button
  • Select the type of chart you want to create
  • Click OK
Attend a workshop on Excel for Mac
Master essential and advanced Excel for Mac skills with hands-on guided instruction.
Show steps
  • Find a workshop on Excel for Mac that fits your schedule and learning goals
  • Register for the workshop
  • Attend the workshop and participate actively
  • Take notes and ask questions
  • Practice what you learn in the workshop
Create a budget using Excel for Mac
Put your Excel skills to the test by creating a practical and personalized budget.
Show steps
  • Gather your financial information
  • Open Excel for Mac
  • Create a new spreadsheet
  • Set up your budget categories
  • Enter your income and expenses
  • Format your spreadsheet
  • Save your budget

Career center

Learners who complete Microsoft Excel for Mac - Office 365 on Mac OS will develop knowledge and skills that may be useful to these careers:
Financial Analyst
Financial Analysts use their knowledge of finance and economics to analyze financial data and make investment recommendations. They work in a variety of industries, including banking, investment management, and insurance. This course on Microsoft Excel for Mac is a great way to develop the skills you need to succeed as a Financial Analyst. You'll learn how to use Excel to build financial models, perform financial analysis, and create presentations. This course will also teach you how to use Excel to automate tasks and collaborate with others. With its focus on the latest features, this course is a great way to stay ahead of the curve in the competitive field of financial analysis.
Data Analyst
Data Analysts use their knowledge of data, statistics, and programming to analyze large datasets and extract meaningful insights. They work in a variety of industries, including finance, healthcare, and retail. This course on Microsoft Excel for Mac is a great way to develop the skills you need to succeed as a Data Analyst. You'll learn how to use Excel to clean and organize data, perform statistical analysis, and create visualizations. This course will also teach you how to use Excel to automate tasks and collaborate with others. With its focus on the latest features, this course is a great way to stay ahead of the curve in the competitive field of data analysis.
Business Analyst
Business Analysts use their knowledge of business and technology to analyze business processes and make recommendations for improvement. They work in a variety of industries, including consulting, healthcare, and manufacturing. This course on Microsoft Excel for Mac is a great way to develop the skills you need to succeed as a Business Analyst. You'll learn how to use Excel to analyze data, create visualizations, and build models. This course will also teach you how to use Excel to automate tasks and collaborate with others. With its focus on the latest features, this course is a great way to stay ahead of the curve in the competitive field of business analysis.
Operations Manager
Operations Managers oversee the day-to-day operations of a business. They work in a variety of industries, including manufacturing, retail, and healthcare. This course on Microsoft Excel for Mac is a great way to develop the skills you need to succeed as an Operations Manager. You'll learn how to use Excel to track inventory, manage customer orders, and schedule employees. This course will also teach you how to use Excel to automate tasks and collaborate with others. With its focus on the latest features, this course is a great way to stay ahead of the curve in the competitive field of operations management.
Project Manager
Project Managers plan, execute, and close projects. They work in a variety of industries, including construction, engineering, and software development. This course on Microsoft Excel for Mac is a great way to develop the skills you need to succeed as a Project Manager. You'll learn how to use Excel to create project plans, track progress, and manage resources. This course will also teach you how to use Excel to automate tasks and collaborate with others. With its focus on the latest features, this course is a great way to stay ahead of the curve in the competitive field of project management.
Data Scientist
Data Scientists use their knowledge of data, statistics, and machine learning to build models that can predict outcomes. They work in a variety of industries, including finance, healthcare, and retail. This course on Microsoft Excel for Mac may be useful for aspiring Data Scientists. You'll learn how to use Excel to clean and organize data, perform statistical analysis, and create visualizations. This course will also teach you how to use Excel to automate tasks and collaborate with others.
Software Engineer
Software Engineers design, develop, and maintain software applications. They work in a variety of industries, including technology, finance, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Software Engineers. You'll learn how to use Excel to create prototypes, track bugs, and manage projects.
Web Developer
Web Developers design and develop websites. They work in a variety of industries, including technology, marketing, and education. This course on Microsoft Excel for Mac may be useful for aspiring Web Developers. You'll learn how to use Excel to create prototypes, track bugs, and manage projects.
Account Manager
Account Managers manage relationships with key customers. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Account Managers. You'll learn how to use Excel to track customer interactions, identify opportunities, and develop sales strategies.
Sales Manager
Sales Managers oversee the sales team and develop sales strategies. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Sales Managers. You'll learn how to use Excel to track sales, manage customer relationships, and forecast revenue.
Product Manager
Product Managers oversee the development and launch of new products. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Product Managers. You'll learn how to use Excel to create product roadmaps, track progress, and manage budgets.
Consultant
Consultants provide advice and expertise to businesses. They work in a variety of industries, including technology, management, and finance. This course on Microsoft Excel for Mac may be useful for aspiring Consultants. You'll learn how to use Excel to analyze data, create presentations, and develop business plans.
Business Development Manager
Business Development Managers identify and develop new business opportunities. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Business Development Managers. You'll learn how to use Excel to create business plans, track progress, and manage budgets.
Customer Success Manager
Customer Success Managers ensure that customers are satisfied with their products or services. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Customer Success Managers. You'll learn how to use Excel to track customer satisfaction, identify trends, and develop retention strategies.
Marketing Manager
Marketing Managers plan and execute marketing campaigns. They work in a variety of industries, including technology, consumer goods, and healthcare. This course on Microsoft Excel for Mac may be useful for aspiring Marketing Managers. You'll learn how to use Excel to create marketing plans, track results, and manage budgets.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Microsoft Excel for Mac - Office 365 on Mac OS.
Great resource for learning how to use formulas and functions in Microsoft Excel 2016 for Mac. It covers all the most common functions, from basic arithmetic to complex financial functions.
Will teach you how to use Excel to analyze data and make informed decisions. It covers topics such as data cleaning, data analysis, and data visualization.
Will teach you how to use VBA (Visual Basic for Applications) to automate tasks in Microsoft Excel 2016 for Mac. VBA powerful programming language that can be used to create custom functions, macros, and add-ins.
Will teach you how to use VBA (Visual Basic for Applications) to automate tasks in Microsoft Excel 2016 for Mac. VBA powerful programming language that can be used to create custom functions, macros, and add-ins.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Microsoft Excel for Mac - Office 365 on Mac OS.
Mastering the Mac
Most relevant
Microsoft Copilot Masterclass - Microsoft 365 Copilot...
Most relevant
Mac OS X Command Line: Beyond the Basics
Most relevant
Copilot for Microsoft 365 Apps (Microsoft Office)
Most relevant
Excel 365 Essentials
Most relevant
Introduction to Microsoft Office Open XML
Most relevant
Microsoft Excel: Data Visualization, Excel Charts & Graphs
Most relevant
Create a Project Management Tracker using Microsoft Excel
Most relevant
Microsoft 365 Security Management Fundamentals
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser