Ask Seth

Do you have a question about how to do something in excel? Ask it here (I may re-post it) and I will record a tutorial as well as write it up here. If it is too complex to do that in a simple free tutorial I will e-mail you and respond.

Here is an example of what I did in response to someone on Facebook. She had a lot of data and wanted to know if there wa a quick way to isolate the data she wanted. Here is the link to the tutorial I recorded for her:

http://www.nerdenterprises.com/Web_Casts/Excel_Data_Manipulation/Excel_Data_Manipulation.htm

Advertisements
  1. pygo
    September 26, 2009 at 7:58 AM

    I am a new user to excel with basic fundamental knowledge on how to use the program for budgeting and things of that nature Lots of fun : ) . Now I just recently started a small business and Im on a different playing field when it comes to tracking daily sales and inventory for business . To start off I will be selling Mainly one Product and I could really use your help in coming up with a template that will help me keep track of my daily sales activity so I can use these reports to keep track of my progress and have an organized method and procedure in place for my daily activities through my business . Now what I want to do is pretty much have categories that contain The day,Month,Customer Name,Qty,Item,Description,Unit Price,Subtotal,Sales Tax and Total. Reason I want it in this manner is because at the end of the day it will make it alot easier for me to transfer all my information from my daily receipts into excel , So if you could provide me with a solution for this You will be the go to guy from here on out as my business expands . I look forward to hearing from you soon . Thanks for all you do

  2. September 26, 2009 at 5:34 PM

    Hey thanks for the inquiry. I will get back to you with an answer and possibly a video response within the week.

    • September 30, 2009 at 6:45 PM

      I haven’t forgotten you – just been busy!

  3. December 8, 2009 at 10:31 AM

    For those of you who are checking, this was answered in a 4 part series on “How to track your business in MS Excel”

  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: