contactus
facebook
twitter
twitter
linkedin
youtube
googleplus

Visitor :

Demo Class
Course Enquiry Call 011- 43522158, +91-9654382235
logo
enquiry

Now you can Dynamically increase your productivity with the help of MS-Excel.By enrolling for this program not only you will acquire advanced level knowledge of spreadsheets, worksheets,tabular data and charts. you will also get your work done much faster.thus all working professionals & freshers looking for job opportunities in Banking,Insurance, FMCG,BPOs,KPOs & retail Sectors increase your proficiency so that you have a lot more time to spare for fulfilling day at work. .

Course Duration: 30-35 HRS with Highly Skilled Trainers

Attitude's MIS Training Delivery Method:
  • Web / Desktop Base
  • Instructor-Led Classroom Sessions
  • Presentations/Demonstration/Practical of Concepts.
  • Handouts/Assignments/Real-time Exposure to Work on Clients

Basic & Advance Excel Objective:

What is Excel?

Microsoft Excel is a general purpose electronic spreadsheet to use to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business

Provide Basic/Advanced Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools.

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.

functions

  • Text Functions
    UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,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,PRICE.....
  • LOGICAL
    IF,AND.OR,NOT,TRUE,FALSE,IFERROR....
  • LOOKUP & REFERENCES
    LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....
  • MATHEMATICS
    SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...
MACRO
  • STREAMING WORKFLOW
    CREATE A MACRO
    EDIT A MACRO
    APPLY CONDITIONAL FORMATING
    ADD DATA VALIDATION CRITERIA
    UPDATE A WORKBOOK PROPERTIES
    MODIFYING EXCEL DEFAULT SETTIING
  • COLLEBRATING WITH OTHERS
    PROTECT FILES
    SHARE A WORKBOOK
    SET REVISION TRACKING
    MERGE WORKBOOK
    ADMINISTRATOR DIGITAL SIGNATURE
ORGANISING AND PRESENTING DATA
  • 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
Auditing & Analaying Data
  • 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
Organizing Worksheets
  • 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)
Importing And Exporting
  • Import/Export & Publish
    Exporting Excel Data
    Importing Delimited Text File
    Publish A Worksheet To The Web
    Importing Data From The Web
    Create A Web Query

ATTITUDE offers 100% job guarantee practical career courses after 12th, Graduation in commerce or non commerce

Job & Career Options available after Advanced MS-Excel Certification

  • Investment Banking Analyst
  • Management Consultant
  • Accountant
  • Marketing
  • Business Intelligence Analyst
  • Management
Placed Learners
Download Brochure
testimonial
Hi I found the institute truly managed in professional way the name signifies its core vlaues faculties are professional in their approach.Cleaniless and simplicity are beyond imagination.

Ajay Sharma

testimonial
Nice Institute for better career prospect for trainees. The trainers were having great knowledge about corporate sectors and guide us well.

Vishal Kaushik

testimonial
Excellent way of training by trainers, simply superb! Overall all supporting staff in institute & best placement team to serve .

Hatim Tanwar

testimonial
it was really a good experience with Attitude Academy. They provided me a Very Good platform to learn and gain enough knowledge in Accounting & Taxation Course.

Anuj Raghav

testimonial
Attitude Academy support person understood our problem properly. Their service & support found quick, solution oriented. Our problem resolved perfectly. Thanks.

Pooja

testimonial
This is my first Chance to Attitude Academy. I am very happy with the solution from Attitude Academy & offcourse He provided instant support very quickly. So very thanks for him.

Sneha Saini

testimonial
Attitude Academy is Those who are using the tally, have any problem related to tally Definitely I will advice you contact Attitude Academy for tally support. Thanku very Much

Mansi

testimonial
No institute is best other than Attitude Academy for Fashion. the teaching methodology is very different from other institutions. very thanks to teacher.

Simran

testimonial
i am very much satisfy from attitude academy support. attitude system will support immediately even after office hours also. Thanks very much.

Uzma

testimonial
AttitudeTallyAcademy(ATA)is a very well respected YamunaVihar location in Delhi. ATA has been a Home away from Home for me. The Frndly attitude of the staff and their willingness to always offer a helping hand has made me feel a part of the

Rohit

testimonial
Here at ATA, you meet all the good, friendly people – from students to lecturers. You enjoy freedom to think, to express yourself and to succeed.

Krishna Verma

testimonial
With the help of ATA I have substantially improved my understanding of Information Technology . ATA is simply an example of studying in a congenial environment.

zahid hussain

testimonial
When I started thinking about attitude Tally Academy, I wanted to find an internationally respected program that balanced Accounts theory with practical skills, and provided a knowledgeable, accessible faculty. Thanku attitude academy :)

mohit kumar

testimonial
"In order to get a first class education, Attitude Academy is the most appropriate place to start!"

Rishi Anand

testimonial
"I enjoyed studying at Attitude Academy as all of my teachers were great and helpful."

Shyamanand

testimonial
"Studying at Attitude Academy has been one of my best decisions ever."

Rais Ahmad

testimonial
"While studying at Aattitude Academy, I grew as an individual, learning to interact and talk to people from different backgrounds."

Dipanshu

testimonial
"I have always felt that I was so lucky to be a student at Aattitude Tally Academy, and not at any other Academy. The thing I admire the most about Aattitude Tally Academy is the support I received from everyone at the Academy.

Sumit Gaur

testimonial
Institute services is very good ,Faculties are well qualified in this institute , I like my course very much, Rahul sharma is my teacher he has good knowledge of Web,Graphic designing

Anuradha

testimonial
Deep in the Dark forest there is a beautiful garden of knowledge , Where techie Butterflies are play around the flowers of technology. ATTITUDE just not trained for technology but it trains people for their success in their life .

Divya

testimonial
For me ATTITUDE is the best decision I ever made because it combines knowledge, virtues and creativity. For students, implied knowledge is very useful and ATTITUDE is a very good platform for career.

Bhawna Kaushik

testimonial
A life changing experience. ATTITUDE provides excellent opportunities to fresher. Those who want both good knowledge and good career in Accounts and IT sector must join ATTITUDE. I felt very glad as my dream comes true .

Muskan

testimonial
I am proud to be a part of ATTITUDE. I had a chance to do more practical things rather the just reading theory. Everybody here in ATTITUDE are very helpful .and I would like to thank Turab sir for being my teacher .

Avinash Sharma

testimonial
Deep in the Dark forest there is a beautiful garden of knowledge , Where techie Butterflies are play around the flowers of technology. ATTITUDE just not trained for technology but it trains people for their success in their life .

Jatin Goel

testimonial
A life changing experience. ATTITUDE provides excellent opportunities to fresher. Those who want both good knowledge and good career in Accounts and IT sector must join ATTITUDE. I felt very glad as my dream comes true as I got good job frm

Priya

testimonial
I Piyush student of B.Com, has done training from ATTITUDE, is grateful to this institute where I learnt, enhanced my knowledge and technical slot. This institute is the best place not only for Tally but for all accounting concepts .

Piyush

testimonial
I had a great expercience with ATTITUDE all the staff of ATTITUDE was very helpfull including teachers and hrdepartment.I would like to thanks specially Turab sir and Kanchan mam for their great support and solve my queries whenever i have

Savita Gupta

testimonial
I feel really proud of to be a part of ATTITUDE. I have had a great time. Here I came to learn so many practical things here, first of all I would like to pay my thanks to Mr. Sachin Sharma for training us so well and for creating the spark

Dheeraj Sharma

testimonial
Just a quick Note to say thanks ATTITUDE .I am proud to be part of ATTITUDE . Here every staff and Teachers are very Co-operative with Students .I Would like to thanks Mr. Puneet sir he is very kind person he Taught me IT Skills .

Nasir Malik

testimonial
I am proud to be a part of ATTITUDE. I had a chance to do more practical things rather the just reading theory. Everybody here in ATTITUDE are very helpful .and I would like to thank Turab sir for being my teacher .

Piyush Gupta

testimonial
For me ATTITUDE is the best decision I ever made because it combines knowledge, virtues and creativity. For students, implied knowledge is very useful and ATTITUDE is a very good platform for career.

Aashu Thakur

ENQUIRY NOW