Name :
Contact :
Email :
City :
Comment :
 
LiveZilla Live Chat Software

Taught by


Hindi


English


Gujarati

Professional Excellence in Excel



PRICE :  5900



In the present competitive environment, all our efforts are focus on increase our efficiency. There is always a desire to improve and excel in our professional career. There so many things we do on MS Excel that makes it worthwhile for us.

This course is particularly design for those people who feel the requirement of getting better command over MS Excel for their daily routine works. Also for those who feels that better Data Management and Analytical Skill with the use of MS Excel will be useful for them.

MS Excel is definitely more than just of Data Storage Tool or just a Tool for Quick Calculation.

We focuses on topics like...

Better Data Management & Designing to make them more presentable.

Tools like Conditional formatting, Table, Charts, Smart Art, are more & more extensive used by people.

MS Excel is one of the very important tools when it comes to analyzing Data. Important Functions like VLOOKUP, HLOOKUP, IF, ANDIF, ORIF, etc. and many more functions are used to customize data as per your need. Better command over them can definitely improve time and efficiency of people.

Same way Pivot Table and Macro take to the advance level for those are looking for MS Excel as research tool. As you do not require to know the Programming Coding and still you can simplify you work my using Macro Recording Option and Pivot Table.

In this workshop we will cover all the important expect of the MS Excel. This workshop will definitely make your work more simple smarter and Skillful.

This workshop is must for all the professional like CA, MBA. CFA. Accountants. ect.

All the participant in this work shop will get the certificate for the course.


Benefits: Career Enhancement tool for...

  • Students - Enhance your skill before introducing yourself to the world.

  • Professionals – Master your tough routine work with intelligent smart solutions.

  • Research Analyst – Develop you customize way to your research.


Course Add-ons:

  • Study Material (Soft Copy)

  • MS-Excel Self Practice Sheet

  • Daily Homework Sheet


Mode of Delivery: Online Module

Features of Online Module

  • E Learning

  • Recorded Video Session

  • Learn at your convenient time & place

  • Easiest way to learn

  • Queries / Doubts Solutions on Mail


System Requirement:

  • PC / Laptop / Tablet / Smart Phone

  • Headphone / Speaker

  • Google Account



Course Validity: 30 Days


FAQ - English



FAQs in Hindi || FAQs in Gujarati



Course Content:


  • PHASE 1 : Excel Basics
  • 1
    Introduction
    2:53
  • 2
    Ribbon Overview
    7:34
  • 3
    Paste Special
    16:28
  • 4
    Wrap Text And Mearg Cells
    4:24
  • 5
    Insert Table
    3:39
  • 6
    Smart Art
    6:47
  • 7
    Hyperlink
    4:39
  • PHASE 2 : Data Management
  • 8
    Web Data
    5:09
  • 9
    Data Filtering And Sorting
    4:56
  • 10
    Data Tools
    5:26
  • PHASE 3 : Formulas
  • 11
    Insert Function
    2:55
  • 12
    Auto Sum
    4:33
  • 13
    Formula Auditing
    6:22
  • 14
    Relative And Absolute Formulas
    4:52
  • 15
    Use Of Fx Button
    5:32
  • 16
    Sum And Sumproduct
    7:01
  • 17
    Sumif
    5:04
  • 18
    Rounding
    7:48
  • 19
    Count
    4:55
  • 20
    Countif
    3:34
  • 21
    Trim And Find
    4:29
  • 22
    Len
    1:56
  • 23
    Left
    5:24
  • 24
    Right
    4:56
  • 25
    Concatenate
    3:10
  • 26
    Date ,Today , Year
    4:46
  • 27
    Time, Hour,Minute
    2:55
  • 28
    If
    6:54
  • 29
    And , Or
    4:51
  • 30
    Isblank And Isnumber
    3:19
  • 31
    Lookuparray)
    5:24
  • 32
    Lookup Vector)
    4:01
  • 33
    Hlookup
    2:56
  • 34
    Index
    3:23
  • 35
    Indirect
    3:20
  • 36
    Match
    6:18
  • 37
    Exact
    1:40
  • 38
    Even N Odd
    1:34
  • 39
    Small N Large
    2:55
  • 40
    Address
    4:29
  • 41
    Cell
    1:27
  • 42
    Rand
    1:45
  • PHASE 4 : Charts
  • 43
    Charts
    4:58
  • 44
    Data Extended Chart
    10:39
  • PHASE 5 : Pivot Table
  • 45
    Creating Pivot Table
    3:26
  • 46
    Pivot Gotchas
    4:23
  • 47
    Pivot Sorting
    2:35
  • 48
    Drill Data
    3:12
  • 49
    Summarizing Data
    3:06
  • 50
    Top 10 Reports
    4:39
  • 51
    Pivot Calculation 1
    3:26
  • 52
    Pivot Calculation 2
    4:28
  • 53
    Pivot Formating
    2:02
  • 54
    Ad Hq Queries
    2:16
  • 55
    50 Reports In 5 Sec
    2:48



Share

Registration


   
 
 
 

$('.hindi-faculty').show();