No Tags Found!


View Poll Results: Type Of Training
Online 9 56.25%
Center 1 6.25%
Video 4 25.00%
Book 11 68.75%
Multiple Choice Poll. Voters: 16. You may not vote on this poll

excelmis1
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
From India, Pune
excelmis1
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

From India, Pune
excelmis1
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


From India, Pune
prashant1668
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

From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.