Formatting and Printing in Microsoft Excel

This will aid you in doing quick formatting and print jobs.Go to print preview, setup,chose the orientation either portrait or landscape.Go to Margins and chose either Horizontally or Vertically.Then go to the Header and customize it.Also go to the Footer to select how your want it to appeare.Now go to sheet and check the gridlines (very important) and finally take ok.Try it.

How to use Edit Menu in Microsoft Excel

This will enable viewers to have access to alighting an entire worksheet by placing the cursor on the first cell of a worksheet and holding down the ctrl+shift key at the sametime then place your cursor at the end of the sheet.Users manually drag from the beginning of a worksheet to the end which is not a time saving techniques.My aim here is to enable users have access to automatic ways of being productive in their offices.

How to use formulas in Microsoft Excel

This blog will enable viewers to learn much about the various formulas on the insert,functions (fx) menu of microsoft excel.People are paying more to learn less in my community.I want to use this medium to allow viewers to understand that excel as to do with practice as practice makes one perfect. Examples are shown below:
DAYS360:Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
Syntax
DAYS360(start_date,end_date,method)
Start_date, end_date are the two dates between which you want to know the number of days. If start_date occurs after end_date, DAYS360 returns a negative number. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
CONCATENATE
Joins several text strings into one text string.
Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Note:You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).