Posted in Excel 2021

INDIRECT: How to Use Text as a Cell Reference in Excel

Usually you type =A1 for referring to the cell A1 in Excel. But instead, there is also another method: You could use the INDIRECT formula….

Continue Reading... INDIRECT: How to Use Text as a Cell Reference in Excel
Posted in Excel 2021

Data Table to Normal Range: How to Convert an Excel Table

Data Tables (or “Excel Tables”) were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality…

Continue Reading... Data Table to Normal Range: How to Convert an Excel Table
Posted in Excel 2021

How To Add Best Fit Line/Curve And Formula In Excel?

For example, you have been researching in the relationship between product units and total cost, and after many experiments you get some data. Therefore, the…

Continue Reading... How To Add Best Fit Line/Curve And Formula In Excel?
Posted in Excel 2021

5+ Great Excel Functions Most Users Don’t Know

Most Excel users only use a small number of the functions in Excel. There are a lot of extremely useful features, but even many advanced…

Continue Reading... 5+ Great Excel Functions Most Users Don’t Know
Posted in Excel 2021

Applicant Tracking System Resumes: How To Beat The Hiring Bot That’s Killing 75% of All Resumes

With 3 million incoming job applications every year, Google and most large companies (98% to be exact) are integrating hiring algorithms into their recruitment process. Meaning,…

Continue Reading... Applicant Tracking System Resumes: How To Beat The Hiring Bot That’s Killing 75% of All Resumes
Posted in Excel 2021

Best Job Search Sites to Get Hired Fast in 2020

Work enables us to put food on the table, pay bills, and bankroll our dreams. It helps us develop skills and build relationships with other…

Continue Reading... Best Job Search Sites to Get Hired Fast in 2020
Posted in Excel 2021

What Does it Mean to Work Remotely in 2020? (Because Things Aren’t Quite the Same)

You’re working from home. Maybe you’ve been at this for a few months now, as a result of the pandemic. Or, perhaps you’ve been working…

Continue Reading... What Does it Mean to Work Remotely in 2020? (Because Things Aren’t Quite the Same)
Posted in Excel 2021

How to Create a Winning Video Resume That Gets You the Job

Did you know that on average, every corporate job opening attracts 250 resumes?  Keeping the tough competition in mind, it’s becoming increasingly important for candidates…

Continue Reading... How to Create a Winning Video Resume That Gets You the Job
Posted in Excel 2021

28 Best Microsoft Office Add Ins in 2020

You can make professional documents with the default feature sets in Word, Excel, and PowerPoint. But Microsoft Office add-ins give your work an extra edge. …

Continue Reading... 28 Best Microsoft Office Add Ins in 2020
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