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        
Live Lecture

·      Subtotals And Outlines

·      Pivot table With Options

·      Pivot table Design And Pivot charts

·      Practical Exercise        
Live Lecture

·      One- And Two-Variable Data Tables

·      Goal Seek And Scenario Manager

·      Solver

·      Practical Exercise
Live Lecture

·      Nested Logical Function

·      Match And Index Lookup Functions

·      Advance Filtering

·      Database Functions

·      Financial Functions

·      Practical Exercise        
Live Lecture

·      Using Conditional Math & Statistical Functions

·      Calculating Relative Standing With Statistical Functions

·      Descriptive Statistical Functions

·      Practical Exercise        
Live Lecture

·      Multiple Worksheets

·      Inserting A 3-D Formula

·      Linking Workbooks

·      Formula Auditing

·      Data Validation

·      Practical Exercise        
Live Lecture

·      Text Manipulation Functions

·      Flash Fill

·      Customizing Excel & Changing Properties

·      Sharing And Merging Workbooks

·      Inserting Comments & Tracking Changes

·      Practical Exercise        
Live Lecture

·      Templates, Themes, And Styles

·      Creating And Using A Template

·      Protection-Protecting A Cell, Worksheet,& Workbook

·      Macro In Excel

·      Creating A Sub Procedure & Custom Function

·      Practical Exercise        

Fees

Offline Training @ Vadodara

  • Classroom Based Training
  • Practical Based Training
  • No Cost EMI Option
20000 18000

Online Training preferred

  • Live Virtual Classroom Training
  • 1:1 Doubt Resolution Sessions
  • Recorded Live Lectures*
  • Flexible Schedule
17000 15000

Corporate Training

  • Customized Learning
  • Onsite Based Corporate Training
  • Online Corporate Training
  • Certified Corporate Training

Certification

  • Upon the completion of the Classroom training, you will have an Offline exam that will help you prepare for the Professional certification exam and score top marks. The BIT Certification is awarded upon successfully completing an offline exam after reviewed by experts
  • Upon the completion of the Online training, you will have an online exam that will help you prepare for the Professional certification exam and score top marks. BIT Certification is awarded upon successfully completing an online exam after reviewed by experts.

Related Courses

Copyright Bitonlinelearn © 2021. All Rights Reserved | Design and Developed By BITINFOTECH

Your experience on this site will be improved by allowing cookies.