Pi-Works

03/06/2025

How to easily use Index and Match in Excel

In this video we're going to walk through how to easily use the Index and Match Functions within Excel to retrieve a value based on our lookup_value. ...

02/23/2025

Analyze your business data quickly and effectively with Pivot Tables in Excel!

Excel pivot tables are incredibly useful tools that let you sift through large amounts of data quickly. They enable you to summarize and analyze complex information effectively. Whether you're new to Excel or familiar with it, this guide will help you master pivot tables to elevate your data analysi...

02/10/2025

You can also follow up in this video --> https://youtu.be/IAzV19nyjHc?si=511KQmeQNl8sSwbL

Have you ever wondered what type of impact a small tweak or modification to a product or service may have on its overall returns?What if you can create a "What If" scenario to help you make better informed decisions and hit your target?Look no further for a simple "What If" analysis that leverages t...

02/26/2024

It takes a village and a team to bring the vision to life.

02/12/2024

Happy Monday!

02/10/2024

New video on our YouTube Channel. Make sure to subscribe!

In this video, we are walking through how to use the TEXT function within google sheets to get the Day, Month, and Year from a Date.

02/05/2024

Our latest video walks through how to create a Pareto Chart in Google Sheets.

In this video we're walking through how to create a Pareto Chart in Google Sheets.

01/27/2024

In this video, we're walking through the LEFT and FIND function within Google Sheets.

Like and Subscribe for more videos like this!

In this video we're going to walk you guys through the Left and Find Function in Google Sheets.

01/21/2024

In our latest YouTube video, we walk through how to use the Concatenate function within Google sheets.

Make sure you like and subscribe for our weekly videos!

In this video, we're walking through 2 examples of how to use the Concatenate Formula in google sheets.

01/16/2024

We are kicking off the year with our new YouTube channel! 👨‍💻📹🎉

Check out this short video on how to do vlookup in Google Sheets!

VLOOKUP Walkthrough with Pi-Works