K2's Advanced Excel Functions and Formulas Webinar

Jul 25
5:00 - 6:40 p.m.

Online

2-Other
CPE Credits

Excel has more than 450 functions with many unused by business professionals. Get on the path to improved Excel productivity with an introduction to powerful, but little used, Excel functions. This course will review functions such as IFS for nested IF statements; AGGREGATE which is best described as SUBTOTAL on steroids; GETPIVOTDATA for producing formal reports from data summarized in a pivot table, CUBEVALUE for building reports directly from the Excel Data Model and TEXTJOIN for joining text or creating CSV files quickly and easily.
Highlights

• Identify key differences between the cloud version and desktop version of Power BI
• Apply the knowledge gained to integrate Excel data into Power BI
• Use built-in query tools in Power BI to search for data
• Create compelling and interactive visualizations to build financial and operational dashboards