Office Productivity Training – Microsoft Office 2019 Excel – Advanced Series

$49.00Add to cart

Description

This course will introduce students Microsoft Office Excel Advanced 2019, Getting Started with Microsoft Office Excel 2019, Performing Calculations, Modifying a Worksheet, Formatting a Worksheet, Printing Workbooks, Managing Workbooks Etc

Who this course is for:
  • This mega Microsoft Office Excel bundle is perfect if you’re looking to finally get to grips with Excel Basic 2019. Each course goes into depth on how to get the most from each content and will  help you become an Advanced user of Microsoft Excel 2019.

Series Taught By: Robert Kent

Requirements

  • There is no required prerequisite for this course however, the candidates are expected to have a working knowledge of the Microsoft Office suite of products.

Course Modules:

Module 01: Working with Multiple Worksheets and Workbooks

(Duration: — m )

  1. Workbook
  2. Course Introduction
  3. Topic A: Use Links and External References
  4. Linked Cells
  5. External Link Syntax
  6. The Edit Links Dialog Box
  7. External References in Formulas and Functions
  8. Creating Links
  9. Topic B: Use 3-D References
  10. Grouped Worksheets
  11. 3-D References
  12. 3-D References in Summary Functions
  13. Using 3-D References
  14. Topic C: Consolidate Data
  15. Data Consolidation
  16. Consolidated Dataset with Linked Source Data
  17. The Consolidate Dialog Box
  18. Consolidating Data
  19. Chapter 01 Review
  20. Review Quiz (Number of attempts allowed: Unlimited)

Module 03: Automating Workbook Functionality

(Duration: –m)

  1. Workbook
  2. Topic A: Apply Data Validation
  3. Data Validation
  4. The Data Validation Dialog Box
  5. Data Validation Criteria
  6. The Input Message Tab
  7. The Error Alert Tab
  8. Applying Data Validation
  9. Topic B: Search for Invalid Data and Formulas with Errors
  10. Invalid Data
  11. The Circle Invalid Data Command
  12. The Error Checking Dialog Box
  13. Error Types
  14. Searching for Invalid Data and Formulas with Errors
  15. Topic C: Work with Macros
  16. Macros
  17. Macro Security Settings
  18. VBA
  19. VBE
  20. The Record Macro Dialog Box
  21. The Macro Dialog Box
  22. Macro Names
  23. The Personal Workbook
  24. Creating a Macro
  25. Editing a Macro
  26. Chapter 03 Review
  27. Review Quiz (Number of attempts allowed: Unlimited)

Module 05: Forecasting Data

(Duration: –m)

  1. Workbook
  2. Topic A: Determine Potential Outcomes Using Data Tables
  3. What-If Analysis
  4. Data Tables
  5. One-Variable Data Tables
  6. Two-Variable Data Tables
  7. The Data Table Dialog Box
  8. Determining Potential Outcomes Using Data Tables
  9. Topic B: Determine Potential Outcomes Using Scenarios
  10. Scenarios
  11. The Scenario Manager Dialog Box
  12. The Add Scenario Dialog Box
  13. The Scenario Values Dialog Box
  14. The Scenario Command
  15. Determining Potential Outcomes Using Scenarios
  16. Topic C: Use the Goal Seek Feature
  17. The Goal Seek Feature
  18. The Goal Seek Dialog Box
  19. Iterative Calculations
  20. Using the Goal Seek Feature
  21. Topic D: Forecast Data Trends
  22. The Create Forecast Worksheet Dialog Box
  23. Forecasting Data with the Forecast Sheet
  24. Chapter 05 Review
  25. Review Quiz (Number of attempts allowed: Unlimited)

Module 02: Sharing and Protecting Workbooks

(Duration: — m)

  1. Workbook
  2. Topic A: Collaborate on a Workbook
  3. Comments
  4. The Compare and Merge Workbooks Command
  5. The Share Options
  6. Microsoft Accounts and OneDrive
  7. The PDF and XPS File Formats
  8. Accessibility Options
  9. The Accessibility Checker
  10. Collaborating on a Workbook
  11. Topic B: Protect Worksheets and Workbooks
  12. Worksheet and Workbook Element Protection
  13. The Protect Sheet Command
  14. The Protect Workbook Command
  15. The Protect Workbook Options
  16. Metadata
  17. The Document Inspector
  18. Protecting Worksheets and Workbooks
  19. Chapter 02 Review
  20. Review Quiz (Number of attempts allowed: Unlimited)

Module 04: Using Lookup Functions and Formula Auditing

(Duration: — m)

  1. Workbook
  2. Topic A: Use Lookup Functions
  3. Lookup Functions
  4. The VLOOKUP Function
  5. The HLOOKUP Function
  6. The MATCH Function
  7. The INDEX Function
  8. The TRANSPOSE Function
  9. Using Lookup Functions
  10. Topic B: Trace Cells
  11. Precedent and Dependent Cells
  12. The Trace Precedents and Trace Dependents Commands
  13. Trace Arrows
  14. The Go To Dialog Box and Trace Arrows
  15. The Go To Special Dialog Box
  16. The Remove Arrows Options
  17. Tracing Precedent and Dependent Cells
  18. Topic C: Watch and Evaluate Formulas
  19. The Watch Window
  20. Formula Evaluation
  21. The Evaluate Formula Dialog Box
  22. Watching and Evaluating Formulas
  23. Chapter 04 Review
  24. Review Quiz (Number of attempts allowed: Unlimited)

Module 06: Creating Sparklines and Mapping Data

(Duration: — m)

  1. Workbook
  2. Topic A: Create Sparklines
  3. Sparklines
  4. Sparkline Types
  5. The Create Sparklines Dialog Box
  6. The Sparkline Tools Contextual Tab
  7. Creating Sparklines
  8. Topic B: Map Data
  9. 3D Maps
  10. Data Structuring
  11. 3D Map Layer Pane
  12. Tours
  13. Creating a 3D Map
  14. Chapter 06 Review
  15. Review Quiz (Number of attempts allowed: Unlimited)

This course includes

  •  On-demand video
  • 6 downloadable Pdf Workbooks
  • Unlimited time access (During Membership)
  • Access on mobile and Desktop
  • Certificate of Completion

$49.00Add to cart

Course Features Include:

  • Expert Lectures
    Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.

  • Certificates of Completion
    Upon completion of a series of courses you can earn a certificate of completion from Career Academy. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.

  • PowerPoint Visuals:
    Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.

  • Professional Development Activities
    Students are provided access to professional development activity files which allow for an individual to test out course theories and apply the knowledge they earned from the course.

  • Review Quizzes
    Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.

  • Mobile Access
    With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!