Course objective : To learn the Basic to advanced formulas, tools & functions of Microsoft excel to calculate, analyse & prepare reports to be an Excel power user.

Duration : 1 Month

Eligibility : Graduate, Accountants, Tax consultants, any one

Knowledge Level : Expert

Advanced Excel training course train you a huge array of skills, including the ability to Visualize and manipulate data. Build complex equations to help you pose and answer questions about company finances, efficiency, workflow, inventory and much more Keywords Excel training course, MS office excel, Microsoft Excel training, MIS Reporting, Training of Mis Reporting, Best Mis reporting training institute, excel training course, excel training in Delhi, Excel certification course, learn advance excel, learn pivot table, Learn v-look up, learn mis reporting

Rating 4.8 (275 ratings) 3154 students enrolled

Quick Enquiry

 
 
 
 
 
 
 
 

Course Description

To develop among the candidate understanding concept of accounting, Understanding of latest busy accounting software, Invoicing through busy, Inventory management and others advance features of busy accounting software.

Course Features

image/7.jpg

I. Customizing common options in Excel II. Absolute and relative cells III. Protecting and un-protecting worksheets and cells Working with Functions I. Writing conditional expressions (using IF) II. Using logical functions (AND, OR, NOT) III. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX) IV. VlookUP with Exact Match, Approximate Match V. Nested VlookUP with Exact Match VI. VlookUP with Tables, Dynamic Ranges VII. Nested VlookUP with Exact Match VIII. Using VLookUP to consolidate Data from Multiple Sheets

I. Specifying a valid range of values for a cell II. Specifying a list of valid values for a cell III. Specifying custom validations based on formula for a cell.

I. Designing the structure of a template II. Using templates for standardization of worksheets

I. Sorting tables II. Using multiple-level sorting III. Using custom sorting IV. Filtering data for selected view (AutoFilter) V. Using advanced filter options.

I. Creating subtotals II. Multiple-level subtotals III. Creating Pivot tables IV. Formatting and customizing Pivot tables V. Using advanced options of Pivot tables VI. Pivot charts VII. Consolidating data from multiple sheets and files using Pivot tables VIII. Using external data sources IX. Using data consolidation feature to consolidate data X. Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field) XI. Viewing Subtotal under Pivot XII. Creating Slicers ( Version 2010 & Above).

I. Date and time functions II. Text functions III. Database functions IV. Power Functions (CountIf, CountIFS, SumIF, SumIfS).

I. Using auto formatting option for worksheets II. Using conditional formatting option for rows, columns and cells Macros I. Relative & Absolute Macros II. Editing Macro's.

I. Goal Seek II. Data Tables III. Scenario Manage

I. Using Charts II. Formatting Charts III. Using 3D Graphs IV. Using Bar and Line Chart together V. Using Secondary Axis in Graphs VI. Sharing Charts with PowerPoint / MS Word, Dynamically VII. (Data Modified in Excel, Chart would automatically get updated) New Features Of Excel I. Sparklines, Inline Charts, data Charts II. Overview of all the new features Final Assignment The Final Assignment would test contains questions to be solved at the end of the Course.

Training And Selection Process

Enrollment & Live Free Demo Classes

Cousre Training

Interview Preperation

Job Interview

Final Selection

KNOW YOUR MENTORS

CMA GAURAV KUMAR

Qualification : FCMA,B.COM(H)

Experience : 15 yrs.

Experties : Cost Accountancy, ROC Compliance, MIS Reporting

Introduction : CMA Gaurav Kumar, a fellow member of The Institute of Cost accountant of India & a Hons commerce graduate from University of Delhi, has a overall experience of near about two decades in accountancy, Cost accountancy, Indirect tax & managing various statutory compliances and audit. He has taken more than two thousands training session on various topic on GST, Roc compliances, Cost audit and advance Microsoft excel. With the knowledge and practical skillset of CMA GAURAV KUMAR, more than 12000+ students get benefit on learning of practical aspect of Cost accounting, Goods & Service tax, Roc compliances and Mis Reporting. Apart from training, he is also a Cost & Indirect tax consultants in New Delhi where he is giving his service to more than 250 companies across India.

Training session : 500 Plus

Student trained : 12000 Plus

CMA GAURAV KUMAR

MR. SANTOSH KUMAR

Qualification : B.com

Experience : 5 yrs.

Experties : Accountancy, Training

Introduction : Mr. Santosh kumar, a commerce graduate from University of Delhi, has an overall experience of near about half of decades in providing training of computerised accountancy. He is also head board of studies and training where he continuously making his effort toward developing latest study material and training & practice material for the students.

Training session : 250 Plus

Mr. SANTOSH

FAQ

A basic Knowledge of Computer, Internet. Qualification may be 12th pass out or Under-graduate/Graduate/Post Graduate

Duration of the course will be about 4 to 6 months. Those who have commerce background can complete this course in 4 months.

Institute all the faculty members are highly qualified like Chartered Accountant/ Cost Accountants, Company Secretaries, Lawyers & Post Graduate Most important thing about faculty members is they are into practice and have great command over practical learning of the subject that they gained through managing and doing task of the clients.

Yes Institute is Registered by the various Government bodies, professionals certification bodies and education partners of Accounting software Institute is registered with Ministry of corporate affairs, Ministry of MSME, National Skills development corporation of India( NSDC), Certified & Authorised by Tally & Busy Accounting software

Yes, You will get course completion certificate from the intitute.

Yes, Your certificate are totally valid and also any person can verify certificate issued on our portal and also on Tally online portal.

A Minimum 2 hrs of classes will be provided every day. However a person desirous to take more classes can take additional classes as per his/her choice.

Yes, Institute provide Instalment option without any extra payment.

A non commerce background can also joined this course. We focus on the entire learning along with the basic concept which a candidate required, whether is theoretically or practically.

Everyday, during entire course, you will be provided actual and live clients accounting & taxation data along with the Assignment and online assessment portal. Classroom are fully computerised and every system is connected through Internet and Latest full version of accounting software. All the taxation relating training are provided on Online Government portal. You will get a hand on experiences on Calculating taxes, depositing challans and filling of various returns.

Students Reviews

Other Reviews

Happy Clients

Quick Enquiry