Office tools

courses icon

11 courses

Data Mining in Excel for Beginners

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.
  • duration 15 hours
  • New New

MS Excel. Module 1: Intermediate

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.

  • duration 11 hours

Statistics in MS Excel

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.

  • duration 12 hours

MS PowerPoint

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.

  • duration 10 hours

MS Word Module 1: Intermediate

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.

  • duration 12 hours

MS Outlook

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.

  • duration 8 hours

MS Excel. Financial Functions

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.

  • duration 12 hours

MS Excel: Tips and Tricks

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.

  • duration 15 hours

Microsoft Excel Advanced

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.

  • duration 15 hours

MS Power BI: Basics of DAX

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