Office tools

courses icon

10 courses

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. 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

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.