Microsoft Excel Advanced

Inquire now

The Microsoft Excel Advanced Training course is designed for experienced Excel users who want to take their spreadsheet, data analysis, reporting, and automation capabilities to a professional level. Building on intermediate Excel knowledge, this advanced training introduces powerful techniques for managing complex datasets, developing sophisticated calculations, analyzing information, and creating professional business solutions.

 

Duration: 1 day – 7 hr.

Overview

This Microsoft Excel Advanced Training course, you will learn how to maximize Excel even further to help you analyze data quicker. You will learn features like PivotTables, macros, and how to protect your spreadsheets from being misused by others. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do.

 

Learning Objectives

  • Resolve formula errors
  • Manage data such as removing duplicates, validating and transposing data
  • Answer “What-if” scenarios using goal seek
  • Work with PivotTables
  • Create basic dashboards to visualize data
  • Use Macros to automate repetitive tasks
  • Protect your spreadsheet from misuse by others

 

Audience

  • Anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing. Basic Excel knowledge at the level of Microsoft Excel Basic and Microsoft Excel Intermediate is expected for this Microsoft excel training.

 

Pre- requisites 

  • Basic Excel knowledge at the level of Microsoft Excel Basic and Microsoft Excel Intermediate

 

Course Content

Part 1.  Basic to Advanced MS Excel Functions

  • Text Functions
  • Combining Texts (CONCATENATE)
  • Extracting Values from Texts (LEFT, RIGHT, MID)
  • Changing Case (UPPER, LOWER, PROPER)
  • Other Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)
  • Logical Functions
  • Basic IF Statements
  • Nested and Series IF Statements
  • Combining Logical Statements with AND and OR
  • Math Functions
  • Basic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)
  • Named Ranges
  • Conditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)
  • Shortening Long Formulas with Arrays
  • Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH

 

Part 2.  Managing Data Using Excel Tools

  • Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Formatting
  • Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
  • Subtotal Tool

 

Part 3. Analyzing and Presenting Data Using PivotTables

  • Basic PivotTable Features
  • Refresh and Change Data Source
  • Grouping Data
  • Using Slicers
  • PivotCharts

 

Part 4.  Introduction to Macros

  • Understanding Macro Security
  • Macro Recording

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