Microsoft Office

Create a new workbook in Excel
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
Create and apply custom border styles in Excel
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
Format a worksheet in Excel
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
Use AutoSum to add up date in Excel
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
Creating Formula in Excel
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
Apply a number format in Excel
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
Using tables in Excel
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
Using Quick Analysis in Excel
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
Sort your data in Excel
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
Filter data in a range or table in Excel
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