Item number: 125743894

TOSA Excel Course E-Learning

Item number: 125743894

TOSA Excel Course E-Learning

129,00 156,09 Incl. tax

Order this unique E-Learning course TOSA Excel online, 1 year 24/7 access to rich interactive videos and tests.

Brand:: Microsoft Excel

Discounts:

Buy 2 for €126,42 each and save 2%
Buy 3 for €125,13 each and save 3%
Buy 4 for €123,84 each and save 4%
Buy 5 for €122,55 each and save 5%
Buy 10 for €116,10 each and save 10%
Buy 25 for €109,65 each and save 15%
Buy 50 for €103,20 each and save 20%

Availability:: In stock

Delivery time:: Ordered before 5 p.m.! Start today.

Startdate:

Student name (Multiple students, we will contact you):

Student email address:

Certificaat:

Award Winning E-learning
Lowest price guarantee
Personalized service by our expert team
Pay safely online or by invoice
Order and start within 24 hours

TOSA Excel Course E-Learning

Order this unique E-Learning course TOSA Excel 2016 online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.

Acquire the skills needed to utilize Microsoft Excel in a work environment as you prepare for the TOSA
Excel 2016 and TOSA Excel 365 certification exams.

Course content

Excel 2016: Getting Started

Course: 20 Minutes

Inserting a chart in Excel 2016 for Windows
Labeling a chart in Excel 2016 for Windows
Formatting a chart in Excel 2016 for Windows
Customizing your charts in Excel 2016 for Windows
Customizing your chart axes in Excel 2016 for Windows
Creating a chart template in Excel 2016 for Windows
Presenting negative values in your chart in Excel 2016 for Windows
Creating a pie chart in Excel 2016 for Windows
Creating a scatter chart in Excel 2016 for Windows
Creating a bubble chart in Excel 2016 for Windows
Creating a radar chart in Excel 2016 for Windows
Combining two types of chart in Excel 2016 for Windows
Creating a comparative chart using symbols in Excel 2016 for Windows
Inserting trendlines in Excel 2016 for Windows
Customizing your trendlines in Excel 2016 for Windows

Excel 2016: Creating, Saving & Sharing Workbooks

Course: 1 Hour, 13 Minutes

Creating & opening a document with Excel 2016 (Windows)
Using document templates in Excel 2016 for Windows
Managing your worksheets in Excel 2016 for Windows
Saving a document in Excel 2016 (Windows)
Saving your document as a PDF in Excel 2016 for Windows
Returning to a previous version of your document in Excel 2016 for Windows
Inserting headers & footers in Excel 2016 for Windows
Setting your print area in Excel 2016 for Windows
Adjusting your print page layout in Excel 2016 for Windows
Printing your document in Excel 2016 for Windows
Checking for compatibility issues in Excel 2016 for Windows
Editing your document properties in Excel 2016 for Windows
Checking for personal information in your document in Excel 2016 for Windows
Creating an accessible document in Excel 2016 for Windows
Protecting your document in Excel 2016 for Windows
Sending your document via email in Excel 2016 for Windows
Sharing your document via OneDrive in Excel 2016 for Windows
Commenting on a document in Excel 2016 for Windows
Following & tracking document changes in Excel 2016 for Windows

Excel 2016: Inserting & Manipulating Data

Course: 1 Hour, 4 Minutes

Selecting cells
Inputting data
Inserting special characters
Editing multiple worksheets simultaneously
Deleting items in your spreadsheet
Undoing & redoing actions
Creating automatic data series
Using the Flash Fill feature
Inserting dropdown menus
Using the Spell Check tool
Configuring Spell Check & AutoCorrect options
Transferring data
Copying & pasting data
Moving data from one worksheet to another
Transposing a data range
Consolidating your data

Excel 2016: Formatting Data

Course: 52 Minutes

Setting your data type in Excel 2016 for Windows
Formatting your data in Excel 2016 for Windows
Aligning your data in Excel 2016 for Windows
Using colors in Excel 2016 for Windows
Changing your cell style in Excel 2016 for Windows
Using document themes in Excel 2016 for Windows
Using formulas to modify your text case in Excel 2016 for Windows
Creating a title in Excel 2016 for Windows
Formatting a title in Excel 2016 for Windows
Creating a table in Excel 2016 for Windows
Resizing columns & rows in Excel 2016 for Windows
Inserting columns & rows in Excel 2016 for Windows
Inserting borders in Excel 2016 for Windows
Transferring format styles in Excel 2016 for Windows

Excel 2016: Illustrating Documents

Course: 28 Minutes

Inserting an image in Excel 2016 for Windows
Inserting a screenshot in Excel 2016 for Windows
Editing an image in Excel 2016 for Windows
Inserting shapes in Excel 2016 for Windows
Inserting a hyperlink in Excel 2016 for Windows
Using Smart Lookup in Excel 2016 for Windows

Excel 2016: Basic Formulas

Course: 49 Minutes

Inserting a formula using the function library
Performing simple calculations
Using automated formulas in a table
Creating automated cumulative totals
Inserting subtotals
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Converting number types
Factorizing the results of a division
Creating random values

Excel 2016: Custom & Conditional Formatting

Course: 32 Minutes

Customizing your number formats in Excel 2016 for Windows
Customizing your text formats in Excel 2016 for Window
Customizing your date & time formats in Excel 2016 for Windows
Creating conditional custom formats in Excel 2016 for Windows
Using the conditional formatting tools in Excel 2016 for Windows
Using advanced conditional formatting in Excel 2016 for Windows
Applying color to the first new entry in a list in Excel 2016 for Windows

Excel 2016: Finding, Sorting & Filtering Data

Course: 46 Minutes

Using the Find tool in Excel 2016 for Windows
Using the Replace tool in Excel 2016 for Windows
Using the Find & Replace tools in a formula in Excel 2016 for Windows
Sorting your data in Excel 2016 for Windows
Filtering your data in Excel 2016 for Windows
Sorting & filtering using colors in Excel 2016 for Windows
Using slicers in tables in Excel 2016 for Windows
Using the advanced filter options in Excel 2016 for Windows
Hiding duplicate values in Excel 2016 for Windows
Freezing & unfreezing panes in Excel 2016 for Windows
Grouping items & creating an outline in Excel 2016 for Windows

Excel 2016: Referencing Data

Course: 47 Minutes

Referencing your cells in Excel 2016 for Windows
Using data across multiple worksheets in Excel 2016 for Windows
Choosing between absolute & relative cell references in Excel 2016 for Windows
Naming your data ranges in Excel 2016 for Windows
Performing calculations using constant values in Excel 2016 for Windows
Using cell references indirectly in Excel 2016 for Windows
Keeping an eye on your data in Excel 2016 for Windows
Activating automatic updates in Excel 2016 for Windows
Using formula auditing in Excel 2016 for Windows
Understanding formula errors in Excel 2016 for Windows

Excel 2016: Working with Formulas

Course: 40 Minutes

Calculating the interest on a loan in Excel 2016 for Windows
Simulating a loan in Excel 2016 for Windows
Reaching a target value in Excel 2016 for Windows
Solving a problem in Excel 2016 for Windows
Using the forecast tool in Excel 2016 for Windows
Creating automatic reports in Excel 2016 for Windows
Finding identical values in your spreadsheet in Excel 2016 for Windows
Finding duplicates in your document in Excel 2016 for Windows
Visualizing your duplicate values in Excel 2016 for Windows
Preventing duplicate values in Excel 2016 for Windows

Excel 2016: Creating Charts & Graphics

Course: 1 Hour, 7 Minutes

Inserting a chart in Excel 2016 for Windows
Labeling a chart in Excel 2016 for Windows
Formatting a chart in Excel 2016 for Windows
Customizing your charts in Excel 2016 for Windows
Customizing your chart axes in Excel 2016 for Windows
Creating a chart template in Excel 2016 for Windows
Presenting negative values in your chart in Excel 2016 for Windows
Creating a pie chart in Excel 2016 for Windows
Creating a scatter chart in Excel 2016 for Windows
Creating a bubble chart in Excel 2016 for Windows
Creating a radar chart in Excel 2016 for Windows
Combining two types of chart in Excel 2016 for Windows
Creating a comparative chart using symbols in Excel 2016 for Windows
Inserting trendlines in Excel 2016 for Windows
Customizing your trendlines in Excel 2016 for Windows

Excel 2016: Creating PivotTables & PivotCharts

Course: 1 Hour, 6 Minutes

Creating a PivotTable in Excel 2016 for Windows
Creating a PivotTable with multiple data tables in Excel 2016 for Windows
Editing your PivotTable in Excel 2016 for Windows
Formatting your PivotTable in Excel 2016 for Windows
Copying & reusing your PivotTable in Excel 2016 for Windows
Inserting a calculation in your PivotTable in Excel 2016 for Windows
Sorting data in your PivotTable in Excel 2016 for Windows
Filtering your table data in Excel 2016 for Windows
Grouping data in your PivotTable in Excel 2016 for Windows
Inserting a slicer in your PivotTable in Excel 2016 for Windows
Customizing your slicer in Excel 2016 for Windows
Comparing values in a PivotTable in Excel 2016 for Windows
Inserting a PivotChart in Excel 2016 for Windows
Modifying your PivotChart in Excel 2016 for Windows
Analyzing your database tables in a PivotChart in Excel 2016 for Windows

Excel 2016: Using Conditional Formulas

Course: 41 Minutes

Inserting a conditional sum formula in Excel 2016 for Windows
Inserting a conditional message formula in Excel 2016 for Windows
Performing complex conditional formulas in Excel 2016 for Windows
Creating multiple conditions in Excel 2016 for Windows
Using IF & OR in conditional formulas in Excel 2016 for Windows
Using conditional formulas to count up value occurrences in Excel 2016 for Windows
Translating data in your worksheet in Excel 2016 for Windows
Using reference positions in conditional formulas in Excel 2016 for Windows
Keeping your table up to date with conditional formulas in Excel 2016 for Windows

Excel 2016: Extracting Information with Formulas

Course: 50 Minutes

Retrieving information with dates in Excel 2016 for Windows
Finding a date automatically in Excel 2016 for Windows
Finding the largest & smallest values in a list in Excel 2016 for Windows
Separating data into multiple cells in Excel 2016 for Windows
Combining data values in a single cell in Excel 2016 for Windows
Retrieving information on a cell in Excel 2016 for Windows
Retrieving information on your text in Excel 2016 for Windows
Cross referencing two data lists in Excel 2016 for Windows
Inserting data automatically in Excel 2016 for Windows
Finding a value in a double entry table in Excel 2016 for Windows
Performing a search across two tables in Excel 2016 for Windows
Finding data in a database in Excel 2016 for Windows
Performing calculations using your database in Excel 2016 for Windows

Excel 2016: Configuring Options & Settings

Course: 29 Minutes

Managing your account & connected services in Excel 2016 for Windows
Installing & managing add-ins in Excel 2016 for Windows
Configuring your input options in Excel 2016 for Windows
Configuring your default formula options in Excel 2016 for Windows
Customizing your document default settings in Excel 2016 for Windows
Customizing your interface in Excel 2016 for Windows
Customizing the Quick Access toolbar in Excel 2016 for Windows
Customizing the ribbon in Excel 2016 for Windows

Excel 2016: Using the Power View Add-in

Course: 1 Hour, 6 Minutes

Activating Power View in Excel 2016 for Windows
Creating a new report in Excel 2016 for Windows
Managing your report tables in Excel 2016 for Windows
Grouping data with tiles in Excel 2016 for Windows
Creating relationships between tables in Excel 2016 for Windows
Illustrating your Power View report in Excel 2016 for Windows
Formatting your Power View report in Excel 2016 for Windows
Organizing your Power View report in Excel 2016 for Windows
Filtering the data in your report in Excel 2016 for Windows
Using the advanced filter options in your Power View report in Excel 2016 for Windows
Reusing a table in Excel 2016 for Windows
Using a Matrix Table to visualize your data in Excel 2016 for Windows
Using bar & column charts to visualize your data in Excel 2016 for Windows
Using line charts to visualize your data in Excel 2016 for Windows
Using scatter charts to visualize your data in Excel 2016 for Windows
Using pie charts to visualize your data in Excel 2016 for Windows
Visualizing your data in map form in Excel 2016 for Windows

Excel 2016: Using the Power Pivot Add-in

Course: 58 Minutes

Activating Power Pivot in Excel 2016 for Windows
Using the view settings in Power Pivot in Excel 2016 for Windows
Importing your database in Excel 2016 for Windows
Creating Power Pivot relationships in Excel 2016 for Windows
Customizing your Power Pivot tables in Excel 2016 for Windows
Applying data formats in Power Pivot tables in Excel 2016 for Windows
Sorting the data in your Power Pivot table in Excel 2016 for Windows
Filtering data in your Power Pivot table in Excel 2016 for Windows
Creating a calculated field in your Power Pivot table in Excel 2016 for Windows
Creating custom views in your Power Pivot table in Excel 2016 for Windows
Updating your Power Pivot tables in Excel 2016 for Windows
Creating an advanced PivotTable in Excel 2016 for Windows
Creating an advanced PivotChart in Excel 2016 for Windows
Creating a dashboard in Excel 2016 for Windows

Excel 2016: Basic Formulas

Course: 48 Minutes

Inserting a formula using the function library in Excel 2016 for Windows
Performing simple calculations in Excel 2016 for Windows
Using automated formulas in a table in Excel 2016 for Windows
Creating automated cumulative totals in Excel 2016 for Windows
Inserting subtotals in Excel 2016 for Windows
Counting cells in a range in Excel 2016 for Windows
Ranking a value in Excel 2016 for Windows
Rounding a number in Excel 2016 for Windows
Using replacement formulas in Excel 2016 for Windows
Converting number types in Excel 2016 for Windows
Factorizing the results of a division in Excel 2016 for Windows
Creating random values in Excel 2016 for Windows

Language	English
Qualifications of the Instructor	Certified
Course Format and Length	Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration	14:20 Hours
Progress monitoring	Yes
Access to Material	365 days
Technical Requirements	Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance	Helpdesk and online knowledge base 24/7
Certification	Certificate of participation in PDF format
Price and costs	Course price at no extra cost
Cancellation policy and money-back guarantee	We assess this on a case-by-case basis
Award Winning E-learning	Yes
Tip!	Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.

There are no reviews written yet about this product.

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.