• Asia’s #1 & Only Award Winning Training Program WITH 100% PLACEMENT ASSISTANCE

Enter Your Details



BESTSELLER

    4.7 (373 ratings)       1800+ students enrolled this month

Offer by ATTITUDE ACADEMY    Last updated:- Jan 1, 1970

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

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 /- INR /- NAN% 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

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

ENQUIRE NOW