18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

Microsoft® Office Excel® 2019: Part 3 Training


What Microsoft® Office Excel® 2019: Part 3 training is all about?

The course provides an overview and in-depth access to the Excel environment to equip students with skills that let them collaborate, automate complex tasks, and utilize conditional logic to create and apply formulas and functions.

Schedule

Contact us to customize this class with your preferred dates, times and location.
You can call us on 1-800-961-0337 or Chat with our representative.

What are the course objectives for Microsoft® Office Excel® 2019: Part 3 training?
  • Creating map data and spark lines.
  • Forecasting data.
  • Protecting and sharing workbooks.
  • Functioning with workbooks and multiple worksheets.
  • Utilize formula audit and lookup functions.
  • Automating workbook functionalities.
Who should attend Microsoft® Office Excel® 2019: Part 3 training?

The target audience for this training are students experienced in Microsoft Excel 2019. Although, students who have deep interest in learning Microsoft Excel features can enrol in this course. You will learn how to troubleshoot complex, large spreadsheets, construct Excel functions and functionalities in performing extensive datasets.

What is the course outline for Microsoft® Office Excel® 2019: Part 3 training?
  • 1. Working with Multiple Worksheets and Workbooks
  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • 2. Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • 3. Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
  • 4. Using Lookup Functions and Formula Auditing
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • 5. Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecast Data Trends
  • 6. Creating Sparklines and Mapping Data
  • Create Sparklines
  • Map Data
1 Day | $ 275
Enroll Now
4
  221 Ratings

1432 Learners

Get In Touch

Are you being sponsored by your employer to take this class?
* I authorize Microtek Learning to contact me via Phone/Email