- Monitor Distant Cells
- Use Real Dates
- How Can I Tell If Have Real Dates?
- Convert Text Dates to Real Dates
- Format Dates
- Format Dates As Quarters or Weeks
- Display Monthly Dates
- Add a Column to Show Month or Weekday
- Calculate First of Month
- Calculate the Last Day of the Month
- Calculate Invoice Due Dates
- Calculate Receivable Aging
- NOW, or TODAY?
- Find the Last Sunday Of the Month
-
- Calculate Work Days
- Farmers Market
- Calculate Age in Years, Months, Days
- Coerce an Array of Dates from 2 Dates
- Use Real Times
- Strangeness of Time Formatting
- Convert Time to Decimal Hours
- Calculate with Time
- Enter Minutes and Seconds
- Convert Text to Time
-
- Track Negative Time?
- Fill Blanks With Value Above
- See Formulas in Excel 2013
- Bell Curve in Excel
- Upper Case in Excel
- Spell Out Numbers in Excel
- Macro Code from the Internet Into an Add-In
- Return Data from a Webservice in Excel 2013
- SUM(B1:B5) is Better Than =B1+B2+B3+B4+B5
- Add New Functions to Excel with Fast Excel SpeedTools Extras
- How to Set up Your Data for Easy Sorting and Subtotals
- How to Fit a Multiline Heading into One Cell
- No Tiny Blank Columns Between Columns
- How to Sort Data
- Sort Days of the Week
- Sort a Report into a Custom Sequence
MORE RESOURCES
FOR MICROSOFT EXCEL
