Analir Pisani

What is Power BI? Who should use it. Power BI for Desktop v's Power BI for Web. Power BI Service. It's a Data Visualization tool, Handles large data volumes, Collaborative tool. Transforms data through Power query. 

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

When to use Delivery Options in Outlook.

• Have replies sent to: someone else (not me)
• Do not deliver before
• Expires after

Microsoft Office Training Specialist in Sydney, Australia
www.azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Get your Windows operating system organized so you can work efficiently.

Pin Apps to the Task Bar
Pin Files run repairs on apps  and learn Windows shortcut keys.

Windows E - File Explorer
Windows S - Search
Windows C - Copilot which is Windows Ai

Microsoft Office training Sessions:
Analir Pisani
www.azsolutions.com.au
[email protected]

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Use Forms command button for more streamlined data entry.

Virtual Microsoft Office Training available.

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Bookmarks are exported as HTML File.

 1.   Three dots top right (more command)

2.   Bookmarks>Bookmark Manager

3.    Three dots top right

4.    Select Export Bookmarks

Virtual Microsoft Office Training available.

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

I'll give you 3 options to how you can create Templates in Outlook.
First - Using New Items command in the home tab
Second - Using Quick Steps
Third - Using Quick Parts. 

More details on my web site: 
www.azsolutions.com.au

Microsoft Office Training available - Sydney - Australia based

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

1 Do not Save, 2 Save Sent Items to, 3 Delay Delivery, 4 Direct Replies to, 5 Quick Parts.

Insert/ Quick Parts

https://azsolutions.com.au/time-management-techniques-in-outlook/#Quick-Parts-in-Outlook%E2%80%93Create-Repetitive-Statements

💻FREE 30 min Webinars
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/

Monthly Microsoft Office Tips & Tricks
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545

🎓 Virtual Microsoft Office Courses
https://azsolutions.com.au/virtual/

👀 F2F Microsoft Office Courses
https://azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

How do you remind yourself to get back to someone re an email.

 Some of my students said

 I create a task, I write it on a sticky note. Delete – Wait till they call again – good one.

How to add custom Flag: https://azsolutions.com.au/working-with-messages-time-management-outlook/#set-reminders-by-flagging-messages

💻FREE 30 min Webinars
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/

Monthly Microsoft Office Tips & Tricks
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545

🎓 Virtual Microsoft Office Courses
https://azsolutions.com.au/virtual/

👀 F2F Microsoft Office Courses
https://azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Train your brain to see different things in relation to learning Microsoft Office applications.
Ease yourself in to learning new things.
Start by sticking your head inside the window.

Set yourself a Task to complete
Explore regularly but for short periods of time.

💻FREE 30 min Webinars
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/

Monthly Microsoft Office Tips & Tricks
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545

🎓 Virtual Microsoft Office Courses
https://azsolutions.com.au/virtual/

👀 F2F Microsoft Office Courses
https://azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Office 365 adds new feature without notifying you. You could be missing out. 
Here is a list of features:
Clipboard, Analyze Data,
 
Recommended Pivot Tables YT:  https://youtu.be/rFM7R4g78so

Data types, Geography, Stocks

Flash Fill - inplace of using Text to column and concatenate function. 
Article: https://azsolutions.com.au/manipulating-data-excel/#Flash-Fill-And-Remove-Duplicates

Quick Analysis
Forecast Sheet
Comments and Notes
Power Query
Xlookup V's Vlookup function in Excel YT: https://youtu.be/II3XXd2uNZ8

🎓 Virtual Microsoft Office Courses
https://azsolutions.com.au/virtual/

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist