Find the Last Day of Any Given Month
Dates can tricky to work with, and finding the last day of a given month can be a challenge. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Add/Subtract Months from a Date
Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult. Read more...
Return a Worksheet Name to a Cell
This tutorial shows how you can display the entire path of your worksheet in a cell using the CELL function. Then, a combination of the MID and FIND functions extracts only the worksheet name from the full pathname. Read more...
Extract Specified Words from a Text String
In this tutorial, we'll show how to extract the last word, the first word, and the nth word from a string of text. Read more...
Display Negative Time Values
Sometimes you want to display negative time values, but Excel will only display ######. There are several ways to escape this problem. Read more...
Sum Every Second, Third, or Nth Row or Cell
Every now and then you might want to sum every second, third, fourth, etc, cell in a spreadsheet. Now you can, with the following tutorial. Read more...
Formulas and Functions Techniques
Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets. Read more...
Excel Pivot Tables
PivotTables are one of Excel's most powerful attractions, though many people don't knoww hat they do. Read more...
Excel's Date and Time Features
Excel's date and time feature is great if you're creating simple spreadsheets, but they can cause problems for more advanced projects. Read more...
Convert Excel Formulas and Functions to Values
Most Excel spreadsheets contain formulas. Sometimes you may want to force only the result of a formula to occupy a cell, instead of leaving the formula in place, where it will change if/when the data it references changes. Read more...
Customize Cell Comments
Although cell comments serve the simple purpose of displaying a message to either yourself or another user, you can customize the cell comment so that it better reflects your intentions. Read more...
Convert Text Numbers to Real Numbers
Remember that numbers in Excel are right-aligned by default, and that text is left-aligned by default. Read more...
Control Conditional Formatting with Checkboxes
Conditional formatting, a feature available since Excel 97, applies formats to selected cells that meet criteria based on values or formulas you specify. Read more...
Validate Data Based on a List on Another Worksheet
This tutorial provides two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Read more...
Extract Data from a Corrupt Workbook
Workbooks sometimes become corrupt for no apparent reason. This can cause all sorts of problems, especially if the workbook is vital and for whatever reason you have no backup. Read more...