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 SpecialistOleh Analir Pisani

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 SpecialistOleh Analir Pisani

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 info@azsolutions.com.au Analir …

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

Backup Google Chrome Bookmarks 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 …

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 Of…

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://azsolu…

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-webinar…

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/#…

What is OneNote? How can you use it efficiently. Learn More Virtual 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 thi…

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 m…

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…

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…

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 miss www.azsolutions.com.au Look out for Free Webinars 🎓 Connect with me on LinkedIn Analir Pisani https://au.linkedin.com/in/analir-pisani…

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.azsolutio…

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 Apps Monthly Microsoft Office Tips & Tricks - you don't want to miss www.azsolutions.com.au Look out for Free Webinars 🎓 Connect w…

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 Exe…

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.au Microsoft 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, NSW http://www.azsolutions.com.au Monthly Microsoft Office Tips & Tri…

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, NSW…

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 t…

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 b…

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 …

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 Of…

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 4…

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. …

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 sessio…

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 Analir Pisani - www.azsolutions.c…

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 bott…

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. Analir Pi…

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

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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. Analir Pisani - www.azsolut…

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

An alternative to Bullet Points is to use Smart Art. YouTube Analir Pisani. Sydney Australia. http;azsolutions.com.au Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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 …

Rules and symbols for creating basic Formulas. YouTube Analir Pisani. Virtual training classes or face to face Microsoft Office Training courses in Australia. Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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 featur…

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 Analir Pisani - www.azsolutions.com.au Microsoft Offi…

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. Analir Pisani - www.azsolutions…

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 S…

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 A…

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

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. Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani

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 Analir Pisani - www.azsolutions.com…

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 Analir Pisani - www.azsolutions.com.au Microsoft Office Training SpecialistOleh Analir Pisani