Course: Excel Office 365 (Windows) for End users
duration: 23 hours |
Language: English (US) |
access duration: 180 days |
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.
After successful completion of the training you are familiar with the functionalities of Excel Office 365.
Please note: chapter 10 is missing.
No specific prior knowledge is required
System Administrator, End users
Excel Office 365 (Windows) for End users
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: 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.
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 immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
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
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.
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
|Certificate of participation
|Award Winning E-learning
|Unlimited access to our IT professionals community
|Our consultants are here for you to advice about your study career and options
|Certified teachers with in depth knowledge about the subject.
|World's best service
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.