Tuesday Tech Thoughts: Not 1, Not 2, But 20 Excel Tips

If only you could run your business from the front. But “running” the business means being in the office as well. It means going over the books. It means hovering over Excel sheets on your computer. How well do you know Excel? Would 20 tips help you get your work done more quickly so you could get back to engaging with the customers?

For example, do you know how to use Excel to calculate the hours worked for any shift? Duh? Just subtract start time from end time! But what if your business shifts also involve “noon” or “midnight?” 

Think military time. But you also need to know what data to use for tabs and cells.  And most importantly, a formula that makes it all work. Now you do.

Other tips include: building dynamic charts that update before your eyes, adding a drop-down list to an Excel cell, and using XLOOKUP which is an easier way to retrieve info from Excel spreadsheets.

There is no denying the fact that you need to be in the office; it comes with the territory of being the person who signs the checks. But you are also the face of your brand. You need to be out there with the customers. Hope these tips help.

Published by Anthony Scialis, Social Media Content Creator

My name is Anthony Scialis and I used to be a newspaper writer. For over 40 years I covered the business and entertainment beats for community newspapers & magazines. Now, I use research & writing experience to provide Small Business Owners with customer-centric information. I assist with writing blogs and tweets, freeing up small biz owners to focus on what they enjoy and do best— run their businesses.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: