Power BI (Business Intelligence) works with many data sources (Excel, Access, SQL Server, and etc.) todevelop an interactive data visualization, or dashboard, giving valuable insights for business reviews and decisions. Those who work with data from multiple sources, to create reports regarding data analysis, marketing, sales, inventory control, production, education, and etc. will benefit most from this course.Requires experience with Excel or other computer applications dealing with data, and different database type software. You should be comfortable developing reports such as PivotTables and charts in Excel.

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.