Posts Tagged time saving

It’s time for another edition of Stupid Excel Tricks!

One of my coworkers recently asked me an Excel question.  He had a spreadsheet with multiple tabs, and wanted to have the value in cell A1 on the respective worksheets to be the name of each tab.  I knew that it could be done, so I searched the deep recesses of my memory for the answer.  When it didn’t turn up there, I went to Plan B.  It’s a good thing that I save everything to my computer using my foolproof file naming system, otherwise this fool would have never found it.

This formula can save you the time of not having to type a heading on each tab.  I’m not sure exactly how this formula works, but I do know the basics.  First, rename your tab by right-clicking on the tab and then left-clicking on Rename (you can give it any name that you’d like; I called mine SALES).

Just right-click on the tab name, and left-click on Rename

Read the rest of this entry »

• Barbaric Book Review: Die Broke by Stephen M. Pollan, Part 3 This is Part 3 of my review of Die Broke.  You can read parts 1 and 2 by clicking on the following links: Die Broke, Part 1 - Quit Today Die Broke, Part 2 - Pay Cash Step 3: Don't Retire Don't retire?  I thought we should be planning for retirement......
• Three Excel How-Tos: Now With Linked Files I've gone back and revised three previous Excel how-to posts.  I've added links to live Excel files, which will make it easier to follow along with my ramblings.  Here are links to the new and improved posts: Excel How-to: The SUMIF Function Excel How-to: Creating a Pivot Table Excel How-to:......
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet, with about 150 rows and 30 columns.  After showing him, he started to hide every other row, which would be an incredible waste of time for someone in his salary......

• Sales Alert: Avon products I like Here are some products I like. The link will go directly to the shop of the one who sells to me, but you can as easily buy from your own consultant, if you have one. Avon is not your mother's company. They are innovative in color and in skin care.......
• Beauty Products - How To Save Money On Them Beauty products can be quite expensive. Have you seen the price of the specialty makeup or perfumes? Everyone wants to look their best all the time. You feel better about yourself and life in general when you look good. Unfortunately, things that are good for your appearance may not always......
• Stealth Startups, Get Over Yourselves: Nobody Cares About Your Secrets When Preetam Mukherjee started Marcellus.tv in March 2007, his company was one of the very few players in the professional online video hosting space. He believed he was building a killer product that would become a blockbuster and would compete handily with the one established player in the space,......