MS Office
Creating databases and working with data can be challenging. Working with databases involves data import, transformation, and visual presentation of information. If you work with large databases, knowledge from these trainings will enable you to speed up your work, improve data quality, and facilitate decision-making for management. This is intended for everyone who works in MS Office (Excel, PowerPoint, Word...) and who creates various sets of reports and databases.
Basic Excel
- Data formatting in Excel
- Conditional formatting
- Filters
- Numeric functions
- Text functions
- VLOOKUP function
- Date functions
- Pivot table
Advanced Excel
- Data manipulation
- Functions in Excel (VLOOKUP, OFFSET, IF, SUBTOTAL, SUMIFS...)
- Data analysis with Pivot tables
- Calculated Field and Calculated Item
- Slicers
- INDEX and MATCH
- Creating interactive reports
- What-If analysis
Data analysis
- Working with databases
- Commands for creating effective databases
- Functions for working with databases
- Database tools
- Pivot tables
- Power Query
- Power Pivot
- Power BI
Power Query
- Power Query - Basic components
- Data import
- Commands for arranging rows and columns
- Text and date commands
- Merge and Append Queries
- Working with new columns
- Integration with other Power and Office applications
Power Pivot
- Differences between Pivot and Power Pivot
- Basic components of Power Pivot
- Data import
- Relationships
- Commands in Power Pivot
- Dashboard
- Functions in Power Pivot
VBA
- Introduction to Visual Basic for Applications
- Range, Sheet, Workbook
- Code optimization
- Loops
- Arrays
- Variables
- Functions
- VBA and Pivot
- File automation
Advanced Word
- Shortcuts in Word
- Paragraphs
- Styles
- Section breaks
- Navigation Pane
- Tables
- Charts
- Shapes
- Table of Contents
- Mail merge
Advanced PowerPoint
- PowerPoint interface
- Shortcuts in PowerPoint
- Formatting shapes
- Standardizing presentations
- Slide Master
- Tables
- Visualization through charts
- Adding video materials
- Animations and transitions
Excel for business analysts
- What is business analytics
- Business analytics and company finance
- What are data sources?
- Using analytics to find customers
- The relationship between project managers and business analysts
- Data interpretation
- Market analysis
- Competitor analysis
- Business "live" models
Databases
- What constitutes a stable database
- Editing an existing database
- SQL commands for automatic error correction in documents
- SQL commands for automatic filling of additional dimensions
- Data dimensioning
- Models for preventing human errors during data entry
- Reading from a database
- Creating models from a database
- Data visualization