Course: Microsoft Excel 2016 for Mac

$149.00
$180.29 incl. vat

duration: 14 hours |

Language: English (US) |

access duration: 90 days

In this online Excel for Mac course you will learn the new features of Excel 2016 for Mac. This course has different subjects and contains a lot of basic functionalities of Excel 2016. You will learn how to open the application, how to make new spreadsheets and how to insert data (manual and automatic).

Other topics this course covers are modifying standard data, to navigate between documents, workbooks, transfer data, modify sheets, use of basic formulas, basic functions, use of graphs, how to save, send and print Excel documents and a far more.

Result

After successful completion of this course you are able to use the basics of Excel 2016 for Mac

Prerequisites

No specific knowledge is required.

Target audience

Office users

Microsoft Excel 2016 for Mac

14 hours

Microsoft Excel 2016 for Mac: Opening and Setting Up Excel

Course_Description=<p>Get started with Excel 2016 for Mac, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.</p> TargetAudience= Duration=00:21

Microsoft Excel 2016 for Mac: Creating, Saving, and Sharing Workbooks

Course_Description=<p>There are numerous ways to set up a document in Excel. Discover how to create, save, print, and manage documents; edit document properties; work with the protection settings; and share documents via email and OneDrive.</p> TargetAudience= Duration=01:08

Microsoft Excel 2016 for Mac: Manipulating Data

Course_Description=<p>It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.</p> TargetAudience= Duration=00:56

Microsoft Excel 2016 for Mac: Formatting Data

You can make your data more meaningful by changing its appearance in the spreadsheet. Learn how to set the data type, format your data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.

Microsoft Excel 2016 for Mac: Custom and Conditional Formatting

In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.

Microsoft Excel 2016 for Mac: Illustrating Documents

Course_Description=<p>There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, and diagrams; insert a hyperlink; and use the Smart Lookup tool.</p> TargetAudience= Duration=00:24

Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data

Course_Description=<p>In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.</p> TargetAudience= Duration=00:29

Microsoft Excel 2016 for Mac: Referencing Data

Course_Description=<p>To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.</p> TargetAudience= Duration=00:33

Microsoft Excel 2016 for Mac: Basic Formulas

Course_Description=<p>The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.</p> TargetAudience= Duration=00:56

Microsoft Excel 2016 for Mac: Working with Formulas

Course_Description=<p>Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, use the Goal Seek and Solver tools, and handle duplicate values in your spreadsheet.</p> TargetAudience= Duration=00:26

Microsoft Excel 2016 for Mac: Charts and Graphs

Using charts is an effective way to present data in your Excel spreadsheet. Learn how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.

Microsoft Excel 2016 for Mac: Pivot Tables

A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.

Microsoft Excel 2016 for Mac: Extracting Information with Formulas

Course_Description=<p>Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.</p> TargetAudience= Duration=00:43

Microsoft Excel 2016 for Mac: Configuring Excel

Excel 2016 for Mac is a highly customizable application. Learn how to customize the interface, view settings, input options, ribbon, and Quick Access toolbar, and how to install and manage add-ins.

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

frequently asked quesions

What is included?

Duration 14 hours
Language English (US)
Certificate of participation Yes
Online access 90 days
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes

Also included in world's #1 eLearning portal

Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Platform Access to our platform.
Service World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact