Product Details

Getting Started With Easy-XL from MrExcel

Use the Open Getting Started Guide option on the Help menu to open the gettting started guide. This guide contains a quick introduction and has examples that you can work through using the included sample data.

Use the Open Easy-XL Sample Workbook on the Help menu (On the Workbooks Menu for Excel 2000 - 2003) to open the sample data. This workbook contains various worksheets that you can use to experiment with Easy-XL.

Excel 2007 / 2010

For Excel version 2007 and 2010, the Easy-XL ribbon menu appears along the top of Excel's ribbon menu next to the Data ribbon item. You can access the classic 2000 thru 2003 menus on Excel's Add-Ins ribbon item and then selecting Easy-XL. You can also right-click on any cell within Excel to access this menu.

Excel 2000 - 2003

For Excel versions 2000 thru 2003, the Easy-XL dropdown menu appears along the top of Excel's main menu bar next to the Data option. You can also right-click on any cell within Excel to access this menu.


Easy-XL's Features

Site Login

Shopping Cart

MrExcel Podcasts

Learn Excel from MrExcel
New Excel Tips & Tricks Every Weekday!
  • Free Fresh Excel Content For Your Blog or Website
    There is a great discussion at the MrExcel forum about using Excel forums to increase your knowledge of Excel. Board member TinaP summarized it this way: “Books got me started with Excel knowledge, but the forums educated me.”. Most people who use Excel 40 hours a week don’t realize which powerful tools they do not(...)
  • Why Haven’t You Adopted Power Pivot Yet?
    It is late 2014, almost 4 years after PowerPivot reached general availability. This product is a game-changer. It enables people to do dramatically more powerful analyses than regular pivot tables. Yet, when I walk into a room full of 100 people who opted to come to a Power Excel with MrExcel seminar, there are only(...)
  • Make Font Red If It Meets a Condition – Without Conditional Formatting
    Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats. Select the range of cells. Press Ctrl+1 to open the Format Cells dialog. Select the Number tab. Choose Custom from the bottom of the list. In the Type box, enter a format such as(...)
  • Data Pasted to Excel Starts Splitting at Comma?
              Usually, you grab text from Notepad or Email or a web page, paste to Excel, and it all stays in one column. But…one day, late in the afternoon, the pasted data starts automatically parsing into separate columns!     Here is the deal… I bet you did a Text to(...)
  • Prevent #N/A! in Excel VLOOKUP
    So, you have this nice little =VLOOKUP(A2,$Z$2:$AB$99,3,False) formula. But in order to prevent the #N/A! error when something is not found, you used to have to do the VLOOKUP twice:  =IF(ISNA(VLOOKUP(A2,$Z$2:$AB$99,3,False)),”Not Found”,VLOOKUP(A2,$Z$2:$AB$99,3,False)). This is far simpler starting in Excel 2010: Think about it. Let’s assume you are doing 1000 VLOOKUPs. There are 990 that are(...)