Office tools

The course gives a general understanding of using MS Excel in data analysis, hypothesis testing, and time-series analysis. This training is aimed to the understanding of main statistic methods, their step-by-step implementation, and interpretation of obtained results, rather than memorizing formulae or definitions. Participants will be provided with practical problems for decision making.

This training covers the ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions / animations, and manage multiple presentations.

This training covers the ability to create and manage documents; insert and format text, paragraphs, and sections; manage tables and lists; create and manage references; and insert / format graphic elements in MS Word.

This training covers the ability to create custom document elements using advanced Word features.

This training covers features of MS Outlook that are necessary for managing application settings, creating and managing messages, appointments, meetings, contact records, and tasks as you would in a typical business environment.

This training covers the ability to use financial functions in MS Excel. You will get basic knowledge about financial topics related to these functions, examine real-life situations highlighting when these functions are most useful, and complete practical exercises.

This training covers useful features of MS Excel for day-by-day use, some unusual technics and special features that can be helpful when you work with Excel.

This training covers the features of workbook management, how to prepare workbooks for collaboration, filling cells with data, conditional formatting and data validation, applying advanced formulas and data analysis, creating macros, creating / modifying advanced charts, and pivot tables in MS Excel.

This training covers principles of using basic DAX functions in Power BI to visualize data effectively.

This training covers the fundamentals of data mining, essential techniques for data preparation and analysis, and how to leverage Excel’s powerful tools for extracting insights. Participants will learn to handle data effectively, apply statistical methods, and utilize advanced features like pivot tables and regression analysis to uncover patterns and relationships in their datasets.

This training covers the ability to create and manage workbooks and worksheets, modify / format cell content, summarize / organize data, present data in tables and charts, perform data operations by using functions and formulas, and insert / format objects on worksheets in MS Excel.