Microsoft Excel Intermediate Training

Microsoft Excel Certification 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

  739 Ratings

               1025 Participants

Group Discount

Upto 15% OFF

Highly Experienced Trainers

Course Designed According To Corporate Requirements

Updated Course Material

Post Training Assistance

Microsoft Excel Training


The Microsoft Excel Intermediate Certification is a Two days (16 hour) 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 Intermediate 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 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

OR

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.

Read More..

Get in touch

By providing your contact details, you agree to our terms & conditions

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

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 

Course Outline


  • Overview of basic spreadsheet concepts
  • Concept of Ranges
  • Understanding View of 2010 Excel
  • Working with backstage options
  • Revision of basic concepts
  • Different file saving options in excel
  • Understand relative referencing
  • Apply Fixed (Absolute) Referencing
  • Benefits and purpose
  • If Statements, Nested If
  • Sumif, Countif, Sumifs, Counties
  • Lookup and Information Functions
  • Vertical lookup (vlookup)
  • Horizontal lookup (hlookup)
  • Match and Index functions
  • Using the Chart Wizard
  • Editing and Formatting charts
  • Saving custom chart types
  • Setting a default chart type
  • Creating mixed chart
  • Sparkline feature
  • Advanced Filters
  • Using List features (creating & using lists)
  • Tables
  • Subtotals
  • 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


FAQ's


  • We are an Accredited Training Organization
  • Experiential Education
  • Experienced Industry Experts
  • Accredited course material
  • Quality Courseware
  • Post-training support