|
Welcome to MrExcel.com, a website that offers support and a wide variety of services to users of Microsoft Excel software, including the following.
- MrExcel.com Message Board: The fastest way to get an answer to your Excel problem is to post it to the new
Mr. Excel Message Board. The Message Board is the most popular section of Mr. Excel.
- I have over 600 video tutorials online, for free. You don't have to spend an entire day at computer class. Learn something in 2-4 minutes: Excel Videos.
- MrExcel.com Consulting: For problems that are more complex, or if you need a complete application,
hire Mr. Excel 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.
- There are over 150,000 pages at MrExcel.com. Use Google to search our site:
- Keep track of what's new at MrExcel in my Blog.
- Check out free spreadsheets from our community!
- If you are upgrading to Excel 2007, check out Bill Jelen's books on Excel 2007:
- 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:
- MrExcel's best selling book for Excel 97-2003 solves 277 Excel mysteries. All questions are posed by real Excel users at my Excel Power Seminars. There are three great ways to get this book.
- Buy the print version of the book.
- Buy the E-Book version. My only regret is that the book is a heavy book. We are finding that airmail shipping to England and Australia is costing as much as the book (not to mention the customs and GST fees added by your country at the border). Usually, publishers wait a few months to offer an E-Book, but in order to make it easy to get the book out internationally, you can buy the e-Book for immediate download. Even US customers in a hurry might appreciate this option.
- Try before you buy! Over 6 million chapters of the book have been given away. Sign up at this page to get a free chapter a week, every week.
CLICK HERE FOR DETAILS
- Excel for Professionals Series:
Click on the title for more information on the book.
Click on the book picture to purchase.
- Business Solution Series:
Click on the title for more information on the book.
Click on the book picture to purchase.
- Resources for Learning Excel VBA :
Click on the title for more information.
Click on the picture to purchase.
- Visual Learning Series :
Click on the title for more information.
Click on the picture to purchase.
- COOL: Download and watch a daily 2-minute podcast about Excel right on your PC. This article walks you through setting it up.
DAILY 2-MINUTE VIDEO PODCAST TO YOUR PC
It’s hard to believe, but in the 2.5 years since the podcast started, we’ve produced over 630 episodes with 21+ hours of Excel content. I don’t think anyone at iTunes considered a daily podcast when they set the limit to 50 episodes per podcast. Since it is becoming increasingly difficult to find all of the episodes, I’ve burned them all on a single DVD-ROM:
- 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
- Books: In cooperation with Holy Macro! Books, there are now twenty-eight titles available:
- 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 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.
- 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.
- Your Access to the World CD-ROM - a self-paced 7-day course on Access.
- Unleash the Power of OneNote - covering Microsoft OneNote - the best new product from Microsoft in years.
You can now find these books at your local Barnes & Noble, Borders, MicroCenter, Indigo and many indepdendent bookstores.
- The MrExcel Online store can ship books around the world and offers great deals on bundles. However, 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:
- Check out our photo album of various people we've met from the MrExcel community.
- Bill Jelen is proud to have been named 2003 Computer America Guest of the Year.
- Training: MrExcel can perform on-site advanced Excel training at your location. Or, if you want to escape your work location, come to one of our 1-day Power Excel Seminars in Akron, our 3-day Power Analyst Boot Camps or various seminars around the country.
- If you need a birthday present for your favorite Excel guru, why not buy them one of our hilarious Excel Function Wall Clocks! Each numeral has been replaced by an Excel function that evaluates to that numeral. Perfect for CPA's, auditors, analysts.
- Visit ExcelGuru.net for a full line of mugs and shirts with sayings that all true Excel fans will understand.
- You can also buy the MrExcel logo on our new shirts, mugs, clocks at CafePress.com
- I am honored to have received the Excel black belt from Colo and the Road to the Cell Masters.
- MrExcel.com Engineering and Graphics Division : Mala manages our MrExcel.com 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.com Graphics & Engineering Division. The Engineering division can automate your Excel to AutoCad needs or custom design a new chart type for you.
- Looking for Excel books written in another language? Check out some of the international titles listed here.
- Tips of the Week: Read our archive of articles featuring some aspect of Excel. There are now 485 articles indexed here.
- Archives: The archive from the original message board has 12000 Excel answers. We are updating the New Board Archive with 70000 answers.
- Daily Tips Weblog: Visit my Daily Tips Weblog for a daily dose of Excel solutions. Each morning, I will select some questions from the mailbag and post an answer.
- E-Mail Support: E-mail your problem to
. 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, Mr. Excel 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.com uses Excel 97, 2000, 2002, & 2003 in Windows XP & ME. For questions which are specific to a Mac or to Excel 4.0, MrExcel.com will not be able to help. Try the message board.
- Challenge of the Month: It's back! The hugely popular
feature is a
doozy. Take a stab at solving this problem and win fame and fabulous MrExcel.com merchandise.
- 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's Books All of MrExcel's great books are available at the
MrExcel.com Store to buy these hot titles.
- MrExcel's Recommended Books Bookstore There are many other great Excel books out there. Let MrExcel.com recommend a perfect book for users at various levels. Visit the
MrExcel.com Bookstore to read my review and then purchase the cream of the crop of Excel books over the Internet.
- Article
Archive: There are a number of articles published here where
MrExcel.com explains, in plain English, powerful ways to make Excel sing. Peruse the
article archive.
- Thanks for your generosity! During the 2002 holiday season, MrExcel readers helped raise $210 for FISH. The donors are listed in our virtual store window. During 2004, we raised $2501 for the American Cancer Society's Relay for Life. See a recap here.
- Catch my appearance discussing Excel for Marketing Managers on the Anita Campbell Radio Show.
- Training. If you are in northeast Ohio, be sure to catch one of my entertaining Excel training classes or call to have me appear at a lunchbox seminar at your company. If you are out of the area, see the list of seminar sessions forOnsite Excel Training. If you need something self-paced, then I recommend this excellent training from the Visual Learning Series. These are self-paced CD's by Dr. Gerard Verschuuren. It is completely visualized and is based on self-instruction with constantly recurring self-checks. The examples used are rooted in a wealth of real-life cases and have been extensively tested. The material has been extensively tested during live training sessions and has been widely praised as a very fine piece of curriculum development.
- Slide Your Way Through Excel VBA CD-ROM - a self-paced, 5-day course on Excel VBA.
- Module 1 - Basics of Excel VBA for $65.
This includes Objects: Their properties and methods; Recording Macros + Editing their code; Controlling code with If and Select; Methods vs. Functions; Use Message Boxes and Input boxes; Using Variables for values and objects; Controlling Charts and Pivot Tables. Contains 233 pages.
- Module 2 - How to Calculate with VBA for $65.
This includes Loops: Do / For / For Each; Manipulating cells and ranges; Using Functions in VBA Code; Using relative and absolute formulas; Using temporary arrays; Using array functions; Creating your own functions. Contains 273 pages.
- Module 3 - Let VBA Interact with the User for $65.
This includes Buttons; List Boxes; Combo Boxes; Creating User-Forms for User Interaction;
Data Validation: Checking the user's data entry; Creating Custom Methods; More on Events: Having things done at the right moment; Error Handling: Making your application more professional. Contains 269 slides.
- Save! All 3 VBA Modules for $99.
Buy the complete "Slide Your Way Through Excel VBA" CD - all 775 pages for one low price. This is equivalent to a 5 day training course with Dr. Gerry Verschuuren, a university professor who has taught Excel to thousands of professionals in the northeast.
- Join the Excellers League CD-ROM - a self-paced, 5-day course on Excel.
- Excel for Scientists CD-ROM - a self-paced, 3-day course for Scientists and Engineers.
- Your Access to the World CD-ROM - a self-paced, 7-day course on Microsoft Access.
- Access VBA Made Accessible CD-ROM - a self-paced 10-day course on Access VBA.
- Master the Web CD-ROM - a self-paced 3-day course on web design.
- Excel 2007 Expert CD-ROM - self-paced visual training course on Excel 2007.
- Search: Use the
Search page to see if your question has already been addressed.
|
Recommended Software
- Add entire spreadsheets across dozens or hundreds of workbooks and more with ExcelCube.
- 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 DIG-DB Toolkit 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
- De-dupe
- Enhance & Simplify PivotTable
- Complex Filter
- Merge (Join)
- Sort, Random, & More
Buy now for $49 and download immediately!. You will be AMAZED.
- ExcelWordRecovery.com: 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 the do-it-yourself
Excel Recovery software or
Excel Fix Software. 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 5% off the price of their excellent service. When your job is on the line, point your browser to
ExcelWordRecovery.com or Excel Recovery for proven results.
- 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.
- Zboard Keyboard for Excel
 - All of the Excel shortcuts at your fingertips!
- 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!
- aSchedule.com Do you manage a restaurant? Check out the hot new scheduling application from
aSchedule.com. The concept was developed by a veteran restaurant manager. Tell them
MrExcel.com sent you!
- 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.
- Chank Foundry: Design with Chank Fonts.
Tip of the Week
Using Filter to Find Records in Excel 2007
Leo Laporte, Bill Jelen, and Kate Abraham on the set of The Lab on TechTV Canada.
The tip in this show is from Learn Excel 97 through 2007 From Mr Excel. As mentioned on the show, you can download a free preview of the entire book from this page.
Excel 2007 provides dramatic improvements to the Filter function in Excel. You can quickly filter a list to find a specific customer, records from a certain month, or records highlighted in a certain color.
Try these steps to add an ad-hoc total to your data set:
- Turn on the filter feature as described above.
- Filter the list to one customer: Open the Customer dropdown. Click Select All to unselect all customers. Click on customer to select that customer.
- Select cells directly below the data in the columns for any numeric fields.
- On the Formulas tab of the ribbon, select the AutoSum icon (it is a Greek letter E, or Sigma)
The totals that appear will only total the visible records. So, in this image, one customer had $406K of revenue:
Choose a different customer from the dropdown in D1 and the total will reflect that customer:
New in Excel 2007
- The dropdown for a date column automatically offers a hierarchical view of the dates. Click the plus sign
next to 2007 to see all of the months in 2007. Click the plus sign next to any month to see all of the days in that month.
Or, use the new Date Filters to filter to last week, this month, next quarter, and so on.
- Filter a text field to only records that contain a certain word
- Filter a numeric column to only records above average:
- Filter by color:
To clear all filters, use the Clear icon on the Data tab of the ribbon.
Check back after March 19, 2008 and you can view my segment here.
I really hope to give away 5 million copies of the book, so please send your co-workers and friends to
leobook.html.
MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.
MrExcel.com provides examples of 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 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 Consulting can be hired to implement this concept with your data.
MrExcel.com debuted on November 21, 1998. Last updated May 14, 2008. All contents copyright 1998 - 2008 by MrExcel.com.
Privacy Policy
|
