It is a fact that Excel is essential for any business professional. Thus, when applied effectively, Excel is a very powerful tool that allows you to process huge amounts of data, automate tasks and present complex information, etc. Therefore, this course is designed to help you learn how to solve business problems with Excel (more) efficiently and promote you to be an advanced user.
Business intelligence programs such as Power BI Desktop help create professional visualtisations and to make data-driven decisions.
In this course you will learn ...
… the basics, in particular how to
- manage spreadsheets and workbooks in Excel
- create clean and effective Excel charts and diagrams
- reference between cells and to other worksheets
- work with basic functions for calculations in Excel (SUM, COUNT, AVERAGE, MAX, MIN, IF, SUMIF, AVERAGEIF)
- change cell formatting based on cell content.
… all about functions and reporting by using
- TEXT functions (CONCATENATE, LEFT, RIGHT, MID,LOWER, ...)
- IF functions
- VLOOKUP
- Sort & Filter
- PivotTables
- Advanced Charts
- Advanced Data Analysis with Dashboards (Excel Powerview)
- Dynamic Data Exchange with external sources (databases, SAP, Powerpoint, internet).
… with practical business examples such as
- BCG Matrix
- ABC Analysis
- Break Even Point
- Contribution Margin
- Discounting Payback Method
- Form Controls (Scroll Bar; Check Box …)
- Goal Seek
- Solver.
… the basics about Power BI Desktop the Business Intelligence App from Microsoft
- Import Data
- Creating interactive Dashboards and Reports
- Vizaulisations from the Market Store
- Modelling of different data sets
- Calculation with Measures and DAX Functions
- Distribute the reports via HTML
- Using PowerBI with Mobile Devices
- Power BI Cloud Resources
… a lot about tips & tricks such as
- working with shortcuts
- protecting, validating and hiding information and formulas
- handling large Databases.