How many files will Excel show in the Recently Used File List? Well, it depends on the version of Excel you’re using and vary between 9 and ninety-nine files. Here is a list of Excel versions, menu navigation to the recent file list, and the max files allowed. Excel 2010, 2007 File>Options>Advanced tab>under the Display …
Since never using the VBA Editor in Excel 2011 for Mac was a slight embarrassment, I thought to give it a whirl with a half-written function that was started in Excel 2010. I quickly found out the Editor’s windows have more of a free-floating style, but the programming looked to be quite the same. Until …
I’ve a simple formula for calculating the Xth Weekday of ANY month. It takes four inputs: Year, Month, Week, and Day. And requires a couple of lookup tables for data validation, one with special formatting. The History It all started when my wife mentioned there were a couple of meetings she had to schedule at …
The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as a graphical object. I didn’t find it in Excel 2011 for Mac, but ran across an article showing they put it inside Word 2011. How very strange. Here I’ll review the Excel 2010 version of Equation Editor first, then …
There are eight default tabs on the Excel 2011 Ribbon, and nine if you unhide the Developer tab. They are Home, Layout, Tables, Charts, SmartArt, Formulas, Data, Review, and Developer. Comparing the Excel 2010 Ribbon, the new Windows version, where the tabs are Home, Insert, Page Layout, Formulas, Data, Review, View, and Developer. The Tables, …
I normally don’t think absolute and relative cell references are difficult, until I try and mix them in one formula with two cell references. Come along and see what I mean. Relative Cell Reference The first example is a worksheet with data for Quantity, Price, and Total. The formula in cell C2 is Price times …
In the year 2000, I began to use Microsoft Query to pull data from corporate client’s database tables, using their raw data to create PivotTable reports. Each table required a different query, each linked by using VLOOKUP formulas. And of course the data had to be restricted to Excel’s 65,536 rows. Soon I was having …
Excel 2010 has new return_type arguments for the WEEKDAY Function. How useful they are is debatable, but you never know when you might come across a particular need. Excel Weekday Function The Excel WEEKDAY Function in has two arguments: serial_number and return_type. The serial_number argument is simply a number that represents a date. The return_type argument …
I decided to test the new Microsoft Excel Web App and tell you about my experience in creating a simple spreadsheet, give you a look at the interface, and share my initial opinion. The Excel Web App – Getting Started In order to use the Microsoft Excel Web App a Windows Live account is required. …