Excel
Studying books and help text is one way to learn formulas. Another: Ask the formula!
Copying and pasting doesn’t always produce the results we need and can take a lot of clicking and dragging.
The error could be the result of a number of circumstances.
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.