SKU: 006-1 Category:



Call us on 9881196664 or mail to preetib@techcraftonline.com

We conduct Certification in Advance Excel & MIS reports which is very meticulously developed and helps you to develop advanced skills in excel,reporting  and grow in your career.

Duration: 2 Month ( Only Sunday)

Batch Timings : 11 am to 1.30 pm

We will be Providing:

1) PC for Working

2) Certificate

3) Excel files of the course content.

1) Basics of Excel:
Revisiting Excel Basics, Writing Basic Formula like Add, Subtract, Multiply, Divide, Logical &Text
formulas.Excel Operators. BODMAS/Formula error checking.Excel Sheet Formatting. Working with
Dates – Concept,Correction techniques Dateformulas: TEXT(), EOMONTH(),EDATE(), DATE().

2) Relative,Absolute & Mixed Referencing:
Creating Absolute/Mixed References. Problems with Absolute/Relative Cell Referencing

3) Look up Functions:
VLOOKUP() – a practical perspective.VLOOKUP() w. TRUE – When & Why? VLOOKUP() with MATCH()
2-D lookup.INDIRECT() + Range Naming for 3-D lookup INDEX() and 2 MATCH() – reverse lookup

4) Pivot Tables:
Creating, Formatting Simple PivotTables.Page Fieldin a PivotTable.Formatting a PivotTable.Creating/
Modifying a PivotChartIF(), Nested IFs, AND(), OR() Combo Logics; IFERROR().Building Complex Formulas.

6) MIS Reporting & Dashboard Techniques :
Automatic row-wise Subtotal,Gridlines,Data Validation (list),Cell-Range Naming,Grouping.Build
Business reports like Sales,Inventory,Salary report,dashboards etc.

7) Advanced Charting:
Creating Multiple Chart Type,Primary, Secondary Chart ,Trend line Charting, Spark Line,Dynamic
Charting Techniques.

8) Protection,Import and Export of Data:
Sharing Workbooks & Tracking Changes, Protectingsheets / workbooks / Files. Importing Data from
Text Files/ Web, Exporting Data.

9) Macros Application:

Developer tab; Visual Basic Editor (VBE) Record & Run a Macro.

10) Data Cleaning:
Learn Data Cleaning Techniques.



Ranjit Kate
MBA Finance
Faculty has 5 years experience in Advanced excel training and MIS reporting.

Course Introduction:

Sample Certificate :


There are no reviews yet.

Be the first to review “Certification in Advanced Excel & MIS Reports starting on 05th May 2019”

Your email address will not be published. Required fields are marked *