Pi-Works

How to easily use Index and Match in Excel

How to use Index and Match EASY 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. ...

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

How to create a Pivot Table in Excel: Easy 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...

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

Analyzing "What If" Scenarios Using Goal Seek in Excel 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...

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

Happy Monday!

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

How to use the TEXT Function to get Day Month and Year 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.

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

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.

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

Like and Subscribe for more videos like this!

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

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!

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

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

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

How to use VLOOKUP in Google Sheets VLOOKUP Walkthrough with Pi-Works