Excel Tips

TOCOL or Not TOCOL

TOCOL or Not TOCOL

TOCOL or not TOCOL…there really is no question.  TOCOL is the easiest way to combine data from multiple lists into one! Check out the gif above - we’ve got several...

TOCOL or Not TOCOL

TOCOL or not TOCOL…there really is no question.  TOCOL is the easiest way to combine data from multiple lists into one! Check out the gif above - we’ve got several...

That's How That Works?!

That's How That Works?!

Ah, the elusive pivot table.  Everyone fears it, nobody understands how it works, and those who unlock its mysteries are the Excel wizards we all hope to be.  Have you...

That's How That Works?!

Ah, the elusive pivot table.  Everyone fears it, nobody understands how it works, and those who unlock its mysteries are the Excel wizards we all hope to be.  Have you...

There’s Nothing You Gantt Do

There’s Nothing You Gantt Do

Ahh, the Gantt Chart.  Is there anything so satisfying?  If you’ve never encountered one, a Gantt Chart is a horizontal bar chart that visually represents a project plan over time....

There’s Nothing You Gantt Do

Ahh, the Gantt Chart.  Is there anything so satisfying?  If you’ve never encountered one, a Gantt Chart is a horizontal bar chart that visually represents a project plan over time....

TRANSLATE.  TRADUCIR.  TRADUIRE.

TRANSLATE. TRADUCIR. TRADUIRE.

We are so excited to share Excel’s newest translation capabilities with you!  Meet TRANSLATE, which allows us to easily translate text from one language to another using language codes within...

TRANSLATE. TRADUCIR. TRADUIRE.

We are so excited to share Excel’s newest translation capabilities with you!  Meet TRANSLATE, which allows us to easily translate text from one language to another using language codes within...

Automating the most tedious tasking in Excel

Automating the most tedious tasking in Excel

Avoid the tedium of adding multiple rows and columns with AutoSum. AutoSum detects data in adjacent cells and adds it all up. First, use CTRL + A to select the...

Automating the most tedious tasking in Excel

Avoid the tedium of adding multiple rows and columns with AutoSum. AutoSum detects data in adjacent cells and adds it all up. First, use CTRL + A to select the...

Teleport PDF data tables into Excel

Teleport PDF data tables into Excel

If you’ve ever tried to copy and paste data from a PDF into Excel, you know it can be uglier than the tears shed by Duke fans on Saturday night....

Teleport PDF data tables into Excel

If you’ve ever tried to copy and paste data from a PDF into Excel, you know it can be uglier than the tears shed by Duke fans on Saturday night....