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