Showing posts with label ms office. Show all posts
Showing posts with label ms office. Show all posts

MS Excel formulas

Microsoft Excel also known as spreadsheet is the most usable application software for accounting purposes. due to its good functionalities and accuracy its famous in all over the world and its easy to use and work on it.
Today i 'm going to tell you about MS Excel and its formula that how to make usable the spreed sheet in our daily life.I 'm trying to make some tutorials about MS Excel formulas and share with you here. let me share now some basic and simple formulas . 

1. How to perform addition:



2.Basic Formulas


3.Functions

4. Date Time Formulas

5.Statistical Formulas

6.Counting formulas

Keyboard Shortcuts for MS Word

Keyboard shortcuts are very essential for a computer user.It make the work more easy than command use. Some shortcuts key for MS Word are follow.

MS Word shortcuts Keys
Shortcut Key
Function
Ctrl+C
Copy selected text or graphics to the Office Clipboard.
Ctrl+Y
Redo the last action.
Ctrl+V
Paste the most recent addition to the Office Clipboard.
Ctrl+X
Cut selected text
Ctrl+Z
Undo the last action.
Home
Go to beginning of document.
End
Go to end of document.
Esc
Exit reading layout view.
Ctrl+Shift+<
Decrease font size one value
Ctrl+Shift+>
Increase font size one value
Ctrl+[
Increase the font size by 1 point.
Ctrl+]
Decrease the font size by 1 point.
Ctrl+N
Create a new document
Ctrl+O
Open a document.
Ctrl+W
Close a document.
Alt+Ctrl+S
Split the document window.
Alt+Shift+C
Remove the document window split.
Ctrl+S
Save a document.
Ctrl+F
Find text
Alt+Ctrl+Y
Repeat find (after closing Find and Replace window).
Ctrl+H
Replace text
Ctrl+G
Go to a page
Alt+Ctrl+Z
Switch between the last four places that you have edited.
Alt+Ctrl+P
Switch to Print Layout view.
Alt+Ctrl+O
Switch to Outline view.
Alt+Ctrl+N
Switch to Draft view.
Alt+Shift+Arrow Up
Move selected paragraphs up.
Alt+Shift+Arrow Down
Move selected paragraphs down.
Ctrl+P
Print a document.
Alt+Ctrl+I
Switch in or out of print preview.
Alt+Ctrl+M
Insert a comment.
Alt+Shift+O
Mark a table of contents entry.
Alt+Shift+I
Mark a table of authorities entry (citation).
Alt+Shift+X
Mark an index entry.
Alt+Ctrl+F
Insert a footnote.
Ctrl+K
Insert a hyperlink.
Alt+Arrow Left
Go back one page.
Alt+Arrow Right
Go forward one page.
Backspace
Delete one character to the left.
Delete
Delete one character to the right.
Ctrl+Backspace
Delete one word to the left.
Ctrl+Delete
Delete one word to the right.
Ctrl+B
Apply bold formatting.
Ctrl+U
Apply an underline.
Ctrl+I
Apply italic formatting.
Ctrl+=
Apply subscript formatting
Ctrl+Shift+ +
Apply superscript formatting
Ctrl+E
Switch a paragraph to left-aligned
Ctrl+J
Switch a paragraph to justified
Ctrl+R
Switch a paragraph to right-aligned
Ctrl+L
Left alignment