1 / 6

Microsoft Advanced Excel Training in Delhi

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.

slaconsultantsindia
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Get in touch 9999491895 MIS & Reporting Advance Excel & Reporting VBA, Macros & Reporting MS Power Pivot Training

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

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

  4. 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 | AarkExIndia@gmail.com

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

  6. Our Other Services :- ++91-9999491895 training@slaconsultantsindia.com www.slaconsultantsindia.com (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com

More Related