The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic

Are you working with Excel and want take your Excel skills to the next level? Or do you want to learn Excel and don’t know where to start? Check out these 70+ tips and shortcuts that will help you make Excel Magic.

Online tutorials & videos

The following online tutorials are mostly free and will teach you quite a bit about Excel. In fact they are better than some of the expensive classroom training courses.

Online introduction to Excel: If you are just starting to use excel, this is the perfect resource for you. Here you will find dozens of audio courses that take a step by step approach to learning excel.
DataPig Technologies: The guys from Data Pig Technologies made a comprehensive collection of videos that explain almost every aspect of Excel. From basic Excel concepts to VBA programming. And most of the videos are free!
Online Charts Tutorial: Jon Peltier is an Excel-charting superstar. You can use his online tutorial to get you started on Excel charting and also as a reference.
Basic Formulas Guide: This excellent tutorial will help you master Excel formulas in no time.
Common uses for Formulas: This collection of samples will help you understand what can be achieved by using excel formulas.
An introduction to Pivot Tables: The Pivot Table is an amazing tool, but people often shy away from it because Pivot Tables seem complicated. The first page of this PDF contains a clear description of Pivot Tables and how they can be used.
Creating a Pivot table: A 7-minute video shows you how to create and work with Pivot Tables.
Pivot Tables in Excel 2007: Excel 2007 Pivot Tables are much easier to use. If you use excel 2007, check out this slightly promotional yet excellent introduction to Pivot Tables.
Practicing Pivot Tables: This step by step tutorial from Microsoft will help you sharpen your Pivot Table skills.
Microsoft Excel help / 2007: When all else fails, Microsoft Excel Help is a good source to try.

Books

In order to harness the full power of Excel, shell out a couple of book bucks. The following books are packed with information and real-world know-how.

General Excel Books

Excel Bible 2003 / 2007 version: The “Excel Bible” was written by the renowned Excel expert, John Walkenbach. It explains everything from basic formulas and functions to data validation, and Excel programming. If you have only $30 to spend on Excel training, buy this book.
Excel Charts: This book is a comprehensive, yet easy to understand, guide to Excel charting. It’s a useful resource for both beginner and experienced excel users.
Excel Formulas: Formulas are the lifeblood of spreadsheets and “Excel Formulas” from John Walkenbach will teach you everything about them. This book covers all things formula, from custom worksheet functions to financials formulas and more.
Pivot Tables and data analysis / 2007 version: One of the most useful yet most feared features in Excel – the Pivot Table, is tackled gracefully by Bill Jelen (aka Mr. Excel) and Michael Alexander. Well worth the read.
Excel Programming: By far, the best guide to Excel programming. The book also outlines a programming methodology for Excel. The only downside to this book is that it assumes a bit of programming knowledge.
Report programming with Excel: If you plan to build a reporting system based on excel, this is the book for you. It shows how to use Excel to build a reporting/data analysis environment and shows how to properly work with SQL databases.

Excel Tips and case studies

Excel case studies: While not for the beginner, this book contains valuable, real-world advice on how to make Fxcel do what you want it to do. Make sure you check out the “Making things look good” chapter.
Excel Tips: A highly recommended Excel tip book from Mr. Spreadsheet himself.
Some more Excel Tips: A compendium of Excel tips. This is not the first book you should own, but I often find that I return to this book when I’m stuck.
This isn’t Excel it’s Magic: Bob Umlas is probably the foremost expert on formulas. The things this guy does with formulas will make your hair stand on end. If you are serious about Excel, than buy this book.

Specialized Excel books

Principals of finance with Excel: This highly recommended book will help you understand the applicability of Excel in financial environments. It is loaded with real world examples and can help both the financial expert and the techie.
Statistical Analysis with Excel: Using plain English and real-life examples, this book provides information that helps with statistical analysis. The book covers samples and normal distributions, probabilities and related distributions, trends and correlations, as well as statistical terms like median vs. mean, margin of error, standard deviation, permutations, and correlations.
Business Analysis with Excel: Running a business is complicated. Understanding issues like cost of goods, inventory, sales forecast, tax statements is crucial to success. Business analysis with Excel explains these issues and shows how to tackle them using Excel.
Sales Forecasting with Excel: This book shows you how to use Microsoft Excel, to predict trends and future sales based on—numbers. Use data about the past to forecast the future. Excel provides all sorts of tools to help you do that, and this book shows you how to use them.
Excel for Chemists: While most of this book is a general introduction to Excel, it is filled with Chemistry oriented examples. The book also contains a complete chapter that shows how Excel can assist chemists in research.

Forums, News Groups and Mailing Lists

No matter how tough or silly your question is, the experts in the following sites/mailing lists will answer it. They will do it for free and usually within a couple of hours. Don’t be shy. Join these communities and ask.

Note: The online Excel community is one of the nicest communities that I have ever had the pleasure of joining.

Mailing Lists: Wow. This is the jackpot. The Excel-G mailing list is monitored by the best Excel experts in the world. They answer every question. If you post an interesting enough problem these Excel gurus will compete among themselves to answer first and give the most elegant solution.
Mr. Excel Message Boards: A very friendly forum whose members will usually provide you with an answer within 3-5 hours. A bunch of Microsoft MVPs (including the Mr. Excel gang) monitor the forums. And, of course, it has a pure html interface which makes it easier to use.
Excel News Groups: If you prefer USENET groups to mailing lists or Message boards, than you’ll love the Microsoft Excel groups. Most questions asked will be answered within 12 hours.
ExcelForum.com: ExcelForum.com provides a web interface to the Excel News groups. If you do not want to be bothered with the USENET interface, this site will is a useful alternative.

Excel Experts

Some Excel projects are too big/difficult to tackle alone. Here is a (short) list of some of the best hired guns in the Excel Field (If you know other top-notch Excel experts, drop a link to their site in the comments).

Jon Peltier: If you have a charting project/problem, I would recommend working with Jon. Jon brings to the table over 20 years of Excel experience A PhD from MIT and is a Microsoft Excel MVP.
Chip Pearson: Mr. Pearson is a renowned Excel expert and while his fees are not low, he is one of the best. If you need an urgent solution or have a critical project, I would consider asking Chip for help.
Mr. Excel Consulting Services: The Mr. Excel team is probably the largest Excel consultancy in the world. Their ranks include numerous excel MVPs and they have an amazing amount of Excel Knowledge.
JMT Consulting: A consulting service from two respected Excel MVPs: Masaru Kaji and Andrew Engwirda.

Excel Blogs and Tip Sites

Tips sites and Excel blogs will usually send you a daily Excel tip. Many Excel professionals register to these sites and read the daily tips to keep their Excel skills sharp. They also serve as repositories for thousands of Excel case studies.

Daily Dose of Excel: A blog managed by Dick Kusleika and authored by many Excel Experts and MVPs. “Daily Dose” is updated several times a week and profiles tips, tricks and news from the excel Industry. Highly recommended!
ExcelTip.com: Over the years ExcelTip amassed hundreds of tips and solutions to real world problems. You can either use the categories or the search function to find the information you want. You can also register to a tips newsletter. The site is managed by Joseph Rubin.
Official Microsoft 2007 Blog: The Official Excel Blog. Written by the Excel product managers/programmers. It contains a lot of information and how-to articles about Excel. The level of articles on this blog varies from “useful to everyone” to “only for hardcore excel services programmers.”
Vital News Excel Tips: Very similar to ExcelTip, this site contains hundreds of tips sorted into categories and offers a weekly newsletter.
Chip Pearson Newsletter: A new service from Chip Pearson. Each issue of this newsletter contains a thorough examination of a technique or of an Excel function. For those of you that wish to gain deep knowledge of Excel, this is an excellent resource.
Excel User: Excel User contains a “Visitor Question” section and many high quality articles. This site was created and maintained by Charles Kyd.
Andrew’s Excel Tips: Andrew Engwirda writes one of the best Excel blogs. What separates Andrew from the flock is his vast amount of Excel and programming experience.
Codswallop: Although we are not a strictly an Excel-centered blog, we plan to bring a lot of Excel goodies in near future. Don’t hesitate – subscribe now!
Smurf On Spreadsheets: Simon Murphy is an Excel programming master. If you are into Excel Programming, this blog is perfect for you.
The Ken Puls Blog: Ken’s blog is neither Excel centered nor frequently updated. However, when Ken does blog about Excel, it’s pure gold. Definitely worth checking out.
XL Dennis: Dennis Wallentin writes about developing Excel centered solutions with the .Net framework.

Excel Templates

Templates can be a huge time saver and odds are that the spreadsheet you are trying to build already exists. We’ve divided Microsoft’s huge template repository into useful categories so you’ll be able to find the right template for you.

Business Related Templates

Budget Templates: Whether you are managing your personal budget, your Wedding budget or your gardening budget, you’ll find a template for it here.
Balance Sheets: You can find almost any kind of balance sheet here.
Expense Reports: Unexpected expenses can have a nasty effect on your bottom line. Use these templates to record and control expenses (including traveling expenses).
Business Forms: Here you can find all types of different forms, from a traveling advance request form to a car mileage log.
Inventory Templates: Manage and track you inventory with these templates.
Invoices, Work Orders, Packing Slips: This is a real time saver. Whether you work in retail or services, you will find the right invoice/work order template here.
Purchase Orders: Not only will these templates help you get the exact the items you need on time and delivered to the right place, they also come in a variety of colors.
Receipts: A variety of receipt templates.
Time Sheets: Use these templates to track employee work time. You can choose a template that will sum the employee and overall working hours on a daily, weekly or even monthly basis.
All kinds of Reports: Different financial and management reports.

Other Templates

All Kinds of Lists: Phone List, Grocery List, Reading List, Gift List and much more.
Planning Templates: Business and personal planning templates.
Schedules: Schedule templates for your employee shifts, business and personal events.

AdditionalTemplate Sites

Vertex42 Excel Templates: Dozens of Excel templates. Some even come with a user manual.
OZGrid Excel Templates Page: Another big and famous collection of templates.

Excel Tools

Excel is the ultimate killer app. But there are cases where even Excel needs a little help. Here are some Excel Add-ins that can double your effectivness.

Asap Utilities: Probably the best known Excel productivity add-in. Asap utilities contains advance selection options, advanced browsing capabilities, better formula handling and much more.
Send Mail: This cool little freebie from Ron de Bruin that allows you to send an email with the contents of a workbook, a single sheet or even a selection area.
Excel Sentry: Use the Excel Sentry to prevent your business data from falling into the competition’s hands. The Excel sentry allows you to encrypt your spreadsheet in such a way that only you or your employees/coworkers can use it.
XL Statistics: A free statistics package that expands the existing Excel functionality.
Palo: A free (open source) OLAP server for excel. On-line Analytical Processing servers usually cost hundreds of thousands and sometimes even millions of dollars. Jedox (the company that made Palo) is giving it away. Definitely worth checking out.
PDF to Excel: One of the most stubborn sources of data for Excel is PDF files. Whether they are scanned or not, PDF2XL will extract the data for you.
FlorenceSoft: This cool little app allows you to easily find the differences between two different sheets.
Excel Password Remover: Do you have a terribly important sheet you encrypted and then forgot the password? The Excel Password remover is your locksmith.
Tree Plan: A set of data analysis tools from Mike Middleton.
DPlot: Create 2D and 3D graphs and plots with DPlot. Especially suited for Engineers and scientist that need expanded charting and plotting functionality. DPlot contains unique chart types such as, the Polar Chart, The triangle plot and more.
DigDB: Another well known Microsoft Excel productivity add-in.

Additional Excel Resources

Excel User Conference: The Excel user Conference, run by Daemon Longworth (MVP), is by far the best venue to advance you Excel skills. You will learn high-end Excel tips and tricks from the best Excel experts (all the instructors are Microsoft MVPs). Plus, everyone is extremely friendly and you’ll get a bunch of laughs and even a couple of beers.
Charts by Jorge Camoes: A site dedicated to Excel charts and charts add-ins. Also runs a chart centered blog.
Excel funny videos: Who said Excel wasn’t fun?
Excel games: And to top the list. I present Excel – the gaming platform.

Now it’s time to Excel.

Freelancer’s Hyper-Drive: 131 Productivity Boosters for Email, Instant Messaging, Word, Excel, and More

Freelancers often have to wear many hats: accountant, boss, quality control, marketing department, and beyond, which can leave you feeling like there’s just not enough time in the day to do everything you’d like. Fortunately, there are a number of tools designed to help you speed up the process of working. Check out these productivity boosters for documents, communications, and more.

Email

Email itself is a productivity tool, but it often turns into a monster task that must be tackled. These tools will help you tame your inbox.

ClearContext: If you have a hard time getting through email you’d rather ignore to get to the good stuff, ClearContext is about to make your life a lot easier. This information management system prioritizes your email, organizing it and assigning color codes. You’ll be able to identify your most important senders and let newsletters or less important senders get pushed down below your VIPs.
Mail Templates: If you often reply to a number of emails on on the same few subjects, consider creating template responses for each one. You’ll save time and be consistent.
copy2calendar: Appointment setting doesn’t have to be a time consuming process. With copy2calendar, you can automatically convert text containing appointment information into calendar entries.
Actioneer: Use actioneer to speed up your Outlook actions like appointments, tasks, contacts, and mail messages.
TimeToMeet: Arrange meetings quickly in Google, iCal, or Outlook using this easy program.
Conversation Preview: Gmail users can view the first few lines of an email with Conversation Preview, even while they’re still in the message list view.
iGTD: Mac users can take advantage of iGTD, a tool that organizes tasks straight out of your inbox and saves a link to the original email.
CSV Exporter: Use CSV Exporter to import your address book contacts into Gmail.
FlipMail: For email on the go, sign up with Teleflip’s FlipMail, a service that forwards email as a text message to your phone.
Chilibase: Don’t spend 20 minutes trying to find that email Bob sent a month ago. Use Chilibase to see complete conversations from your contacts with a single click.
l8r: If you’re working at 2AM but prefer that your client thinks you keep normal hours, you can use l8r to delay sending messages until a specified time. You can also use it to schedule emails that you know you’ll send, like reminders.
SpamSieve: No one likes spam, especially when you have to wade through it to get to important emails. Combat this junk mail with SpamSieve, a program that zaps spam out of your inbox.
Copernic Summarizer: If you find yourself wishing that your email correspondents would just get to the point, Copernic can lend you a helping hand. This tool summarizes mail messages and other documents, highlighting key concepts and sentences.
Saved Searches: Check out this user script that allows you to save searches you’ll need to access frequently.
Gmail Loader: If you’ve switched to Gmail, but still need to access your archives without going back and forth to your old email provider, check out Gmail Loader. It imports existing emails to your Gmail inbox so you’ll have easy access.
Office Outlook Forum: Get quick answers to your pressing Outlook questions on this forum.
emailStripper: To quickly get rid of email clutter that accumulates in long back-and-forth conversations, use emailStripper. Just paste your email into the tool, and it will clean up all extraneous characters.
MailTags 2.0: This plugin for Mail.app allows you to add keywords and notes to your messages for quick retrieval.
GmailThis: Send web pages quickly to anyone using GmailThis. The tool makes it easy to instantly send a message with a URL attached through Gmail.
Getting Things Done Add-in: Productivity Leader David Allen has created an add-in that allows you to better accomplish his recommended workflow methodology.
Microsoft Office Outlook Team Blog: Find out how to improve formatting, get rid of junk mail, organize, and more by reading the MSDN Outlook blog.
Gmail Manager Add-on: Firefox users can take advantage of this Gmail add-on that displays email data at the bottom of your browser. This tool can show information from multiple Gmail accounts and is easy to customize.
10 Minute Mail: Save your real email for clients and other important people with 10 Minute Mail. This service allows you to sign up for a temporary email address that’s great for forums and other sign up forms that you think might sell your address to spammers.
AmikaFreedom: Receiving email on your mobile device is convenient, but sometimes, you’re hit with an information overload. Use AmikaFreedom to trigger emails to forward to your wireless device when specified key words and phrases are used.
Destroy beacons: Beacons are small images embedded in spam emails that, when downloaded by your email client, let spammers know they’ve got a hit. Avoid advertising your email in this way by blocking images from anyone not in your address book.
Take Back Your Life Add-in: Get organized with templates, appointment prompts, and more functionality tools from Sally McGhee.
Fuser: Use Fuser to consolidate your email accounts into one central place.
ActiveWords: If you hate switching back and forth from Word to Outlook just to look up a contact, you’ll love ActiveWords. This tool makes Outlook “hot” in any Windows application, which allows you to look up contacts from a number of different programs.

Instant Messaging

IMs are a convenient communication tool, and there are a number of ways to improve their functionality. Read on to find out how you can share documents, schedule meetings, and send SMS messages using IMs.

Acronyms: Use texting and chatroom acronyms to get your point across in fewer keystrokes. Of course, remember your audience: if you’re speaking to a client, you’ll need to tone down on the netspeak.
Meebo: Share files with your contacts using Meebo’s IM.
IMified: Access lots of web apps from one place using IMified.
TodoBot: By setting up your own TodoBot, you can IM to do list items to yourself.
Gaim: Use Gaim to chat on a number of instant messaging platforms at the same time.
MyCyberTwin: Let a chatbot answer your IMs while you’re away.
gTalk Sidebar: Firefox users can add on Google Talk as a sidebar, so you can chat while surfing web pages.
AOL Mobile: With AOL Mobile, you can send a text message to SMS-enabled phones using the AOL Instant Messenger.
Merge IM Contacts: Check out Lifehacker’s lowdown on how to get your AIM, MSN, Yahoo! and other contacts on Google Talk.

Word

For most users, Word is a fairly simple tool to use, but when you’re drowning in lots of documents, revisions, and lots of editing, it can be a mess. Clean it up with these Word boosters.

Word Hyperlink Checker: Use this tool to make sure that all of the links in your Word document are active.
Word Hotkeys: Check out this guide to find hotkey codes for common tasks.
Boiler: Avoid excessive copying and pasting when combining Word files. Mesh multiple Word Files into one central file using Boiler.
Save as PDF: With this tool, you can save any Word document as a PDF for easy reading.
RapidoWrite: RapidoWrite makes it easy to cut down on repetitive text. Check it out for a good text replacement utility.
Microsoft Office Word Team Blog: Check out the MSDN Word blog for tips, news, and more from Microsoft.
Recover Lost Files: This guide offers tips for recovering Word files that would otherwise be lost forever.
Fore Words Pro: Analyze your words for word echoes, differences, and more.
Turn Off Word Features: For tips on how to turn off annoying and unnecessary Word features, be sure to take a look at this guide.
Compare File Versions: If you’ve had someone edit your document, but they left you with no way to track their changes, you can find yourself spending a lot of time trying to find them. Use this tutorial to make comparing file versions a lot easier.
Word Kit: Use Word Kit to produce frequently generated documents with ease and consistency.
WordFast: Quickly translate text in Word using this handy tool.
MS Works Converter: So your word processing file turned into more tabular data than you expected it to be? Not to worry, you can convert everything into an Excel file with this tool.
Speed up Word: Word often loads lots of templates and add-ins that you may not need, which slows down the program. Read this tutorial from Lifehacker to find out how to stop them.
Wordware: Wordware’s productivity pack has 45 tools designed to help you save time when using Word.
AutoSummarize: If you need to summarize a large amount of text, don’t go through the tedium of reading it yourself. Check out this tutorial on how to use AutoSummarize to highlight key points.
SumsBox-W: Improve Word’s number and tables functions with this handy tool.
Docx Converter: So your client has Word 2007 and has started sending you .docx files that are incompatible with your Word version. Make them readable by using the Docx Converter.

Excel

Excel is a great tool for wrangling lots of data into one convenient place, but it can get out of hand. Find out how to streamline your spreadsheets, create easier graphs, and find time-saving templates with these tools.

Daily Dose of Excel: Check out Dick Kusleika’s Daily Dose of Excel for help with formulas, functions, and lots more.
Mr. Excel: Bill Jelen, Mr. Excel, has over 18 years of spreadsheet experience, and he’s more than willing to help you figure out how to better use Excel.
Marketing Charts: Download Excel spreadsheet templates and marketing charts with this resource.
Copy Text to Multiple Worksheets: Find out how to copy text from one worksheet to many others in this answer thread.
Conditional Formatting: Formatting in Excel is a great way to make data easier on the eyes and highlight important information, but it’s a lot of work. Find out how to set up conditional formatting to make the entire process automated.
ASAP Utilities: Use ASAP Utilities to automate frequently used tasks in Excel.
Excel Forum: If you need help using Excel, check out these forums for information on worksheet functions, programming, and more.
Excel Keystrokes: Save yourself some time and the perils of carpal tunnel syndrome by checking out these easy Excel keystrokes.
Nuts About Microsoft Excel: On this blog, you’ll find loads of tips and solutions for MS Excel.
Excel AutoFilter: Use AutoFilter to sort by selected criteria without changing any data.
Dual Excel Worksheets: Find out how to view two Excel worksheets at once at Digital Streets.
Excel Templates: Save yourself loads of time by using these Excel templates instead of starting from scratch.
Excel In-cell Graphs: Check out this link for a tutorial on how to easily create a bar graph inside Excel cells.

Excel Split Views: Read this tutorial to find out how to split your Excel screen so that you can view and edit two different areas at once.

Excel Gantt Charting: Turn Excel into project management software using this tempate from David Seah.

ExcelUser: On ExcelUser, find Excel news and tips, create Excel Dashboards, and learn how to better use Excel in your business.

Excel Experts: If you’re in need of an Excel Expert, check out this directory.

Microsoft Excel: Check out the Microsoft Excel blog for beta news, improvements, and more.

PDF

PDF is a versatile, functional document format that offers more than meets the eye. Find out how to save time and stretch your PDFs to the limit with these resources.

PDF Converter Professional: Streamline your data input from clients by creating fillable PDF forms with this tool.
Combine PDFs: You can use Adobe’s Insert Page tool to combine PDF files, but if you’ve got a few to do, that can prove to be time consuming. Instead, use this tool to merge multiple PDF files into one with a few easy clicks.
Sumatra PDF Viewer: For a lighter, faster PDF viewer than Adobe Reader, check out Sumatra.
PDF Download: If your clients send you a lot of PDF documents, you probably have to figure out how to deal with them on a regular basis. Using PDF Download, you can specify how Firefox downloads these files.
Adobe Reader 8 Optimization: Get Adobe Reader 8 to boot up faster by following this tutorial.
Skim: Take notes on your PDF file as you read it using Skim. Some features include highlighting, circling, and more. You’ll also be able to see your notations and jump to them more easily.
PDFill PDF Editor: This utility corrals lots of common PDF manipulation actions into one easy interface.
ScanR: Snap photos and turn them into emailable PDFs using ScanR.
Adobe Reader SpeedUp: Adobe Reader is known for its slow load times due to unnecessary plugins. Use Adobe Reader SpeedUp to selectively remove plugins that you don’t need.
Notepad Generator: Create personalized PDF notepaper that you can print out and take to meetings using this generator.
PDF to Image Converter: If your client can’t quite grasp the concept of downloading Adobe Reader, save yourself the time you’ll need to explain it, and just use this tool to send them an image file instead.
Shoka: Corral all of your PDFs in this library manager. This tool makes it quick and easy to search, share, and tag your PDF documents.
PDFCreator: Don’t spend time finding ink and paper when you can just print to PDF. Use the PDFCreator to print PDF files from just about any Windows application.
RSS 2 PDF: Take your RSS newsfeeds offline by converting them to PDF that you can read at your convenience.

Phone & Text

The phone may seem like a tool that operates more slowly than its digital counterparts, but it has a number of time-saving tricks to offer, too. Use phone and text messaging to budget, take notes, navigate traffic, and more, all on the fly.

Reminders

Expense Tracker: Read this guide to find out how to use K7.net’s free voicemail to send yourself messages for expense tracking.
Yahoo! Mobile: Don’t go searching around for your phone to send a text message–just send one using Yahoo! Mobile.
YouTube Mobile: Share videos on YouTube on the go by using YouTube Mobile to upload via your cell phone.
Pinger: Forgot to send an email? Don’t worry, you can send an audio email message to your recipient instead using Pinger.
MoneyManager: Track transactions on your phone with MoneyManager. Reports can be generated and sent to your email.

Yahoo! Local: Don’t worry about taking the time to print or write out directions from Yahoo!–just send them as a text message to your phone.

Popularity Dialer: If you know your client meeting is going to run long but you have things to do, you can use Popularity Dialer to schedule a call to your cell phone that will allow you to excuse yourself.

The Traffic Line: Call the Traffic Line to find out what traffic is like in your area so you’ll never be late again.

CallBurner: If you need to keep audio records of your Skype conversations, it’s easy to do it with CallBurner. Using this tool, you’ll be able to go back and review what you’ve said without having to do a lot of work.

Disable Skype Notifications: Check out this guide to find out how to keep Skype messages and notifications from popping up constantly.

CallWave: With CallWave, your voicemails are transcribed, highlighting only the key information.

Jott: Send yourself a note by recording a message with Jott. The service will transcribe your voice into text and email it to you.

SmartCam: If you need to use video chat, but don’t have a webcam, you can turn your Smartphone into one.

Dodgeball: Assure your clients that you’re on the way to your meeting by broadcasting your location via Dodgeball.

Dial DIR-ECT-IONS: Dial this number, and you can get a text message on our phone with driving directions.

Blog From Your Cell Phone: Send a text or photo SMS to go@blogger.com, and you’ll be able to make posts to your blog.

Google info: Send Google a text message to find listings, dictionary definitions, and more.

Skylook: With this Outlook extension, you can record calls, get text alerts, voicemail in your inbox, reminders to your phone, and much more.

Pickle: Share videos and photos with clients using your phone and Pickle’s service. You’ll just send your files to a special email address and it will publish them to sites like MySpace, Blogger, or your own site.

Other

Check out these tools to find even more boosters for documents, travel, collaboration, and more.

AutoHotKey: Using AutoHotKey, you can turn any block of text or keystroke sequence into a hotkey that will perform repetitive tasks.
Google Presentation: Google’s answer to PowerPoint makes it easy to do simple manipulations of PowerPoint files without actually firing up the program.
Delivery Intercept: Control what happens to your package once it leaves your hands with this feature from UPS.
Ditto: Corral your copy-and-paste function with this handy clipboard manager.
TripIt: For entrepreneurs on the go, check out TripIt, a tool that automativally organizes your travel itinerary using email.
Guide to Hotkeys: Hotkeys are keyboard shortcuts that allow you to execute an action without using your mouse. This guide has hotkeys for email, messaging, file management, and more.
Audio Documents: Learn how to record written documents to audio for “reading” on the go with this tutorial.
Mango: If you need to learn a foreign language, but don’t have time to hit the books, check out Mango for courses in conversational language.
DocuFarm: This Firefox add-on makes it quick and easy to preview documents in your browser without having to take the time to open up a new program.
QuickLogger: Keep track of your workday by logging tasks into QuickLogger.
Scriblink: Collaborate with others on a digital whiteboard with Scriblink.
Mini Map Sidebar: If you’re reading an email invite to a meeting, but have no idea how to get there, you can fire up the Mini Map Sidebar to map addresses and get directions without ever leaving your browser’s email client.
Google Alerts: Keep track of your online reputation, favorite news items, and anything else you regularly check online by setting a Google Alert. You’ll be notified of any new pages that include your key words.
Backpack: This productivity tool has lots of great features, including the ability to send scheduled or unscheduled reminders to email, SMS, or both.
Snapter: With Snapter, you can scan photos of business cards and documents using your digital camera.
Airport Parking Reservations: If you’re always getting to the airport at the very last moment possible, check out this service so you’ll save time parking.
Virtual Folders: If you’re using Vista and find yourself often searching your machine for the same thing, you can save your search results as a virtual folder. Find out how here.
FileTaxes: Who needs an accountant? File taxes for your employees on this site, and the service will generate forms, submit them to the IRS, and mail them to recipients for you.
Office Jargon: Check out this handy guide to office jargon from Lifehacker and Brazen Careerist to spend less time trying to figure out what in the world your corporate clients are talking about.
Digital Filing System: Read this tutorial to find out how to take your filing system online, creating a time saving, easily searchable database.
Online Sign Off: Streamline your document approval process by taking it online with this service.
Mailbox Map: Don’t spend time searching for a mailbox–just check out Mailbox Maps, a tool that finds nearby mailboxes and provides pickup information on each one.
Windows Keyboard Shortcut of the Day: For time-saving keyboard shortcuts, check out this ongoing blog.
Monkey On Your Back: Remind coworkers and clients of deadlines using Monkey On Your Back, a tool that sends scheduled email reminders to others.

Bookmark this article at del.icio.us »

Conversion Central: 101 Tools to Convert Video, Music, Images, PDF and More

Few things are more irritating than having to deal with a format that is incompatible with what you need it to do. It doesn’t matter if it’s a media file, document, or shoe size; it’s just plain frustrating. To make your life easier, check out this list of 101 tools that will allow you to convert just about anything.

Original Art by Bob Ostrom

Using This Article : This is a fairly long article that can be used as a resource. If you don’t have time to read it now, you can bookmark it on del.icio.us and return to it later.

Mega Tools

There are lots of specialized tools out there, but sometimes you just need one good tool to get the job done. These mega tools are great for general conversions.

Zamzar: Zamzar does all sorts of conversions, ranging from documents and images to music and video. In addition to its versatility, this tool boasts the ability to do all of your conversions without downloading software.
SUPER: This aptly-named tool offers a simple and efficient way to convert any multimedia file to any format you need. You won’t need to download any additional codecs or deal with any time or function limitations.
CZ Document Converter: CZ Document Converter is a powerful batch document converter. It supports every popular document file you may need, including PDF, HTML, DOC, XLS, and WPS.
Media Convert: This tool is another great all-around converter. It can take files from your computer or a webserver and convert them into pretty much any format. The tool is web based and full of versatility.
Image Converter Plus: Image Converter Plus can professionally convert graphic files, photos, drafts, finance documents, and any image format. It supports more than 120 graphics formats and more than 800 dialects of these formats. You can convert files in a batch while also altering and enhancing images.
Quad-Lock Unit Converter: The Quad-Lock Unit Converter does conversions for more than 650 units. With this all-inclusive library, you’re sure to find what you’re looking for.

Media

If you use an MP3 player, download movies, or even just rip CDs, there’s a good chance you’ve had to deal with the frustration of having a format that’s incompatible with your device or software. These tools will make it all better.

Audio

Audacity: Audacity is a great tool that can be used to convert tapes and records into digital recordings or CDs. Check out their site to see what else this audio powerhouse can do.
RM to MP3 Converter: If you’ve got a bunch of Real Media files, but want to be able to listen to them on other players, check out this tool. It will convert RM files to MP3s individually or in batches. You can even save them with space-efficient VBR.
OSS Audio Converter: This tool is an audio format converter with a high level of customization. Using the OSS Audio Converter, you can select the coding method for VBR compression, fine-tune settings, and choose a range of frequencies to filter.
All Converter: Use All Converter to switch your files between popular formats like MP3, APE, AAC and many more. Files can be converted in batches, even if they’re not the same media or convert-to type.
Audio Converter: Audio Converter has lots of formats for conversion, including AIFF, Vorbis OFF, MP3 and more. You can convert files one by one or do them in batches, all while editing options like volume normalization and silence removal.
Intelliscore Polyphonic WAV to MIDI Converter: With IntelliScore, you can convert MP3, WAV, and WMA files to MIDI. It has lots of additional features, like vocal track removal and sheet music.
Free WMA to MP3 Converter: With this tool, you can take any Windows Media file and turn it into an MP3 that can be used with a variety of different players.
Zune Multi-Extension Support Mod: With this hack, Zune users can covert formats that the player doesn’t normally recognize, like AAC, DVR-MS and MPEG.
FreeRIP: This freeware application allows users to convert files between MP3, FLAC, WAV and more.
dBpoweramp Music Converter: The dBpoweramp can be used to rip CDs and convert audio files to pretty much any format you might need. This can all be done without altering tags.
Acoustica MP3 to Wave Converter Plus: Acoustica’s converter makes it easy to convert MP3 files to WAVs so that you can create custom CDs or edit audio.
Direct Audio Converter and CD Ripper: Music lovers can use this tool to convert music files to popular formats while keeping folder structures and tags intact.

Video

Koyote: This tool can covert FLV, DIVX, AVI and other formats to an iPod video format. That means you can download YouTube videos and put them directly on your video iPod.
MediaCell Blackberry Video Converter: If you want to view videos on your Blackberry, check out this tool. It converts all popular video files to Blackberry video while maintaining a high standard of quality.
Videora: With Videora, you can convert pretty much any video file into an iPod format. The tool includes an auto-resize feature that chooses the best resolution for you.
VidDownloader: This simple tool allows users to save streaming video and convert then to DivX AVIs.
Avi2Dvd: Avi2Dvd is a freeware program that converts AVI files to a format that works for DVDs, VCDs, and SVCDs.
iSquint: Mac iPod users who want a way to convert videos to something that works for their device will be happy to find iSquint. This tool converts videos to the correct format and also optimizes their resolution.
Any Video Converter: Using AVC, you can convert any video format to any other video format. The tool supports AVI, DIVX, FLV and more. You can create custom profiles that for devices like the iPod and PSP.
Tube Sock: Tube Sock is for Mac OSX users who want to download, convert, and copy YouTube videos to their iPod, Mac, or PSP.
Zune TVWatcher: Use this tool to convert recorded TV shows to a Zune-ready format.
Grand Theft Auto Mission Converter: Use the Grand Theft Auto Mission Converter to convert GTA1’s INI mission to GTA2’s .MIS mission.
Mplayer: Mplayer is an open-source video player, but it also has an interface called mencoder that allows users to convert between lots of formats, including TiVo’s tystream.
Lathe: With Lathe, you can convert TiVo files to play on a variety of media devices, including Archos, PDAs, smartphones, and more.
Hey!Watch: You can upload videos from your hard drive or online video sites to Hey!Watch, then use the tool to convert the files to pretty much any format you’d like.
PodTube: Mac YouTube enthusiasts will love the convenience of PodTube. It allows users to point to a URL, then let the program get to work by downloading, converting and adding the file to your iTunes library.
iTube: iTube is just like PodTube, but it’s made for Windows users.
HandBrake: HandBrake is a free, open source application that rips DVDs to a number of different formats, including those supported by Apple TV, PS3, Quicktime, and more.
MediaCoder: MediaCoder is a batch media transcoder. It can be used to convert to and from different formats as well as compress files.

Images

Graphic designers, professional photographers, and point and shoot enthusiasts can all benefit from using these easy image conversion tools.

Photo To Sketch: This program takes your photographs and converts them into black and white sketches or watercolor paintings. Using this functionality, you can make your own coloring book.
Image Thumbnailer and Converter: Image Thumbnailer and Converter makes it easy to create thumbnail images, convert formats, adjust sizes, set folders, and create web pages automatically.
GIMP: The GNU Image Manipulation Program is a great program for easily changing the format of images.
Smart Converter: This multipurpose program allows users to convert, view and edit images, even in batch mode. You can apply over 100 image effects, watermarks, and use loads of supported formats.
Easy Graphic Converter: Convert image files to lots of different formats while at the same time taking advantage of features like previews, 50 different effects and filters, simple editing and more.
Advanced Batch Converter: Use Advanced Batch Converter to change the format of multiple graphics at once. You’ll also be able to do minor editing. This program supports about 90 file formats.
Image Icon Converter: Convert images of various formats into Windows icons using the Image Icon Converter. You can also use this program to convert icons into popular image files and do basic editing.
Image Converter .EXE: Take things a step further with Image Converter .EXE. This tool allows you to change the format of multiple files at once, plus apply affects to the files at the same time.

Documents

These tools make it easy to read and print all sorts of documents, so you can avoid having a difficult discussion with your boss about why you just can’t open his MS Works 1996 file.

PDF

Adobe Online PDF creator: For quick PDF conversions, check out the official Adobe online PDF Creator. This tool converts a number of different formats, including DOC, JPG, WMF and more.
ExpressPDF: If you need a high quality PDF output in a hurry, consider using ExpressPDF. Users can upload documents, choose an output quality, then receive an email with the new PDF. This is all done without downloading any software, so it’s great if you’re in a pinch on a borrowed computer.
CC PDF Converter: Install this tool as a printer subsystem. It will enable you to print pretty much from any Windows application to a professional quality PDF document. It will also allow you to set the copyright terms for your PDF file.
Scan to PDF: ScanToPDF is a simple tool that allows you to convert your paper based documents into PDFs. Just insert the pages into your scanner, press the scanning button and the paper document will be converted into a PDF file.
Cogniview’s PDF to Excel Converter: If you get a lot of numerical data you need for your work in PDF format, Cogniview’s PDF to Excel Conversion tool is the best solution for you. Open your PDF file, mark the data you need and it will be instantly pasted into an excel spreadsheet.
Solid Converter PDF to Word: With the Solid PDF Converter, you can open up PDF files in Word and edit text in the original document. Solid PDF will identify and maintain the formatting of the original document (tables, bullets and so on) which makes it perfectly suited for PDF to word conversion.
Easy PDF Converter: The Easy PDF Converter tool, like many others, converts various document formats to PDF. What sets this program apart is its ability to convert an entire batch of files in one click, eliminating the need for lots of user input.
PDF Converter Professional: Using PDF Converter Professional, you can convert static PDF files into fillable forms.
PDF to Image Converter: You can convert PDF files to lots of popular image formats using PDF Image Converter. The program will convert detailed elements like text, color, images, ellipses, and more.
RSS 2 PDF: Use this tool to convert your RSS or OPML newsfeed into a PDF file quickly. It creates a readable, formatted file that you can view offline.

Word Processing

Docx Converter: The Docx Converter makes it easy to read Word 2007 files without having to upgrade your software. It extracts text and formatting from DOCX files and turns them into simple HTML files. You can even download their desktop widget for the tool.
3A PDF to Word Batch Converter: If you have a PDF file that needs text editing, you may have a hard time getting it to do what you want. Use the 3A PDF to Word Batch Converter to convert PDF documents into Microsoft Word, where you’ll be able to edit as much as you like.
WordFast: This language translation tool can be used on any language that’s supported by Microsoft Word. You can also use it with external dictionaries and machine translation engines.
MS Works Converter: With this converter, you can turn Microsoft Works files into Excel files, even in batches.
Doc to Image Converter: This simple converter allows users to save Microsoft Word files as image file formats including JPEG, TIFF, BMP and more.
Babel Fish: If you’re looking for a light, web-based translator, Babel Fish is for you. The translations aren’t always perfect, but you should be able to get a good idea of what’s being said. You can translate a block of text or an entire webpage.

Excel

Excel to PDF Converter: This spreadsheet converter is very simple. All you do is select “Save as PDF” in Excel, and the converter will create a document that can be read by PDF viewers.
XLS Converter: You can use this converter to take data from Excel files and turn them into formats like HTML, TXT, and CSV. It can be run in command-line mode, plus Excel isn’t required for it to work.
ABC Amber Excel Converter: With the ABC Amber Excel Converter, you can turn Excel files into PDF, HTML, RTF, DOC and more, all without the use of the MS Excel program. This tool offers command line support and batch conversion as well.

PowerPoint

Presentation to Video Converter: If you’re tired of manually clicking through PowerPoint slides during presentations, you can convert them into a video that eliminates the need for your interaction.
Convert PowerPoint: With Convert PowerPoint, you can turn PPT files into PDF, HTM, TXT and more. This application can be run on a command line.

Drafting

Universal Document Converter: Use this converter as a virtual printer to export any document to a raster PDF or image file. Doing so ensures that your document will be change-protected and viewed accurately. Universal Document Converter works with Adobe PDF, PowerPoint, AutoCAD and more.
AutoDWG DWG to PDF Converter: If you’ve been sent an AutoCAD drawing, but don’t have the software to open it, use this program to view it as a PDF. It has lots of options, including merged files and batch creation.
DWG2Image Converter: Convert DWG and DXF files to popular image files like BMP and JPG using the DWG2Image Converter. This program works without the use of AutoCAD.
Any DWG: Any DWG has lots of specialized tools that allow you to convert between lots of file formats, including DWG, PDF, DXF and various image types.
Raster to Vector Converter: Use this converter to take raster formats and create vector formats like DXF, ASCII, and AI. It will refine curves, create fine lines, and more.
Universal CAD Converter: This handy tool makes it easy to turn AutoCAD drafting files into pretty much any format you like, converting between DWG, DXF, PDF and DWF without using AutoCAD. You’ll also be able to convert any of these formats to images.

International Standards

These conversion tools are useful whether you’re traveling, baking, or just buying some nice Italian shoes on eBay.

Measurements

Metric Converter: If you often need to do complicated metric conversions, use this tool to get the job done.
FCC Conversion: This FCC webpage converts degrees, minutes, and seconds to decimal degrees in latitude and longitude, or vice versa.
EZ Unit Converter Wizard: This unit converter is highly customizable. You can add or delete the units that you’d like to use, with more than 130 units to choose from.
Unit Conversion: This tool does calculations for lots of different units, including Celsius to Farenheit and pounds to kilograms.

Currency

Google Search: You can use Google to calculate currency conversions as well as units like gallons and liters. It’s great because you can get an answer by using a nationality if you don’t know the name of the currency.
Universal Currency Converter: XE’s UCC performs forex rate calculations with live currency rates. They offer conversions for the top 85 currencies in the world as well as special units and precious metals.

Clothing Sizes

International Show Size Conversion Charts: These charts convert shoe sizes from Europe, Mexico, U.K. and more.
Ring Size Conversion: Use this ring size tool to determine what your size is in the U.K., France, Switzerland and more.
Women’s Clothing Conversion: With this tools, you can find out what size clothing you should buy for France, Italy, and a number of other countries.
Men’s Clothing Conversion: This tool works the same way as the women’s tool, but it comes in men’s sizes.

Time

Time Conversion Tool: This utility from NASA makes it easy to convert from calendar dates and times to Julian dates, or vice-versa. You can also convert between featured world time zones and figure out what day of the week you’re looking at.
Time Zone Converter: Use this tool to convert time zones between two cities. It accepts dates for the past or future.

Web Development

These tools are great for converting between different script languages, databases, and more.

User Script Compiler: With User Script Compiler, you can convert your Greasemonkey scripts into Firefox extensions.
Advanced PDF to HTML Converter: Use this program to convert PDF files into HTML to make it easier for users to view them. It will preserve all graphics, hyperlinks, bookmarks and lines.
Access to Visual Basic Object Converter: Use this program to quickly convert Access Objects to Visual Basic.
Gmail: Using Gmail, you can convert most document formats into HTML. It’s as easy as sending an attachment to yourself and selecting the option to view it as HTML.
IRun RTF Converter: The IRun RTF Converter makes it easy to put your documents online by converting RTF files to XML or HTML. You can even generate HTML with CSS.
HTML to ASP Converter: This tool converts HTML code for use with ASP.
XML Converter Standard Edition: This converter takes data from MySQL databases, MS SQL Servers and more and turns them into XML documents.
IDN Conversion Tool: With the IDN Conversion Tool, you can translate an IDN or nameserver from native characters to RACE and Punycode or vice-versa.
C to Java Converter: This converter automatically translates C code source files into Java classes. It supports standard ANSI C runtime and L&R C libraries.

Mobile Tools

These tools let you create ringtones for your device and convert while you’re on the go.

Google SMS: If you need to get a short language translation or currency conversion on the fly, use your cell phone and Google SMS to get an answer. All you have to do is send a text message and you’ll get the information you need.
Ringtone Converter: This tool allows you to convert ringtone files from one format to another, like MIDI to Motorola. Ringtone Converter works with most makes and models, plus you won’t need any cables to get the tone on your phone.
Mobile Unit Converter: Do quick metric conversions on your Smartphone or PDA using Mobile Converter. It works for decides running Windows Mobile 5.0.
Coding Workshop Ringtone Converter: With the Coding Workshop Ringtone Converter, you can convert ringtones from one format to another. It supports most makes and models of phones. You can also trim and compress files as you convert.
Converter: Use your Palm to easily look up unit conversions like miles to kilometers on the fly.

Bookmark this article at del.icio.us »

How typing may lead to madness (and how to avoid it)

Warning: shameless self-promotion ahead

The Psychology of Typing

Sometimes, there is no way around it. You just have to sit down and spend an hour—or two, or three—typing. It’s boring and often infuriating. Boredom, as Wikipedia tells us, leads to anxiety. And mixing anger with anxiety can lead to—madness!

And so, at Cogniview, we have decided to create a new product line that will help lessen anger and anxiety in the world. Products that dramatically reduce the amount of typing in your life. The new Typing Free™ product line.

A typing-free world

PDF2XL is our primary and best-selling product. Several thousands of clients are already using it and IMO it’s the best PDF to Excel conversion tool in the universe (I’ll admit I am a bit biased).

So if you want to avoid typing data from PDF documents to Excel, give PDF2XL a try.

PDF2XL OCR is a new product. It combines OCR technology from IRIS Software with PDF2XL’s data extraction interface.

I am proudest of two features in PDF2XL OCR:

The data-validation module: Every OCR engine has recognition errors, but one thing that most OCR tools lack is a way to efficiently browse through the suspected words and correct recognition errors. Our data validation module displays the suspected word and the image of the actual word from the document side by side (with a huge zoom). This helps you catch a problem in a fraction of a second, because your eyes see the difference and you don’t actually have to read.
The numerical column: An OCR engine works about a million times better if you tell it that it is trying to identify a number (I’ll expand on that if anyone is interested). When you define a column as numeric in PDF2XL OCR, it asks you whether you want to try to improve results by rerunning the OCR only on that column!

If you need to convert data from scanned documents to Excel, give PDF2XL OCR a try.

PDF2XL Enterprise is really a magical tool. It combines a print driver with an extraction tool. You can print whatever you want to it and then extract the data to Excel. It also includes all the functionality of PDF2XL and PDF2XL OCR.

Check it out. It’s really cool!

The secret, sure-fire way to avoid madness, hand cramps and blindness

Buy one of our products. They are good for your health!

How to win the war on spending, visually!

Recently I have been scolded for writing too much about technology and theory (i.e. stuff that only interests me). The main Scolder was Ms. Hadar Kadar, our director of customer relations. She pointed out that every once in a while we should post something that is actually useful to our customers (and was right as she usually is).

And so with this post, we are starting a new tradition. Every week, Hadar will prepare and post a new Excel Video Tutorial. This week’s tutorial is about controlling expenses. We would love to get your feedback on this. This template was prepared for Excel 2007.

Enjoy!

You can download the template here

Microsoft Office 2007 launches

It finally happened. Microsoft launched office 2007. For many of you, this is hardly news, since you have been using the 2007 beta version for some time. But for the tech world, this is a big deal.

There are mixed feelings about this release. Delaware Online believes that the “new Office isn’t a must-have” while others like the Indianapolis Star state that “Microsoft office makes encouraging strides.”

I agreed at first with the reporter for Delaware Online, but after meeting a couple of our clients and discussing Excel 2007 with them, I came to see that the Indianapolis Star was correct. Many of the new features in Excel 2007 resonated really well with our clients and both of them decided to try Excel 2007. One of them even asked his IT staff to order the new version from Microsoft.

These are the features in Excel 2007 our clients liked the most:

the increase in row and column count (especially the row count)
the new charts and graphs design
the formatting preview
the print layout editing mode
the conditional formatting
the changes to the formula editing interface

My recommendation? If you are an Excel power user, take Excel 2007 for a test drive.

Funny Excel Comics

I think this is hilarious. I actually worked with the people in this comics.

Office 2.0 - That was the word I was looking for

It seems that while I was rambling about online collaboration and Excel as a design and programming tool. Some guys have already called the concept - Office 2.0. Rod Boothby’s blog is an excellent place to start reading about Office 2.0 despite the fact that every so often he gets overly excited about Web 2.0 and Office 2.0.

Purchase-order tracking system based on Excel 2007: current process and requirements

Current process

In a previous post, I said that we would be developing a new purchase-order tracking system in Excel 2007. I started by interviewing the customers. I sat down with Inbal, our “accounting department,” and this is what she said …

“Today, we have a licenses management solution [Nick named Hendrix]. Every purchase is entered into Hendrix, and the customer then receives an automated e-mail from Hendrix with his payment code and download and activation instructions.”

“When a purchase order arrives, it is entered into the system, so that a license will be issued to the customer. I also manage an Excel sheet with a list of POs to track.”

Here is a sample of the Excel sheet that Inbal uses:

Purchase Order Tracking Sheet

“Purchase orders are not paid immediately; they usually have net or net+30 payment terms. it’s my job to see that all the payment orders are eventually paid,” Inbal added.

“So, every week, I single out the POs that have not been paid, and according to how late the payment is, I either send an e-mail or mail, or I call the customer. When a purchase order is paid, I update the tracking sheet to reflect that, this way I know not to bother the customer.”

Users’ requirements

I then asked her what she would like to the tracking system to do.

“I need to be able to define contact details for both customer and end user,” Inbal said. “This is because sometimes (especially with POs), the customer’s accounting department is ordering the software for their users. So I need to send the download and activation instructions to the user and work with the accounting department on payment issues. In any case, the customer has to be notified about the delivery of the software as well as the user.

“I want to be able to define the due date for each PO (net, net+30, etc.).”

“I want to get a weekly report of all the purchase orders that should have already been paid. If possible, I want to get it by e-mail.”

“When closing an order, I need a place to enter the payment date and some sort of transaction ID (check number, bank transfer ID, etc.).”

And that was it.

If you have any ideas on how to make this system better, please, pretty please … add them as a comment to this post.

Purchase-order tracking application with Excel 2007: kickoff

The company I work for, Cogniview, offers customers various ways to purchase its products. A customer can use PayPal to purchase online, send a fax order, or send a purchase order by fax or e-mail.

We have had an unusual amount of purchase orders lately. Everybody is happy when a PO comes in, but our accounting department started complaining that tracking those purchase orders is becoming difficult.

We had a meeting in which we agreed that some sort of purchase tracking system should be created. I persuaded everyone that it would take a tenth of the time to write it in Excel 2007 then in C++ (the language of choice for our programmers). So I have been awarded the pleasure of writing it myself.

In the coming week or so, I will share with you the process of designing this system and implementing it–successfully, I hope.

I will also make the Excel application available to anyone who’s interested.