excelmis1 Started The Discussion:
I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays. Call-8802579388
16th March 2012 From India, Pune

I provide training on Excel VBA which includes Excel formulae and simple VBA programs for beginners; then advanced VBA at the later stages. This is a job oriented training that helps you in getting job in various organisations. This training is done on Saturdays and Sundays
Call- 8802579388

16th March 2012 From India, Pune
Advanced MS Excel Course Content

Advanced Functions

IF Function & Nested IF Statements

And & Or Functions

Lookup Functions (Horizontal And Vertical Lookup

Index Function

Array Function

Subtotals

Conditional Formatting

3D Ranges

Create & Maintain (Within Worksheets In a Single File & Between External Files)

Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Pivot Tables

Create Pivot Table

Work With Row/ Column Fields

Data Fields

Customise Table Display

Organising Workbooks

Create Templates

Styles

Protect Ranges & Worksheets

Data

Enter & Select Records Using The Input Form

Sort Data Into Lists

Filter Data - Autofilter, Advanced Filter

DataBase Functions

Validation Rules

Goal Seeking

Solver

Goal Seeking With Charts

What-If

Scenarios

Create Scenarios

Create Summary Report

Merge Scenarios

Protect Scenarios

Macros

Create Macros Record

Relative Referencing

Assign To Toolbars/ Keyboard

Make Available To All New Documents/ Current Document Only

Outlines

Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae

Display Summary Rows And Summary Styles

Custom Views

Create, Modify, Delete

Include Hidden Rows, Columns, Filter Settings

Report Manager

Create, Modify, Delete

Create Sections (Sheet, View1, Scenario)

Contact : -

Sujeet Kumar

8802579388


16th March 2012 From India, Pune
Hi,
I am Microsoft Certified Trainer and have an experience more than 7 year in this field. Below is my contact details. You can contact me any time and I am open to travel. Thank you!
Regards,
Prashant Pardeshi
9867163640 / 8080588159
prashant1668@gmail.com
12th July 2015 From India, Mumbai
Please share if you have any insights for this topic page and be part of our fostered professional community at Cite.Co. Avoid "Thank You" posts to preserve the integrity and readability of this page. Instead, help someone else with your knowledgeable inputs. If you have any related query please start a discussion thread.



 
 
 
 





Anonymous (Don't Display Username)


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network