How to use PivotBY Function in Excel for Data Analysis

Ever feel like your data analysis could be simpler? In this video, we'll explore Excel 365's PIVOT function—a powerful tool for organizing and analyzing data. We'll walk you through how to use it to streamline your workflow and get the insights you need faster. The PIVOT function allows you to aggregate data without relying on traditional pivot tables. Using a simple loans table, we'll guide you through how to work with loan products, dates, balances, and credit limits.

You'll learn how to define fields for rows and columns, customize them to display data by month, and see how dynamic arrays update your analysis automatically as you modify your source data. The PIVOT function is invaluable for real-time data insights and streamlined reporting in corporate finance. It efficiently summarizes key metrics, making your Excel work more dynamic and responsive.

About Corporate Finance Institute:

CFI is the #1 rated online provider of finance and banking training, certifications, and productivity tools. With the industry's leading training library, we empower professionals with job-ready training and practical resources to succeed in diverse roles within finance and banking. Our courses' exceptional depth and quality stem from the extensive industry experience of our instructors, who ensure each lesson is immediately applicable. Established in 2016, CFI is the go-to resource for over 2 million individuals and thousands of organizations worldwide.

#ExcelTips #ExcelFormulas #Excel #ExcelFunctions #ExcelTutorial

[mehdimirj]

Hi Scott,
Thanks so much for the explanation, it was really helpful!
I have a couple of questions about using the TEXT function in the PivotBy function:
1-When I use the TEXT function, my date rows end up sorting alphabetically by month name (e.g., April, August, etc.), instead of chronologically. How can I get the dates to sort in the correct month order? I use in Text function this format "yyyy-mmm"
2-Is there a way to add two col_fields when I’m using the TEXT function? I’d like to display another col_field alongside it.
Thanks in advance for any guidance on this!