Archive

Posts Tagged ‘MS Excel’

Setting Goals and Tracking Progress – Using Excel to track progress at the gym

January 6, 2010 Leave a comment

Web Cast Date: 1/14/09

Video


Running Time: 00:19:57

It’s important to be humble enough to recognize that I don’t know everything. Based on that I seek help in areas of my life that are important to me. The Gym is one example. This was my web cast from Jan 14, 2009 – just about a year ago. I am no longer working with the trainer – cut-backs.

Microsoft Excel is the tool that I use to track progress on anything that involves numbers. It is made for this sort of thing so that makes the most sense. In this web cast I show you how to use MS Excel to enter the statistics and then graph them. I also show you how to change the parameters on the graph to be sure you are tracking your progress with meaningful results. This not only allows me to track progress but it also gives me the opportunity to analyze the information and make sure I understand it. As you will see I can look at the graph and see things that won’t be as obvious from only looking at the numbers. Then I can ask questions if things don’t make sense to me.

When setting goals it will be difficult to gauge my progress without doing something at some regular intervals to stop and look at where I was when I started compared with where I am today. It is useless in life to compare myself to others and very meaningful to compare myself today to myself yesterday so that I am always sure I am growing and improving. Even if I see a setback, I am still growing because I am taking the time to measure my progress and this way I can make corrections – changing the actions to change the results!

Microsoft Excel is a great tool for financial analysis. This is an example of something non-financial where excel is also a GREAT tool to use for tracking and analysis.

Introduction to Pivot Tables

September 16, 2009 Leave a comment

Pivot tables in excel are not really all that different in concept from when a basketball player pivots on one foot after he (OR SHE) has stopped dribbling (not drooling). The idea is that you stop on one piece of data and then focus on the surroundings. Then you can describe your surroundings with other pieces of data in terms of your columns and rows. In the web cast here we show you how to start using pivot tables using sample data (of course J) based on an export from a QuickBooks file. We show you how you can begin to describe sales data in powerful and meaningful ways using pivot tables.

We begin with a regular table filled with Data:

Then go to your Insert tab and choose Pivot Table:

Next you will select your range (Excel will recognize your table as the range) and you will be presented with some options as well as the opportunity to re-define your range in case Excel was wrong L.

Once you click ‘ok’ excel will insert a new sheet with the layout for the pivot table. Now you’re ready to get started building the pivot table based on your data.

The Video Web Cast will give you a clear introduction on this.

You can watch it here (from the Youtube insert) or for a better quality version, watch the original unfiltered web cast as seen directly from our home website here: Microsoft Excel –Introduction to Pivot tables


How to set the number of sheets in a new workbook

September 2, 2009 Leave a comment

Step I Click the MS Office Button and click Excel Options:

Step 2 – set the number of sheets as shown below:

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/