Spreadsheets

Formulas on a blackboard - Jon Boyes/Photographer's Choice RF/Getty Images

A Beginner's Guide to Excel Formulas

Use the AVERAGE-IF Array Formula to Ignore Errors - © Ted French

Ignore Errors when Finding the Average in Excel

Shading Alternate Rows with Conditional Formatting Forumulas in Excel - © Ted French

Shade Alternate Rows with Excel Conditional Formatting

Our Spreadsheets Expert
Spreadsheets
The Latest in Spreadsheets
Find the Cosine of an Angle in Excel with the COS Function - © Ted French
Excel COS Function: Find the Cosine of an Angle
Use Excel's COS function to find the cosine of an angle measured in degrees or radians. A step by step example is included.
Find the Sine of an Angle with Excel's SIN Function - © Ted French
Excel SIN Function: Find the Sine of an Angle
Use Excel's SIN function to find the sine of an angle measured in degrees or radians. A step by step example is included.
Use the UPPER, LOWER, and PROPER Functions to Convert Case in Excel - © Ted French
Convert Text to Upper, Lower, or Proper Case in Excel
Use Excel's PROPER, UPPER, or LOWER functions to correct or convert text data to capital and small letters as needed. A step by step example included.
Excel Database, Tables, Records and Fields - © Ted French
Excel Database, Tables, Records and Fields
Definition and uses of the database terms: table, records, fields, and field names in Excel. An overview of Excel's data tools is included.
Using the Excel TODAY Function in Date Calculations - © Ted French
Excel TODAY Function
Use Excel's TODAY function in date calculations and to add the current date to a worksheet. Step by step instructions are included.
Calculating Loan Payments and Saving Plans with Excel's PMT Function - © Ted French
Excel PMT Function: Calculate Loan Payments or Saving Plans
Use Excel's PMT function to calculate loan payments or saving plans for investments. Step by step examples included.
Divide Numbers in Excel with the QUOTIENT Function - © Ted French
Divide in Excel with the QUOTIENT Function
Use Excel's QUOTIENT function to return the integer portion of division operations without the remainder. A step by step example is included.
Find the Most Frequent or Average Value with Excel's MODE Function - © Ted French
Find the Average (Mode) with Excel's MODE Function
Use Excel's MODE function to find the mode - the most frequently occurring value in a group of numbers . A step by step example is included.
Multiplying Numbers in Excel with the PRODUCT Function - © Ted French
Multiply Numbers with Excel's PRODUCT Function
Use Excel's PRODUCT function to make it easy to multiply individual numbers, arrays, or ranges of values together. A step by step example is included.
Extract the Month from a Date with the Excel MONTH Function - © Ted French
Excel MONTH Function
Use the MONTH function to extract the month from a specified date in Excel. Multiple examples and step by step instructions included.
Using the EDATE Function to Add and Subtract Months to a Date in Excel - © Ted French
Excel EDATE Function: Add/Subtract Months to Dates
Use Excel's EDATE function to add or subtract months to dates in order to calculate future or back dates of investments or projects.
Merge and Center Cells of Data in Excel and Google Spreadsheets - © Ted French
Merge Cells in Excel and Google Spreadsheets
How to merge cells in Excel and Google Spreadsheets. Also covered: Excel's Merge & Center and Center Across Selection options. Instructions included.
How to Store, Copy and Delete Entries in the Office Clipboard in Excel - &copy: Ted French
Excel Clipboard: Copy Multiple Items Multiple Times
What the Office Clipboard is and how to use it to copy and paste data between Excel worksheets, workbooks, or other programs. Examples included.
Using the EOMONTH Function to Add and Subtract Months to a Date - &copy: Ted French
Excel EOMONTH Function: Add/Subtract Months to Dates
Use Excel's EOMONTH function to add or subtract months to dates in order to calculate future or back dates of investments or projects.
Find the Smallest Number, Fastest Time, Shortest Distance, Lowest Temperature, or Earliest Date with Excel's MIN Function - © Ted French
Excel MIN Function Shortcut: Find the Smallest Values
Find the smallest number, the fastest time, the shortest distance, the earliest date, and other minimum values with Excel's MIN function.
Prev
1
2
3
4
5
…
7