Advanced Excel -

Diploma in Excel & Advanced Excel Course

Diploma in Excel & Advanced Excel Course
Rs. 9,550 5,990 /-

Overview

Softpro offers professional courses in Advanced Excel. The Advanced Excel course in Mumbai is a short-term course for students from accounting, finance and Management background. With the application of the formulas & functions your financial analysis skills to the next level.

Course Content

MODULE 1. ADVANCED EXCEL DIPLOMA

Sub Total Reports, Auto Filter
Sorting Data
Password Protecting Worksheets
Linking Multiple Sheets
Sheet Referencing
Linking Between Word/Excel/Ppt
COUNTIF, SUMIF.
What-if-analysis
Pivot Tables, Pivot Charts
NESTED IF
Reporting

Character Functions
Scenario Manager
Date Functions
Age Calculations
Consolidation of Data
Data Validation
Logical Functions
MACROS Definition & Concepts
Record & Run a Macro
Store a Macro
Intro to VBA Prog (25 Projects)

MODULE 2. MS EXCEL

Electronic Spreadsheet basics
Formatting Fonts, Numbers
Relative & Absolute Reference
Date & Currency Formatting
Formula charts & Graphs
2D/3D Graphs, Pie, Line Cone
Formatting Charts
Data Values

Other Courses

Tally PRO Executive

Tally ERP, Tally Champs, GST, Inventory & Accounting

Advanced Excel Course

Formulas & functions, financial analysis.

Corporate Advanced Excel

Lookup, Pivot Tables, Macro’s, Function, Data Analysis

Financial Accounting & Master Excel

Excel, Tally ERP, Tally Champs, GST, Inventory & Accounting, Macros

Facilities & Features
Eligibility
Course Fee Includes
Timings

1. Honest Counselling : Choose the Right Course @ Right Price.
2. Small Batches 7-10 Students leads to Personal Attention.
3. 100% Practicals with Projects.
4. Original, Leagal & Official Software from Autodesk, Adobe.
5. Industry Endrosed Cirriculum.
6. Highly Trained, Experienced & Certified Faculty.
7. High Emphasis on Projects & Assignments.
8. Friendly, Supportive, Patient & Qualified Faculty.
9. Easy Installment Facility.

Who Can Do This Course:

Graduates, Undergraduates, 10+2
Having the minimum knowledge on Bussiness management
Commerce Subject Students

More You Learn Less You Pay
Professional Training – Take a Free DEMO
Call 8476850580

Fees: Rs. ~~7,550~~ 4,950/-

What do my Tuition Fees include?
1. Course Book.
2. GST Included.
3. Certificate.
4. Extra Practice/Computer Time.
5. 100% Placement Assistance.

Morning Batches : 7:30-9am, 9-10am, 10-11am, 11-12pm
Afternoon Batches : 12-1pm, 1:30-2:45pm, 3-4pm, 4-5pm
Evening Batches : 5-6pm, 6-7pm, 7-8pm, 8-9pm.
Weekend & Fast Track Batches are conducted.
Please call to confirm the Timings.
Daily & Alternate Day batches are conducted.
Call 8476850580