SandiMays

Neil J. Rubenking at PC magazine published a great tip for how to quickly print all of the file names in a folder.  I use SnagIT to print file names and details … but this works, too. Click Start, then Run, and enter cmd … This command will get you a list of filenames in sorted order: DIR /B /ON *.* > filelist.txt. The /B switch gives a Bare listing (filename only) and /ON means sOrt by Name. You will have to delete the name filelist.txt itself from the list. If you’re using Vista, this... Read Full Story

Question: When I build a pivot able, and have 2 or more sets of row labels, the label to the left only shows once. How do I fill the data in columns in a pivot table? To make this work, you need to be in the Classic Pivot Table view see this blog post for instructions on how to convert to the classic pivot table view: http://businesstoolsblog.com/2011/05/display-pivot-tables-with-the-row-labels-side-by-side-instead-of-in-one-column/ In a standard pivot table the row labels after the first... Read Full Story

Question: How do I change the pivot table so that if I have 2 or more row labels, they can be displayed side by side, in different columns vs. stacked in one column? In other words, please make my Pivot Table look like it did when I used Excel 2003. My guess is that your pivot table looks something like this: And you want them to look like this, with the Labels in separate columns: Just right click on the pivot table and select “PivotTable Options” Then check the box next to... Read Full Story

If you’re a small business owner, or even a medium to large business owner, it can be difficult to generate new productivity out of the same divisions and strategies. No matter how many incentives you offer, employees see themselves as having a set job that is immune from evolution or change. Your San Diego tax consultant can scare up some old receipts from your file and find a way to increase your write-offs—why can’t everyone be so productive? The reality is, it’s not necessary to hire new... Read Full Story

A new year has arrived and the economy looks no less stagnant than ever. True, unemployment levels have gone down, but the average small business owner has probably seen no signs of a waning recession. If you’re one of those business owners, there’s a good chance you’ve been looking to cut costs. And, if you’re looking to cut costs, there’s no better place to look than your company’s overhead. This is especially the case if business is good and sales remain strong, but you’re still struggling... Read Full Story

You spend ten hours a day crunching numbers, making graphs with Excel and using widgets and software apps until it feels like you’ve turned electronic yourself. Business tools are a means to an ends, but you’re counteracting everything you work for if you don’t take care of the most valuable tool in your toolkit: your mind. Whether you’ve been tasked with a new website interface or you’ve got to provide custom packaging for a new fleet of smartphones, your boss, customers, and clients will... Read Full Story

Net Installs are tracked and forecasted on a weekly basis.  We use historical net installs as a rear view mirror and a forecast, to tell us where we are going . We use a stacked bar to depict net installs.  The top of the bar = Net Installs.  Notice that when Net Installs >$0, the blue bar is split into 2.  The bottom blue bar = the disconnect bar, the other blue bar = the amount that Net Installs is >$0. Here’s how you build the chart: 1.  Start by setting up the data sheet: In... Read Full Story

When starting a new business, the entrepreneur has a lot of considerations and issues on his table. He needs to meet with potential investors, figure out budgets, determine and hire a workforce, and seek out contract management solutions. The list goes on and on. For many such entrepreneurs, one of the first moves they make is to buy a domain and create a website. In the initial stages of a start-up, the time, cost, and effort that goes into the creation of a website may seem like a waste... Read Full Story

Question from a reader:  My Gmail has gotten way out of hand.  Is there an easy way to delete all email in your Gmail inbox?  or do I have to delete 100 emails at a time? Answer:  Yes, you can delete your entire inbox in one simple step … this super easy.  To delete all existing Gmail messages click “All Mail”then click the Delete button.  You may be prompted to choose the 100 emails displayed or all emails in your inbox.  Select all email, and your Gmail inbox will be empty. Reminder... Read Full Story

Have you ever been in a flash mob? Well, let me tell you, it’s a lot of fun. My friend ran for student government last week and her idea to get votes was to organize a flash mob. A bunch of people from my house (like in Harry Potter our college has houses) decided to help her out. We did a flash mob to the song “Party Rock Anthem” by LMFAO to support her campaign: I’m in a bright pink shirt, with really curly hair, a clashing purple scarf, and a bright orange bandanna off to the right... Read Full Story