Mia Padula

In my Digital Communication class, I used several Excel techniques to analyze and present data effectively. The three techniques that stand out to me are: XLookup, pivot tables, and graphs and charts. 

I used XLookup in Excel to efficiently search for and retrieve specific data from different tables and worksheets. This function allowed me to match values accurately without manually searching through large data sets, which saved time and reduced errors. Using XLookup helped keep my data organized and ensured consistency when updating or analyzing information. 

Pivot tables were used to quickly summarize and analyze large amounts of data. By organizing data into categories, I was able to compare values, identify trends, and extract meaningful insights that would have been difficult to see in raw data. Pivot tables made it easy to adjust and filter information, allowing me to view the data from multiple perspectives.

I used graphs and charts to visually communicate the data in a clear and engaging way. These visuals helped highlight key trends, comparisons, and patterns that might not be obvious in a table alone. By turning data into visual representations, I was able to present my findings more effectively and make the information easier for others to understand.