Home Microsoft Training MS Application Microsoft Excel

Advanced Excel Training Course

Mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease through Advanced Excel Online Training Course.

  • 15000
  • 17000
Download Brochure
  • Course Includes
  • Live Class Practical Oriented Training
  • 35 + Hrs Instructor LED Training
  • 20 + Hrs Practical Exercise
  • 10 + Hrs Project Work & Assignment
  • Timely Doubt Resolution
  • Dedicated Student Success Mentor
  • Certification & Job Assistance
  • Free Access to Workshop & Webinar
  • No Cost EMI Option
Report

Have Query ?

What you will learn

  • Build a solid understanding on the basics of Microsoft Excel. Writing formulas and performing calculations
  • SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions. Inserting headers and footers, and adjusting margins
  • Color code data that meet certain criteria with Conditional Formatting. Save time applying formatting to other cells wit...
  • Create different variations of charts and graphs that can be used to represent real life scenarios. Manipulate data to g...
  • Analyze & sort/filter data to create powerful & captivating pivot tables. Implement formulas, functions & calculations t...

Requirements

  • Basic Computer Knowledge.

Description

|| About  Advance Excel Training Course

Microsoft Excel Online Training at BIT aims to impart basic skills in using Excel to its best. Participants will learn to use statistical, math, and logical functions, organize data using filter and sort and effectively present data for quick decision-making using charts and graphs.  Participants will also gain some advanced skills in Excel, such as using VLOOKUP, PivotTables, and Macros among others.

Microsoft Excel is a very popular software program included in the Microsoft Office suite and used to create spreadsheets documents which is laid out in rows and columns as a big table. Excel has become one of the most used software programs in the business world due to its supreme versatility and power. Excel is an extraordinarily powerful tool used frequently in the business world to store, manipulate, and measure complex sets of data. Below are a few examples a company might use Excel.

 

 

Course Content

Live Lecture

·      Introduction To Spreadsheets

·      Creating Formulas, Auto Fill

·      Formatting

·    Practical Exercise
Live Lecture

·      Basic Formulas

·      Inserting Basic Math & Statistics Functions

·      Using Date Functions

·      Logical Functions - IF Function

·      Lookup Function-Vlookup() & Hlookup()

·      Financial Functions

·      Range Names

·      Practical Exercise
Live Lecture

·      Chart Creation Basics

·      Chart Elements

·      Chart Design And Sparklines

·      Practical Exercise
Live Lecture

·      Large Datasets- Freezing & Printing

·      Excel Table With Manipulation And Aggregation

·      Conditional Formatting

·      Practical Exercise