How to use format painter

If you like how certain text or graphics look like, you can apply it in your document. For instance the font style, font size, boldness, color and highlights formats, you can apply them by simply   following simple steps.

1st step: Select the content text or graphics with the format you prefer.

2nd step: click format painter in Home Tab 

3rd step: select any text or graphics in your document, the same format will automatically apply

N.B: To apply the format in multiple places you double-click format painter.

How to use conditional formatting

Easily spot the patterns, trends, in your data using bars, colors, and icons to visually highlight the important values. The conditional formatting reflect the value of the information provided within the cells.

To find conditional formatting in Excel, just click Home Tab. this apply to the number formatting 

How to use Sum, Average, Minimum and Maximun formula.

Sum

By Using the formula of =Sum(selected range) you can add the numbers from certain cells in your spreadsheet. 

You can also use AutoSum by selecting the cells you wand to add up and the total will automatically appear after the selected cells.

Average

By Using the formula of =Average(selected range) you can find the average from certain cells in your spreadsheet. 

Minimum

By Using the formula of =Min(selected range) you can the smallest value of the numbers from certain cells in your spreadsheet. 

Maximum

By Using the formula of =Max(selected range) you can the Highest value of the numbers from certain cells in your spreadsheet. 

Sorting 

You can find your value quickly by sorting your data. You can either sort alphabetically, from in certain order or numbers in ascending or descending order.  

Click in Data Tab to customize your sorting.

How to Filter your data

You can select cells you want to stay in window view by simply clicking filter in Data Tab. Click the arrow in the column header to narrow down the data you want to view.

How to use freeze pain

you can freeze everything above row or everything before column. This allows you not to lose the description of the data on your spreadsheet. 

Freeze panes has 3 options. 

1st option Freeze panes: you can keep rows and column visible while the rest of the worksheet.

2nd option: Keep the row visible while scrolling through the rest f the worksheet.

3rd option: Keep the column visible while scrolling through the rest of worksheet.

You can watch our video on YouTube channel for how these features work.


See Our Latest Posts

 167 total views,  1 views today

Share