easydatasolutions's blog by Rafi Karp
Just another JobShuk site
Over the past year or so I have posted a few blogs every now-and-then about the importance of understanding the information generated by your business. I have also posted some handy tips on using various Microsoft Excel functions to assist you in understanding and manipulating your business data. Obviously, Excel is a great tool for …
Continue reading “Free Excel Demonstration – You can harness the power!”
This blog was authored by Y. Karp. Not knowing how to program in VBA (Visual Basic for Applications) should not stop you from adding some “whiz-bangery” to your Excel spreadsheets. Out of all of the non-core Excel features, the macro recorder is one of the most handy. A macro is just a fancy term for …
Continue reading “Excel Tips #6: Macros – Taking spreadsheet customization to the next level”
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). …
It’s been a while since I have posted a blog to Jobshuk, but there is good reason as to why it has been so long. I have just completed 6 months of army service but I have now settled back into civilian life and I have re-opened my business, Easy Data Solutions. I had the …
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”
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!”
The other night I saw a great docu-movie called "The Fog of War". It provided a great insight into what happened in the confines of the White House during the early-mid 1960s when the Cold War was at boiling point and US intervention in Vietnam was intensifying exponentially. The docu-movie was centred around Robert McNamara who …
Continue reading “How important is your business information?”