Book Online Tickets for 2 days workshop on Advance Excel, Pune.  
 
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:

2 days workshop on Advance Excel

 

  • Advance Excel

    Sale Date Ended

    INR 1800
    Sold Out

Invite friends

Contact Us

Page Views : 12

About The Event

 

 

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/-

 

 

 

More Events From Same Organizer

Similar Category Events

    Venue Map