computer free courses

Monday, July 2, 2018

Bullets and Numbering

With Word, you can make bulleted lists, numbered lists, or outlines.

Bullets and Numbering

In the Home command tab within the Paragraph group click Numbers or Bullets.

A list pull down.

Click the desired Bullet or Number format.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Borders and Shading Options Dialog Box Option

Muhammad Adnan MS Word ,

Borders and Shading Options Dialog Box Option

Select the paragraph(s) to which you want to add shading and/or border(s)

Borders and Shading Options Dialog Box Option

From the Ribbon, select the Home command tab

Within the Paragraph section, click BORDERS » select Borders and Shading...

The Borders and Shading dialog box appears

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

IF Function

The IF function is used to make decisions. It returns one value if a specified condition evaluates to TRUE and another value if it evaluates to FALSE. For example, you can display a massage “Pass” if marks are more than 40 or “Fail” otherwise. The syntax for the IF function is:

If(condition, value_if_ture, value_if_false)

Condition is the value to be tested.

IF Function in MS Excel

Value_if_true is the value that is returned if condition evaluates to TRUE.

Value_if _false is the value that is returned if condition evaluates top FALSE.

Insert marks of the student in A1.

Type IF(A1>40,”Pass”,”Fail”) in B1

Press ENTER

If the value of A1 is more than 40, “Pass” will be displayed in B1. Otherwise

“Fail” will be displayed

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Functions are used in MS Excel

Muhammad Adnan MS Excel ,

Some commonly used Functions

There are most recently or commonly used functions are as followings.

Functions are used in MS Excel

Function Syntax Purpose

=Sum(range) For addition of cells or values

=product(range) For multiplication of cells / values

=average(range) For average of cells or values

=max(range) For Maximum value of range

=min(range) For minimum value of range

=count(range) For counting of numeric values

=counta(range) Count the numbers of cells that are not empty.

=countblank(range) Count the empty cells in the range

=countif(range, criteria) Count the number of cells within a range that meet the condition.

=today() Shows the today date

=now() Shows the current date with time

=days360(St_date,En_date) Return the number of days between two dates.

=day(date) Return the day from the date

=month(date) Return the month from the date

=power(value,power) Calculate the result of number raised powers

=sumif(range, criteria,sum_range) adds all numbers in a range of cells, based on a given criteria.

=If(condition,value_if_ture,value_if_false) The IF function is used to make decisions.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Paragraph Shading in MS Word

Muhammad Adnan MS Word ,

Adding Shading

Select the paragraph(s) to which you want to add shading

Paragraph Shading in MS Word

Open the Borders and Shading dialog box

Select the Shading tab

From the Fill pull-down list, select the desired fill effect

Click OK

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Paragraph Border in MS Word

Muhammad Adnan MS Word ,

Adding Borders

From the Ribbon, select the Home command tab Within the Paragraph section, the Shading and Border options are available.

Paragraph Border in MS Word

Select the paragraph(s) to which you want to add shading and/or border(s)

To add a border, click BORDERS » select the desired border option

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Absolute Cell References in MS Excel

Muhammad Adnan MS Excel ,

Absolute Cell References

Situations arise in which the cell reference must remain the same when copied or when

using AutoFill. Dollar signs are used to hold a column and/or row reference constant.

Absolute Cell References in MS Excel

Summary of absolute cell reference uses:

$A1

Allows the row reference to change,

but not the column reference.

A$1

Allows the column reference to

change, but not the row reference.

$A$1

Allows neither the column nor the row

reference to change.

Example:

In the example below, when calculating commissions for sales staff, you would not want

cell B10 to change when copying the formula down. You want both the column and the

row to remain the same to refer to that exact cell. By using $B$10 in the formula, neither

changes when copied.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Relative Cell References in MS Excel

Muhammad Adnan MS Excel ,

Relative Cell References

This is the most widely used type of cell reference in formulas. Relative cell references are basic

cell references that adjust and change when copied or when using AutoFill.

Relative Cell References in MS Excel

Example:

=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the

next cell.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Formula in MS Excel

Muhammad Adnan MS Excel ,

Entering Formula in Worksheet

Formula Building

Excel allows you to use formulas to calculate and analyze data in your worksheet. A

formula always begins with an equal sign (=), and includes cell references, and some type

of mathematical operator. For example, the formula =C4+ C5 takes the value in C4 and

adds it to C5.

Formula in MS Excel

Operators in Formula

Excel uses arithmetic operators in formulas to perform mathematical calculations.

Arithmetic Operators include the addition (+), Subtraction (-) , Multiplication (*),

division (/), Percent (%), and exponent (^) symbols.

You can use Logical operators, which return values of TRUE or FALSE, in formulas to

compare two values.

Comparison and Logical Operators include the greater than (>), less than (<), equal to

(=), greater then or equal to (>=), less than or equal to (<=), and not equal

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Inserting Symbols in MS Word

Muhammad Adnan MS Word ,

Inserting Symbols and Special Characters

When creating documents, you may need to use a symbol or special character that does not appear on the keyboard. These symbols and special characters can be accessed through the Symbol dialog box.

Inserting Symbols in MS Word

Inserting Symbols

Use the Symbol dialog box to locate symbols, characters from other languages, arrows, and other characters. Symbols inserted into documents can then be formatted as regular text.

Place the insertion point where the symbol will be inserted

From the Insert tab, in the Symbols group, click SYMBOL

Select the Symbols tab

Select the desired symbol

Click INSERT

The symbol appears in your document.

Click CLOSE

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Changing Page Size in MS Excel

Muhammad Adnan MS Excel ,

Changing the Page Size

The default paper size is 8 1/2" x 11", but you can select other available paper sizes, such

as legal (8.5" x 14"). To select a different paper size:

Changing Page Size in MS Excel

From the Ribbon, select the Page Layout command tab

In the Page Setup group, click SIZE » select the desired paper size

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Page orientation in MS Excel

Muhammad Adnan MS Excel ,

Changing Page Orientation

From the Ribbon, select the Page Layout command tab

In the Page Setup group, click ORIENTATION » select the

desired orientation (i.e., Portrait or Landscape)

Page direction in MS Excel

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Typing Master Pro Portable

Muhammad Adnan Softwares ,

Typing Master Pro Portable

Tying Master is a program that will work as a personal typing tutor helping you to improve your typing speed.

Typing Master Pro Portable

Typing Master Pro Portable is a great tool when you are learning typing because it can help you to improve your typing speed by means of lessons, advice and advanced tests. Lessons increases their difficulty according you move forward to higher levels; besides, those are not typical boring lessons, but you can play games where you will have to type very well if you want to move forward to next lesson.

For free download Typing Master Pro Portable click link below

Download Typing Master Pro

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Print cell range in MS Excel

Muhammad Adnan MS Excel ,

Printing Ranges of Cells

You can manually select ranges of cells for printing. You also have the option of selecting multiple non-contiguous ranges for printing.

Select the Cells you want to print.

Print cell range in MS Excel

click the OFFICE BUTTON» select Print

Press [Ctrl] + [P]

The Print dialog box appears.

In the Print what section, select Print Selection

Click PRINT

The specified range of cells is printed.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Define the Print Area in MS Excel

Muhammad Adnan MS Excel ,

Defining the Print Area

By default, Excel prints all data on the current worksheet. However, you can define a specific print area from the Page Setup dialog box or the Print Area command.

Define the Print Area in MS Excel

Select the Page Layout command tab In the Page Setup group, click Page Setup

The Page Setup dialog box appears.

Select the Sheet tab

In the Print Area text box, type the range of cells you want to print

To select the area

Click COLLAPSE DIALOG

Select the desired range of cells

Click RESTORE DIALOG

Click OK

The print area is defined.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Custom pages print in MS Word

Muhammad Adnan MS Word ,

Specifying the Pages to Print

This section lists options for printing and the selection or specifications that you must make in the Page range section of the Print dialog box to achieve the desired results.

Custom pages print in MS Word

From the OFFICE BUTTON, click PRINT. The Print dialog box appears.

Select the desired page range, then click print.

If my posts are useful for you، or if there is any reduction in them so kindly comment me.

Monday, July 2, 2018

Bullets and Numbering

Borders and Shading Options Dialog Box Option

IF Function

Some commonly used Functions

Sunday, July 1, 2018

Adding Shading

Absolute Cell References

Summary of absolute cell reference uses:

Example:

Relative Cell References

Example:

Saturday, June 30, 2018

Entering Formula in Worksheet

Formula Building

Operators in Formula

Tuesday, June 26, 2018

Inserting Symbols and Special Characters

Inserting Symbols

Changing the Page Size

Changing Page Orientation

Monday, June 25, 2018

Printing Ranges of Cells

Defining the Print Area

Specifying the Pages to Print

Search This Blog

Blog Archive

Post Top Ad

Categories

Popular Tags

Contact Form