Excel
3 shortcuts for selecting cells, working in multiple workbooks and activating Quick Analysis options.
If the Excel icon appears in the Windows taskbar, right-click it.
Accuracy is the responsibility of each person producing reports to support business decisions. Now that there is a sense of accountability, it’s knowing the tools that can help.
Troubleshooting 3 problems in Excel.
Conditional formatting can be useful with out-of-range conditions, allowing an alert as data entry is happening.
While there are many ways to fix combined data like “Chicago, IL, 60660,” many are fragile and not suited to connected data sources in a workbook.
If you need the day number within the year for a particular date, subtract 1/1/2020 or the first day of the current year with which you’re concerned. Then add 1.
Whether it’s a speedy way to create a bar chart or a trick for switching from one window to the next, keyboard shortcuts can help even the experienced admin knock out work faster. Here are a few of our readers’ faves:
Time zone math … Workday calculations … Time math overnight
There are three ways to get formulas copied down.
Have two spreadsheets that should be identical, but you want to make sure? Use the Inquire add-in in Excel.
3 shortcuts for named ranges.
Sometimes Excel tries to help us when we wish it wouldn’t.