logo

Microsoft Office – Level 3 (MB5926)

This Microsoft Office 2019/365 course bundle covers the advanced usage of Microsoft Office 2019/365 products, such as Excel and Word. It provides knowledge on the key topics for users that are interested to learn more advanced topics in the Microsoft Office 2019/365 suite of tools.

Microsoft

A preferential rate (-15%) applies to the regular cost for non-profit organizations, as well as the government sector. In addition, you can benefit from additional advantages through a corporate agreement when you need to train several people or teams in your company. Contact us for details.

Public class

Duration: 
2 days / 14 hours

Private class

Virtual classroom
Minimum no. of participants: 6
2 days / 14 hours
Price on request
English or Serbian
Training plan: 

Module 1: Excel - Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Module 2: Excel - Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Module 3: Excel - Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Module 4: Excel - Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Module 5: Excel - Forecasting Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecast Data Trends

Module 6: Excel - Creating Sparklines and Mapping Data

  • Create Sparklines
  • Map Data

Module 7: Word - Manipulating Images

  • Integrate Pictures and Text
  • Adjust Image Appearance
  • Insert Other Media Elements

Module 8: Word - Using Custom Graphic Elements

  • Create Text Boxes and Pull Quotes
  • Add WordArt and Other Text Effects
  • Draw Shapes
  • Create Complex Illustrations with SmartArt

Module 9: Word - Collaborating on Documents

  • Prepare a Document for Collaboration
  • Mark Up a Document
  • Review Markups
  • Merge Changes from Other Documents

Module 10: Word - Adding Document References and Links

  • Add Captions
  • Add Cross-References
  • Add Bookmarks
  • Add Hyperlinks
  • Insert Footnotes and Endnotes
  • Add Citations and a Bibliography

Module 11: Word - Securing a Document

  • Suppress Information
  • Set Formatting and Editing Restrictions
  • Restrict Document Access
  • Add a Digital Signature to a Document

Module 12: Word - Using Forms to Manage Content

  • Create Forms
  • Modify Forms

Module 13: Word - Automating Repetitive Tasks with Macros

  • Automate Tasks by Using Macros
  • Create a Macro
Exclusives: 
  • Course material accessible in electronic format
  • Certificate of attendance (on request)
Audiences: 

Contact us for more information on pricing::

Eccentrix
Office: 1-888-718-9732
E-mail: info@eccentrix.ca

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca