2 days workshop on Advance Excel

Sale Date Ended

INR 1800
Sold Out

Invite friends

Page Views : 13

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.

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.

Date: 12th and 13th May 2018.

Time: 10 am to 5 pm

Fees: 1800/-