MS Office
MS Office 365
MS Office 365 obuke pomažu da ovladate kreiranjem baza i radom sa velikim količinama podataka. Rad sa bazama podrazumeva uvoz informacija, njihovu transformaciju i vizuelnu prezentaciju. Obuke su namenjene svima koji rade u MS Offce (Excel, PowerPoint, Word..) i koji kreiraju različite setove izveštaja i baza podataka.
Ako svakodnevno radite u Excelu, PowerPointu ili Wordu, MS Office obuke će vam omogućiti da ubrzate rad, unapredite kvalitet podataka i olakšate donošenje odluka menadžmentu. Pogledajte kalendar otvorenih obuka i pronađite termin koji Vam odgovara.
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
MS Office 365 obuke
U ovom praktičnom videu AIM Instituta, trener Marija Urošević pokazuje korak po korak kako da automatizujete ponavljajuće zadatke u Excelu pomoću Macro alata – bez pisanja koda! Naučite kako da snimite niz radnji, ubrzate svakodnevni rad sa tabelama i povećate efikasnost uz samo nekoliko klikova.