In this module, you will learn how to use advanced techniques in Excel to analyze data at a deeper level. Using tools such as advanced pivot tables, you will learn how to ask the right questions to analyze your data in-depth and then find ways to answer those questions through several of Excel’s more advanced data analysis techniques.
You will then move on to explore Power BI, a powerful tool for visualizing data. You will have the opportunity to explore some of its capabilities and think about how you might use data visualization to share complex information with a variety of audiences.
Please note that this module focuses on a broad survey of some of Excel’s advanced data analysis tools as well as an introduction to Power BI. It isn’t meant to be a how-to tutorial. Rather, we want you to think about the various ways you can drill down into the data to investigate it from multiple perspectives and how to share that complex information through visualization. The overarching objective is for you to be aware of the various advanced tools and visualization techniques that enable you to add value to your job by enhancing your analytic skills.
Who Should Attend:
Additional Course Information:
This self-paced module is a part of The Ohio Society of CPAs Workforce Development: Upskilling & Reskilling the Accounting Profession Technical Skills bundle. We encourage you to explore each of these courses as a part of your professional development plan. If interested in purchasing the entire bundle, refer to the related products below the product description.