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”