The Neat Company NeatScan To Office Scans to Excel Outlook Word and PowerPoint (White)

SCANNER, NEAT SCAN TO OFFICE, USB 2

Price: $279.95

Click here to buy from Amazon

Vending Machine Company Business Plan - MS Word/Excel

The Vending Machine Company Business Plan is a comprehensive document that you can use for raising capital from a bank or an investor. This document has fully automated 3 year financials, complete industry research, and a fully automated table of contents. The template also features full documentation that will help you through the business planning process. This is a full and complete business plan with original research, financial models, and marketing/advertising plans that are specific for a Vending Machine Company. Since 2005, BizPlanDB and its parent company have helped raise more than $100,000,000 through its developed plans.

Price:

Click here to buy from Amazon

Wine Cellar 2.1 Template for Microsoft® Excel Lets You Easily Track Your Personal Wine Collection

Wine Cellar 2.1 Template for Microsoft® Excel lets wine enthusiasts easily track and manage personal wine collections. The template saves people the time of setting up their own system. Data entry is easy and wines can be sorted by varietal, pairing, when to drink, quantity, price and many other categories. The spreadsheet can be customized to match different collections. Please note that the template is delivered via email. Added information: Very important; the template is designed for personal use where someone doesn't want to have to stand in their cellar or thumb through a notebook trying to decide what to drink. If you are in a business where you have to manage wine inventory, this is not the right solution. You need inventory management software.

Price:

Click here to buy from Amazon

Excel 2007 Bible

• This book is a single reference thatâ??s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers wonâ??t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the liworldâ??s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Price: $39.99

Click here to buy from Amazon

Apple iWork '08 [OLD VERSION]

Item #: 35072F. Apple's amazing productivity suite for the Mac, iWork '08 includes three applications: Pages '08 for word processing with an incredible sense of style; Numbers '08 for powerful, compelling spreadsheets made easy; and Keynote '08 for cinema-quality presentations for everyone.

Product Description
IWork '08 - complete package
Category: Office applications
Subcategory: Office applications - presentation, office applications - word processor
License Type: Complete package
License Qty: 1 user
License Pricing: Standard
Platform: MacOS
Distribution Media: CD-ROM
Package Type: Retail
OS Required: Apple MacOS X 10.4.10
Customers also search for: Discount IWork '08 - Complete Package - 1 User - CD - Mac, Buy IWork '08 - Complete Package - 1 User - CD - Mac Wholesale IWork '08 - Complete Package - 1 User - CD - Mac, 0885909140244, MA790Z/A, Photo Editing Software

Price: $74.00

Click here to buy from Amazon

Use copy paste & to maintain references to tables [Quick Tip]

Posted on 23 May 2011 to learn Excel-9 comments

Using Excel 2007, Microsoft introduced powerful and useful feature called as tables. One advantage of tables that you can write formulas readable using structural references. This means, you can write easy to understand such formulas,

[Help SUMIF formula]

But there is a problem. When you type this formula and dragging formula cell remaining side fill cells, Excel changes the reference columns of the table and thus makes your formulas almost useless.

In addition, there is a simple solution for this problem.

Instead of dragging the cell to fill the formulas, you can use the copy paste to fill formulas &. In this case, Excel preserves all references table while changing cell references and accordingly. Watch this demo to understand:

Since the found feature tables in Excel 2007, I have been using them to save time and simplify working with data. Schedules of many useful features that make life simple for analysts and data junkies everywhere.

What about you? Are you using Excel tables? What are the tricks above your table? Participation please use the comments.

If you use Excel 2007 or above, I encourage you to learn Excel tables. They make your life simpler. Go to the bottom of articles for more information,

Spread some love
It makes you fabulous!

& Navigation functions

Tags: data Excel Excel Excel tables, see "Paste" and "quick tip", "References" and "screencasts" and "spreadsheets" and "structured references", "sumif)

RSS feed for comments on this post. TrackBack URI

View the original article here

Lost Excel functions

Error in deserializing body of reply message for operation 'Translate'. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 2, position 9250.
Error in deserializing body of reply message for operation 'Translate'. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 1, position 13902.
Posted on May 16th, 2011 in Excel Howtos , Huis , Posts by Hui - 26 comments

Following on from Chandoo’s MLookup function published on 1st April 2011, I thought it might be worth documenting a few undocumented, no-longer documented and rarely used Excel functions.

Although some of the functions below aren’t documented they still work as of Excel 2010.

Users should be cautious with their use going forward as Microsoft may withdraw them from future versions of Excel.

But if you see them appear in older Excel models at least you’ll be the full bottle.

This post will look at the following functions:

DatedifRoundupRoundDownEvaluateConvertRomanFactDoubleBahttext

Worked examples of all these functions are presented in the Example File which is compatible with all versions of Excel.

The DATEDIF function computes the difference between two dates in a variety of different intervals, such number of years, months, or days.

This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000.

By the way, do not confuse the DATEDIF worksheet function with the VBA DateDiff function.

=DATEDIF(Start Date, End Date, Interval)

Where:
Start Date must be less than the End Date.

Interval is the interval type to return.

Interval value must be one of the following:

Complete calendar months between the dates.Number of days between the dates.Complete calendar years between the dates.Complete calendar months between the dates as if they were of the same year.Complete calendar days between the dates as if they were of the same year.Days Excluding Years And MonthsComplete calendar days between the dates as if they were of the same month and same year.

If you are including the Interval string directly within the formula, you must enclose it in double quotes:

=DATEDIF(Date1,Date2,”m”)

Datedif has been used a number of times at Chandoo.org

http://chandoo.org/forums/topic/how-to-calculate-age-from-their-dob

http://chandoo.org/wp/2009/09/22/elapsed-time-excel/

http://chandoo.org/wp/2008/08/26/date-time-tips-ms-excel/

Disclaimer:

Although the Datedif function above isn’t documented it still works as of Excel 2010. Users should be cautious with their use going forward as Microsoft may withdraw support for them in future Excel versions.

The Roundup and Rounddown functions rounds a number up or down, away from zero and have pretty much been replaced by the Round function.

The Roundup function rounds a number up, away from zero.

=ROUNDUP(number, num_digits)

The Rounddown function rounds a number down, towards zero.

=ROUNDDOWN(number, num_digits)

Roundup() behaves similarly to the Round() function, except that it always rounds a number up based on the following rules:

If num_digits is greater than 0, then number is rounded up to the specified number of decimal places.If num_digits is 0 or omitted, then number is rounded up to the nearest integer.If num_digits is less than 0, then number is rounded up to the left of the decimal point.

ROUNDUP(4.1,0) equals 5

ROUNDUP(106.9,0) equals 107

ROUNDUP(3.14159, 3) equals 3.142

ROUNDUP(-3.14159, 1) equals -3.2

ROUNDUP(31415.926, -2) equals 31500
Rounddown() behaves similarly to the Round() function, except that it always rounds a number down based on the following rules:

If num_digits is greater than 0, then number is rounded down to the specified number of decimal places.If num_digits is 0 or omitted, then number is rounded down to the nearest integer.If num_digits is less than 0, then number is rounded down to the left of the decimal point.

ROUNDDOWN(4.1, 0) equals 4

ROUNDDOWN(106.9,0) equals 106

ROUNDDOWN(3.14159, 3) equals 3.141

ROUNDDOWN(-3.14159, 1) equals -3.1

ROUNDDOWN(31415.92654, -2) equals 31400

The Roundup and Rounddown functions have been used several times at Chandoo.org

Roundup

http://chandoo.org/wp/2010/04/29/quarterly-totals-from-monthly-data/

http://chandoo.org/wp/2010/04/30/quarterly-totals-multi-year-data/

Rounddown

http://chandoo.org/wp/2010/04/30/quarterly-totals-multi-year-data/

http://chandoo.org/wp/2009/07/06/excel-formulas-round-sort/

Evaluate is an Excel ver 4.0 macro function which is still supported and functional in Excel 2010.

The Evaluate function allows for the evaluation of a text equation as an algebraic equation.

The evaluate function cannot be used as a spreadsheet function but can be used in Named Ranges.

It is probably best described by example; Evaluate 1, from the Example File.

Say you have a polynomial equation in a cell as Text A1: ‘=X2 + 5*Y – Z

Setup 3 named ranges, X, Y , Z with values X=10, Y=5 and Z=3

You can use Evaluate in a a Named Range eg: Result =Evaluate(SheetName!$A$1)

And then on a worksheet =Result, which will return the answer 122 = 102 + 5*5 – 3

Evaluate can be used to allow graphing of equations without use of worksheet functions or even worksheet ranges, an example of each is shown in the examples file as Evaluate 2 and Evaluate 3 .

Evaluate 2: Uses a Range as the X Values and a Named Range using the Evaluate function as the calculated Y Values

Evaluate 3: Uses Named Ranges as the X Values and as the calculated Y Values based on an Evaluate function

Use of the Evaluate function on Chandoo.org:

Not Used

Converts a number from one measurement system to another.

For example, CONVERT can translate a table of distances in Kilometres to a table of distances in Miles.

Convert includes 49 units spread amongst the following 10 categories

=Convert(number, From Unit, To Unit)

A list of all the Conversion Units and Conversion Prefixes is included on the Conversion Factors tab of the Examples File.

Converts a 5 pound mass to kilograms (2.267)Converts 80 degrees Fahrenheit to Celsius (26.6)Data types are not the same so an error is returned (#N/A)‘=CONVERT(CONVERT(100,”ft”,”m”),”ft”,”m”)Converts 100 square feet into square meters (9.290304).

A list of all the Conversion Units and Conversion Prefixes is included on the Conversion Factors tab of the Examples File.

http://chandoo.org/forums/topic/convert-function

The Roman function converts a number to Roman format.

=ROMAN(number, form)

=ROMAN(45 ) = XLV

Form is a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases.

More concise. See example below.More concise. See example below.More concise. See example below.Converts 499 to Roman (CDXCIX)Converts 499 to Roman (CDXCIX)Converts 499 to Roman (LDVLIV)

Nil

Factdouble returns the double factorial of a number and is expressed in mathematics as n!!

Double factorials are used in probability theory and other higher levels of mathematics and is really just a way to simplify an otherwise complex expression

If the number is Even Factdouble = n(n-2)(n-4)…(4)(2)

If the number is Odd Factdouble = n(n-2)(n-4)…(3)(1)

So it is simpler to write 10!! than 10x8x6x4x2

=Factdouble( number )

Factdouble of 8 = 8x6x4x2 = 384Factdouble of 9 = 9x7x5x3x1 = 945

Not used

Converts a number to Thai Text represention of the number

Use:

=Battext( Number)

=Bahttext(250) , Returns

Not used

An example file with worked examples from all the above functions is available from the following link; Example File

The file is compatible with all Excel versions.

What Functions Have You Stumbled Onto?

Let us know in the comments below:

Spread some love,
It makes you awesome!

Posts & Navigation

Tags: Convert, Datedif, Evaluate, FactDouble, Learn Excel, Microsoft Excel Formulas, Roman, rounddown(), roundup, spreadsheets

RSS feed for comments on this post. TrackBack URI

View the original article here