Course: Excel 2019 for Windows

$139.00
$168.19 incl. vat
ADD_TO_CART_INFO_FOR_BUSINESS

duration: 23 hours |

Language: English (US) |

access duration: 180 days |

In Onbeperkt Leren

Details

New the Excel 2019 for Windows. Excel 2019 is the new spreadsheet of the Microsoft Office 2019 suite.

Discover the new interface and functions, learn the way of developing new workbooks and how manipulating data and formatting data.

Learn more about adding and adjusting images, hyperlinks and the new Smart lookup function, using the basic formulas and the easy way to share documents by email or how you can upload them within OneDrive and Sharepoint.

Result

After completing this course you are familiar with the new functions of Excel 2019 for Windows.

Prerequisites

There is no specific knowledge required.

Target audience

Office users

Content

Excel 2019 for Windows

23 hours

Excel 2019 for Windows: Getting Started

Excel 2019 is the spreadsheet

Excel 2019 for Windows: Creating & Saving Workbooks

In Excel 2019, it

Excel 2019 for Windows: Inserting & Manipulating Data

Excel contains a number of features

Excel 2019 for Windows: Formatting Data

Formatting data makes it easier to

Excel 2019 for Windows: Illustrating Documents

An Excel 2019 worksheet can contain

Excel 2019 for Windows: Using Basic Formulas

The power of Excel 2019 is the

Excel 2019 for Windows: Sharing & Collaborating on a Document

Excel 2019 enables you to easily

Excel 2019: Custom & Conditional Formatting

To customize data, you can use the built-in formats in Excel 2019, 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 2019: Finding & Grouping Data

Excel 2019 includes a number of

Excel 2019: Sorting & Filtering Data

  • The first step in analyzing the data in a worksheet is often

  • with Excel's sorting and filtering tools. These tools help you to
  • control what is displayed in your data range, and how the values
  • are organized. See how to perform basic and more advanced sort
  • operations, filter data using the Filter and column header tools,
  • and manage color-tagged and duplicate entries.

Excel 2019: 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, and formula auditing in Excel 2019.

Excel 2019: Forecasting & Solving Problems

Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel 2019.

Excel 2019: Creating Charts & Graphics

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

Excel 2019: Working with Different Chart Styles

Excel offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts.

Excel 2019: Working with Excel Tables

Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data as well as change its appearance and formatting.

Excel 2019: Inserting PivotTables

Excel includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables, sort, filter, and group data, and work with slicers and timelines.

Excel 2019: Working with Data in PivotTables

Once your Excel PivotTables have been created you'll need to know how to manage and work with the data contained within. See how to analyze, calculate, collaborate and more with Excel PivotTables.

Excel 2019: Using Conditional Formulas

Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

Excel 2019: Finding & Analyzing Information with Formulas

There is a wide variety of tools that can be used to retrieve, return, and calculate data in Excel. See how to retrieve date information and rank values, retrieve, combine and separate data that is already available, and automate and simplify calculations using look-up tools and SUMPRODUCT.

Excel 2019: Configuring Options & Settings

Get more out of Excel by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar.

Excel 2019: Managing Data

Excel offers a set of tools that allows you explore more in detail data analysis and complex formulae. If you need to work with data from other sources, you can import and edit data from a text and a .csv file.

In this course you'll see how to use different formulae to make calculations when you have multiple conditions imposed. You'll also be able to forecast data using the NPER function.

With complex formulae you can run calculations to discover the average numbers or the smallest or largest values depending on a settle of conditions, for example.

Excel 2019 for Windows: Getting to Know Macros in Excel

  • If you have tasks in Excel 2019 that you do repeatedly, you can

  • record a macro to automate those tasks. When you create a macro,
  • you are recording your mouse clicks and keystrokes. After you
  • create a macro, you can edit it to make minor changes to the way it
  • works. Key concepts covered in this 10-video course include how to
  • record macros and perform actions that can be implemented in Excel
  • workbooks, how to save a workbook with macros and an Excel
  • macro-enabled workbook, how to find and use macro tools that are
  • available in multiple locations, and how to add macro recording to
  • your status bar for easy access. Then learn how to navigate the VBA
  • Editor interface, an application easily accessible via Excel, to
  • manage your macros and workbook VBA code; how to manage macros,
  • edit macros, and enable macros in a workbook; and how to access
  • macro security settings and manage macro security options. Finally,
  • you will observe how to use macros across multiple workbooks.

Excel 2019 for Windows: Creating & Editing Macros

In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.

In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

Excel 2019 for Windows: Working with Macros in Excel

If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users.

Excel 2019 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others.

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