Welcome to JobShuk. This is your first post. Edit or delete it, then start blogging!
Category Archives: Uncategorized
Microsoft Excel demonstration – now available on-line, free
As per my post on February 23rd, here are a couple of links to an Excel-based client record keeping demonstration: To view it through the Easy Data Solutions website: http://www.easydatasolutions.co.il/demos.htm and select the "Client information database" demonstration. To view it through the JobShuk website: http://jobshuk.com/uploads/assets/easydatasolutions/ClientRecordsDemo.xls 2 Important Notes: 1) It is probably best to save the …
Continue reading “Microsoft Excel demonstration – now available on-line, free”
Free Excel Demonstration – You can harness the power!
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!”
Excel Tips #6: Macros – Taking spreadsheet customization to the next level
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”
Excel Tips #5: Freeze, split and hide
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). …
Information is power
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 …
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!”