Microsoft Certified Trainer - МСТ. Професійний викладач з досвідом понад 20 років. Автор навчальних програм та посібників. Проводить навчання з программуванання на VBA, прикладні курси з аналітики засобами Power BI та Excel.
Effective data analysis becomes a key factor in successful decision-making. Microsoft Excel remains the most popular tool for data analysis, but classic pivot tables have their limitations. The Power Pivot add-in and DAX language are used to overcome these limitations. Study Power Pivot and DAX for deeper and more accurate data analysis. 2.5 days - 20 academic hours - 15 astronomical hours
• Cloud technologies and Microsoft 365 • Working with OneDrive • Using Office Web Apps • Co-editing documents
Master Power BI, Microsoft's most popular Self-Service BI tool. Learn how to create reports, dashboards, and analyze data on your own in the Power BI cloud service without the need for programming or complex modeling.
Advanced Power BI course: workspaces, apps, data security (RLS), and analytics for advanced users. In just 1 day!
На курсі Power Query учасники навчаться як ефективно використовувати Power Query для видобутку і трансформації даних у Excel. Учасники зможуть освоїти потужний інструмент для отримання даних з різних джерел і їх подальшої обробки, що дозволить значно спростити вашу роботу з даними. 16 академічних години - 12 астрономічних години - 6 занять по 2 години. Тренер Максим.
Advanced Power Query course: complex queries, M language, non-standard tasks, and practical cases for automating data processing in Excel and Power BI.
Power BI Desktop Advanced Course: Data Modeling, Advanced Visualizations, What-If Analysis, and DAX. For advanced Power BI users.
Gain programming skills with the Visual Basic for Applications (VBA) for Microsoft Excel course, learning the basics of programming and developing macros. The VBA Excel course will equip you with the necessary knowledge and skills to effectively use VBA in your everyday work with Excel. 4 days - 32 academic hours - 24 astronomical hours.
In the course "Office 365: Maximum Productivity for Users" you will learn how to effectively use Microsoft Office 365 tools to improve your productivity. Awareness of the features of Word, Excel, PowerPoint, Teams and other services will help you optimize workflows, collaborate with your team and manage projects with ease. Regardless of your level of training, you will find useful tips and practical skills that you can apply immediately.
The Microsoft PowerPoint course reveals the secrets of creating professional presentations - from basic functions to creating your own presentation templates. In 1 day, you will master the powerful tools of PowerPoint and gain skills that you can immediately apply in your work or studies.
Microsoft PowerPoint 365 - for creating professional presentations. In our intensive 12-hour course, you will learn all aspects of working with PowerPoint: from structuring slides and formatting content to complex animations, interactive elements and recording presentations.