Microsoft Excel Advance Training

Microsoft Excel Advance Certificate Course

Microsoft Excel certainly does much more than just text editing, text alignments, and calculations, and that is why it has been the most widely utilized office software in the world. It is an advantageous spreadsheet-making tool that has numerous functions such as Conditional Formatting, Formulae Generation, Relative and Fixed Referencing, VLookup, Pivot Tables, Graphs, Charts, Data Hiding, and other logical functions. Be it an IT or a domain of Media you work for, understanding the operations of Microsoft Excel is the need of the hour.

COURSE SCHEDULE ENQUIRE NOW

1054 Ratings

2075 Participants

Group Discount

Upto 15% OFF

Panel of Microsoft Excel Certified Experts with 20+ years of Industry and Training Experience

Facilitators conducted 500+ Microsoft Excel Trainings

Approved and Quality Course Material

Trained 25,000+ Professionals across the Globe

Microsoft Excel Advance Certificate Training

The Microsoft Excel Advanced Certification is a Two day (16 hours) program and the aspirant must possess basic knowledge of Microsoft Excel before applying for the same.

Make and edit your own project management charts, time logs, goal or task planners, and accounting and scheduling sheets more efficiently with an Advance Certificate Training Program in Microsoft Excel. In this program, participants are guided on a comprehensive and intensive approach of using Microsoft Excel and are given simple hacks to manipulate tables, sheets or charts according to one’s requirement.

After the completion of the Program, the participants would be able to:

Learn to practice the advanced key functions of Microsoft Excel efficiently
Learn to create, edit and merge multiple graphs, charts, sheets, and tables together
Learn to generate diverse formulae using Conditional / Logical Functions

Learn to use the Pivot table tool and its several applications along with many other functions of Microsoft Excel

Course Curriculum

Audience

CIO / CTO/Vice President
IT Heads / Senior IT Managers
Head/GM / AGM Projects
Senior Project Managers
Program Managers
Projects Managers
Senior Consultants
Project /Team Leads /PMO
Business Practice Heads
Department/ Business Heads
Business Analysts
Management Trainee
Graduates
Freshers

Eligibility Criteria

Secondary degree (high school diploma, associate’s degree or global equivalent

Four-year degree (bachelor’s degree or global equivalent

Basic knowledge of Excel is a must.

Course Objectives

To describe the purpose of using Microsoft Excel in a broader manner and utilizing all the key functions to make day-to-day operations smoother.
To learn to generate and implement any type of formula on any type of information.
To be able to save data in an orderly and accurate form.
To understand the importance of Formatting, Referencing, Conditional Functions, and Lookup and Information Functions.
Demonstrate a clear understanding of Microsoft Excel and its advantageous techniques to promote unabridged and error-free practices.

Training Options

ONLINE TRAINING

Instructor-Led Session

2 days Instructor-led Online Training
Experienced Subject Matter Experts
Approved and Quality Ensured training Material
24*7 leaner assistance and support

ENROLL NOW

CORPORATE TRAINING

Customized to your team's need

Blended Learning Delivery Model (Self-Paced E-Learning And/Or Instructor-Led Options)
Course, Category, And All-Access Pricing
Enterprise-Class Learning Management System (LMS)
Enhanced Reporting For Individuals And Teams
24x7 Teaching Assistance And Support

Contact Now

Course Outline

Excel Overview

Overview of basic spreadsheet concepts
Concept of Ranges
Understanding View of 2010 Excel
Working with backstage options

Creating and editing formulae and functions

Revision of basic concepts
Different file saving options in excel
Understand relative referencing
Apply Fixed (Absolute) Referencing

Conditional/Logical Functions

Benefits and purpose
If Statements, Nested If
Sumif, Countif, Sumifs, Countifs

Conditional Formatting – various options

Data validation
Lookup and Information Functions
Vertical lookup (vlookup)
Horizontal lookup (hlookup)
Match and Index functions

Excel Charts/ Graphs

Using the Chart Wizard
Editing and Formatting charts
Saving custom chart types
Setting a default chart type
Creating mixed chart
Sparkline feature

Advanced List Management

Advanced Filters
Using List features (creating & using lists)
Tables
Subtotals

Pivot Tables & Charts

Using the Pivot Table Wizard
Changing the Pivot Table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table options
Display/ hide data in fields
Slicers in Pivot table
Pivot Chart

Course Reviews

Training is not everyone’s cup of tea. It is an art of communicating the right things, in the right manner, and to the right audience. The trainer for this programme was able to do exactly that. He possessed immense knowledge and was able to communicate most of it to all the participants (including me) that attended the highly effective training programme. A well-organized learning session that upgraded everyone – can easily say this on behalf of all the participants based on the feedback post the session!