Course: Microsoft Excel 2016 for Windows fundamentals

$149.00
$180.29 incl. vat

ADD_TO_CART_INFO_FOR_BUSINESS

duration: 25 hours |

Language: English (US) |

access duration: 90 days |

Details

Make yourself an expert and show that you understand and master Microsoft Excel 2016 functionalities.

In this training, you will become acquainted with the basic principles and benefits of Microsoft Excel 2016. You learn how to best manage and protect documents. You will also learn more about data management and how to shape it. Finally, various topics are discussed in the training such as; set up a calculation model, various layout styles, use of tables, graphics, and prints.

Result

After successful completion of the training

  • You can add, edit and analyze data in spreadsheets.
  • You can use tables and graphs to display your data.
  • You are familair with practical tips for using Excel 2016.

Prerequisites

No specific prior knowledge is required.


Target audience

System Administrator, End users

Content

Microsoft Excel 2016 for Windows fundamentals

25 hours

Excel 2016: Getting Started

Excel 2016 is the spreadsheet application in the Microsoft Office 2016 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.

Excel 2016: Creating, Saving & Sharing Workbooks

Excel 2016 is highly customizable and easy to share with others. Learn how to create, manage, and save documents; insert headers and footers; edit document properties; and protect and share your workbooks.

Excel 2016: Inserting & Manipulating Data

Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.

Excel 2016: Formatting Data

Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2016 to change data presentation.

Excel 2016: Custom & Conditional Formatting

To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

Excel 2016: Finding, Sorting & Filtering Data

Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

Excel 2016: Working with Formulas

In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.

Excel 2016: Illustrating Documents

An Excel 2016 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes; insert hyperlinks; and use the new Smart Lookup feature.

Excel 2016: Referencing Data

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.

Excel 2016: Basic Formulas

The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

Excel 2016: Creating Charts & Graphics

Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

Excel 2016: Creating PivotTables & PivotCharts

Excel 2016 includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables and PivotCharts; use calculations; sort, filter, and group data; and work with a slicer.

Excel 2016: Using the Power View Add-in

You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.

Excel 2016: Using the Power Pivot Add-in

You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.

Excel 2016: Using Conditional Formulas

In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

Excel 2016: Extracting Information with Formulas

Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

Excel 2016: Configuring Options & Settings

Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins

Excel 2016: Using Excel 2016 with Office 365

  • If you or your organization has a qualifying Office 365
  • subscription, you can use it to install Excel 2016 and get the
  • latest software updates released by Microsoft. Recent updates
  • available to Office 365 subscribers using Excel 2016 include
  • streamlined document management, annotation, and share interfaces,
  • additional PivotTable configuration tools, and icon insertion
  • capabilities.

Microsoft Excel 2016 for Windows: Creating Tours with 3D Maps

Microsoft Excel 2016 for Windows: Creating Tours with 3D Maps

Microsoft Excel 2016 for Windows: Working with Data in 3D Maps

Knowing how to bring in data and map it to your 3D Maps tours is key to getting the most out of your data. Learn how to use data from multiple tables, add layers, timestamps, and filters to better understand your tours, and how to customize the information on display.

Course options

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 deelname 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.

read more about the order process

What is included?

Certificate of participation Yes
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes
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.
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