اکاؤٹينگ کیلۓ ما ئيکروسافٹ آفس کا اہم ترين پروگرام ما ئيکروسافٹ ايکسل سيکھیں۔ نيچے ويڈ یو کلک کريں۔
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
