Course: Excel Office 365 (Windows) for End users

$149.00
$180.29 incl. vat
ADD_TO_CART_INFO_FOR_BUSINESS

duration: 23 hours |

Language: English (US) |

access duration: 180 days |

In Onbeperkt Leren

Details

Microsoft Excel from the Office 365 suite is the newest version of Excel. This course is therefore intended for everyone who wants to know more about Microsoft Office 365 Excel. We handle all functionalities of data management and design. Finally, we will take you along in functions such as creating graphs and tables and creating formulas.

Result

After successful completion of the training you are familiar with the functionalities of Excel Office 365.

Please note: chapter 10 is missing.

Prerequisites

No specific prior knowledge is required


Target audience

System Administrator, End users

Content

Excel Office 365 (Windows) for End users

23 hours

Excel Office 365 (Windows): Getting Started

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

Excel Office 365 (Windows): Creating & Saving Workbooks

Excel Office 365 (Windows): Creating & Saving Workbooks

Excel Office 365 (Windows): Inserting & Manipulating Data

Excel 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 Office 365 (Windows): 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 to change the presentation of your data.

Excel Office 365 (Windows): Illustrating Documents

An Excel for Office 365 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 Office 365 (Windows): Basic Formulas

The power of Excel Office 365 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 Office 365 (Windows): Sharing & Collaborating on a Document

Excel for Office 365 enables you to easily share your documents via email or upload them to OneDrive and SharePoint to collaborate with your team. This version of Excel also comes with a chat feature to communicate with others in real-time.

Excel Office 365: Finding & Grouping Data

Excel for Office 365 includes a number of methods for locating, displaying and manipulating data entries. Learn how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools.

Excel Office 365: Sorting & Filtering Data

Excel Office 365: Sorting & Filtering Data

Excel Office 365: 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 for Office 365.

Excel Office 365: 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 for Office 365.

Excel Office 365: Creating Charts & Graphics

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

Excel Office 365: 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 Office 365: 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 Office 365: 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 Office 365: 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 Office 365: 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 Office 365: 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 Office 365: 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 Office 365: Getting to Know Macros in Excel

If you have tasks in Excel Office 365 that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. 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. Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. Once enabled, you'll be able to locate the VBA Editor as well as other key tools for managing macros in Excel.

Excel Office 365: 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 Office 365: Creating & Editing Macros

In Excel for Office 365 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 Office 365: 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 for Office 365 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