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
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
Career | Knowledge
No comments :
comment on job