Many of you use Microsoft Excel daily for planning, analysis and business reporting. 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). We offer MasterClass on-line or on-premise trainings than can help you improve existing and gain new knowledge in the application of these applications and services. The following is a list of courses. By clicking on the “+” icon you can see a detailed description of each course.
The course aims to systematize knowledge and improve participants' productivity. The emphasis of the course is on Excel shortcuts and topics related to: content and cell formatting, movement, selection, working with worksheets and workbooks, formulas, addressing and fixing cell addresses, working with series, Paste Special option, creating charts, print preview, printing, comments, document views…
Knowledge of the functions makes up at least 50% of the skills of an advanced Excel user. The emphasis of this course is on mastering the functions used in the business environment, and it includes work with the most commonly used: mathematical, statistical, logical (IF, IFS, CHOOSE, SWITCH, AND, OR, NOT), functions for conditional and multiconditional data aggregation (SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS), lookup & reference functions (VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, OFFSET), text functions, time and date functions ...
The goal of this course is to master advanced Excel functions. At the beginning, participants will be introduced to the options for evaluating formulas, finding and resolving errors. Then we'll focus on information functions, error processing functions and financial functions. In the following, we will deal with array formulas and constants. Finally, significant time is devoted to dynamic array functions (XLOOKUP, XMATCH, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY).
This course deals in detail with the presentation and preparation of data for reporting. The first part will be about formatting, styles, themes and conditional formatting. Then we will focus on working with filters and report layout, and then we will deal with advanced options for working with charts, images, links, symbols, shapes, SmartArt, WordArt…
This course covers the areas of automation and analysis. Structured tables (Data Tables) are processed first, followed by basic concepts related to data retrieval and word processing, consolidation, duplicate removal, What-if data analysis tools and Solver. The Forecast Sheet option will also be a theme we’ll deal with. In short, this course covers application controls and creating macros.
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 basics in creation of dashboards.
Power Pivot is an Excel add-in that turns it into a reporting platform for creating business intelligence solutions. The course covers retrieving tables from various sources, linking them, building data models, preparing reporting dimensions (measurements and calculated columns) by writing DAX expressions and their presentation through Power Pivot reports and charts. The course will also cover the creation of KPIs, as well as the tool for creating 3D maps (Power Map).
Power Query is an Excel add-in that is used to retrieve data from various sources, refine it, and consolidate it for further use when creating reports. The course covers: downloading and transforming data, adding, merging and combining queries.
This course deals in detail with the DAX expression language starting from the calculation context, through "X" functions, filter functions, all the way to the CALCULATE function ... It covers the active role of slicers, DAX variables, many mathematical, statistical, logical, functions for working with dates and text and other useful DAX functions. At the end of the course, you will learn how Time Intelligence functions work, which can make it much easier for you to create complex business reports.
This course aims to teach participants how to create Power BI reports using the Power BI Desktop reporting platform. After a short introduction that covers Power BI service, Power BI Desktop will be shown in details, namely: retrieving data tables from various sources and making relationships, basics of DAX language and creating calculated columns and measures, quick measures and calculated tables. Course follows on to creating reports and elaborates on the creation and formatting of commonly used visuals (tables, charts, slicers etc.), filtering, Drill-Down and Drillthrough techniques and other useful options needed to create functional and vivid Power BI reports. This course does not cover topics related to data transformation (Excel BI: Power Query) and DAX functions (Excel: BI DAX), which are included in detail in Excel BI courses. If you have previously completed Excel BI courses, it will be incomparably easier for you to master Power BI reporting.
Power Query is an add-in that has been an integral part of the Power BI reporting platform from its very beginning. It is used to retrieve data from various sources, refine it, and consolidate it for further use when creating reports. The course covers: downloading and transforming data, adding, merging and combining queries, creating custom data types…
This course deals in detail with the DAX expression language, within Power BI, starting from the calculation context, through "X" functions, filter functions, all the way to the CALCULATE function ... It covers the active role of slicers, DAX variables, many mathematical, statistical, logical, functions for working with dates and text and other useful DAX functions. At the end of the course, you will learn how Time Intelligence functions work, which can make it much easier for you to create complex business reports.
Power BI courses, due to their specificity, are organized in small groups or in the form of individual trainings. “Power Query” and “DAX” trainings, whether you opt for Excel BI or Power BI, are not much different. The author’s recommendation is to complete all Excel BI courses first, and then the first Power BI course, because in this way you gain comprehensive knowledge for creating business intelligence reports.
Courses can be attended individually or in groups.
For online teaching, in order to be able to communicate with the lecturer, you need to have a microphone + speakers or headphones with a microphone. A web camera is desirable but not mandatory. Also, you need to have a quality and stable Internet connection.
All courses assume that you have the working computer and the current version of the Windows operating system. To attend the Excel Revisited and Advanced Excel courses, the minimum requirement is to have Excel 2013 or later, or any Office 365 plan that includes the installation of MS Office packages. To attend the Advanced Excel: Complex Functions course you must have any Microsoft 365 (Office 365) plan that includes the installation of the MS Office package. For Excel BI courses, it must be Excel 2016 Pro Plus or any Microsoft 365 (Office 365) plan that includes the installation of MS Office packages. This is a necessary prerequisite, because without the appropriate version of Excel, you will not be able to do the exercises, and therefore it is pointless to apply for the course.To be able to attend Power BI Reporting course, you need to have a computer that has at least an Intel i5 processor, 8 GB of RAM, a 256 GB SSD drive and a minimum of 1366*768 screen resolution. You need to have a newer version of Office or Office 365 installed. You also need to download and install the latest version of Power BI Desktop from powerbi.com.
Make sure you meet all the necessary prerequisites because, otherwise, it is pointless to apply for courses – you will not be able to follow the lessons, solve examples and exercises.
Trainings include work in small groups (usually 2-4, and a maximum of 6 participants) and a high degree of interaction between lecturers and participants. The programs are intensive, and the trainings are held by a certified lecturer (MCP, MOS Excel Expert). The courses are intended for individuals or legal entities, and can be organized on computers and in the user’s premises (on-premise) or as on-distance trainings (on-line).
For more details please write on an e-mail address on this link.