TOSA Excel Cursus E-Learning

Bestel deze unieke E-Learning cursus TOSA Excel 2016 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, voortgangsbewaking door rapportages en testen per hoofdstuk om de kennis direct te toetsen.

Verwerf de vaardigheden die nodig zijn om Microsoft Excel in een werkomgeving te gebruiken terwijl u zich voorbereidt op de TOSA Excel 2016 en TOSA Excel 365 certificerings examens.

Cursusinhoud

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