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 …
Read More »How To Select Only Visible Cells In Excel
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 …
Read More »How To Sort Data In Rows In Excel
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 …
Read More »How To Find The Date Of A Specific Day Of The Month In Excel
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 …
Read More »How To Stop Numbers Converting To Date In MS Excel
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 …
Read More »