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
Dodecagon-shaped Jamaican One Cent Coin - De Agostini / A. Dagli Orti/Getty Images
Polygon Geometry: Pentagons, Hexagons and Dodecagons
Characteristics of polygon plus common examples such as triangles, quadrilaterals, hexagons, and the million-sided Megagon.
Venn Diagram of an Intersection Set - © Ted French
Sets
Definition of mathematical sets and set notation including set elements, set-builder notation, venn diagrams, and intersecting sets.
Find the Tangent of an Angle with Excel's TAN Function - © Ted French
Excel TAN Function: Find the Tangent of an Angle
Use Excel's TAN function to find the tangent of an angle measured in degrees or radians. A step by step example is included.
Copy Formatting Between Cells with the Format Painter in Excel - © Ted French
Excel Format Painter: Copy Formatting Between Cells
Quickly copy formatting options from one cell to another with Excel's and Google Sheets format painter. Step by step instructions are included.
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.
Prev
1
2
3
4
5
…
7