Categories

Advanced Excel Training helps managers to understand various difficult issues related to MS excel. MIS course by IIT Computer assurances value additions in terms development of managers and other employees of the organisation.

Microsoft Excel is an automated spreadsheet package used to store, organize and manipulate data. Nowadays, it is one of the most public software tool used maintain sales tendency, generate documents and execute other finance-related activities.

From the viewing platform of the boss, mostly those in the field of Management Information Systems (MIS), use of Excel as an end-user calculating tool is necessary.

After following this course, you can THINK like Excel, and write dominant and forceful formulas from mark and understand shortcut techniques for earlier and capable use of Excel.

MBA CA’s CS and other working people can come and solve their problem in few days learning. Advanced excel classes in delhi Badarpur are conducted on weekends. It become more and more convinient for working persons to join advanced advanced excel course.

Industry experienced corporate trainer takes up classes in small group to teach various advanced functions and techniques, small size batch gives individual attention to each participant.

 

Course Contents

  • Working with Excel Files
  • Entering data
  • Working with numbers
  • Formatting data
  • Managing your data in excel worksheet
  • Working with text and date
  • Manipulating data
  • Working with charts
  • Working with pivot table
  • What if analysis
  • Excel Formulas
  • Conditional Statements & Logical Operator
  • Statistical Functions
  • Lookup/Reference Functions
  • Text Functions
  • Date & Time Functions
  • Formula-Based Formatting
  • Array Formulas
  • VBA and Macros
  • Grouping and outlining data
  • Financial Analysis & Reporting
  • Shortcut keys and references

Students during this course will cover 8 certifications and will be able to do and understand:

  • Microsoft Office Specialist
  • CCC by NIELIT (Course on Computer Concepts)
  • Adobe Certified Associate- Visual Communication Using Adobe Photoshop
  • Adobe Certified Associate- Web Authoring Using Adobe Dreamweaver
  • Adobe Certified Associate- Web Authoring Using Adobe Dreamweaver
  • Adobe Certified Associate- Print& Digital Media Publication Using Adobe InDesign
  • Adobe Certified Associate- Interactive Media Using Adobe Flash Professional
  • Oxford Certified Graphics- Web-2D Design Professional

All certification products and company names are trademarks™ or registered® trademarks of their respective holders. All certification exams are subject to availability and are subject to change or completely removed without prior notice. We do not ensure that participation in any of the above will result in successful completion of the certification/examination. Also the student need to pay the respective examination fee for certification for every attempt.

Career Opportunities

In the current job scenario, this course will offer an absolutely stunning career options as follows :

Data Analyst/Consultant

Financial Planner

Financial Research

Business Analyst

Portfolio Researcher

Account Assistant

Consultant

MIS Executive