This blog was authored by Y. Karp. Excel 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and 16,384 columns). …
Tag Archives: spreadsheet
Excel Tips #4: Filtering your business data for efficient analysis
This blog was authored by Y. Karp. Visit www.ykarp.com for some light-hearted blogs from the same author. One of the easiest ways to find pertinent information in your Excel spreadsheet is to use the sort function. Sorting allows you to display the data in alphabetical or numerical order. While this is an easy solution for …
Continue reading “Excel Tips #4: Filtering your business data for efficient analysis”
Excel Tips #3: Formatting, Conditionally
This blog was authored by Y. Karp. Visit www.ykarp.com for some light-hearted blogs from the same author. Let’s say that you have a very complicated spreadsheet, or that you rely on your spreadsheet to give you information that will determine what steps you take next. Now let’s say that the rows and rows of numbers …
Excel Tips #2: Easy Navigation in Excel Workbooks
This blog was authored by Y. Karp. Visit www.ykarp.com for some light-hearted blogs from the same author. Excel provides the user with the option to create an almost unlimited number of tabs in a workbook. This is great for enabling the user to spread out the data among different sheets, allowing for a more organized …
Continue reading “Excel Tips #2: Easy Navigation in Excel Workbooks”
Excel Tips #1: Pivot Tables – Feel the Power of Automation!
This blog was authored by Y. Karp. Visit www.ykarp.com for some light-hearted blogs from the same author. Most people, even true beginners, know the very basics of how to type in data into an Excel spreadsheet. After all, an Excel spreadsheet is really just an electronic version of the old-fashioned bookkeeping grid. While the horizontal …
Continue reading “Excel Tips #1: Pivot Tables – Feel the Power of Automation!”