"This is a fun book about Microsoft Excel. It covers using Excel for a variety
of simulations - from Gambling to Genetics. Most books in this category are
$100+ Text Books. This title offers a solid introduction to using Microsoft
Excel Simulations in the disciplines of Business, Science, and Casino Gaming."
Learn Excel 2007 through Excel 2010 from MrExcel
Available Now in Print and E-Book versions!
Master Pivot Tables,
Subtotals, Charts, VLOOKUP, IF, Data
Analysis, and Much More!
"Includes 35% more tips
than the previous edition. "
This is an in-depth look at the topics
from Bill's Power Excel Seminar. In the
process of solving 512 real-world
business problems, you will learn how to
use Excel more efficiently than you ever
thought possible. The new topics include
features unique to Excel 2010, and new
techniques available in all versions of
Now in Print and E-Book versions!
"Each featured topic
has a problem statement and description,
followed by a broad strategy for solving
Many Excel books try to go in a serial
fashion through every single Excel
option. These books are tough to use. No
one at my dinner table ever uses the
word "concatenation" in dinner
conversation. How would you know to turn
to the chapter on concatenation when you
need to learn how to join a column of
first names with a column of last names?
This book offers 512 real-life business
problems. To Learn More...
The Microsoft Excel Book
To Get You Started in Excel!
"Don't Fear The Spreadsheet"
Available! [Print, ePub or PDF Version]
by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones
What is 'Don't Fear The Spreadsheet'?
The Ultimate, Straight Forward Excel Beginner's Guide.
the Foreword of 'Don't Fear The Spreadsheet':
“Excuse me,” I interrupted. “You are aware that there are people
out there who haven’t a clue what to do after opening Excel,
right?” Crickets…. Followed by a table of people staring at me….
Silent, both astonished and horribly disappointed... It was at that moment that I realized that the
group of Excel geniuses that surrounded me had been so far
removed from their first days of Excel, that they couldn’t
fathom such a statement.
The Spreadsheet starts with clicking that Excel icon on your desktop
and opening your first Excel Workbook. What develops is a logical
and concise directive guiding you to a better understanding of
Excel, what Excel is capable of and how YOU CAN use it!
Click Here to learn more about this book...
A definitive guide to VBScript. Tired of trying to learn VBScript without a guide, or by reverse engineering existing programming? With 367 slides, this self-paced training package is loaded with informative sample VBScripting plus frequent self-tests to enhance your learning.
The Podcast DVD-ROM - A searchable DVD-Rom with over 20 hours of the Learn Excel from MrExcel daily 2-minute podcasts.
OnHome&Office podcast by InformIT with 'experts' showing tips and tutorials on everything you need to get more out of the technologies you rely on at work and for play. This
link will let you subscribe at iTunes.
For problems that are more complex, or if you need a complete application, hire MrExcel Consulting to do
Excel or Office consulting by e-mail. MrExcel and a team of consultants work full time developing applications that work with Excel, Access and all of the Office Applications. We develop applications of various sizes for clients around the world, from Western Australia to Argentina to Palo Alto, California to London, England.
We offer expertise in VBA (Visual Basic for Applications), Lotus to Excel macro conversion,
emergency data analysis in Excel, Access, PowerPoint, Outlook, and custom
map design in MapPoint or MapInfo, and more.
MrExcel Engineering and Graphics Division: Mala manages our MrExcel Engineering & Graphics Division, which specializes in developing solutions to engineering problems and creates some of the most incredible graphics automation macros. Whether you are looking for engineering graphs or new chart types, check out Mala's work at the MrExcel
Graphics & Engineering Division. The Engineering division can automate your Excel to AutoCad needs or custom design a new chart type for you.
E-mail your problem to MrExcel. The best problems will be published on this site, in either the Daily Tips Weblog or as a Tip of the Week with our solutions. Due to the volume of mail received, MrExcel can not respond personally to all requests. Why am I giving away Excel answers? Your questions are helping me write a book of Excel tips. I'm betting the problem that is plaguing you is plaguing others out there. Note:
MrExcel uses Excel 97, 2000, 2002, 2003, & 2007 in Windows XP & ME. For questions which are specific to a Mac or to Excel 4.0, MrExcel will not be able to help. Try the
Business Basics & Beyond - if you're tired of tracking business finances
manually, preparing staffing schedules by hand, or simply want to know how
to get more information from your business data then this book is for YOU.
The Spreadsheet- The Ultimate, Straight
Forward Excel Beginner's Guide. Go from Fear of Excel to Empowerment with
Learn Excel 97 through Excel 2007 From MrExcel
- 377 Excel Mysteries Solved - This book takes an in-depth look at the topics from Bill's Power Excel Seminar. In the process of solving 377 real-world business problems, you will learn how to use Excel more efficiently than you ever thought possible. Updated to cover Excel 97 through Excel 2007, this book includes 100 new topics.
Excel for The Math Classroom - Discover powerful uses of Excel to help bring math concepts home for your students and enable your students to become better at mathematics.
Excel for Auditors - Learn essential Excel skills for analyzing mounds of data as well as tips to make your use of Excel far more efficient.
Excel for the CEO - Learn how to use Excel in running your business using the "do & learn" style of teaching, enabling you to learn the techniques in an easy yet definitive way, which will remain forever in the mind.
Learn Excel From MrExcel - 277 Excel Mysteries Solved - Discusses solutions, strategies, and gotchas for 277 real life Excel problems.
You can now find these books at your local Barnes & Noble, Borders, MicroCenter, Indigo and many indepdendent bookstores.
If you need a single book shipped to Canada, the United Kingdom, or the United States, you can save on shipping using one of these ExcelBookstore sites:
Recommended Products, Software, and Services for Excel
EmployTest - Test your potential job applicants efficiency in Excel! The interactive (not multiple choice) Excel tests show you exactly what they know or don't know. To see how it works or to get a free sample test, email us at
Visit ExcelGuru.net for a full line of mugs and shirts with sayings that all true Excel fans will understand.
Just Back away from the keyboard!
Friends Don't Let
Friends Use Lotus
You can also buy the MrExcel logo on our new shirts, mugs, clocks at
MrExcel's Recommended Books Bookstore - There are many other great Excel books out there. Let MrExcel recommend a perfect book for users at various levels. Visit the
MrExcel Bookstore to read my review and then purchase the cream of the crop of Excel books over the Internet.
Convert PDF to Excel or Word using
Able2Extract. It is annoying how people use PDF now to ensure that you can not change their data. This easy-to-use utility will grab data from PDF files and quickly send it to Excel or Word. The Pro version can even take the super-hard-to-crack PDF files where all of the text is saved as an image and convert it to Excel. Check out my
review of the product with screenshots.
If you want to take your worksheets to the web, check out
Are you working with big Excel workbooks that are difficult to maintain because of their size? Then Palo is for you. Palo is an advanced data store for Microsoft Excel that allows you to handle large amounts of Excel data on a small number of worksheets. In addition, it also allows you to share Excel data real-time with your colleagues. What is Palo? Click here for more information.
If you have to deal with massive amounts of data, you have to try out the AMAZINGEASY-XL Add-in. You will wonder how you ever lived without it. Unlike the general-purpose utility add-ins, this POWERFUL add-in truly extends the power of Excel. Here are some of the features:
The number one complaint is from people suffering from a corrupt Excel file that will not open. Recover hours or days of lost work with these products or services!
ExcelFIX Software: Recover data, charts, images, comments, merged cells, groups and outlines, subtotals, and all the formula elements from a Microsoft® Excel file that shows an error on opening in 15 minutes.
the web source of data recovery software for email, databases and office productivity applications. Over 40 quality software products are available to meet your data recovery needs.
Or, if you want to hire someone to solve your corrupt file problem, Florent Chassignol has launched a service called
ExcelWordRecovery.com. The Excel recovery software is pretty easy to use, but if you would rather hire someone, give Florent a try. Send your file to Florent, and they will recover the entire file. The ExcelWordRecovery service can also recover files from damaged floppy disks. As a special offer, list the Discount Code of "MrExcel.com" at ExcelWordRecovery and receive 10% off the price of their excellent service.
Want to lose weight? Try the new
Weight Loss Boss from Ron Martin, author of Success Made Easy.
LostPassword.com: Lost Passwords? The software at
LostPassword.com can help. If you have just one file to decrypt, try the new service from
decryptum.com. They offer instant online recovery service for password protected MS Word and Excel files, with free online preview of encrypted file content!
If you are interesting in stock market investing, you NEED these
If you are a techie who has to have the coolest toys, you should check out the
Neural Network Tool for Excel. This add-in will help you forecast business, financial or sports outcomes.
Excel OCX for VB Programmers is a powerful ActiveX Control with over a hundred useful functions to
assist in exchanging data between Excel and Visual Basic and much more using COM
technology! Included in the download is a sample Visual Basic project which
demonstrates the power of Excel OCX. Try it now and see for yourself how your programming time can be cut down drastically with this handy control!
In his book, Beautiful Evidence, Edward Tufte introduced the concept of SparkLines. A SparkLine compresses intense amounts of data into a word-sized graphic like the ones shown below.
SparkMaker allows you to add SparkLines to Excel. The free version can produce simple sparklines like the left example below. The Basic edition adds the SparkBars and the Pro Edition adds Excel functions to dynamically generate multi-color SparkLines. In the top right example, the monthly stock price for Google for 28 months. The red bar is the low, the blue bar is the high. Below that, the monthly stock price for Microsoft. Rather than show the current value of something on a dashboard, add a SparkBar to show the history of that number.
Charley Kyd is the king of Excel dashboards. He has put together an EXCEL-lent kit showing how to make cool dashboards using nothing more than Excel. You get his e-book plus 18 sample files. I love this kit! Anyone responsible for reporting data to managers should have a copy of the
If you are tired of Intuit's Quicken, check out XLYourFinances for a $20 Excel-based tool for managing your finances.
MrExcel has partnered with EmployTest to offer tests to insure your job applicants have what it takes! It’s fast, efficient and will give you confidence to make a smarter hiring decision. The result is an easy to read Score Report, which is instantly emailed to you. We're offering a special deal to MrExcel site visitors! For more information see this page on
Pre-employment tests by EmployTest.
Interact within the MrExcel Community
Become a fan of MrExcel.com on Facebook
and get the latest news on seminars, webinars, and all that is happening in the MrExcel community.
Challenge of the Month: Take a stab at solving an
Excel Challenge and win fame and fabulous MrExcel merchandise.
Check out the free cool spreadsheets developed by the MrExcel community. Donate yours too!
Send in your Excel question for an episode or a 'better solution' to a previous episode of the daily, 2 minute
Learn Excel from MrExcel Podcast
and possibly earn the MrExcel master pin for top, new tips.
Check out our photo album of various people we've met from the MrExcel community.
Can You Total That Diagonally For Me? Seasoned Excel veterans will appreciate this feature, which looks at the bizarre and seemingly impossible requests handed down from real managers. To qualify for inclusion here, the problem must cause MrExcel.com's brain to nearly explode.
MrExcel.com provides examples of
Formulas, Functions and Visual Basic procedures for illustration only,
without warranty either expressed or implied, including but not limited to
the implied warranties of merchantability and/or fitness for a particular
purpose. The Formulas, Functions and Visual Basic procedures on this web
site are provided "as is" and we do not guarantee that they can be used in
MrExcel.com debuted on November 21, 1998. Last updated
Today. All contents copyright 1998 - 2012 by MrExcel.com.
There are over 150,000 pages atMrExcel.com Use Google
to search our site: