computer free courses

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...

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...

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,...

Some commonly used Functions There are most recently or commonly used functions are as followings. Functions are used in MS Excel Function Syntax                                            ...

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...

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...

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...

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)...

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...

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...

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,...

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...

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...

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 OR Press [Ctrl] +...

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...

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...