Ms Excel Tutorial

اکاؤٹينگ کیلۓ ما ئيکروسافٹ آفس کا اہم ترين پروگرام ما ئيکروسافٹ ايکسل سيکھیں۔ نيچے ويڈ یو کلک کريں۔


Microsoft Office is used all over the World for different office work solutions. Ms Office primary kit consists of different applications, like Ms Word, Ms Excel, Ms Powerpoint and Ms Access,  which are largely being used for all offce requirements.

Content of the Complete Course


(You can Get DVDs, Easy Notes and Short Cut Keys also available on Demand by sending SMS- or Calling at 0334 334 4464)
After Completing Course, you can also get Board – University Affiliated Recognized Certificate by giving Online Test.

1. Introduction
Worksheet sizes
Printing the excel row and columns headings
How to check Spell check
Work Sheet Preview
Viewing workbook side by side
Printing options
Page orientation
Paper size
Margins
Scaling
Printing
Proof Reading
Exporting files in other Fromats

2. GUI and Menus

3. Functions and formulas
Getting help with functions
Nested functions
Consolidating data using A 3D reference sum function

4.Mathematical functions

Round
Rounddown
Roundup

5.Logical functions

IF
AND
OR

6.Mathematical functions

SUMIF

7.Statistical functions

COUNT
COUNTA
COUNTIF
COUNTBLANK
rank

8.text functions

left
Right
Mid
Trim
Concatenate

9.Financial functions
NPV
RATE
PMTFV
PV

10. Managing Database
DSUM
DMIN
DMAX
DCOUNT
DAVERAGE

11. Lookup functions

VLOOKUP
HLOOKUP

12.Named ranges

Naming cell ranges
Removing a named range
Named cell ranges and functions

13.Cell formatting

Applying styles to a range
Conditional formatting
Custom number format

14.Manipulating worksheets

Copying or moving worksheet between workbooks
Splitting a window
Hiding rows
Hiding columns
Hiding worksheets
Un-hiding rows
Unhiding columns
Un-hiding worksheets

15. Creating and using a pivot table
Filtering and sorting data within a pivot table
Automatically grouping data in a pivot table and renaming groups
Manually grouping data in a pivot table and renaming groups

16.Paste special options

Using paste special to Add, subtract, multiply and divide
Using paste special values
Using paste special transpose options

17. Templates

Using templates
Creating excel templates
Displaying hidden templates folders on a Window 7 computer
Editing excel templates in a window 7 computer
Displaying hidden templates folders on a window vista computer
Displaying hidden templates folders on a window XP computer
Editing excel templates on a window XP computerPivot tables

18.Input tables

One-input data table
Two-input data table

19.Charts

Creating a combined line and column chart
Adding a secondary axis to chart
Changing the chart type for a particular data series
Adding a data series to a chart
Removing a data series from a chart
Repositioning chart title
Repositioning the chart legend
Moving and formatting chart data labels
Modifying chart axis scales
Formatting an axis to display using comma
Inserting images into chart column
Inserting images to chart bars
Formatting the chart plot area using a picture
Formatting the chart area using a picture

20.Linking and embedding

What is embedding and linking
Linking data within a work sheet
Linking cells between worksheets within a work book
Linking data between workbook
Linking data from excel to word document
Linking an excel chart to a word document
Updating, locking and breaking links

21. Hyperlinks

Inserting a hyperlink
Editing a hyperlink
Removing a hyperlink

LEARN MS-POWERPOINT IN TEN MINUTES

Leave a Reply

Your email address will not be published. Required fields are marked *