Logo

How to Excel in Business to Save You Time and Money, part 4

| Community | May 11, 2018

Did you know that Excel sorts data, processes data and compiles data? As I’ve said in previous articles, there’s virtually nothing Excel can’t do with data.

Once, a manufacturer received a multi-store report with no page breaks from a vendor. The manufacturer needed separate pages for each store, but he wanted to stop manually going through the reports and putting in page breaks before printing them.

The solution to that problem was to write a macro that went through the large report and logically figured out the page breaks according to the store codes and line breaks.

Excel also works really well with data over different worksheets. A client was given a spreadsheet with more than 200 worksheets with about 30 data elements on each sheet. Her task was to combine all the information into one sheet so it could be used as a master roster. She didn’t want to copy and paste each field, which she estimated would take a week.
By coming up with a formula that combined all the data in seconds, it saved her hours and hours of copying and pasting each cell.

Finally, if the data is repetitive, Excel can process it. A client had some extremely large data files that he got from his ongoing clients. This data was uploaded into the main system to update information. The problem was the clients often supplied invalid data, causing the updates not to load and causing delays in processing the information.

Advertisment

By writing a spreadsheet that reviewed all the data files and showed all the errors before they went into the main system, the files were cleaned up before the main load, thus saving countless reloads.

For more information on how to find the right web developer, contact Warren Schultz at warren@tapsolutions.net or call him at 818-281-7628.

About Warren Schultz

Warren Schultz from TAP Solutions has been in business since 1999 and in the programming field since 1983. Warren is a MS Excel Specialist who does Excel Support and Development. Warren also develops website that help you be found on the web and represent your company in the way you want it to be seen. For any questions please call Warren at 818-281-7628 or e-mail me at Warren@tapsolutions.net. Additional information can be found at www.TAPSolutions.nett

Leave a Reply

Doug’s Rant – Video Edition

  • WatchDoug’s Rant June 22
  • WatchDoug’s Rant June 15