Many people use Excel daily for planning, analysis, and business reporting and some have even heard of self-service business intelligence tools that exist as an add-on (Power Pivot, Power Query, Power Map) or for a Microsoft cloud service and business reporting platform (Power BI). Excel Kitchenette offers you MasterClass on-line or on-premise trainings than can help you improve existing and gain new knowledge.
This course aims to systematize knowledge and increase participants’ productivity. Emphasis is placed on shortcuts on topics related to: cell content and formatting, moving, selection, working with worksheets and workbooks, formulas, addressing and fixing cell addresses, working with series, Paste Special option, production charts, prepress, printing, comments, views …
Functions are an important aspect of working with Excel. The course covers following topics: working with formulas, finding and processing errors, most commonly used: mathematical, statistical, logical, date, financial, text, string, and some other useful Excel functions.
The reports should be both functional and beautiful. In the first part of the course will discuss in detail the formatting, styles, themes, and conditional formatting. We then filter and look at reports, and then handle advanced charting options, images, formats, WordArt… The knowledge gained in this course can also be used to display and format graphical objects in most other MS Office applications.
Automation & Analysis *
Subject of this course are Excel automation and analysis. First, it deals with structured tables (data tables) and further with basic concepts regarding data retrieval and text processing, consolidation, removing duplicates, What-if data analysis tools, and Solver. Briefly participants will learn how to use development tools such controls and macros.
Pivot Tables *
This course is dedicated exclusively to working with Pivot Table reports, which allow data aggregation and viewing from multiple angles. It will be shown how they are made, how to impact their appearance, formats the content and exploit numerous additional options. You will learn how to create Pivot charts and interactive filters (slicers, timeline). Also, it will be about the techniques of preparing report dimensions, connection between Pivot tables and traditional Excel reports, as well as the creation of dashboards.
* Participants can take each individual course or all Advanced Excel courses together.
Power Pivot *
Power Pivot is a add-in that has radically changed Excel and made it an even more powerful business reporting tool. It enables the construction of Data Model, preparation of reporting dimensions (measures and calculated columns) by writing DAX statements and displaying them through Power Pivot reports and charts. The course will also cover the creation of KPIs, as well as a tool for creating 3D maps of Power Map.
Power Query *
Power Query first appeared as an add-in to become an integral part of Excel with version 2016. Since version 2019, it has been an indispensable tool when it comes to collecting and transforming data. It allows you to connect to a multitude of different data sources, define rules for processing them, and then create the desired reports based on “refined” data.
In this course we will deal in detail with the DAX language and its features. The themes covered by course are: data aggregation functions, data contexts, filters, Time Intelligence, and many other useful DAX functions…
* Participants can take each individual course or all Excel BI courses together.
Power BI Reporting
Power BI is a cloud service for collecting data from various sources, linking, processing and creating reports with the help of attractive visual tools. These reports can be viewed using an Internet browser, integrated into web applications, or viewed through a mobile application available on all existing platforms (Windows, iOS, Android). The emphasis of the course is on using the Power BI Desktop application to produce functional and beautiful reports.
These MasterClass courses assume working in small groups and a high degree of interaction between lecturers and participants. The programs are very intensive, and the trainings are held by a certified lecturer (MOS Excel Expert). These courses are intended for individuals or companies, and can be organized as on-premise and on-line trainings.
For more details please write on an e-mail adress on this link.