by Laura | Jun 30, 2019 | Microsoft Excel Tips, Microsoft Outlook, Microsoft PowerPoint Tips, Microsoft Word Tips
Save time and get your work done more easily. Click on any of the links below to download Keyboard Shortcuts. Word Format Microsoft Word Keyboard Shortcuts Microsoft Excel Keyboard Shortcuts Office 365 Keyboard Shortcuts PDF Format Microsoft Word Keyboard...
by Laura | Jun 21, 2019 | Microsoft Excel Tips
As of Excel 2016 there are 467 functions, but the designers couldn’t possibly anticipate every user’s calculation needs. So Excel provides you with the ability to create your own custom functions. Custom functions use the Visual Basic for Applications (VBA)...
by Laura | Jun 18, 2019 | Microsoft Excel Tips
Arranging your data alphabetically, from smallest to largest numerically, or using other criteria can help you find the information you’re looking for more quickly. Select a cell in the column you want to sort and on the Data tab, in the Sort & Filter group,...
by Laura | Jun 18, 2019 | Microsoft Excel Tips
You can do this with conditional formatting. Conditional formatting applies one or more rules to any cells you want. An example of a rule might be If the value is greater than 5000, color the cell yellow. By applying this rule to the cells in a worksheet, you’ll...
by Laura | Jun 18, 2019 | Microsoft Excel Tips
When you create a new Excel file, it has a used range that includes only cell A1. But as you build your file it grows to include the cell in the lowest right corner of the spreadsheet. (You can find out what Excel thinks is the lowest right corner of your...
by Laura | Jun 12, 2019 | Microsoft Excel Tips
There are several ways you can do this. Enter the first date in a cell. Drag the fill handle down as many rows as you want to fill. When you release, the range will be filled with consecutive dates. If you don’t want to increase by 1 day at a time, you can...
