Count Functions in MS Excel

Count Functions in MS Excel
Count, Counta, Countblank, Countif

Count - Count only numeric value in a range not text
Counta- Calculates all except blank and including space in a range
Countif - Count no. of cell within a range that meet the given condition.
Countblank - Count blank cells space will be counted as zero.

BACK TO CHAPTER 1

Concatenate in MS Excel

Concatenate in MS Excel

CONCATENATE is a text function used to join two or more text strings into one string.

Syntax: CONCATENATE(text1, [text2], …)

BACK TO CHAPTER 1

Format Painter in MS Excel

Format Painter in MS Excel

Format Painter copies formatting from one place and applies it to another quickly. It is usefull in Tables, Value and Header formatting. Double click the Format Painter button to apply the same formatting to multiple cells.

BACK TO CHAPTER 1

FIRST 10 MS EXCEL KEYBOARD SHORTCUTS

FIRST 10 EXCEL MS KEYBOARD SHORTCUTS

1. Ctrl+Z Undo
2. Ctrl+Y Redo
3. Ctrl+C Copy
4. Ctrl+V Paste
5. Ctrl+S Save
6. Ctrl+N New Workbook
7. Ctrl+O Open
8. Ctrl+F Find
9. Ctrl+P Print
10. Ctrl+A Select All

BACK TO CHAPTER 1

FIRST FIVE TEXT FUNCTIONS - PROPER, UPPER, LOWER, LEN, TRIM

MS Excel First Five Text Functions
PROPER, UPPER, LOWER, LEN, TRIM

BACK TO CHAPTER 1