Advance Excel Feature

Microsoft Excel is perhapes the most important computer software program used workplace today.

Excel Contents:
Section - 1 Make a start with Excel

Working with worksheet
Number formatting
Cell Reference
Fill series
Working with Functions :- Mathematical, Statistical, Text, Date

Section - 2 Working with Advance Functions

Logical Functions:- IF, AND,OR,NOT
Financial Functions:- PMT,PV,RATE,FV & More
Lookup Functions:- VLOOKUP & HLOOKUP
Match and Index Functions
Depreciation Functions
Database Functions
Information Functions

Section - 3 Processing Data in Excel

Spark Line
Pivot Table & Charts
Conditional Formatting
Data Validation
What-if-Analysis Tool(Goal Seek,Solver,Scenario & Data Table)
Auto & Advance Filter
Sorting,Subtotal,Consolidate
Formula Auditing
Workbook Protection
Creating Templates



Feedback job publisher: Navneet | job publish date : 08:24
|
Suggest job to a friend :

5 KANPURIYA: Advance Excel Feature Microsoft Excel is perhapes the most important computer software program used workplace today. Excel Contents: Section - 1 Make a start ...

No comments :

comment on job