Free Online Excel Training For Mac

Free Excel Training for Excel 2019 and Excel for Office 365 Online: Introduction

I, like most people, have some experience with Microsoft Excel — but not as much as I wish I did. Their training center for Excel has a whole bunch of free tutorials, videos, and guides on Windows, Mac OS, Android, iOS, and Windows Phone. Mar 19, 2018  Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are.

The following link is to our free Excel training playlist on YouTube for Excel 2019 and Excel for Office 365: Excel Training Tutorial: A Complete Excel 2019 and 365 Training. The videos in this free Excel training playlist come from our premier Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” However, our free Excel Training for Excel 2019 and Excel for Office 265 on YouTube only contains the premier course’s video lessons. Alternatively, our full Excel tutorial is also available for purchase online if you want a more complete Microsoft Excel training.

Both our free Excel training and our premier Excel training contain 211 video lessons. These video lessons show you how to use Microsoft Excel. However, the premier version also includes a PDF instruction manual with additional images and practice exercises. It also includes chapter reviews and a final exam. Upon passing the final exam, you can also receive a certificate of completion for the course.

Free Excel Training for Excel 2019 and Excel for Office 365 Online: A picture of the interface for the DVD or digital download versions of the “Mastering Excel Made Easy v.2019 and 365” tutorial, on which our free Excel training is based.

Free Excel Training for Excel 2019 and Excel for Office 365 Online: Additional Resources

Microsoft Excel– This is a link to Microsoft Excel on the Microsoft web site. You can purchase the software directly from Microsoft at this link.

Mastering Excel Made Easy– This is a link to our complete Microsoft Excel training. You can purchase it as online learning, on DVD, or as a digital download, directly from TeachUcomp, Inc.

Mastering Excel Made Easy for Lawyers– This is an enhanced version of the “Mastering Excel Made Easy” training, with material specifically tailored for using Microsoft Excel by legal professionals.

Microsoft Excel 2019 Introductory Quick Reference Card– Designed with the busy professional in mind, this 4-page laminated quick reference guide provides step-by-step instructions in Excel 2019. It provides quick instructions right at your fingertips. Durable and easy-to-use, quick reference cards are perfect for individuals, businesses, and as supplemental training materials.

Mastering Excel Made Easy- Manual Only (Download)– These are the PDF manuals for the complete “Mastering Excel Made Easy v.2019 and 365” course. These are a perfect addition if you wish to watch the free Excel training for Excel 2019 and Excel for Office 365 on YouTube.

Download - Mella – Minimalist eCommerce Magento 2 Theme Download this file @ Usenet.nl ( mella-minimalist-ecommerce-magento-2-theme.zip) blog business clean corporate creative ecommerce fashion Magento2 Mella minimalist modern photography portfolio responsive. Mella magento 2 demo download free. Free Download Mella – Minimalist eCommerce Magento 2 Theme (Nulled) Latest Version Download & Demo Links Kindly Note: We update new con. Mella – Minimalist eCommerce Magento 2 Theme. Home Web Themes & Templates Mella – Minimalist eCommerce Magento 2 Theme. PixelHand, January 27, 2019 January 27, 2019, 0. Magento 2 Demo is the live demo site that brings the real experience on Mageplaza extensions instead of installing Magento 2 on localhost. Magento 2 Demo with sample data allows you interacting as a customer in the frontend and working as an admin in the backend. Using the online Magento 2 Admin Demo is the perfect solution that helps you enjoy all ulities of Magento 2 without any installation. Magento 1 to Magento 2 Migration Tools. We’ve developed migration tools to assist you with moving from Magento 1 to Magento 2. The Magento 2 Data Migration Tool helps you efficiently port all of your key product, customer, and order data, store configurations, promotions and more to from Magento 1 to Magento 2. To learn more about it, see the Data Migration Guide.

What you can read next

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.

• 720p
• 540p
• 360p

Certificate

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

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.

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.