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.
Read more- Brand:
- Microsoft
- 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.
- 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.
Loading...
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.
Reviews
There are no reviews written yet about this product.
