Most spreadsheet software comes with a default font pre-selected. For example, Microsoft Excel worksheets always start with the Calibri font set at size 11. For Excel on a Mac, the …
When working with financial data, you will notice that currency values are automatically formatted by Excel to include a dollar sign. This might not be the currency symbol you want …
Working with a spreadsheet full of hyperlinks can be quite frustrating. Unless otherwise specified, Excel usually recognizes the formats of email addresses and URLs and automatically converts them to hyperlinks. …
If you’re dealing with a spreadsheet that was not created by you, formatting hassles are quite likely. You might come across a list of phone numbers with leading zeros. It …
You might have encountered times where you find Excel not letting you perform certain operations on your data due to the presence of merged cells. Merged cells are often so …
Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …
Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …
Working with rows after rows of data can sometimes get monotonous. Often times, it becomes difficult to differentiate one row from the other. The solution? Highlighting (or shading) alternate rows …
Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …
When dealing with databases in Excel, you might come across spreadsheets that have data organized in particular patterns. For example, census data usually consists of alternating columns of actual data …
If you need to subtract a single value from a range of cells at the same time, there are multiple ways can do this in Excel. For example, suppose you …
Using Excel for office work often requires copying sheets from one workbook to another. You might need to compile individual employee sales reports into a single workbook. Or, you might …