# Microsoft Advanced Excel Training in Delhi - PowerPoint PPT Presentation

1 / 6

If you are looking for the best provider of MS Advanced Excel Training, Course, Tutorial, Microsoft Advanced Excel 2010 Training Institute in Delhi NCR, Meerut, Hapur, Muzaffarnagar, Noida, gurgaon Excel Software Training Delhi then you must give a chance to SLA Consultants as we will teach you all shortcuts of MS Excel Online.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Microsoft Advanced Excel Training in Delhi

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Get in touch

9999491895

MIS

&

Reporting

&

Reporting

VBA, Macros

&

Reporting

MS Power

Pivot Training

### MIS & Analytics Course Content

Module-1 | Basic & Advance Excel Objective:

• Lookup & Reference Functions:-

• Mathematical Functions:-

• Text Functions:-

• Date & Time Function

• Logical Functions:-

• Other Functions:-

Module-2 |DASHBOARD & VBA / Macros Programming Objective

• Excel VBA Power Programming For VBA Macros

• Overview of Using User forms To Create Business Wizards

• Connection between Excel VBA & other platforms

• Testing and Debugging Your Code

• Automation Development Reports & Live Projects

Module-3 | MS - Access & SQL

• Basic Key skills:

• - Basic Computer Skills

• Basic Microsoft Office Knowledge

(c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com

### Microsoft Advanced Excel Course Content

Module- |

Mathematical Functions:-

Text Functions:-

Date & Time Function:

Logical Functions:-

Lookup & Reference Functions:-

Other Functions:-

(c) www.AarkEx.com | 0091-86 8989 5577 | AarkExIndia@gmail.com

### VBA & Macros Course Content

Module- |

Introduction to Programming Introduction to logical thinking flowcharts & algorithms:

Complete Review of the VBA Language (Subs,Functions,Variables,Arrays,Loops,Logic...etc.)

Excel VBA Power Programming For VBA Macros

Overview of Using User forms To Create Business Wizards

Connection between Excel VBA & other platforms

Effective Error Handling

Automation Development Reports & Live Projects

(c) www.AarkEx.com | 0091-86 8989 5577 | AarkExIndia@gmail.com

### MS Power Pivot Course Content

Module -|

MS Power Pivot Practical Training Course -

Basics of MS Power Pivot for Excel - 2013

Start the Power Pivot in Microsoft Excel add-in

Troubleshooting: Power Pivot Ribbon Disappears

Power Pivot Creating a Data Model in Excel 2013

Adding more tables to the Data Model using Existing Connection – In Power Pivot

Add relationships to Data Model in Power Pivot

How to add Filter for data retrieval in Power Pivot Data model.

Create a calculated column in Power Pivot

Add Slicers to PivotTables in Power Pivot

Import data using copy and paste from Excel sheet or other source for Power Pivot Data Model.

Add a relationship using Diagram View in Power Pivot

Extend the Data Model using calculated columns

Create a Power View report

Create a calculated field in Power Pivot

Set field defaults in Power Pivot

Set Table Behavior in Power Pivot

Set Data Categories for fields in Power Pivot

(c) www.AarkEx.com | 0091-86 8989 5577 | AarkExIndia@gmail.com

### Our Other Services :-

++91-9999491895

training@slaconsultantsindia.com

www.slaconsultantsindia.com

(c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com