Listen Now

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 Webinarshttps://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Monthly Microsoft Office Tips & Trickshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545🎓 Virtual Microsoft Office Courseshttps://azsolutions.com.au/virtual/👀 F2F Microsoft Office Courseshttps://azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS 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 Webinarshttps://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Monthly Microsoft Office Tips & Trickshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545🎓 Virtual Microsoft Office Courseshttps://azsolutions.com.au/virtual/👀 F2F Microsoft Office Courseshttps://azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS 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 completeExplore regularly but for short periods of time.💻FREE 30 min Webinarshttps://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Monthly Microsoft Office Tips & Trickshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545🎓 Virtual Microsoft Office Courseshttps://azsolutions.com.au/virtual/👀 F2F Microsoft Office Courseshttps://azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS 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/rFM7R4g78soData types, Geography, StocksFlash Fill - inplace of using Text to column and concatenate function. Article: https://azsolutions.com.au/manipulating-data-excel/#Flash-Fill-And-Remove-DuplicatesQuick AnalysisForecast SheetComments and NotesPower QueryXlookup V's Vlookup function in Excel YT: https://youtu.be/II3XXd2uNZ8🎓 Virtual Microsoft Office Courseshttps://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

What is OneNote? How can you use it efficiently. Learn MoreVirtual sessions available: https://azsolutions.com.au/virtual/OneNote Did you know that OneNote is available if 4 different formats? Desktop Web Windows 10 Mobile Welcome my name is Analir Pisani form AZ Solutions I’d like to share with you the benefits of OneNote. I think,  like Word this app is under utilized What is OneNote? It is part of office 365  OneNote is  your scrap book  your mood board  your miscellaneous bits of information Out of the 4 different formats Desktop is King It’s the one that has all the bells and whistles you are ever going to need I have started to use OneNote for planning Course material Full day courses and 90 min Virtual sessions I’ve set myself a page template ·         Topics ·         Exercise File Links ·         Where to Promote  ·         Reference Notes ·         Related Meetings You can create multiple Notebooks to share with different groups It’s a place to store, images and links for your projects When you save links on your browser – create a folder a bookmark But you then have to relate it to a word and excel and PowerPoint document. Put it in OneNote instead You can email the Notes to yourself or a college You can assign tags and search by:  Tag Name Section Title Date Note Text Search in Current Notebook or other Create your own tags Insert Tables, files,  Create spreadsheets Video record  You can password protect pages Link notes to Word doc Want to know more. Join me in my 90 min course on OneNote  Details in the description of this podcast. Connect with me on LinkedIn : https://www.linkedin.com/in/analir-pisani-9539a749/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

What can you do to ease interruptions? 13-12-2021 Sleep Interruptions are inevitable but we can minimize them. Sleep is so important for our mental and physical wellbeing. This is the time the body needs to rebut and heal. Our stress glands rest and recharge between 11pm and 1 am. We should get our sunlight between 6am and 8:30 am for at least 30 min   Keep your bedroom at 15 – 20 C for the ideal sleep. Magnesium is important for sleep. It balances your blood sugar, muscle relaxation and calms the nervous system. Try setting your phone to Do Not Disturb during the night. Don’t know about but we have family members from around the world who will text or try and call forgetting what time it is at the other end. This can disrupt our sleep. Putting your phone on silent or vibrate is prohibiting you from getting that restful sleep. I found a setting on my Samsung S21 that allows me to set my sleeping times. I’ve set mine from 10:30pm to 6:30 am Day All of that is great for our night interruptions, but what about during the day. When you are in a meeting or need some time to get a job finished set your phone to Do Not Disturb. Whenever possible exit out of outlook so you are not interrupted with notifications. Exit out of all other applications other that what you are currently working on. This will help with disruptions but also boost your PC speed. Let people know you can’t be disturbed from X time to Y time. You need to be specific.  Saying I’ll be 20 min isn’t good enough as nobody is going to keep track of- “ is the time up”. Let people know the time you will be free and what you are currently working on.  If they know you are working on booting the system so everyone can get working again. They will be less likely to interrupt. If you are working on a proposal that needs to be completed by lunch time, let others know.  You will be less likely to be interrupted when you are doing something that they will needs done.  Place your phone inside the draw. Even looking at your phone can be a distraction. Don’t feel you have to attend to someone because they are physically in front of you. It’s ok to say. I’m working on getting the system backup/ working on a proposal due by lunch. Can I come get you when I’m done? Should be after lunch, around 2pm. It’s important to give an estimate time otherwise they will be coming back to you again and again. TRY: Keep a note pad hand at your desk or To Do task on your phone. When someone interrupts you, make a note to get back to them and what it was about. They will feel like you listened and will get back to them.   You can say things like: ·         Let’s schedule a time to talk about that ·         No problem, lets come back to that in a minute ·         We can discuss that later ·         Love to hear more, a little later ·         I’ll tackle that point later Every interruption takes over 23 minutes to refocus. Try focusing on 45 min tasks and take a break, go to the toilet, put rubbish in the bin, make a cup of coffee.  Remember you can’t focus if you are hungry or dehydrated. So have some nuts or fruit and water. Make sure you take regular breaks, set an alarm if you have to. 10:30 - 20 min 12:00 – Lunch 3:00 – 20 min Listen to music, your choice. I find however music with words distracting for me.  Each to their own. Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Office 365 is in a nutshell the latest version of Office that is currently out there on the market for example 2019 is the latest. You can still purchase Office 2019 which will give you only the desktop version of the Microsoft Office suite- Word, Excel, PowerPoint, Access, Outlook, and OneNote. Office 365 is offered as a subscription you have HOME and then you have BUSINESS there is the 365 BUSINESS BASIC STANDARD PREMIUM and 365 APPS.Offer Microsoft Office Training: Virtual and F2F Sydney, NSWwww.azsolutions.com.au   Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Virtual Technology is going to be your first barrier when needing to complete a course online. To ensure a smooth connection check the following. ·         If possible, plug directly to your modem. Yes, the old fashion way plug in that blue ethernet cable. ·         If at home going wireless, best most convenient choice. However, you want to be as close as you can to the modem. ·         Look into Wi-Fi Extenders that plug into the power point. ·         Keep your Router updated at least every 3 years, use the latest technologies  ·         Switch to 5 GHZ where possible, it’s a less crowded band ·         Position your Router high up on a Shelf and away from glass and mirrors ·         Move the router away from air conditioners, microwaves, refrigerators and washing machines ·         Restart your router at least once a month ·         Turn off and disconnect electrical devices not in use – computers, phones, tablets, Smart TV Using your camera during a Virtual session may cause dropouts. If this happens, try turning off the camera. Monthly Microsoft Office Tips & Tricks - you don't want to misswww.azsolutions.com.auLook out for Free Webinars🎓Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Virtual Classes or join me face to face in Sydney NSW Australia.https://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Corporate PowerPoint templates design for your organization. Suggest save as design theme and make it the default. Use along with Reuse slides feature.Monthly Microsoft Office Tips & Tricks - you don't want to misswww.azsolutions.com.auLook out for Free Webinars🎓Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://www.azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Google Lens is a cool feature which allows you to search for the name of a plant by taking a snap shot of it with your mobile phone.You might like a chair you saw  while you were out and about. Take a photo with your phone using Google lense and it can find it for you and give you places where you can purchase it from.  Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Share your thoughts on how you spent your time during Covid-19. Have you taught your self any programs. Did you find time for yourself and family. 🎓Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://www.azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Tools to use when list making.  Differences between choosing to use Outlook for the Desktop, Outlook on the Web = To Do List and the last is Planner part of Microsoft 365 web options.If you can't see Planner> search all AppsMonthly Microsoft Office Tips & Tricks - you don't want to misswww.azsolutions.com.auLook out for Free Webinars🎓Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://www.azsolutions.com.au Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

This podcast will guide you on how you can Double click to follow a link. Double Click is usually reserved for opening or in the case of Excel to get into edit mode in the cell. You will need to change a setting and will carry on for all Excel files. Follow along with me by downloading this Excel exercise file:Download Free Exercises 👀 YouTube ExercisesYT: https://youtu.be/h_9cRrdY78ghttps://azsolutions.com.au/how-to-microsoft-office🎓Offer Microsoft Office Training: Virtual and F2F Sydney, NSWwww.azsolutions.com.auMonthly Microsoft Office Tips & Tricks - you don't want to misshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545Free 30in Webinars, Last Thursday of every month.https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Make sure your Word Document is created using Styles if you want to convert it to a visual aid later on. Visit my blog page for details on how to. www.azsolutions.com.au/convert-word-doc-to-powerpoint. Feel free to connect with me on LinkedIn Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Methods for inserting Tables in PowerPoint. Draw your own or use embedded Excel option which give you all Excel formulas capabilities. YouTube Analir Pisani. Customised courses for your team available in Sydney Australia. 🎓Offer Microsoft Office Training: Virtual and F2F Sydney, NSWhttp://www.azsolutions.com.auMonthly Microsoft Office Tips & Tricks - you don't want to misshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545Free 30in Webinars, Last Thursday of every month.https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

To keep formatting the same font, size colour and more use Styles to make your life easier. YouTube Analir Pisani. http: azsolutions.com.au. By using styles you can then create a table of content at the press of a button. Virtual training classes customised to your team needs available. 🎓Offer Microsoft Office Training: Virtual and F2F Sydney, NSWhttp://www.azsolutions.com.auMonthly Microsoft Office Tips & Tricks - you don't want to misshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545Free 30in Webinars, Last Thursday of every month.https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Listening can be better than reading. Listen to what you have just typed out in your Microsoft Office Word document. I often pick up that I typed you instead of your. YouTube Analir Pisani. http:azsolutions.com.au. There is also a dictate button if you need to save your fingers from doing the work. Virtual Microsoft Office classes as well as face to face training.🎓Offer Microsoft Office Training: Virtual and F2F Sydney, NSWhttp://www.azsolutions.com.auMonthly Microsoft Office Tips & Tricks - you don't want to misshttps://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545Free 30in Webinars, Last Thursday of every month.https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/Connect with me on LinkedIn Analir Pisanihttps://au.linkedin.com/in/analir-pisani-9539a749For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/Virtual Classes or join me face to face in Sydney NSW Australia.https://azsolutions.com.au/virtual/ Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Change is inevitable and whether you are young or old technology is here to stay and we must figure out what are the best tools and methods to keep ourselves organized. The internet is the first place to start. We visit many websites and often like to re visit them so show your Bookmark bar on Google Chrome then start adding links to the bookmark bar even go as far as to create folders. I have a folder for School related links, Finance and Holiday researching to give you some ideas. When it comes to Gmail there are 5 features you need to keep in mind Starred, Mark as important, Creating labels, Mark as Read and Unread.Connect with me on LinkedInMicrosoft Office Customised Computer courses available in Sydney Australia.We come to you.More on YouTube - Analir Pisani Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

To group like data together you want to sort your information first. This is going to be key. Using the Subtotal feature of Microsoft Excel you will be able to group the like data eg; State then perform a mathematical instruction like sum, Average or count. Watch the video on my YouTube Analir Pisani if you need further clarification. AZ Solutions Pty Ltd also offers Virtual Classroom training and Face to Face in Sydney Australia.  Analir Pisani - www.azsolutions.com.auMS Office Training Specialist

Microsoft Word has amazing tool to help you read your documents better. They are found under the View tab and are called Focus and Immersive Reader. For more details you can visit https://azsolutions.com.au/microsoft-word-read-to-you.AZ Solutions Pty Ltd provides face to face learning in Sydney Australia. We come to you and tailor the Microsoft Office Course to your needs and you are able to show us you files and ask any questions you like. Feel free to connect with me on LinkedInYouTube Channel - Analir Pisani Analir Pisani - www.azsolutions.com.auMS Office Training Specialist