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.
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.
By Using the formula of =Average(selected range) you can find the average from certain cells in your spreadsheet.
By Using the formula of =Min(selected range) you can the smallest value of the numbers from certain cells in your spreadsheet.
By Using the formula of =Max(selected range) you can the Highest value of the numbers from certain cells in your spreadsheet.
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
- Download Windows 11 ISO Files 64 bit Microsoft
- Love Personality Test: Take Quiz Now
- Job application: CHIEF ACCOUNTANT
- Apply for job: PROJECT MANAGER – FEDERAL FOREIGN OFFICE
- Job application: MONITORING, EVALUATION, ACCOUNTABILITY AND LEARNING & RESEARCH OFFICER