Learning Excel on a Mac is different from learning Excel on a PC. Luckily, we’ve got you covered. We’ve put together this comprehensive Beginners Excel course, and it’s all recorded using Excel for Mac 2019. In this course, we assume you have zero Excel knowledge and help you grow your confidence with spreadsheets. If you’re brand new to Excel and you’re using the Mac version, then this course is certainly for you. This course uses Excel for Mac 2019, but much of it is still relevant if you’re using a different version. What You’ll Learn. To create, open and save new workbooks in Excel Mac. How Excel for Mac works. What is Microsoft Excel 2019 for Mac? At its core, Microsoft Excel is an application used to create and manage spreadsheets. The premise is simple, but Excel goes far beyond just entering numbers and labels into a grid system.
Latest Version:
Microsoft Excel 16.35 LATEST
Requirements:
macOS 10.13 High Sierra or later
Author / Product:
Microsoft Corporation / Microsoft Excel for Mac
Old Versions:
Filename:
Microsoft_Excel_16.35.20030802_Installer.pkg
Details:
Microsoft Excel for Mac 2020 full offline installer setup for Mac
Microsoft Excel for Mac is the world’s most famous and widely used spreadsheet editing application. Originally developed by the Microsoft in 1987, this software received numerous expansions of capabilities, making it the go-to source for spreadsheet editing, use of graphing tools, pivot tables, macro programming, and much more. Available today on all modern platforms, including Windows, MacOS, Android and iOS, today this app is used by hundreds of millions of people each day. Since 1990, Microsoft Excel for macOS can be found as a part of the Microsoft Office, a suite of document, presentation and email editing applications covering all usage scenarios needed in a modern collaborative working environment. It is very hard to quickly review software so powerful, versatile, ubiquitous, and genre-defining as MS Excel for Mac. Regarded as the gold standard for spreadsheet creation and analysis, MS Excel to this day outmatches all competition with its wide array of tools and powerful advanced features that satisfy the needs of everyone, from first-time spreadsheet users to largest corporations who are interested in analytics and integrated forecasting functions. Its versatility enables effortless integration into workflows for managing countless tasks, including but not limited to, document creation, budgeting, personal finance, tax record management, small business document management, student/research analysis, and extensive needs of government agencies, non-profit organizations and largest corporations on the planet. Even though it is filled to the brim with tools and services, the user interface of the MSExcel
is as intuitive as ever, providing easy access to every one of its functions via tabbed toolbars on the top of the window, right-click cell menus and powerful configuration tools in the main setting window. Longtime users will have no trouble adapting to the latest version of the app, only really needing to get accustomed to the newly introduced integration into the Office 365 online suite that enables effortless online collaboration and document sharing. Features and Highlights
Effortless Spreadsheet creation – Manage spreadsheets of all sizes, from personal or school documents to government databases.
Extensive toolset – Take advantage from most advanced toolset present in modern spreadsheet software, including advanced formulas, pivot tables, lookup formulas, charts, sorting & filtering data, conditional formatting, structural references, data explorer, data analysis, VBA, macros, automation and much more.
Analytics – Gain valuable insights from built-in analytics tools.
Audit Trail – Track changes in audit files using the integrated Review and Track Changes tools.
Advanced calculations – Take financial and data analysis to a whole new level.
Charting – Visualize data with a wide array of charts that can be exported to other apps from Office suite.
Multi-user collaboration – Office 365 integration enables all users of Excel to easily share their documents and collaborate.
Templates – Simplify document creation with powerful and customizable template offering.
Note: 5 days trial version. Also Available: Download Microsoft Excel for Windows
Award-winning instructors
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.
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.
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.
Auto
720p
540p
360p
cc
Certificate
Ms Excel For Mac
Yes (learn more)
Accredited by
CPD
Video duration
2h 08m
The Ribbon
Identify the terminology and elements of the Ribbon.
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.
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
Ms Excel For Mac Tutorial
Use to understand the anatomy of Excel functions, and what their components mean.
Math Functions
Learn basic math functions including SUM, ROUND and SUBTOTAL.
Basic Statistics
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
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.
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.