•   Visitors:
  •   B-2/19A, Yamuna Vihar, Delhi-53

Course Overview

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: 65-70 Hrs with Highly Skilled Corporate Trainers [2 Modules]

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

Module 1 : Basic & Advance Excel Objective [Duration : 25-30 Hrs]

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.

  • Sum, Count, Conta, Count blank, Average, Max, Large Min, Abs, Sum if, Count if, Sum ifs, Count ifs, Lowers, Upper, Proper, Trim, Len, Left, Right, Mid,
  • Concatenate, Subtotal, And, Or, Day, Year, Eo month, E date, Net workdays, Today, Weekday, Week number, Workday, Find, Search, V-lookup, H-lookup, Match, Ifferror, Ifna, If, Index, Offset
  • Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Single and Multiple Charts/Graphs, Conditional Formatting, Data Validation, Group & Ungroup, Data split.
  • Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
  • Report Development - (Live Project)
  • Placement Assistance

Module 2 : Dashboard & VBA Objective [Duration: 35-40 Hrs]

Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively.

Latest Jobs

Enquire About a Course

Placed Learners