Sale Date Ended
Greetings from Techcraft !!
We are conducting 2 Days Certification course in Advance Excel on 12th and 13th May 2018.
Below is course content which would be practically covered in 2 days.
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 Date formulas: 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, Trendline Charting, Spark Line, Dynamic
Charting Techniques.
8) Protection, Import and Export of Data:
Sharing Workbooks & Tracking Changes, Protecting sheets/workbooks / Files. Importing Data from
Text Files/ Web, Exporting Data.
9) Macros Application:
Developer tab; Visual Basic Editor (VBE) Record & Run a Macro, Writing Macros.
10) Data Cleaning:
Learn Data Cleaning Techniques.
Address- Office no.24, 2nd Floor,Mudra Commercials, Above PN Gadgil, Opp. D Mart, Pune-Satara Road, Bibvewadi, Pune, Maharashtra 411037
Date: 12th and 13th May 2018.
Time: 10 am to 5 pm
Fees: 1800/-
