Details
This Microsoft 365 Apps course bundle covers the advanced usage of Microsoft 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 365 suite of tools.
Outline
Module 1: Working with Multiple Worksheets and Workbooks
- Use Links and External References
- Use 3-D References
- Consolidate Data
Module 2: Sharing and Protecting Workbooks
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Module 3: Automating Workbook Functionality
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Module 4: Using Lookup Functions and Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Module 5: Forecasting Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecast Data Trends
Module 6: Creating Sparklines and Mapping Data
- Create Sparklines
- Map Data
Module 1: Manipulating Images
- Integrate Pictures and Text
- Adjust Image Appearance
- Insert Other Media Elements
Module 2: Using Custom Graphic Elements
- Create Text Boxes and Pull Quotes
- Add WordArt and Other Text Effects
- Draw Shapes
- Create Complex Illustrations with SmartArt
Module 3: Collaborating on Documents
- Prepare a Document for Collaboration
- Mark Up a Document
- Review Markups
- Merge Changes from Other Documents
Module 4: Adding Document References and Links
- Add Captions
- Add Cross-References
- Add Bookmarks
- Add Hyperlinks
- Insert Footnotes and Endnotes
- Add Citations and a Bibliography
Module 5: Securing a Document
- Suppress Information
- Set Formatting and Editing Restrictions
- Restrict Document Access
- Add a Digital Signature to a Document
Module 6: Using Forms to Manage Content
- Create Forms
- Modify Forms
Module 7: Automating Repetitive Tasks with Macros
- Automate Tasks by Using Macros
- Create a Macro
Our goal is to offer quality and up-to-date training courses, while following the latest trends in technology and applications. These are courses that target the real and concrete needs of our customers, ensuring that the knowledge acquired is put into practice. Additionally, many prepare our participants for certification exams with the brands we are accredited with - Microsoft, EC-Council, CompTIA, and PeopleCert.
Eccentrix has the most comprehensive offer in terms of Microsoft accredited trainings. In addition, a complete set of benefits comes with each enrollment to our trainings. Since the very beginning of our operations, Eccentrix has been a Microsoft Partner in learning following the numerous changes in the learning paths and programs, notably for certification-based courses.
EC-Council
Eccentrix has the highest level of EC-Council partnership, delivering the complete portfolio of EC-Council cybersecurity courses since 2017. With an EC-Council course comes a set of benefits that greatly help our participants get certified. EC-Council is a key vendor for Eccentrix, since we have a strong focus on cybersecurity courses and that relationships just gets better over the years. ...