COUNT function

• Counts the number of cells that contain numbers

• =COUNT(A1:A20)

COUNTA function

• Counts the number of cells that are not empty in a range

• =COUNTA(A2:A6)

COUNTBLANK function

• Count the number of empty cells in a range of cells

• =COUNTBLANK(A2:B4)

Use of Status Bar

• Customizing Status bar

Protect your excel sheet in 5 methods.

1) Save the workbook as read only

2) Protect the workbook with a password

3) Protect one sheet with a password

4) Protect certain cells in a sheet

5) Protect the workbook from structural changes with a password

• Ctrl +   Down Arrow = Move to the last cell of selected column

• Ctrl + Up Arrow = Move to the   first cell of the selected column

• Freezing Top row of your sheet

• Advantage of using freezing

• Unfreeze Pane

• Freezing first column

• How to freeze column and row together

• Inserting picture within a cell

• Inserting picture over a cell

• Formatting a picture

• Adjusting transparency

• Adjusting color, brightness

• Insert a shape

• Resizing a shape with different handles

• Using shape format menu

• Inserting Icon

• Using graphic Format Menu

• Inserting 3D Models

• Deleting added elements

• Adding Smart Art - To plot relationship or hierarchy

• Using Smart Art Design menu

• Inserting charts in excel

• Recommended charts

• Understanding the chart, element, title, Axis, Labels

• Line chart

• Understanding chart design tab

• Comparing two values using chart

• Customizing the chart

• Alt+= Auto Sum

• Inserting 3D Pie Chart

• Customizing the chart

• Chart Design Tab

• Ctrl + P = Print

• Need of Header and Footer

• Adding information on header and Footer

• Adding pictures to header and footer

• What is conditional Formatting

• How to add a formatting based on a condition

• How to manage the existing condition

• How to delete the conditional formatting

• Highlight a cell that contains duplicate values

• Highlight a cell that contains unique values with conditional formatting

• Margins, setting margins of an excel sheet

• Setting unites for measurements

• using Built-in Margins

• Orientation - landscape and Portrait

• Setting print Area

• Choosing Printer

• Printing as a PDF

• Print Settings

• Collated and Un Collated

• Selecting Page size

• Scaling

• Printing multiple sheets in one page

• Challenges in printing large data

• How to insert header as a title in all the pages

• Adjusting the page orders in large data

• Adjusting the columns size to accommodate the data in all the pages