Tag Archives: excel

Microsoft Excel lets you apply conditional formatting to cells. If the value in a cell meets certain rules that you’ve set, the conditional formatting feature will change the color of the text in the cell, or the fill color, or both. This is a basic feature that works right out …

MS Excel is an exceptionally powerful tool. If you can code, Excel is likely of little consequence to you. For those who can’t code, this app is heaven sent. It offers a wide range of features and can be used in a myriad of industries where workers are more likely …

Excel lets you hide columns and rows.This is a great way to make a clean, presentable Excel sheet. You can insert formulas in rows and columns, and hide them later. It also keeps other users from editing your formula. If the formula isn’t visible, chances are people are less likely …

Microsoft Excel lets you filter data. It’s a useful feature that can help you make sense of large amounts of data. If you lack the technical know-how needed to create a database, this feature is a life saver. The filters are fairly basic and allow you to include or exclude …

Microsoft’s productivity suite of apps support rich text formatting and a whole host of other elements. You can change the font size, color, and type but you can also add images, tables, shapes, videos, links to external documents, and hyperlinks. This isn’t even the tip of the iceberg though. The …

Microsoft Excel is a powerful spreadsheet app. It lets you process a substantial amount of data. You can sort it, apply formulas, and use conditional formatting to make it easier to read. Add to this the many types of graphs it supports and you can get a lot done with …

If you use Excel to maintain schedules and/or time sheets, you might have needed to find the date of a specific day of the month. For example, what date does the second Monday of the month fall on? If you ever need to look up this same information but don’t …

MS Excel is an exceptionally intelligent spreadsheet app and it’s not just because it supports a lot of logical arguments. The app can recognize data for what it is, e.g. it knows when it’s dealing with currency, and when it’s dealing with time values. It’s precisely because of this that …