• Asia’s #1 & Only Award Winning MS-Excel (Advanced) Training Program WITH 100% PLACEMENT ASSISTANCE

Enter Your Details



MIS & Data Analytics Using MS-Excel

Complete Advance Excel, Data Analytics, MIS Reporting

BESTSELLER

    4.7       6345 students enrolled this month

Offer by ATTITUDE ACADEMY    Last updated:- Jun 15, 2020

What you'll learn

  • Introduction to Excel

  • Basic Understanding Menu and Toolbar

  • Introduction to different category of functions like Basics

  • Mathematical and Statistical

  • Date and Time

  • Logical

  • Lookup and References

  • Text and Information

  • MACROS

  • Organising & Presenting Data

  • Auditing worksheets & Analysis Data

  • Import/Export & Publishing the Data.

Requirements

  • You must be a little familiar with Computer.
  • Innovative and Creative Ideas.

Description

Advance Excel is best computer course who wants to learn MIS Data Entry. this Advance Excel courses notes is also useful for beginners and the students who wants to apply for government jobs, because today all vacancy additional eligibility are Advance Excel certificate. So it is good option for start to increase your computer application skills and also internet skills this is very beneficial for who needed jobs after Advance Excel. So many jobs after Advance Excel Course jobs , many small firms recruits candidates who have Advance Excel certificate and job profile will be Data Entry, Handling huge record, accounting section, MIS jobs, etc.

Module -1

  • Introduction to Excel

  • Basic Understanding Menu and Toolbar

  • Introduction to different category of functions like Basics

Module-2

  • Text Functions
    UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,FIND,LEN,TRIM....
  • DATE & TIME
    DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF
  • FINANCIAL
    DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,.....
  • LOGICAL
    IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
  • LOOKUP & REFERENCES
    LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,HYPERLINK....
  • MATHEMATICS
    SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,COS,PI,ROUND,POWER,PRODUCT

Module-3

  • STREAMING WORKFLOW
    CREATE A MACRO
    EDIT A MACRO
    APPLY CONDITIONAL FORMATING
    ADD DATA VALIDATION CRITERIA
    UPDATE A WORKBOOK PROPERTIES
    MODIFYING EXCEL DEFAULT SETTIING
  • COLLABORATING WITH OTHERS
    PROTECT FILES
    SHARE A WORKBOOK
    SET REVISION TRACKING
    MERGE WORKBOOK
    ADMINISTRATOR DIGITAL SIGNATURE

Module-4

  • CALCULATING DATA WITH ADVANCE FORMULA
    MANAGE CELL & RANGE NAME
    CALCULATING DATA ACROSS WORKSHEETS
    USE SPECIAL FUNCTIONS
    USING FORMULA TO SEPERATE DATA INTO SEPERATE COL.
    LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
  • Organizing Worksheet And Table Data
    Create A Chart
    Chart Element
    Changing A Chart Type
    Modifying A Chart
    Format A Chart
    Set Up Dynamic & Intreactive Chart
    Calculating In Pivot Table

Module-5

  • Auditing WorkSheets
    Trace Cell
    Trouble Shoot Error In Formulas
    Troubleshoot invalid Data And Formula
    Watch And Evalute Formula
  • Analyzing Data
    Create A Scenarios
    Perform What-if-analysis
    Perform Statistical Analysis
    Anlysis Toolpack

Module-6

  • Organizing Sheet And Table Data
    Table
    Create Table Dialog Box
    Styles And Quick Style Set
    Formate Table
    Sort Or Filter Worksheet Or Table Data
    Database function…….Dsum(), Daverage(),Dcount()
  • Inserting Graphics Object
    Insert And Modify Picture And Clipart
    Draw And Modify Shapes
    Illustrate Workflow Using SmartArt graphics
    Layer And Group Graphics Object
    Customizing And Enahancing Workbook
    Customizing Workbook
    Manage Themes
    Create And Use Template(ex-bills)

Module-7

Exporting Excel Data
Importing Delimited Text File
Publish A Worksheet To The Web
Importing Data From The Web

Limited Period Offer
INR 1499/- INR 5000/- 70% Off
Book Now

7 Days Money-Back Guarantee*

Includes

What you'll learn

  • Introduction to Excel

  • Basic Understanding Menu and Toolbar

  • Introduction to different category of functions like Basics

  • Mathematical and Statistical

  • Date and Time

  • Logical

  • Lookup and References

  • Text and Information

  • MACROS

  • Organising & Presenting Data

  • Auditing worksheets & Analysis Data

  • Import/Export & Publishing the Data.

Requirements

  • You must be a little familiar with Computer.
  • Innovative and Creative Ideas.

Description

Advance Excel is best computer course who wants to learn MIS Data Entry. this Advance Excel courses notes is also useful for beginners and the students who wants to apply for government jobs, because today all vacancy additional eligibility are Advance Excel certificate. So it is good option for start to increase your computer application skills and also internet skills this is very beneficial for who needed jobs after Advance Excel. So many jobs after Advance Excel Course jobs , many small firms recruits candidates who have Advance Excel certificate and job profile will be Data Entry, Handling huge record, accounting section, MIS jobs, etc.

Module -1

  • Introduction to Excel

  • Basic Understanding Menu and Toolbar

  • Introduction to different category of functions like Basics

Module-2

  • Text Functions
    UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,FIND,LEN,TRIM....
  • DATE & TIME
    DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF
  • FINANCIAL
    DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,.....
  • LOGICAL
    IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
  • LOOKUP & REFERENCES
    LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,HYPERLINK....
  • MATHEMATICS
    SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,COS,PI,ROUND,POWER,PRODUCT

Module-3

  • STREAMING WORKFLOW
    CREATE A MACRO
    EDIT A MACRO
    APPLY CONDITIONAL FORMATING
    ADD DATA VALIDATION CRITERIA
    UPDATE A WORKBOOK PROPERTIES
    MODIFYING EXCEL DEFAULT SETTIING
  • COLLABORATING WITH OTHERS
    PROTECT FILES
    SHARE A WORKBOOK
    SET REVISION TRACKING
    MERGE WORKBOOK
    ADMINISTRATOR DIGITAL SIGNATURE

Module-4

  • CALCULATING DATA WITH ADVANCE FORMULA
    MANAGE CELL & RANGE NAME
    CALCULATING DATA ACROSS WORKSHEETS
    USE SPECIAL FUNCTIONS
    USING FORMULA TO SEPERATE DATA INTO SEPERATE COL.
    LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
  • Organizing Worksheet And Table Data
    Create A Chart
    Chart Element
    Changing A Chart Type
    Modifying A Chart
    Format A Chart
    Set Up Dynamic & Intreactive Chart
    Calculating In Pivot Table

Module-5

  • Auditing WorkSheets
    Trace Cell
    Trouble Shoot Error In Formulas
    Troubleshoot invalid Data And Formula
    Watch And Evalute Formula
  • Analyzing Data
    Create A Scenarios
    Perform What-if-analysis
    Perform Statistical Analysis
    Anlysis Toolpack

Module-6

  • Organizing Sheet And Table Data
    Table
    Create Table Dialog Box
    Styles And Quick Style Set
    Formate Table
    Sort Or Filter Worksheet Or Table Data
    Database function…….Dsum(), Daverage(),Dcount()
  • Inserting Graphics Object
    Insert And Modify Picture And Clipart
    Draw And Modify Shapes
    Illustrate Workflow Using SmartArt graphics
    Layer And Group Graphics Object
    Customizing And Enahancing Workbook
    Customizing Workbook
    Manage Themes
    Create And Use Template(ex-bills)

Module-7

Exporting Excel Data
Importing Delimited Text File
Publish A Worksheet To The Web
Importing Data From The Web

Placed Learners


Related Courses

Why Choose Us

BEST FACULTY

100+ BATCHES

100% PRACTICAL

24*7 ONLINE ACCESS

8,676 + PLACED

10+ YEARS

Enter Your Details

Still have questions? Call @+91-9654382235 for answers

  CALL NOW