|
|
|
|
Microsoft Excel Tips
& Solutions from MrExcel
Welcome to MrExcel.com
- a website that offers support and a wide variety of services to users of
Microsoft Excel.
We are glad you're here. Select
your area of need from the offerings below and enjoy your visit to MrExcel.com!
|
 |
|
|
| |
|
 |
| |
|
Available: 1-June-2012 |
|
|
"Don't Fear The Spreadsheet"
- Available June 1ST, 2012
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.
Taken from
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. After what
seemed an eternity of awkward and terrifying silence, Bill Jelen
turned to me and said, “I’m not sure what you mean.” I repeated
my question. 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.
Don't Fear
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! |
|
| |
|
|
|
| |
|
|
|
|
The
Microsoft
Excel
Book
That
Has
Helped
Millions!
|
|
|
|

Order This Selection in
Print, Click Here
Order This Selection in
E-Book, Click Here
|
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!
512 Excel
Mysteries Solved!
"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
Excel...Available
Now in Print and E-Book versions!
"Each featured topic
has a problem statement and description,
followed by a broad strategy for solving
the problem."
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...
Click Here
|
|
|
|
|
|
|
|
MrExcel
Podcasts! Now on WordPress!
Click Here To
Go Now!
Looking for More from Microsoft Excel?
If so, then you've come to the
right place. View our recommendations below.
|
Excel Tutorials and Resources:
Excel Forum:
The fastest way to get an answer to your Excel problem is to post it to the new
MrExcel Forum. The Excel Forum answers over 30,000 questions a year for free and is the most popular section of MrExcel.
Excel Podcasts:
-
Download and watch a daily 2-minute
podcast about Excel right on your PC.
-
The Learn Excel from MrExcel Podcast Blog has over 1000 podcast videos on Excel tips and techniques.
-
Directory of Excel video tutorials - over 600 video tutorials online, for free and indexed by topic.
-
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.
-
Crunching Data with Pivot Tables in Excel 2003 - Seven videos covering over 1 hour of Pivot Table basics & tips.
Excel Articles:
There are over 485 articles published here where
MrExcel explains, in plain English, powerful ways to make Excel sing. Peruse the
Excel article archive.
Excel 2007:
Visit the Excel 2007 Resource Page
to learn about the updates made in this latest version of Excel.
Excel Consulting:
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.
Or get more information on the INTUITIVE, INTERACTIVE, and SIMPLE to use Xcelsius Dashboards .
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.
Excel Training and Seminars:
E-Mail Microsoft Excel Support:
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
Excel forum.
Excel Books and Products
MrExcel's Books - All of MrExcel's great books are available for purchase at the MrExcel Store.
Excel 2007
Quickly learn to utilize the amazing updates in Excel 2007.
|
|
|
|
|
|
See more Microsoft Excel 2007 Books
|
|
|
MrExcel's Top Sellers
|
|
|
Power Excel Seminars
My favorite part of being MrExcel is traveling to entertain and inform people with my Power Excel Seminars. There are now three versions of this seminar available on DVD-ROM.
|
|
|
|
See more Power Excel Seminar Products
|
|
|
Excel for Professionals Series
Maximize your efficiency in Excel at work or for your business.
|
|
|
|
See more Excel for Professionals Series Books
|
|
|
Excel Business Solution Series
Learn Excel quickly and in a concise method using Bill Jelen's proven techniques and tips.
|
|
|
|
See more Excel Business Solution Books
|
|
|
Visual Learning Series
Visual training on Excel and other Microsoft Office programs with self-checks. Learn on your own schedule and at your own pace.
|
|
|
|
See more Visual Learning
products |
|
|
|
All Excel Books & Products: In cooperation with Holy Macro! Books, there are now 33 titles available at the MrExcel Store:
-
Learn Excel 2007
Through Excel 2010 - Filled with the bizarre and arcane - Most tricks will only be of interest to the hard-core Exceller!!
-
Excel
Outside The Box -
Think that you
know everything that there is to know about Microsoft Excel? Guess again.
-
Slaying Excel
Dragons - This enthusiastic introduction
provides support for Excel beginners and focuses on using the program
immediately for maximum efficiency.
-
Excel Gurus Gone Wild: Do the Impossible - Filled with the bizarre and arcane - Most tricks will only be of interest to the hard-core Exceller!!
-
Access 2007 VBA Made Accessible DVD-ROM - How to Steer Access 2007 Using Visual Basic for Applications - 1,110 slides.
-
The Podcast DVD - 634 episodes of the Learn Excel from MrExcel Podcast on one searchable DVD-ROM.
-
Excel 2007 for Scientists and Engineers - a
second edition with expanded content on Excel for scientists and engineers.
-
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.
-
See Sharper with C# DVD-ROM - Learn C# to enhance Excel's features. Bonus - a copy of Visual C# 2005 Express edition is included!
-
Excel 2007 VBA CD-ROM - Get up to speed with on Excel 2007 VBA with this course from the Visual Training Series.
-
Excel 2007 For Scientists CD-ROM - A self-paced visual training package covering Excel 2007 for scientists.
-
Excel 2007 Miracles Made Easy - The quick guide to Excel 2007's new features.
-
Excel 2007 Expert CD-ROM - self-paced visual training course on Excel 2007.
-
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.
-
Office VBA Macros You Can Use Today - 125 cool macros for Excel, PowerPoint, Word, Outlook, and Access.
-
From VBA to VSTO - A book to help VBA programmers get comfortable with VSTO.
-
Guerilla Data Analysis Using Microsoft Excel - for anyone who regularly processes large amounts of data in Excel.
-
Holy Macro! It's 2,500 Excel VBA Examples CD-ROM - whether you've just recorded your first macro or you write Excel VBA for a living, you need this CD!
-
Excel Knowledge Base CD-ROM - an archive of the first 2.5 years of MrExcel Q&A
-
Slide Your Way Through Excel VBA CD-ROM - a self-paced, 5-day course on Excel VBA
-
Excel for Scientists CD-ROM - a self-paced, 3-day course for Scientists and Engineers.
-
Excel for Scientists & Engineers - a complete guide to Excel for Scientists and Engineers.
-
Excel for Teachers - Learn Excel with 25 real-life applications for your classroom.
-
Excel for Marketing Managers - Learn Excel using examples from the world of the marketing manager.
-
Join the Excellers League CD-ROM - a self-paced, 5-day course on Excel.
-
Dreamboat ON WORD - Anne Troy's guide to Microsoft Word
-
Grover Park George ON ACCESS - George Hepworth's guide to developing Access databases.
-
Kathy Jacobs ON POWERPOINT - Kathy Jacob's guide to PowerPoint.
-
Link'em Up ON OUTLOOK - Stephen J. Link's guide to Outlook.
-
Master the Web CD-ROM - a self-paced 3-day course on web design.
-
Access VBA Made Accessible CD-ROM - a self-paced 10-day course on Access VBA.
-
Unleash the Power of OneNote - covering Microsoft OneNote - the best new product from Microsoft in years.
-
Your Access to the World CD-ROM - a self-paced, 7-day course on Microsoft Access VBA.
|
|
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:
Looking for Excel books written in another language? Check out some of the
international titles.
|
Recommended Products, Software, and Services for Excel
Excel Products
-
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
EmployTest@MrExcel.com.
-
Xcelsius Dashboards: Get a competitive edge with Xcelsius dashboards for your business. We specialize in: Executive Cockpits, Financial Interactive, What-if-Analysis, Solutioning tools with real time inputs, ROI or Cost calculators, Budgeting, Benchmark dashboards.
-
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
CafePress.com
|
|
|
|
|
Software for Excel
-
Getting Excel 2007? Add Excel 2003 Menus to Excel 2007!
-
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
KDCalc.
-
Auditors: If you need to crunch through millions of records, check out
ActiveData for Excel.
-
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 AMAZING
EASY-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:
-
Do Access in Excel
-
Simplify PivotTable
-
Complex Filter
-
Merge (Join)
-
Sort, Random, & More
Free 30 Day trial. You will be AMAZED.
-
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.
-
OfficeRecovery.com:
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.
-
Need to do Rollups? Read about the
amazing new software to manage rollups from Balenz.
-
Want to duplicate your Excel calculators on a web page? Convert Excel to JavaScript using
Excel Everywhere
-
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!
-
Check out this cool Formula Manager Add-in for $29.95
-
If you are interesting in stock market investing, you NEED these
AnalyzerXL tools.
-
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!
-
Contractors - while we can design a custom program exactly for your business, first check out these affordable Excel programs:
HomeCOST Estimator,
RemodelCOST Estimator,
RepairCOST Estimator,
JobCOST Controller,
PaintCOST Estimator,
General Cost Estimator,
ContractorPACK Advantage,
Remodel Pack,
BuilderPACK Advantage, or
FloorCost Estimator.
-
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.
|
|
|
|
|
Excel Services
-
Chank Foundry: Design with
Chank Fonts.
-
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!
-
Add yourself to the MrExcel Community Map!
-
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 Information
|
|
|
|
|
|
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
all situations. |
|
|
|
MrExcel.com debuted on November 21, 1998. Last updated
May, 2012. All contents copyright 1998 - 2012 by MrExcel.com.
|
|
|
|
There are over 150,000 pages at
MrExcel.com
Use Google
to search our site:
|
|
|
|
|
|
Learn Excel RSS |
|
|
|
|
|
 |
CFO EXCEL PRO
Weekly E-Newsletter |
 |
|
|
 |
|
|
 |
|
|
 |
|