Microsoft Office
Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking alm...
Wed, 24 Nov, 2021 at 11:20 AM
You can create a cell style that includes a custom border, and then you can apply that cell style when you want to display the custom border around selected...
Wed, 24 Nov, 2021 at 11:30 AM
You can help improve the readability of a worksheet by applying different types of formatting. For example, you can apply borders and shading to help define...
Wed, 24 Nov, 2021 at 11:34 AM
When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum. Select the cell to the right or below...
Wed, 24 Nov, 2021 at 11:36 AM
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed...
Wed, 24 Nov, 2021 at 11:38 AM
To distinguish between different types of numbers, add a format, like currency, percentages, or dates. Select the cells that have numbers you want to form...
Wed, 24 Nov, 2021 at 11:41 AM
To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). Not...
Wed, 24 Nov, 2021 at 11:56 AM
The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Ex...
Wed, 24 Nov, 2021 at 12:02 PM
Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory leve...
Wed, 24 Nov, 2021 at 12:15 PM
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you fi...
Wed, 24 Nov, 2021 at 12:29 PM