Your One Stop for Excel Tips & Solutions


 

MrExcel - Photos of MrExcel
Questions
About MrExcel
Consulting Services
Learn Excel Resources
Excel - Visual Learning
Challenge of the Month
MrExcel Seminars
Message Board
MrExcel Store
Learn Excel Blog
Search
Media
Contact
Home
Having an Excel Emergency?

Read The Latest...

Learn Excel Blog   MrExcel on YouTube   Excel Daily News   Amazon MrExcel Books

Let's Connect

Twitter @MrExcel   Facebook MrExcel   LinkedIn Bill Jelen   Google+ Bill Jelen

LinkedIn - MrExcel.com   Google+ MrExcel.com   Facebook - Bill Jelen   Pinterest - Bill Jelen

GoodReads - Bill Jelen   About.Me Bill Jelen   RSS - MrExcel Forum Hot Topics   RSS - Learn Excel Blog

 

 

 

 
QQube for Quickbooks Information Page

Microsoft Excel Tips & Solutions from MrExcel

 

 

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:

Excel Articles:

  • The Excel Daily News - by Bill 'MrExcel' Jelen: a daily e-publication designed to keep you informed on up-to-the-minute Excel Technologies and More!

  • 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 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).

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:

  • MrExcel will perform on-site advanced Excel training at your location. Choose a session that suits your organization.

  • To see when MrExcel will be presenting a seminar in your area, check the list of scheduled Excel seminars around the country.

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 2010 & 2013. 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 2013 and Earlier Versions

 

"Learn Excel 2007 Through Excel 2010" by Bill Jelen
"Learn Excel 2007
Through Excel 2010"
by Bill Jelen

Buy Now button
spacing bar
More Info button


Excel 2013
In Depth
by Bill Jelen

Buy Now button
spacing bar
More Info button

 

 

MrExcel's Top Sellers

Excel 2007 Power Bundle Excel 2010 Pro Power Bundle
Excel 2010
Pro Power Bundle

Buy Now button
spacing bar
More Info button


Holy Macro!
It's 2,500 VBA Examples

Buy Now button
spacing bar
More Info button

 

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.

LiveLessons DVD picture
LiveLessons
Power Excel 2013
DVD-ROM

Buy Now button
spacing bar
More Info button

LiveLessons DVD picture
LiveLessons
Excel VBA and Macros
DVD-ROM

Buy Now button
spacing bar
More Info button

See more Power Excel Seminar Products

 

 

Excel for Professionals Series

Maximize your efficiency in Excel at work or for your business.

Excel for Auditors Book
Excel for Auditors

Buy Now button
spacing bar
More Info button

Excel for the Small Business Owner Book
Excel for the Small Business Owner

Buy Now button
spacing bar
More Info button

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.

VBA and Macros for Microsoft Excel 2013 Book
VBA and Macros
for Microsoft Excel

(Excel 2013)

Buy Now button
spacing bar
More Info button

Charts and Graphs for Excel 2013 Book
Charts and Graphs for Excel 2013

Buy Now button
spacing bar
More Info button

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.

Excel 2007 Expert DVD-Rom Picture
Excel 2007 Expert

Buy Now button
spacing bar
More Info button

Excel 2013 VBA
Excel 2013 VBA

Buy Now button
spacing bar
More Info button

See more Visual Learning products

 

All Excel Books & Products: In cooperation with Holy Macro! Books, there are now 35+ titles available at the MrExcel Store:

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.

  • Visit ExcelGuru.net for a full line of mugs and shirts with sayings that all true Excel fans will understand.

Excel Guru Shirt

       Just Back away from the keyboard!

spacing bar

Excel Guru Mug

     Friends Don't Let Friends Use Lotus


You can also buy the MrExcel logo on our new shirts, mugs, clocks at CafePress.com

spacing bar
spacing bar
spacing bar
Excel Function Clock
  Excel Function Clock
spacing bar
spacing bar
spacing bar
spacing bar
spacing bar
spacing bar
spacing bar
spacing barspacing bar
License Plate Frame
    License Plate Frame
  • 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.

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.

  • 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 Dashboard kit

  • If you are tired of Intuit's Quicken, check out XLYourFinances for a $20 Excel-based tool for managing your finances.

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


 

DMCA.com

 

Spread the Word Excel
submit to reddit
Search MrExcel.com
150K Pages of Excel


The Daily News  - with Bill 'MrExcel' Jelen
 
"Power Excel 2013" with Bill Jelen a.k.a. MrExcel!
"Easy-XL" from MrExcel!
 
 
     
   
 

MrExcel.com debuted on November 21, 1998.

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.

Excel ® is a registered trademark of the Microsoft Corporation.
MrExcel ®
TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved