Posted in Excel 2021

Why You Should Be Using INDEX MATCH instead of VLOOKUP

After using Excel for many years, its power continues to surprise me on a constant basis. One of the best formulas and a personal favorite…

Continue Reading... Why You Should Be Using INDEX MATCH instead of VLOOKUP
Posted in Excel 2021

RDBMS Basics: SQL Database Fundamentals

Let’s talk about RDBMS basics. If you’ve ever dipped your toes in the warm but deep waters of programming, then you’ve probably wanted to store…

Continue Reading... RDBMS Basics: SQL Database Fundamentals
Posted in Excel 2021

Illustrator vs Photoshop vs InDesign: What’s the Difference?

Adobe’s software suite is the gold standard when it comes to creating or editing graphics. Knowing each applications strengths and weaknesses is key in order…

Continue Reading... Illustrator vs Photoshop vs InDesign: What’s the Difference?
Posted in Excel 2021

6 Time Management Tips for Remote Workers

You’ve packed in the nine to five rat race, and you’re ready to embrace the refreshing flexibility of working remotely. Great! But are you really prepared…

Continue Reading... 6 Time Management Tips for Remote Workers
Posted in Excel 2021

Business Intelligence vs. Big Data: What’s the Difference?

Business intelligence and big data sound similar but they are not the same. In general, business intelligence (BI) refers to structured and readily usable information…

Continue Reading... Business Intelligence vs. Big Data: What’s the Difference?
Posted in Excel 2021

20 Free Illustrator Business Card Templates Sure to Impress

Even though so much of our business lives have moved to the digital world, there’s one arena that stays comfortably rooted in the physical world:…

Continue Reading... 20 Free Illustrator Business Card Templates Sure to Impress
Posted in Excel 2021

33 Excel Business Templates for Workplace Productivity (2020 Update)

There’s a reason Excel is so ubiquitous in the workplace. Its versatility allows you to do a plethora of different things like track KPIs, create…

Continue Reading... 33 Excel Business Templates for Workplace Productivity (2020 Update)
Posted in Excel 2021

6 Most Helpful Soft Skills Interview Questions and Answers

I know what you’re thinking: Soft skills don’t actually matter. They’re just the buzzwords you sprinkle throughout your resume when you can’t think of any…

Continue Reading... 6 Most Helpful Soft Skills Interview Questions and Answers
Posted in Excel 2021

Excel VBA – Advanced Filtering Tutorial

What is VBA? VBA is a programming language that can automate tasks within Excel using macros. You can calculate, move and manipulate data using this…

Continue Reading... Excel VBA – Advanced Filtering Tutorial
Posted in Excel 2021 office

5 Tips to Conquer Your Taxes in Excel (Free Template Included)

Two words. Seven letters. Say them and most people start to worry. Tax Time. As a CPA, the first and last thing on my mind…

Continue Reading... 5 Tips to Conquer Your Taxes in Excel (Free Template Included)