MS Office
MS Office 365
MS Office 365 training helps you master creating databases and working with large amounts of data. Working with databases involves importing information, transforming it, and visually presenting it using the tools you already use daily.
Who are the MS Office trainings for?
MS Office training is intended for everyone who works in the MS Office 365 environment — Excel, PowerPoint, Word, Outlook, Teams — and wants to improve the efficiency, accuracy, and quality of their work. They are ideal for:
- Analysts and administrative staff who works with data, documents, and reports
- Managers and team leaders who communicate, plan, and present information
- Employees in sales, procurement, HR, finance, and operations who use Office tools for reporting, coordination, and documentation
- Sectors working in the Teams environment use or share documents and manage tasks in real time
Outlook users who want to optimize the management of email communication, calendars, and tasks
Regardless of previous knowledge level, the trainings are tailored to different profiles and needs, from basic operation to advanced automation and visual data presentation.
What do MS Office 365 training courses cover?
MS Office training covers practical and advanced topics:
- Excel: formulas, pivot tables, Power Query, work automation
- PowerPoint: creating professional presentations
- Word: efficient formatting and structuring of documents
What are the benefits of MS Office 365 training?
AIM MS Office 365 trainings are designed to address real challenges at work. They provide tangible benefits for everyday tasks and business decision-making:
- Speeding up work through task automation and more efficient use of tools
- Improving data quality through more precise formulas, tables, and documents
- Better reporting thanks to structured databases and visually clear presentations
- Greater safety at work with large amounts of information and complex data
- Management support through more accurate and clearer reports that facilitate decision-making
Development of digital skills that are crucial for the modern business environment
Training
Sign up for the training
Look calendar of open training find MS Office 365 training and a date that suits you.
Microsoft Excel
- Navigating the database
- Shortcuts
- Sorting and filters
- Cell Formatting (Conditional Formatting)
- Numeric functions (SUM, COUNT, AVERAGE…)
- Text functions (LEFT, MID, RIGHT, LEN, TEXT...)
- VLOOKUP Function
- Creating a Pivot Table
- Commands and filters in Pivot
Advanced Microsoft Excel
- Commands to speed up work in Excel
- Absolute and relative references
- Functions in Excel
- VLOOKUP vs. XLOOKUP
- Commands and filters in Pivot tables
- Multidimensional analysis
- Calculated field & Calculated item
- Slicers & Timeline in Pivot
- What-If analysis
Data analysis
- Working with databases
- Data sources (Excel, SQL, Text/CSV…)
- Creating models from a database
- Power Query - basic parts
- Importing data from various sources (Excel, SQL, Text/CSV…)
- Text and date commands in Power Query
- Power Pivot - basic components
- Dimensional vs Fact Tables
- Commands and functions in Power Pivot
Microsoft Office 365
- Advantages of working in a Microsoft 365 environment
- Tools and platform capabilities
- Account Security Basics (MFA)
- Integration of Outlook and Teams calendars
- Real-time collaborative document editing
- Creating teams and channels within Teams
- Creating sites and teams on SharePoint
- Storing and organizing documents on OneDrive
Power Query
- Power Query as an ETL process (Extract, Transform, Load)
- Importing and transforming data (Excel, Text/CSV, SQL)
- Commands for arranging rows and columns
- Textual and date commands
- Regional format settings (separators, date)
- Merge and Append Queries Options
- Working with new columns
- Data loading options (Load to Table, Data Model)
Power Pivot
- Differences between a Pivot Table and Power Pivot
- Types of Data Views (Data View vs Diagram View)
- Establishing relationships (One to Many, One to One)
- Commands in Power Pivot
- Measures vs Calculated Columns
- DAX in Power Pivot (Sum, Max, Calculate)
- Creating a Pivot Table from the Data Model
- The connection between Power Query and Power Pivot
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
- 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
VBA
- Introduction to Visual Basic for Applications
- Recording a Macro
- Code optimization
- Recording a Macro
- Variables and Loops
- 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
Creating advanced charts in Excel
- 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.