Get
This presentation is the property of its rightful owner.
Sponsored Links
1 / 6

Microsoft Advanced Excel Training in Delhi PowerPoint PPT Presentation


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.

Download Presentation

Microsoft Advanced Excel Training in Delhi

An Image/Link below is provided (as is) to download presentation

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

Presentation Transcript


Microsoft advanced excel training in delhi

Get in touch

9999491895

MIS

&

Reporting

Advance Excel

&

Reporting

VBA, Macros

&

Reporting

MS Power

Pivot Training


Mis analytics course content

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 | [email protected]


Microsoft advanced excel course content

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 | [email protected]


Vba macros course content

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

Testing and Debugging Your Code

Effective Error Handling

Automation Development Reports & Live Projects

(c) www.AarkEx.com | 0091-86 8989 5577 | [email protected]


Ms power pivot course content

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 | [email protected]


Our other services

Our Other Services :-

++91-9999491895

[email protected]

www.slaconsultantsindia.com

(c) www.AarkEx.com | 0091-868989 5577 | [email protected]


  • Login