Formulas and Functions give you answers based upon input. If you know what a formula’s answer should be, but can’t derive the input value, Goal Seek is the tool for you. I have a simple formula from my last post that takes one input, a Date in “m/d/yyyy” format, and returns the Day of the …
I just found a new feature in Excel 2010 that will save you some time. There’s an optional feature at the bottom of the File>Recent menu to Quickly access this number of Recent Workbooks. When you already have a file open in Excel, clicking the File menu will default to the Info tab so you …
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 …
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 …
Each week I download the over-under calories report from Lose It! and dump the data into a spreadsheet. I just created my first Sparkline graphic to show the last 7 days of this data. For this example I’ll use an OFFSET Function inside a named range, which was created in my last couple of posts. …