Return to site

Excel For Mac Tutorial

broken image


Award-winning instructors

  • Excel for Mac Training and Tutorials Learn how to use Excel for Mac. Tutorials range from beginner to advanced, covering a wide range of topics, including how to create Excel formulas, understand Excel functions, create an Excel spreadsheet or pivot table, and more. Start My Free Month.
  • This tutorial is for Excel 2011 for Macs. Go to this page for the Excel 2010 PC tutorials. Want to use the same data as the tutorial? Some of the exercises use data from the New York City Census Tracts. To follow along with this tutorial.

Free Mac guides and tutorials. Learn how to use your Mac today. Welcome to MacForBeginners. Our guides, articles and tutorials will help you become a better and more confident Mac user. All our articles are free. Show all articles. Or, get started by reading our Mac OS X Introduction.

Get certified

Mobile (learn on-the-go)

Regularly updated content

New to Excel or need a refresher? This online course is designed to give you a solid foundation in the basics of Excel for Mac.
Supports Excel for Mac 2016. Also available: Excel Basic (PC).

In 24 engaging lessons you will learn how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. How to reformat external hard drive mac.

Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Excel Ninja! Learn more about how a GoSkills Excel certification can boost your career.

Video tutorials are recorded in Microsoft Excel for Mac 2016. https://aupygr.over-blog.com/2020/12/bloom-1-0-467-download-free.html.

What os does apple use. Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

Focus video player for keyboard shortcutsAuto
  • 720p
  • 540p
  • 360p
cc

Certificate

Yes (learn more)

Accredited by

CPD

Video duration

2h 08m

The Ribbon

Identify the terminology and elements of the Ribbon.

Free Excel Mac Tutorials For Beginners

The Work Surface

Recognize the main terms used to describe Excel's work canvas.

Navigation

Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.

First File

Create your first Excel file, enter data and create a table.

Formatting

Format cells by selecting fonts and color fills to make information more attractive. https://herehfil562.weebly.com/my-alarm-clock-1-7-download-free.html.

Basic Math

Utilize basic mathematics including multiplication and division in Excel.

Formula Anatomy

Understanding Excel Formula Anatomy.

Cell Referencing

Learn about working with absolute and relative cell referencing, and techniques for copying formulas.

Function Anatomy

Use to understand the anatomy of Excel functions, and what their components mean. Anydesk com mac.

Math Functions

Learn basic math functions including SUM, ROUND and SUBTOTAL.

Basic Statistics

Excel For Mac Tutorial

Learn basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.

Logic Functions

Learn to build standalone logical IF functions, and make them more complex by nesting AND and OR within them.

Text Functions

Learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character.

Conditional Math

Learn to use SUMIF, COUNTIF and SUMPRODUCT to add cells only when certain conditions are met.

External Links

Excel For Mac Tutorial

Learn about creating and updating external links, and about the potential dangers of external links in Excel.

Sorting

Learn to sort data in Excel by a single column or by multiple columns.

Filtering

Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table. Autocad inventor mac student.

Contiguous Data

Learn tricks for consolidating your data so it's vertically contiguous (without blank rows) – for Tables, PivotTables and Charts.

Cell Formatting

Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells.

Building Column Charts

Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages.

Building Bar Charts

How to create an effective bar chart by reducing ink and noise that distract from the story.

Building Pie Charts

Learn how to build an effective pie chart, and when you should and shouldn't use them.

Building Line Charts

How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability.

For

Learn basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.

Logic Functions

Learn to build standalone logical IF functions, and make them more complex by nesting AND and OR within them.

Text Functions

Learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character.

Conditional Math

Learn to use SUMIF, COUNTIF and SUMPRODUCT to add cells only when certain conditions are met.

External Links

Excel For Mac Tutorial

Learn about creating and updating external links, and about the potential dangers of external links in Excel.

Sorting

Learn to sort data in Excel by a single column or by multiple columns.

Filtering

Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table. Autocad inventor mac student.

Contiguous Data

Learn tricks for consolidating your data so it's vertically contiguous (without blank rows) – for Tables, PivotTables and Charts.

Cell Formatting

Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells.

Building Column Charts

Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages.

Building Bar Charts

How to create an effective bar chart by reducing ink and noise that distract from the story.

Building Pie Charts

Learn how to build an effective pie chart, and when you should and shouldn't use them.

Building Line Charts

How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability.

Comments

Learn about creating, reviewing and printing Excel comments.

Lesson 27: Free Resources for Learning Office for Mac

Free Microsoft Excel For Mac Tutorial

/en/excel-tips/how-to-add-line-breaks-in-excel/content/

Free resources for learning Office for Mac

Our Microsoft Office tutorials are some of the most popular courses we offer. These tutorials, however, are designed for those using Office on computers with Microsoft Windows, so perhaps it's no surprise that we frequently hear from learners who want to know why we don't offer tutorials on Officefor Mac. While Office for Mac shares a lot of functionality with the Windows version, its interface and design are different enough that we would need to create entirely new courses.

With our small staff, it would be a real challenge to produce the same kind of detailed tutorials for the Mac-friendly Office we provide for the Windows version. We may consider adding some type of Office for Mac tutorial in the future, but for now we'd like to share a number of excellent—and mostly free!—resources that can help you learn how to use Office for Mac.

Office 2016 for Mac is very similar to the Windows version. So if you have Office 2016 for Mac, check out our Office 2016 tutorial.

Free Office for Mac tutorials

If you're using Office for Mac, the Office for Mac team has provided great series of tutorials and how-to guides to help you get started and even learn advanced skills:

  • If you're just getting started, check out the Office 2016 for Mac Quick Start Guides, which provide an overview of each Office for Mac product.
  • If you're looking for even more, the Office for Mac Blog and YouTube channel provide the latest news and step-by-step videos to guide you through.

If you're using an earlier version of Office for Mac, check out the video below from the Office for Mac team on the Word 2011 Interface.

Of course, you can also find help on the Microsoft Office for Mac Support page from the Office community and support team. If you need additional support, you might consider purchasing a subscription to Lynda.com to take advantage of its thorough Office for Mac Tutorial. It's not free, but it's still a great resource if you need to learn the software quickly.

What if I use an older version of Office for Mac?

If you use Office 2008 for Mac, you should be aware that Microsoft discontinued support for this version in 2013. While this doesn't mean the programs will stop working, it does mean it will be more difficult to get help from Microsoft if something goes wrong.

If you're thinking of upgrading to the latest version of Office for Mac, you may want to consider purchasing a subscription to Office 365 instead of buying the stand-alone Office for Mac 2011 suite. A subscription includes a copy of Office for Mac on up to five computers, and you'll be able to upgrade to the latest version of Office for Mac when it becomes available. You can check out our What is Office 365? lesson to learn more.

/en/excel-tips/understanding-regional-differences-in-excel/content/





broken image