http://iloveexcel.com we actually like using this thing? Wed, 12 Nov 2008 23:16:37 +0000 http://backend.userland.com/rss092 en Every try calculating a pivot table in Excel?  How long would you guess it takes for 800 rows of data?  10 seconds?  15 seconds?  How about minutes?  Two minutes? That's right.  I've got enough time to go post on a blog when I ask Excel to calculate a Pivot Table on ... http://iloveexcel.com/2008/11/12/microsoft-office-2008-for-mac-you-suck/ Thanks to LyteBite, people like midlakewinter are now able to have two spreadsheets open on separate monitors.  Mac Office 2008 opens everything in a new window, but if you're 99% of the modern office, the Windows version of Office is on your computer and this tip should be really helpful. http://iloveexcel.com/2008/08/28/how-to-open-two-excel-files-side-by-side-in-separate-monitors/ Is Microsoft embittered by the exodus of business people to the Apple platform?  Microsoft's Mac Office takes 2 or 3 times as long to start and I regularly get this error when working with spreadsheets on my MacBook Pro with 4 GB of ram: The spreadsheet which triggered the error was ... http://iloveexcel.com/2008/06/30/excel-for-mac-2008/ When you have a lists of numbers, you don't need to use the SUM() function to get the sum of the numbers when you just need to know it at a glance.  Just highlight the cells and the sum will appear in the status bar at the bottom of the ... http://iloveexcel.com/2007/09/15/sum-at-a-glance/ Summarizing data by month is very popular - but if you need to summarize data by month and your dataset bridges two years, your data will most likely be out-of-order or worse, summarized incorrectly as the group for "July" will contain 2006 and 2007 data.  Here's a function I use ... http://iloveexcel.com/2007/09/14/summarize-dates-yearmonth/ If you've had to summarize data in Excel, there's no question you've used the "month()" function and the "year()" function, but many of us don't realize there's also a "week()" function.  Given you have dates within your table of data... How do you append the week number? One solution is to calculate ... http://iloveexcel.com/2007/08/30/week-numbers-summarize-data-by-week/ Many of us are still using spreadsheets for tracking hours in professional service organizations. It's easy to get time-sheets and track metrics in a quick Excel spreadsheet so we do it instead of soliciting IT to build or buy a system. Once you get more than a few ... http://iloveexcel.com/2007/07/30/conditional-formatting/ Working with Finance, Sales, and Marketing- you must calculate summaries based on financial and calendar quarters. There are no built-in function to handle this in Excel 2000-2003. Luckily, you can create a short formula to create the value: Calendar Quarter: =INT((MONTH(A2)-1)/3)+1 Financial Quarter (Sept. Start): =MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1 http://iloveexcel.com/2007/07/23/calculate-calendar-quarter-of-fiscal-quarter-from-date/