Microsoft Office Development and Consultancy

Excel

Office Online Articles - 2010

2010: Why is my formula broken

2010: Why do I get an unprotected formula message

2010: What are those buttons and triangles in my cells

2010: Use functions in formulas

2010: Show and protect formulas

2010: Move and copy a formula

2010: Find and fix circular references

2010: Combine the contents of multiple cells into one cell

2010: Add and subtract numbers

2010: Use formula autocomplete

2010: Use error checking to correct common errors in formulas

2010: Switch between relative absolute and mixed references

2010: Sum the values in cells columns or rows

2010: Subtract numbers

2010: Round a number

2010: Remove or allow a circular reference

2010: Nest a function within a function

2010: Multiply numbers

2010: Move or copy a formula

2010: Learn the basics of Excel formulas with ExcelisFun videos on YouTube

2010: Guidelines and examples of array formulas

2010: Find and correct errors in formulas

2010: Evaluate a nested formula one step at a time

2010: Divide numbers

2010: Display the relationships between formulas and cells

2010: Display or hide formulas

2010: Delete or remove a formula

2010: Create or change a cell reference

2010: Create an external reference link to a cell range in another workbook

2010: Create 3D reference to the same cell range on multiple worksheets

2010: Count unique values among duplicates

2010: Count Non Blank cells

2010: Count how often a value occurs

2010: Correct a #VALUE! error

2010: Correct a #REF! error

2010: Correct a #NAME? error

2010: Correct a #N/A error

2010: Correct a #DIV/0! Error

2010: Control when external references links are updated

2010: Combine two or more columns by using a function

2010: Change the case of text

2010: Calculation operators and precedence

2010: Calculate the average of a group of numbers

2010: Calculate percentages

2010: Break a link to an external reference

2010: Add numbers

Office Online Articles - 2007

2007: Watch a formula and its result by using the Watch Window

2007: Use Excel as your calculator

2007: Understanding formula basics

2007: Summing up ways to add and count Excel data

2007: Set rounding precision

2007: Select cells that contain formulas

2007: Replace a formula with its result

2007: Protect or audit formulas

2007: Overview of formulas

2007: Move or copy a formula

2007: Understanding floating point precision

2007: Knowing when to use mixed references

2007: Knowing when to use absolute references

2007: How to handle leading zeros and precision in number codes

2007: Enter formulas

2007: Find and correct errors in formulas

2007: Examples of commonly used formulas

2007: Evaluate a nested formula one step at a time

2007: Display the relationships between formulas and cells

2007: Create formulas with Formula AutoComplete

2007: Create or change a cell reference

2007: Create a formula

2007: Create a 3-D reference to the same cell range on multiple worksheets

2007: Correct common errors in formulas

2007: Correct a #VALUE! Error

2007: Correct a #REF! error

2007: Correct a #NUM! error

2007: Correct a #NULL! Error

2007: Correct a #NAME? error

2007: Correct a #N/A error

2007: Correct a #DIV/0! Error

2007: Correct a ##### error

2007: Copy cell values not formulas

2007: Change formula recalculation iteration or precision

2007: Calculation operators and precedence

Office Online Articles - 2003

2003: Watch a formula and its result

2003: Use a calculator with Office

2003: Switch between relative absolute and mixed references

2003: Subtract numbers

2003: Select cells that contain formulas

2003: Replace a formula with its result

2003: Remove cells from a Watch Window

2003: Refer to the same cell or range on multiple sheets

2003: Multiply numbers

2003: Move or copy a formula

2003: Lotus 1-2-3 keyboard equivalents

2003: Let Excel be your calculator

2003: An _xlfn. prefix is displayed in front of a formula

2003: Find and correct errors in formulas

2003: Extend formats and formulas to additional rows

2003: Examples of commonly used formulas

2003: Evaluate a nested formula one step at a time

2003: Enter a formula

2003: Divide numbers

2003: Display the relationships between formulas and cells

2003: Display or hide formulas

2003: Worried about performance review confidentiality? IRM can help

2003: Slice and dice sales data with PivotTable reports

2003: Is your financial data worksheet calculating the results you intended?

2003: Delete a formula

2003: Create conditional formulas

2003: Create a multiplication table

2003: Correct a #VALUE! Error

2003: Correct a #REF! error

2003: Correct a #NUM! error

2003: Correct a #NULL! error

2003: Correct a #NAME? error

2003: Correct a #N/A error

2003: Correct a #DIV/0! error

2003: Correct a ##### error

2003: Change which cells a formula refers to

2003: Change when and how formulas are recalculated

2003: Change the precision of calculations in a workbook

2003: Calculate percentages

2003: Allow or correct a circular reference

2003: Add numbers

2003: About formulas

2003: About correcting formulas

2003: About cell and range references

2003: About calculation operators

2003: About calculation in workbooks