Duration: 2 days – 14 hrs.
Overview
The Microsoft Office Advanced Training Course is designed to elevate your proficiency in Microsoft Office applications, including Microsoft Excel, Word, and PowerPoint. Whether you are a professional seeking to enhance your productivity, a manager aiming to optimize team collaboration, or an individual looking to stand out in the workplace, this course will provide you with advanced skills and techniques to master the full potential of these powerful tools.
This comprehensive Microsoft Office Advanced Training Course offers in-depth knowledge and practical skills in Excel, Word, and PowerPoint, enabling participants to become proficient users of these essential office tools.
Objectives
- Excel Mastery: Gain expertise in complex functions, data analysis, and automation using Excel.
- Word Excellence: Learn advanced formatting, document automation, and referencing in Word.
- PowerPoint Proficiency: Create dynamic and engaging presentations with advanced features.
- Integration Skills: Seamlessly integrate Office applications for enhanced productivity.
- Problem-Solving: Develop problem-solving skills using real-world scenarios.
- Advanced Techniques: Master pivot tables, macros, and advanced formulas.
Audience
- Professionals seeking to enhance their Microsoft Office skills
- Managers and team leaders aiming to boost team productivity
- Individuals looking to improve their job prospects
- Anyone interested in becoming an advanced Office user
Prerequisites
- Participants should have a fundamental understanding of Microsoft Office applications and basic computer skills.
Course Content
Index-Match, the powerful lookup
- One dimension lookup
- Multiple dimensions lookup
- Working with multiple criteria
Logical function Part 2
- Working with more than possible results and conditions
- Applying OR / AND conditions
- Nested lookup, logical and if functions
- Replacing error
PivotTable in-depth
- Generate multiple reports.
- Inserting slicer, timeline and sparkline
- Controlling pivot tables with slicer and timeline
- Finding the Percentage of Total
- Finding the Difference From
- Creating Running Totals
- Limitation of running totals
- Creating Calculated Fields
- Creating Calculated Items
- PivotTable Options
Formula-based formatting
- Understanding how reference in formatting works
- Sample for customized conditional formatting
- Highlight rows based on value from specific column.
Introduction to Power Query (Excel version 2016 / 2019 / 2021 / 365)
- Automation of data transformation
- Consolidate data from files from a folder.
- Create Pivot Table as summary of transformed data
ADVANCED MS WORD
Custom Formatting
Working with Outlining
- Outline Level
- Navigation Pane
- Viewing Outline
- Dynamic Table of Contents
Working with Quick Parts
Advanced Graphics and Objects
Customizing Headers & Footers
Working with Reference
- Citations
- Footnotes and Endnotes
- Captions and Cross-references
- Indexing
Working with links and Bookmarks
Mailing Tab
- Integration of Microsoft Excel and Microsoft Word
- Sort and Filter Records
- Insert Merge Field Code
- Formatting Field Code
- Finishing Mail Merge
- Updating Links
Microsoft Word Form Controls
- Enabling Developer Tab
- Design Controls
- Working with Text Box, Button, Combo Box and Check Box
- Grouping Text
ADVANCED MS POWERPOINT
- Advanced Formatting
- Customizing Shapes and Selection Pane
- Customizing Layout
- Working with Animation Pane
Types of animations
Timing and Duration
- Transition effects and timing
- Working with Table in PowerPoint
- Zoom and Morph transitions.
- Links and Bookmarking
- Working with Slideshow and Presenter
- Working with Handouts
