Pin your frequently used Excel workbooks for easy access
If the Excel icon appears in the Windows taskbar, right-click it.
Category: Excel
Simple ways to ensure accuracy in Excel
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.
Excel: This makes no sense!
Troubleshooting 3 problems in Excel.
Excel: Try conditional formatting
Conditional formatting can be useful with out-of-range conditions, allowing an alert as data entry is happening.
Fixing combined data in Excel
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.
Excel dates: Just add 1
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.
Admins’ favorite keyboard shortcuts
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:
3 questions about time and dates in Excel
Time zone math … Workday calculations … Time math overnight
Excel: 3 ways to get formulas copied down
There are three ways to get formulas copied down.
Compare two spreadsheets in Excel
Have two spreadsheets that should be identical, but you want to make sure? Use the Inquire add-in in Excel.