Tag: Excel

Cool Tools – Pivot Tables

Pivot Tables are an easy way to organize information. You can use them in either Excel or in Google Sheets if that’s your thing. What we love about pivot tables is that you can create them to pull data, and it will automatically update totals or summaries when the data changes! Voila! We use this...

Read more

Cool Tools – Excel Charts

Yet, another reason to love Excel! Excel Charts helps users interpret data visually. Many of us are visual learners and putting report data into a Chart format makes it easier to see the story the numbers are telling. Select and highlight your cells in Excel that have the data you want to see reported, press...

Read more

Cool Tools – Excel – LastPass Authenticator

Protect every password in your business.  Every password is an entryway to your business, and LastPass makes it easy to secure them all. LastPass’s two-factor authentication is awesome. LastPass now offers a new level of security to their website. With the identity authenticator, LastPass requires you to verify your identity with the LastPass Authenticator app...

Read more

Cool Tools – Excel Concatenate

Cleaning up spreadsheets might not be in your job description, but it’s a common task for most financial managers. Use Excel’s handy concatenate function to optimize databases by joining character strings in destination cells. Excel’s concatenate function is designed to join character strings from several cells together in another destination cell. For example, you might...

Read more

Cool Tools – Excel

Here is something you don’t hear too often. We love Excel! Excel is a Bookkeeper/Accountants friend. We love Excel because we can import and export numbers within QBO. This is extremely helpful when reviewing numbers. We can export information without affecting your books. Excel can also help us move many transactions at once into your...

Read more

For Disability Assistance Call