(+64) 9 425 40 99| Contact Us| FAQ's | Dealer Login

Cart (0)
Shopping cart (0)
Total 0

Course detail

Home Course Office 2019 Excel P3

1590971161-excel-2019.jpg

Share with your friend

Office 2019 Excel P3

0 rate

0 purchased SKU: SKU_NUYIC17026


Available ONLY TO SMART TRAINER USERS

To Purchase this Product you must be a customer BUY A SMART TRAINER

10 USD Become a customer

Course Outline

  Chapter 01 - Working with Multiple Worksheets and Workbooks
  Topic A: Use Links and External References
  Linked Cells
  The Edit Links Dialog Box
  External References in Formulas and Functions
  Demo - Creating Links
  Topic B: Use 3-D References
  Grouped Worksheets
  3-D References
  3-D References in Summary Functions
  Demo - Using 3-D References
  Topic C: Consolidate Data
  Data Consolidation
  The Consolidate Dialog Box
  Demo - Consolidating Data
  External Link Syntax
  Consolidated Dataset with Linked Source Data
  Chapter 02 - Sharing and Protecting Workbooks
  Comments
  Topic A: Collaborate on a Workbook
  The Compare and Merge Workbooks Command
  The Share Options
  Microsoft Accounts and OneDrive
  The Accessibility Checker
  Demo - Collaborating on a Workbook
  Topic B: Protect Worksheets and Workbooks
  Worksheet and Workbook Element Protection
  The Protect Sheet Command
  The Protect Workbook Command
  The Protect Workbook Options
  The Document Inspector
  Demo - Protecting Worksheets and Workbooks
  Metadata
  The PDF and XPS File Formats
  Accessibility Options
  Chapter 03 - Automating Workbook Functionality
  Topic A: Apply Data Validation
  The Data Validation Dialog Box
  Data Validation Criteria
  The Input Message Tab
  The Error Alert Tab
  Demo - Applying Data Validation
  Topic B: Search for Invalid Data and Formulas with Errors
  The Circle Invalid Data Command
  The Error Checking Dialog Box
  Topic C: Work with Macros
  Macro Security Settings
  The Record Macro Dialog Box
  The Macro Dialog Box
  The Personal Workbook
  Data Validation
  Macros
  Invalid Data
  Error Types
  Demo - Searching for Invalid Data and Formulas with Errors
  VBA
  VBE
  Macro Names
  Demo - Creating a Macro
  Demo - Editing a Macro
  Chapter 04 - Using Lookup Functions and Formula Auditing
  Topic A: Use Lookup Functions
  The VLOOKUP Function
  Demo - Using Lookup Functions
  Topic B: Trace Cells
  Precedent and Dependent Cells
  The Trace Precedents and Trace Dependents Commands
  Trace Arrows
  The Go To Dialog Box and Trace Arrows
  The Go To Special Dialog Box
  Demo - Tracing Precedent and Dependent Cells
  Topic C: Watch and Evaluate Formulas
  The Watch Window
  The Evaluate Formula Dialog Box
  Demo - Watching and Evaluating Formulas
  The HLOOKUP Function
  Lookup Functions
  The MATCH Function
  The INDEX Function
  The TRANSPOSE Function
  The Remove Arrows Options
  Formula Evaluation
  Chapter 05 - Forecasting Data
  Topic A: Determine Potential Outcomes Using Data Tables
  What-If Analysis
  One-Variable Data Tables
  Two-Variable Data Tables
  The Data Table Dialog Box
  Demo - Determining Potential Outcomes Using Data Tables
  Topic B: Determine Potential Outcomes Using Scenarios
  Scenarios
  The Scenario Manager Dialog Box
  The Add Scenario Dialog Box
  The Scenario Values Dialog Box
  The Scenario Command
  Topic C: Use the Goal Seek Feature
  The Goal Seek Dialog Box
  The Create Forecast Worksheet Dialog Box
  Demo - Forecasting Data with the Forecast Sheet
  Data Tables
  Demo - Determining Potential Outcomes Using Scenarios
  The Goal Seek Feature
  Iterative Calculations
  Demo - Using the Goal Seek Feature
  Topic D: Forecast Data Trends
  Chapter 06 - Creating Sparklines and Mapping Data
  Chapter 06 Review
  Topic A: Create Sparklines
  Sparklines
  The Create Sparklines Dialog Box
  The Sparkline Tools Contextual Tab
  Demo - Creating Sparklines
  Topic B: Map Data
  3D Maps
  3D Map Layer Pane
  Sparkline Types
  Data Structuring
  Tours
  Demo - Creating a 3D Map
  Chapter 07 - Importing and Exporting Data
  Chapter 07 Review
  The New Web Query Dialog Box
  Topic A: Import and Export Data
  Importing Data
  Exporting Data
  Methods of Importing Text Files
  The Text Import Wizard
  XML
  XML Schemas
  XML Maps
  The XML Source Task Pane
  The XML Maps Dialog Box
  Chapter 08 - Internationalizing Workbooks
  Chapter 08 Review
  Topic A: Internationalize Workbooks
  Worksheet and Worksheet Tab Direction
  The Symbol Dialog Box
  International Number Formatting
  Chapter 09 - Working with Power Pivot
  Chapter 09 Review
  Topic A: Work with Power Pivot
  Power Pivot
  The Power Pivot Tab
  The Data Model
  The Power Pivot User Interface
  The Data and Diagram Views
  The Create Relationship Dialog Box
  Calculated Columns
  Chapter 10 - Advanced Customization Options
  Custom Lists
  Chapter 10 Review
  Language Options
  Advanced Options
  The AutoCorrect Dialog Box
  Topic A: Customize Advanced Options
  Formulas Options
  Data Options
  Proofing Options
  Save Options
  Ease of Access Options
  The Add-Ins Tab
  The Trust Center
  Chapter 11 - Working with Forms and Controls
  Chapter 11 Review
  The Developer Tab
  Forms
  Topic A: Work with Forms and Controls
  Form Types
  Form Controls
  Control Properties
  Demo - Adding and Editing Data Using a Data Form
  Demo - Adding Form Controls

Additional Information

author

Author

Administrator

Lessons

level

Level

Beginner

Related Courses

1590971093-excel-2019.jpg
Office 2019 Excel P1
0 rate

0 purchased

10

1590971137-excel-2019.jpg
Office 2019 Excel P2
0 rate

0 purchased

10

1590971257-office-2019-new-feature.jpg
Office 2019 New Features
0 rate

0 purchased

10

1590971402-word-2019.jpg
Office 2019 Word P1
0 rate

0 purchased

10