Office Productivity

Home Office Tech

View all Hubs

Computing & Hardware

Education

Engineering Technology

Environment

Health & Wellness

Internet

Mobile

Money & Finance

Multimedia

Office Productivity

Science Technology

Video Games

Must Read

Interior Design Tips for your Home Office
How to Backup Computer Files & Data
Ergonomics & the Alexander Technique
Network & Sharing Center in Vista
How to Clean a Laser Printer
Firefox 3 vs. IE7
Windows Vista DVD Maker: How-To
Microsoft Excel Tricks

See what's in...

Articles
Reviews
Blog
Media Gallery
Discussions
Members
Channel Home

91 Tips for Calculating with Microsoft Excel

Article by Mr Excel (11,376 pts

)

Published on Jun 19, 2008

The Ultimate resource for Excel calculations. Taken from the fabulous book 'Learn Excel from Mr Excel' - written by Bill Jelen. This table of contents provides a walk through of Microsft Excel calculations and processes.

606 views

Table of contents for Calculating with Excel.

Copy a Formula That Contains Relative References
Copy a Formula While Keeping One Reference Fixed
Create a Multiplication Table
Calculate a Sales Commission
Simplify Entry of Dollar Signs in Formulas
Learn R1C1 Referencing to Understand Formula Copying
Create Easier-to-Understand Formulas with Named Ranges
Use Named Constants to Store Numbers
Build a Formula Using Labels Instead of Cell Addresses
Use Natural Language Formulas to Refer to the Current Row
Assign a Formula to a Name
Total Without Using a Formula
Count, Average, etc Without Using a Formula
Add Two Columns Without Using Formulas
How to Calculate Sales over Quota
How to Join

Two Text Columns
How to Sort on One Segment of an Account ID
How to Isolate the Center Portion of an Account ID
How to Isolate Everything Before a Dash in a Column by Using Functions
How to Use Functions to Isolate Everything After a Dash in a Column
How to Use Functions to Isolate Everything After the Second Dash in a Column
How to Separate a Part Number into Three Columns
Avoid #REF! Errors When Deleting Columns
Create Random Numbers
Create Random Numbers to Sequence a Class of Students
Play Dice Games with Excel
Play Bunco with Excel
Play Craps with Excel
Create Random Letters
Convert Numbers to Text
Calculate a Loan Payment
Calculate Many Scenarios for Loan Payments
Get Help on Any Function While Entering a Formula
Discover New Functions Using the ƒx Button
Three Methods of Entering Formulas
Use AutoSum to Quickly Enter a Total Formula
AutoSum Doesn’t Always Predict My Data Correctly
Use AutoSum Button to Enter Averages, Min, Max, and Count
The Count Option of the AutoSum Doesn’t Appear to Work
Automatically Number a List of Employees 212 Rank Scores
Sorting with a Formula
Rank a List Without Ties
Add Comments to a Formula
Calculate a Moving Average
Calculate a Trendline Forecast
Build a Model to Predict Sales Based on Multiple Regression
Use F9 in Formula Bar to Test a Formula
Quick Calculator
When Entering a Formula, You Get the Formula Instead of the Result
Calculate a Percentage of Total
Calculate a Running Percentage of Total
Use ^ Sign for Exponent
Raise a Number to a Fraction to Find the Square or Third Root
Calculate a Growth Rate
Find the Area of a Circle
Figure out Lottery Probability
Help Your Kids with Their Math
viii of xii LEARN EXCEL FROM MR E
Measure the Accuracy of a Sales Forecast
Round Prices to Next Highest $5
Why Is This Price Showing $2785000001 Cents?
You Change a Cell in Excel but the Formulas Do Not Calculate
Use Parentheses to Control Order of Calculations
Before Deleting a Cell, Find out if Other Cells Rely on It
Navigate to Each Precedent
Formula Auditing
How Is This Cell Calculated?
Total Minutes That Exceed an Hour
Convert Text to Minutes and Seconds
Convert Text to Hours, Minutes, and Seconds
Convert Times From H:MM to M:SS
Display Dates as Months
Group Dates by Month
Calculate Last Day of Month
Create a Timesheet That Can Total over 24 Hours
Find Which Customers Are in an Existing List
Use VLOOKUP to Find Which Customers Are in an Existing List
Match Customers Using VLOOKUP
Watch for Duplicates When Using VLOOKUP
Count Records That Match a Criteria
Build a Table That Will Count by Criteria
Build a Summary Table to Place Employees in Age Bands
Total Revenue from Rows that Match a Criterion
Use Conditional Wizard to Help with SUMIF
Create a CSE Formula to Build a Super Formula
Learn to Use Boolean Logic Facts to Simplify Logic
Replace IF Function with Boolean Logic
Test for Two Conditions in a Sum
Can the Results of a Formula Be Used in COUNTIF?
Back into an Answer Using Goal Seek
Protect Cells with Formulas

Part 1: The Excel Environment

Part 2: Calculating with Excel

Part 3: Wrangling Data

Part 4: Formatting Excel

View more Home Office Tech Articles >

91 Tips for Calculating with Microsoft Excel

More From This Author

Channel Tags

Recent Articles...

Recent Reviews...

Recent Blogs...