5 Great Ways to Use Spreadsheets and Stay Organized!
- Date: 2007-02-22 - Word Count: 628
Share This!
Does just the mention of the word 'spreadsheet' cause your mouth
to go dry? Do you immediately think of sums, formulae, and
figures?
Well fear not any more -- spreadsheets aren't just for sums!
I'm here to give you some tips on how you can use spreadsheets
in your every day business to help you keep organized and on top
of your work - and there isn't a formula in sight!
No.1 'To Do' List
How do you manage your day-to-day tasks? Do you have a notebook
for your To Do lists and cross out each one as you go along? Or
do you have little yellow post-its stuck all over the place? Is
this really the best way of managing your daily tasks?
Spreadsheets are a great way for you to organise your To Do
list. Set up headings in the first row and add your tasks
below. You can then sort your list by any column that you
choose, making it an interactive To Do list. And best of all,
your list is contained in one place.
Create a shortcut to your To Do list and place it on your
desktop so that you can access it easily, or just keep it open
and minimise your screen each time you're not using it.
No.2 Log Registration/Password Data
Another great way to use spreadsheets is to keep track of all
those websites that you've registered at, and need to insert a
username and password in order to gain access to.
Even though I try and keep to the same username/password I
sometimes find that a website will require you to insert your
username or password in a certain way, with digits as well as
letters, or a minimum of six characters etc. etc. and then it
starts to get confusing remembering which username/password for
which site!
Set up a spreadsheet with Organisation, Website Address,
Username, and Password as your column headings, and keep track
of this information in one easy-to-use place. As your list
starts to get longer, you can also sort your data into
alphabetical order, making it even easier to find your
registration details.
No.3 Create a Simple Mailing Database
Another great use for a spreadsheet is to set up a simple
mailing database. Perhaps you've researched a target market and
want to send them a mailing. By creating a spreadsheet to input
their name, address, phone number, email address, and website
you can easily keep a track of your data.
You can also use this data to carry out a mail merge via Word.
Create active hyperlinks for the email and website addresses and
you can email or visit their website directly from your
spreadsheet.
And if you add an additional column for 'Responses' you can
simply monitor your success rate too!
No.4 Track Potential Clients and Follow-ups
If you regularly have enquiries from potential clients, whether
they're phone calls or directly via your website, you can set up
a spreadsheet to track this data. You can see where your
enquiries are coming from, which method of marketing is the most
effective, and if the prospect turned into a client.
You can also add an additional column for 'Follow-up Date' and
perform a sort on this column so that you know who to follow up
with and when!
No.5 Monitor a Project/Activity Planning
Because spreadsheets also accept date formats they are a great
way to track projects or plan activities. You can easily use
autofill to create a date timeline too. Use the column headings
for your dates, and the rows for your activities.
As you work along the timeline, you can hide the columns with
past dates, showing only those columns for current and future
dates. And if you want to be really creative, use different
colours for the cells to represent different activities, i.e.
blue cells = to be done; red cells = overdue etc.
There are so many more projects that you could use a spreadsheet
for that don't require you to input complicated formulae. When
I was compiling this list for you, I thought of twice as many
again, all of which would help you to organise your day-to-day
business activities.
to go dry? Do you immediately think of sums, formulae, and
figures?
Well fear not any more -- spreadsheets aren't just for sums!
I'm here to give you some tips on how you can use spreadsheets
in your every day business to help you keep organized and on top
of your work - and there isn't a formula in sight!
No.1 'To Do' List
How do you manage your day-to-day tasks? Do you have a notebook
for your To Do lists and cross out each one as you go along? Or
do you have little yellow post-its stuck all over the place? Is
this really the best way of managing your daily tasks?
Spreadsheets are a great way for you to organise your To Do
list. Set up headings in the first row and add your tasks
below. You can then sort your list by any column that you
choose, making it an interactive To Do list. And best of all,
your list is contained in one place.
Create a shortcut to your To Do list and place it on your
desktop so that you can access it easily, or just keep it open
and minimise your screen each time you're not using it.
No.2 Log Registration/Password Data
Another great way to use spreadsheets is to keep track of all
those websites that you've registered at, and need to insert a
username and password in order to gain access to.
Even though I try and keep to the same username/password I
sometimes find that a website will require you to insert your
username or password in a certain way, with digits as well as
letters, or a minimum of six characters etc. etc. and then it
starts to get confusing remembering which username/password for
which site!
Set up a spreadsheet with Organisation, Website Address,
Username, and Password as your column headings, and keep track
of this information in one easy-to-use place. As your list
starts to get longer, you can also sort your data into
alphabetical order, making it even easier to find your
registration details.
No.3 Create a Simple Mailing Database
Another great use for a spreadsheet is to set up a simple
mailing database. Perhaps you've researched a target market and
want to send them a mailing. By creating a spreadsheet to input
their name, address, phone number, email address, and website
you can easily keep a track of your data.
You can also use this data to carry out a mail merge via Word.
Create active hyperlinks for the email and website addresses and
you can email or visit their website directly from your
spreadsheet.
And if you add an additional column for 'Responses' you can
simply monitor your success rate too!
No.4 Track Potential Clients and Follow-ups
If you regularly have enquiries from potential clients, whether
they're phone calls or directly via your website, you can set up
a spreadsheet to track this data. You can see where your
enquiries are coming from, which method of marketing is the most
effective, and if the prospect turned into a client.
You can also add an additional column for 'Follow-up Date' and
perform a sort on this column so that you know who to follow up
with and when!
No.5 Monitor a Project/Activity Planning
Because spreadsheets also accept date formats they are a great
way to track projects or plan activities. You can easily use
autofill to create a date timeline too. Use the column headings
for your dates, and the rows for your activities.
As you work along the timeline, you can hide the columns with
past dates, showing only those columns for current and future
dates. And if you want to be really creative, use different
colours for the cells to represent different activities, i.e.
blue cells = to be done; red cells = overdue etc.
There are so many more projects that you could use a spreadsheet
for that don't require you to input complicated formulae. When
I was compiling this list for you, I thought of twice as many
again, all of which would help you to organise your day-to-day
business activities.
Related Tags: planning, tips, contacts, data, activity, project, clients, excel, spreadsheets, formula, follow-up, follow up, password, registration, mailing, spreadsheet, to do lists, excel spreadsheets, excelsheet, sums, using spreadsheets, uses of spreadsheets, project management spreadsheets
Your Article Search Directory : Find in Articles
Recent articles in this category:
- The No. 1 Rule For Projecting Confidence - Speak With Authority
One of the most important characteristics a person can project in a business setting - or any situat - After the Autumn Checkout European Debt Crisis and U.S. Brewing Rebound
In the commotion caused by the Fed on interest rates come to an end, the "disastrous" for the euro a - Advantages Of Arcade Game Rentals
There are many different advantages to arcade game rentals. Most people need something to release th - A General Primer on Truck Cargo Nets
In modern highways it is quite rare to see truck cargo nets in action, this is because they are usua - The United States Will Burst More Severe Financial Crisis
Not long ago, suddenly announced that the central bank to raise interest rates, the interest rate hi - Niche Marketing Profits - 3 Easy Steps to Finding a Profitable Niche Market Income in 10 Minutes
Like most beginners I was having a very difficult time trying to find a niche market to earn extra m - The Importance of Hospitality Management Consulting Firms Toronto
Businesses and the managers that help guide any business are in a constant state of improvement and - New Keynesian Theory Label
2010 winner of the Nobel Prize in Economics three theories have been labeled as "New Keynesian" labe - Federal Reserve Pouring Money QE2 Unpredictable Fortune
U.S. economist Milton Friedman proposed a "throw the cash from a helicopter" view, while the practic - Fiscal Consolidation Should no Longer Delay
British Chancellor of the Exchequer George Osborne today announced fiscal consolidation policy, shoc
Most viewed articles in this category:
- Common Financial Problems to Avoid
One must first change their habits and not procrastinate. American Consultants Inc at offers key fi - How a Bad Hire Can Hurt Your Business
What's worse - hiring the wrong person or not hiring anyone at all? Companies can become almost des - Joel Comm Is Dr. Adsense
What is Adsense? If you are new to making money online and net marketing, you may not know what Ads - 5 Steps For A Dynamic Wealth System Online
Recipe: Opportunity + knowledge + Dynamic Wealth System + Your Action = Massive Success!!! Step 1 - How To Stop Foreclosure
Losing your house to a foreclosure can be very scary. There are times when circumstances are ou - How to Always Pitch A Strike
As business owners, we are always working on new ways to convince people to become customers, client - Membrane Diffuser Solutions for Wastewater Treatment Systems
In the aeration basin of a typical wastewater treatment plant there are both organic and inorganic m - Another Year Hating Your Job or Loving Life?
Copyright © 2007 Mary Foley I've come to the conclusion that to be successful - really successf - Dyestuff Industry In India And China
World demand for dyes and organic pigments to touch $10.6 billion in 2008According to a study on dye - Cma-cgm Case : the Series of Lawsuits Continues in Syria, Lebanon, Egypt, France, England and the United States
Damietta company case : The series of lawsuits continues in Syria, Lebanon, Egypt, France, England a