Use XLOOKUP and Pivot Tables in Excel to Create Dynamic Graphs
By using xlookup and pivot tables, we'll be able to create an amazing graph that shows our data in a visual way.
If you're familiar with Excel, then you know how powerful xlookup and pivot tables can be. In this video, we're going to see how to use these tools to create a line graph from our data. By the end of the video, you'll have a graph that shows how our data changes over time!
If you like this video, you might like the following:
Excel Line Graph Tutorial: How to Make It & Format It
• How To Make a Line Graph in Excel Super Fast!
10 excel tips and tricks to format your reports and learn excel:
• 10 Excel Tricks to INSTANTLY Improve Your ...
NPV in Excel: The Easiest Way to Calculate It & Prove It to Yourself
• Calculate Net Present Value (NPV) in Excel
How to Calculate ROI in Excel (Return on Investment)
• How to Calculate ROI in Excel ➡️ Return on...
==================================
I post daily accounting and finance quizzes
/ @patrickbraycpa
==================================
#exceltips #excelformula #financialanalysis #financialformulas #excel #exceltutorial #exceltricks #exceldataanalysis #finance #dataanalysis #analyzing #financialstatementanalysis #financialeducation #pivottables #pivot_table #pivottable #xlookup #excelgraphs #excelgraphs
0:00 - Intro
0:21 - Using Xlookup
0:53 - Using a Pivot Table
1:42 - Creating a line graph