MS Office
MS Office 365
MS Office 365 training help you master the creation of databases and working with large amounts of data. Working with databases involves importing information, transforming it, and visually presenting it. The training is intended for anyone working in MS Office (Excel, PowerPoint, Word..) who creates different sets of reports and databases.
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. Programi obuhvataju teme kao što su napredno korišćenje Excel formula, pivot tabela, Power Query, automatizacija rada, izrada profesionalnih PowerPoint prezentacija i efikasno formatiranje dokumenata u Word-u.
AIM MS Office obuke osmišljene su tako da odgovore na potrebe poslovnog okruženja koje se brzo menja – jer vreme, preciznost i efikasnost danas prave razliku. Pogledajte calendar of open training and find the training and appointment that suits you.
Microsoft Excel
- Data formatting in Excel
- Conditional formatting
- Filters
- Numeric functions
- Text functions
- VLOOKUP function
- Date functions
- Pivot table
Napredni Microsoft Excel
- Data manipulation
- Funkcije u Excel-u
- Data analysis with Pivot tables
- Calculated Field and Calculated Item
- Slicers
- Funkcija XLOOKUP
- Creating interactive reports
Data analysis
- Working with databases
- Commands for creating effective databases
- Functions for working with databases
- Database tools
- Pivot tables
- Power Query
- Power Pivot
Microsoft Office 365
- Microsoft 365 okruženje
- Alati i mogućnosti platforme
- Integracija sa drugim aplikacijama
- Microsoft Outlook
- Microsoft Teams
- SharePointt
- OneDrive
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
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
Microsoft Word
- Shortcuts in Word
- Paragraphs
- Styles
- Section breaks
- Navigation Pane
- Tables
- Charts
- Shapes
- Table of Contents
- Mail merge
Microsoft Power Point
- PowerPoint interface
- Shortcuts in PowerPoint
- Formatting shapes
- Standardizing presentations
- Slide Master
- Tables
- Vizualizacija kroz grafikone
- 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
VBA
- Introduction to Visual Basic for Applications
- Snimanje Macro-a
- Code optimization
- Referenciranje ranga
- Varijable i Petlje
- Functions
- VBA and Pivot
Kreiranje izveštaja u Excel-u
- Creating a set of reports
- Table and its automation
- Examples of good and bad reports in Excel
- Kombinovanje grafikona u finalnom izveštaju
- Standardizing report sections
- Uvezivanje izveštaja u Excel-u sa Power Point-om
Kreiranje naprednih grafikona u Excel-u
- Types of charts in reports
- Line chart
- Column chart
- Bar chart
- Stacked column
- Waterfall
- XY scatter
- Chart automation
Video review | AIM Minute
In this practical video of the AIM Institute, the trainer Marija Urošević shows step by step how to automate repetitive tasks in Excel using the Macro tool - without writing code! Learn how to record a series of actions, speed up everyday work with tables, and increase efficiency with just a few clicks.