Archive

Archive for August, 2009

Timesheets – Conditional Formatting, Vlookup, & Weekday formula

August 26, 2009 Leave a comment

MS excel’s conditional formatting feature allows you to highlight data based on certain criteria and especially in MS Excel 2007 there are many options in terms of what you can bring to light and how.
Since time allowed we also gave you a bonus tip on this one – how to write a simple Vlookup formula on a named range so you can being in data from a set list based on other criteria.

This is useful in creating a timesheet as you will see because timesheets are very much dependent on having a date in there, and it is handy to have today’s date light up to bring attention to it. When designing forms it is always good to make it as easy as possible to use. Adding little bells and whistles like this can help your end user. Formatting goes a long way to, but we did not get into this. E-mail us at classes@nerdenterprises.com for a copy of the timesheet we use at Nerd Enterprises, Inc. as well as the sheet created in this video tutorial.

Please enjoy the video tutorial: http://nerdenterprises.acrobat.com/p31944487/


The 10 Minute Household Budget

August 24, 2009 Leave a comment

You want to keep your household budget simple and make sure it includes everything. Ms Excel of course is the tool we use for any kind of budget. You want to lay your budget out in a month by month format – even if you are already well into the year you want to start from January. This makes it all uniform in terms of having a series of 12 columns making up one year. Otherwise you have a partial year in the first year and it won’t match up. This makes it easy to copy and paste, then do a search and replace to expand the months and add another year as you will see demonstrated in this video tutorial.

The first step is to lay out the income – set up a unique line for each source of income (ie Payroll, 1099, other..).

Then you will lay out the expenses. I’ve seen people lay out some pretty complex and hard to follow budgets in terms of the expenses. You will see that in this budget we keep it very simple. If you want to look at credit card debt and look at the interest rates and monthly payments, that should be done in a separate schedule. Then you can tie the payment total into the main schedule. This keeps it simple. You can see a tutorial on how to use our Credit Cards Template here: http://www.nerdenterprises.com/Web_Casts/Debt_Management_Tutorial/Debt_Management_Tutorial.htm This can easily be brought in to a template like the budget we are creating in this budget tutorial.

The trick is to keep the budget simple. What happens all too often is that we complicate things and then we don’t want to spend time on this sort of thing because it is complicated and painful!

Watch the 10 minute household budget video tutorial here: http://nerdenterprises.acrobat.com/p87449821/

Payroll – using excel to plan your new hires

August 19, 2009 Leave a comment

We use excel for the planning and analytics. Many people ask me how companies get into the situation where they cannot afford to stay in business because they’ve over extended themselves. My first rule in good financial management is paying attention to your finances. This means more than just going out and hiring someone at the “market” rate. Once you have that information you have to lay it out in terms of the true cost and make sure you can afford that rate. Then you either know you can, or you have to negotiate with someone – maybe you can offer more than just a salary, but a great opportunity for the person to grow & learn, or maybe you can lower the salary to something you can afford as a base and make the rest performance based.

We also show you how you can calculate and determine your commission structure for sales people. The power of excel is in being able to plan things before you commit and start actually spending money so that you can be sure of what you can afford. This is the critical mistake so many businesses make because they don’t do this.

Please enjoy the web cast by clicking here: http://nerdenterprises.acrobat.com/p90748849/