Analir Pisani

Get your Windows operating system organized so you can work efficiently.Pin Apps to the Task BarPin Files run repairs on apps  and learn Windows shortcut keys.Windows E - File ExplorerWindows S - SearchWindows C - Copilot which is Windows AiMicrosoft Office training Sessions: Analir Pisaniwww.azsolutions.com.auinfo@azsolutions.com.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist

Use Forms command button for more streamlined data entry.Virtual Microsoft Office Training available.Analir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist

Backup Google Chrome BookmarksBookmarks are exported as HTML File. 1.   Three dots top right (more command)2.   Bookmarks>Bookmark Manager3.    Three dots top right4.    Select Export BookmarksVirtual Microsoft Office Training available.Analir Pisani - www.azsolutions.com.auMicrosoft 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 tabSecond - Using Quick StepsThird - Using Quick Parts. More details on my web site: www.azsolutions.com.auMicrosoft Office Training available - Sydney - Australia basedAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist

1 Do not Save, 2 Save Sent Items to, 3 Delay Delivery, 4 Direct Replies to, 5 Quick Parts.Insert/ Quick Partshttps://azsolutions.com.au/time-management-techniques-in-outlook/#Quick-Parts-in-Outlook%E2%80%93Create-Repetitive-Statements

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

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.

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

What is OneNote? How can you use it efficiently. Learn MoreVirtual sessions available: https://azsolutions.com.au/virtual/OneNoteDid you know that OneNote is available if 4 different formats?DesktopWebWindows 10MobileWelcome my name is Analir Pisani form AZ SolutionsI'd like to share with you the benefits of OneNote.I think,  like Word this app is under utilizedWhat is OneNote?It is part of office 365 OneNote is your scrap book your mood board your miscellaneous bits of informationOut of the 4 different formatsDesktop is KingIt's the one that has all the bells and whistles you are ever going to needI have started to use OneNote for planning Course materialFull day courses and 90 min Virtual sessionsI've set myself a page template·         Topics·         Exercise File Links·         Where to Promote ·         Reference Notes·         Related MeetingsYou can create multiple Notebooks to share with different groupsIt's a place to store, images and links for your projectsWhen you save links on your browser – create a folder a bookmarkBut you then have to relate it to a word and excel and PowerPoint document.Put it in OneNote insteadYou can email the Notes to yourself or a collegeYou can assign tags and search by: Tag NameSectionTitleDateNote TextSearch in Current Notebook or otherCreate your own tagsInsertTables, files, Create spreadsheetsVideo record You can password protect pagesLink notes to Word docWant 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/

What can you do to ease interruptions?13-12-2021SleepInterruptions 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 amDayAll 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 laterEvery 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 min12:00 – Lunch3:00 – 20 minListen to music, your choice.I find however music with words distracting for me.  Each to their own.

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 

VirtualTechnology 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 TVUsing 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

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

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. 

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. 

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

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

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

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. http:azsolutions.com.au

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. 

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.

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

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. 

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

Deciding on which Microsoft Word course to book into can be tough. This pod cast will give you ideas on what is classified as Introduction, Intermediate or Advanced.You can also read about these on www.azsolutions.com.au/course-outlines.If you would like to follow up by attending a face to face training session in Sydney Australia. call M: 0414 417 059Subscribe for more podcasts like this one or visit YouTube - Analir Pisani.Feel free to connect with me on LinkedIn

Deciding on which Microsoft Office Excel course to book into can be daunting. Listen to this podcast for some ideas on the difference between booking into an introduction, Intermediate or advanced course in Excel. You can also read about the course levels by going to www.azsolutions.com.au/course-outlines.Feel free to connect with me on LinkedIn.Face to face training courses also provided for Sydney, Australia. www.azsolutions.com.auSubscribe to a podcast or YouTube Videos - Analir Pisani

Pivot Tables Field lists can be hard to find the field you are after. Since 2013 Microsoft added a search bar in the Pivot Tables Field List area. YouTube Analir Pisani. If you still can't find it drop us a line by visiting our web site http:azsolutions.com.au. If you get really stuck AZ Solutions Pty Ltd customised Microsoft Office training sessions.

Struggling to keep your inbox under control. I have a few tips to help. Set some rules. Use the Do not Save command button and a great one to remember is to file it away before you hit the send button. The idea is that you want to touch the inbox files a little as possible. More great tips. https:azsolutions.com.au

There are some great features of the XLOOKUP Function, most peoples favourite part I imagine would be that the lookupvalue can be located anywhere not just on the first column of your table. XLOOKUP function eliminated the need for nesting other functions to get the job done like the IFERROR and MATCH functions. You can also search from top to bottom or from Bottom to top. The IFERROR component is built into the functions. I also have a YouTube Video if you prefer lookup Analir Pisani. If face to face consulting is best and you are in Sydney Australia https:azsolutions.com.au can help.

Change Case using Shortcut keys. YouTube Analir Pisani. http:azsolutions.com.au. Face to Face Microsoft Office Computer Courses Sydney Australia.

Change the bullet design, Add to a numbering system in Microsoft Word, Changing Bullets to Numbers. Stop numbering enter twice. YouTube Analir Pisani. Virtual Classes available. http:azsolutions.com.au

Getting the 2 in H2O to sit below the line level you need Subscripts. Think submarine and for 20 degrease Celcius o to sit above the line level you need SuperScript. Think superman. YouTube Analir Pisani. http:azsolutions.com.au. Virtual and Face to Face Microsoft Office training for groups available in Sydney Australia. 

Need to pull bits and pieces of your data out of one cell. You may use text to column. There is a new way it's called Flash Fill. As the name suggests it will save you soooo much time. Yes in a Flash. YouTube Analir Pisani. http;azsolutions.com.au. Want more try face to face customised Microsoft Office Training session just for your team. 

An alternative to Bullet Points is to use Smart Art. YouTube Analir Pisani. Sydney Australia. http;azsolutions.com.au

No need to be a design expert PowerPoint has a feature that can help with that. YouTube Analir Pisani, attend face to face training classes in PowerPoint or any Microsoft Office product. If face to face is not your thing Virtual lessons available. http:azsolutions.com.au

Get ideas on how to best use Microsoft PowerPoint. Less is more when it comes to bulleted slides and consider converting them to Smart Art Graphics instead. Don't feel obligated to include animation. Consider hiding your bullet point after presenting more tips in this podcast or visit YouTube Analir Pisani for further customised learning you could do a Face to Face training session Sydney Australia. Virtual Classroom sessions another option.https://www.azsolutions.com.au

Instead of hiding and unhiding cells use the outlining feature of Microsoft Excel. Press plus and Minus buttons instead of hid/unhide. YouTube Analir Pisani. Outlining is the name of this feature. http:azsolutions.com.au

Microsoft Excel has a command button in the ribbon that will apply several feature in one hit. It's great. It Applies Colour on every second row, turns on the Filters, has a totals row at the bottom, Grows with you if you watch my video on Format As Table and Pivot tables you'll understand where is is great. You can create a graph using this feature for Jan feb when you have the data for March later on it will automatically update your graph. http:azsolutions.com.au

Rules and symbols for creating basic Formulas. YouTube Analir Pisani. Virtual training classes or face to face Microsoft Office Training courses in Australia.

You have gone through the trouble to apply multiple formatting styles to a cell in a Microsoft Excel spreadsheet. Heard of the Format Painter. but there is a trick to using it that most people over look. YouTube Analir Pisani. Need help with any other Microsoft Office applications AZ Solutions Pty Ltd customised Computer training to your needs in Sydney, NSW Australia. Virtual Microsoft Office Training also available.

Need to be left with a unique list of data try remove duplicates is just one command button under the Data tab and you are done. You can always undo. YouTube Analir Pisani. Still stuck AZ Solutions Pty Ltd focus on customising Microsoft Office Training Courses to the group or individual. Virtual Classrooms are also available. Based in Sydney, NSW Australia

Playing with Filters in Excel spreadsheets. First ensure you have all the data selected. Quick tip mentioned for how to enter the current date by a shortcut key. YouTube Anallir Pisani. Customised Microsoft Office Training Course Face to Face Sydney and Virtual Classroom. http:azsolutions.com.au

There is a little trick to entering your data in Excel as a percentage. We will talk you through the places where people tend to get stuck. YouTube Analir Pisani. If you need further assistance for any Microsoft Office question visit http:azsolutions.com.au our join a Virtual Training Session just for you or a group.

You may have been filling Excel Formulas by simply dragging for 100 years. Well there is no need this podcast will reveal a stress free technique.YouTube Analir Pisani or hop on a Virtual Training Session customised just for you or your group. Face to Face Courses also available in Sydney. http:azsolutions.com.au

Struggling to see where formulas have been used in Microsoft Excel spreadsheets. I have a simple keystroke that will reveal all. YouTube Analir Pisani. Virtual Classes and Face to Face Customised Courses Sydney, NSW. http: azsolutions.com.au

Join several cells to make them appear as one great for headings spread out over several columns of data. YouTube Analir Pisani. Classes available both Virtual and Face to Face Sydney. http:azsolutions.com.au

Widen Columns in a Microsoft Office Excel Spreadsheet is easy. YouTube Analir Pisani. Face to Face Customised lessons Sydney New South Wales and Virtual Classroom.

Talk you through setting up and Excel spreadsheet to monitor your Income your expenses and what you have left to spend. YouTube Analir Pisani. Virtual training courses and Face to Face Classes. http:azsolutions.com.au

When you have lots of Excel Spreadsheets it can be a pain to navigate around. I have a tip that will knock your socks off. YouTube Analir Pisani. Virtual Classes in Microsoft Office as well as Face to Face Sydney, Australia. http:azsolutions.com.au

Keeping Zeros in front of a number has always been a bit of a challenge. However I have the best solution. YouTube Analir Pisani or attend classes Virtual or Face to Face. http:azsolutions.com.au

Date keeps changing to a number and it stays eg;red formatted. One button and it's all sorted. This podcast will clarify the technique to clean your formatting in Microsoft Excel Spreadsheets. YouTube Analir Pisani. Virtual Classes or Face to Face Customised Courses in Sydney New South Wales Australia. http:azsolutions.com.au