Many of people use Excel to perform spreadsheet calculations, analysis and business reporting on a daily basis, and some of you have heard about self-service business intelligence tools that exist as an Excel add-in (Power Pivot, Power Query, Power Map) or as a cloud service and platform for design of business reports (Power BI). In cooperation with the company IIB (www.iib.rs), “Excel kitchenette” offers you MasterClass courses to help you improve existing and gain new knowledge.
Advanced Excel (4 days)
Productivity* (1 day)
This course aims at systematizing knowledge and increasing the productivity of students. The emphasis is on the Excel shortcuts and the topics related to: content and formatting of cells, movement, selection, work with worksheets and workbooks, formulas, addressing and fixing of cell addresses, work with series, Paste Special option, making charts, print preview, printing, comments, protection of worksheets and workbooks …
Functions* (1 day)
Knowing functions is an important aspect of working with Excel. The course includes working with formulas, finding and processing errors, and most commonly used: mathematical, statistical, logical, date, financial, array, string and other useful Excel functions.
Reporting* (1 day)
Reports should be both functional and beautiful. The first part of the course will be detailed about formatting, styles, themes and conditional formatting. Further we’ll deal with filtering and report layout, and then you will learn about advanced chart options, images, shapes, WordArt … Knowledge gained in this course can also be used to display and format graphic objects in most other Office applications.
Analysis* (1 day)
In this course we will deal with automation and analysis. First of all: structured tables, data retrieval, import of text, duplicates removal, What-if data analysis tools and Solver. We will briefly demonstrate how to use controls and create macros. Further attendants will learn how to work with Pivot tables and charts with techniques for preparing report dimensions.
* It is possible to attend each individual course or all advanced Excel courses together.
Business Intelligence (2 days)
Excel BI (1 day)
Power Pivot is an add-in that changed Excel from the root and made it even more powerful tool for business reporting. It enables the construction of the Data Model, the preparation of the reporting dimensions (measures and calculated columns) by writing the DAX expression and displaying them through Power Pivot reports and charts. The course will also include Power Query, tool for obtaining and processing data, as well as Power Map, a tool for creating 3D maps.
Power BI (1 day)
Power BI is a cloud service for retrieving data from various sources, linking them into a Model and creating reports with attractive visuals for designing tables, charts and filters. It supports work on desktop, laptop and mobile devices (Windows, iOS, Android) and works on all existing OS platforms (Windows, OSX, Linux). The course, besides Power BI cloud service is mostly oriented on designing reports using the Power BI Desktop platform.
DAX ** (1 day)
In this course, we will deal in detail with the DAX language and the functions it offers. Data aggregation functions, calculation constants, filters, Time Intelligence and many other useful functions will be shown throughout the course.
** The DAX course, with minor differences, is offered as the second day of training for Excel BI or Power BI. That is, the Business Intelligence course is organized as Excel BI + DAX or Power BI + DAX, depending on the affinity of the attendants. It is possible, if agreed, to hold only one of the presented courses or all three of them.
„Excel kitchenette“ offers MasterClass courses, which involves working in small groups (3-6 participants), a Microsoft certified lecturer and a number of examples and exercises taken from the sphere of everyday business. The working material and the training attendance certificates are provided. These courses are made for legal entities, and can be organized on computers and user premises (In-House training) or within company IIB. For any additional questions, please write to us at firstname.lastname@example.org.