The Role of Microsoft Excel in Digital Transformation.
As the shift to data-driven thinking continues, it is likely that the conversation of digital transformation will advance beyond the tools required to achieve it – such as Excel and an employee’s digital capability to use the spreadsheet programme – to the employee’s mindsets and whether their thinking adds value. Don’t get left behind and find yourself worrying that you don’t have the skills required to convey your thoughts and contribute to your company’s digital transformation.
This 2-Days course will help participants familiarize themselves with the features Power Query, Power Pivot, Cleaning Data and Dashboard. If you have the basic knowledge of
Excel charts, pivot tables, functions, and formulas, you can proceed to this course to learn how to create dashboard out of your, example sales data, that allows you to interactively slice-and-dice within the data and gain greater insights out of your company’s business performance.
After the completion of this workshop, participants should be able to understand the following:
- Understand what Power Query and Power Pivot.
- Identify where in the data analysis process Power Query sits.
- Import data from various sources.
- Restructure and transform data ready for output.
- Loading data to a Table Query, Create a Connection only and add to the Data Model.
