Microsoft Office Advanced

Inquire now

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

 

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy