Accountants are in an optimal position to deliver value through data analytics. In the business world, this starts with Microsoft Excel. Today’s Excel is a significantly more robust spreadsheet, where the application of Excel’s power query and power pivot tools enable dramatic improvement in the data analytics process. The knowledge and skills gained in Excel’s advanced tools translates directly to the PowerBI platform.
You have the tools you need to get started in data analytics.
After completing this course, you will be able to:
Microsoft Excel is a ubiquitous tool in accounting and finance and developing your Excel and data analysis skills is key to keeping your skills relevant in the data driven world we now live in. It is also the gateway to effectively using Microsoft’s PowerBI services.
Excel data analytics knowledge reviewed in this session will include:
All attendees receive a case study “project how-to guide” on how to generate an automated File Directory list from their computer / network drive. This is an excellent resource and will provide immediate value to your work world.
None
All accountants interested in improving their Excel knowledge, and embracing the opportunity to become a more data driven professional.
Experience using Excel functions and formulas in Excel is helpful. The power query discussion uses the Microsoft 365 version of Excel. In older Excel versions (2010 and 2013), this is an add-in that needs to be installed. Power query will look different depending on the Excel version installed.
To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.
Update your browser to view this website correctly.
