Microsoft 365
Successor to classic Microsoft office suite
Productivity cloud (includes office apps, cloud service and advanced security)
When was Microsoft 365 introduced?
1989
One Drive
Cloud file storage
Virtual drive where documents are stored or/and shared
Microsoft Teams
Easy virtual connections to work in real time without meeting
For virtual meetings, (group) chats, common or personal data storage
Based on cloud
When was Microsoft Teams introduced?
2017
One Note
Digital notebook which automatically saves and synchronizes notes
When was One Note introduced?
2003
Microsoft Defender
Antivirus program for different types of malware
Basic free protection, not enough to protect against all cyber attacks
Clipchamp
Video editor which allows to create videos in easy way
Combining videos, images, audio files, text, or effects
Microsoft Editor
Writing assistant (available for Word and Outlook)
Connected with AI
Outlook
Mails can be split into different folders
Rules for splitting can be set
Calendar can be shared with co-workers in different forms
Messages are encrypted
When was Outlook introduced?
1996 as Hotmail
2012 changed into Outlook
What are the 3 different forms to share your Outlook calender?
Full sharing: Authorized users can see details of meetings, their duration and title
Partial sharing: Authorized users can't see details of the meeting, but their duration and title
Only dates: Authorized users can see time blocks marked as busy
Microsoft Word
Used for text writing, editing, and formatting
Main parts of interface: Ribbon and toolbar, document window, and status bar
Who do you do an non-breaking space in Word?
CRTL + SHIFT + ENTER
What is a shoemaker / orphan?
The first line of a paragraph is left at the top of the page (avoid)
When was Word introduced?
1983
Excel
Spreadsheet is a technical advanced system
Allows math, calculations, analyses, graphical data representation
When was Excel introduced?
1987
Since 1993 Visual Basics
What is a whole rows and column in Excel?
Whole column B (B:B)
Whole row 2 (2:2)
What is a block of cells in Excel?
left top corner cell address : right down corner cell address
What is a relative and absolute address in Excel?
Relative address: Corresponds to the change of formula cell to another one
Absolute address: Contain $ character inside the cell address
Completely blocked ($A$1)
Column absolute address ($A1)
Row absolute address (A$1)
What are Pivot tables?
Interactive and dynamic way to summarize large amount of data to provide visualization
4 basic element: value fields, column fields, row fields, filter fields
Requirements: not have empty cells, all columns have titles
What are the requirements for Pivot tables?
Don’t have empty cells
All columns have titles
When was PowerPoint implemented?
PowerPoint
Computer presentation software
general rules for content creation / slide formatting
KISS (keep it short and simple)
SSS (say what u are going to say, say it, say what u said)
Last changeda year ago