Shows
Analir PisaniDownload Troubles Solved: How to Locate Missing FilesWhere did your Download files end up. Downloads folder. Shortcut Windows E for Windows explorer. Ctrl J for Downloads history in Browser.AZ Solutions Pty Ltd delivers Microsoft Office Training Courses - Sydney AustraliaAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2025-07-3104 minAnalir PisaniPower BI Data Driven DecisionsWhat 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.auMicrosoft Office Training Specialist2024-09-2607 minAnalir PisaniUse Outlook Delivery Options To Your BenefitWhen to use Delivery Options in Outlook.Have replies sent to: someone else (not me)Do not deliver beforeExpires afterMicrosoft Office Training Specialist in Sydney, Australiawww.azsolutions.com.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2024-08-1502 minAnalir PisaniPin Task, Run Simple Repairs and Customize Windows Workspace to Power Through your Work TodayGet 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 Specialist2024-04-3006 min
Analir PisaniStreamlining Spreadsheets Your Guide to Effective Excel FormsUse Forms command button for more streamlined data entry.Virtual Microsoft Office Training available.Analir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2023-09-2302 min
Analir PisaniUnlocking Peace of Mind Safely Storing Chrome Bookmarks - A Podcast TutorialBackup 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 Specialist2023-09-2301 min
Analir PisaniMastering Outlook Templates with 3 Expert TipsI'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 Specialist2023-09-0506 minAnalir Pisani5 Time Savers In Outlook Messages1 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💻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.auAnalir...2022-11-0105 minAnalir PisaniSet Reminders in Outlook and MoreHow 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=a352b0debea85...2022-10-1208 min
Analir PisaniHow to Overcome Your Fear Of TechnologyTrain 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...2022-03-2509 min
Analir PisaniFeatures You May Overlook In Microsoft ExcelOffice 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...2022-03-0116 min
Analir PisaniUnderstanding Microsoft OneNoteWhat 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 ...2022-02-2204 minAnalir PisaniWhat can you do to ease interruptions?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...2021-12-1309 min
Analir PisaniOffice 365 ExplainedOffice 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 - w...2021-09-0111 min
Analir PisaniF2F Virtual or Hybrid Microsoft Office CoursesVirtualTechnology 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...2021-07-1420 min
Analir PisaniWorking with Corporate Microsoft PowerPoint TemplateCorporate 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.au2021-04-2704 min
Analir PisaniFind the name of that plant by taking a photoGoogle 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.auMicrosoft Office Training Specialist2021-04-2202 min
Analir PisaniPositive Outcomes From Covid-19Share 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2021-04-2003 min
Analir PisaniDifferent List Making tools:To Do Lists, Planner and OutlookTools 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/...2021-04-1612 min
Analir PisaniExcel Double Click To Follow A LinkThis 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.azsolut...2021-01-1204 minAnalir PisaniConverting Word Into PowerPointMake 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 LinkedInAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-12-0804 min
Analir PisaniUpdatable Formulas in PowerPoint Without Importing and Excel SpreadsheetMethods 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/...2020-11-0305 min
Analir PisaniConsistent Formatting in Word using StylesTo 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=a3f142...2020-10-0605 min
Analir PisaniHave a Word Doc be Read Out To You - Microsoft WordListening 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 misshtt...2020-09-0802 min
Analir PisaniWhat Every High School Student Needs To Know When Using The InternetChange 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.2020-08-1111 min
Analir PisaniTotalling in Groups on Excel SpreadsheetsTo 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.auMicrosoft Office Training Specialist2020-08-0403 min
Analir PisaniWord Tools To Help You Read Like Break Up SyllablesMicrosoft 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...2020-07-2805 min
Analir PisaniChoose A Word Course levelDeciding 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 LinkedInAnalir Pisani - www.azsolutions.com.au...2020-07-2107 min
Analir PisaniChoose An Excel Course LevelDeciding 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 PisaniAnalir Pisani - www.azsolutions.com.au...2020-07-1411 min
Analir PisaniSearch Bar in Pivot Tables Microsoft ExcelPivot 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.Analir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-07-0501 min
Analir Pisani5 Tips to Reduce Your Inbox Stress in Microsoft OutlookStruggling 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-2608 min
Analir PisaniCross checking - Matching functions XLookup trumps Vlookup in Excel but there's a catchThere 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...2020-05-2008 min
Analir PisaniSave Time With Auto Fill Data in ExcelNeed 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 Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1801 min
Analir PisaniBasic Formatting Using WordChange 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.auMicrosoft Office Training Specialist2020-05-1801 min
Analir PisaniH20 SuperScript in Microsoft WordGetting 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.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1801 min
Analir PisaniBullets and Numbering Microsoft WordChange 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1802 min
Analir PisaniPowerPoint Design IdeasNo 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1803 min
Analir PisaniAlternatives to Bullet Points PowerPointAn alternative to Bullet Points is to use Smart Art. YouTube Analir Pisani. Sydney Australia. http;azsolutions.com.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1803 min
Analir PisaniDesign Ideas - Do's and Don't in PowerPointGet 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1813 min
Analir Pisani5 Good Reason to use Excel "Format As Table" Feature - More than pretty coloursMicrosoft 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.auAnalir Pisani - www.azsolutions.com.au2020-05-1403 min
Analir PisaniEfficient Alternatives to Hide and unhide in Excel SpreadsheetsInstead 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1405 min
Analir PisaniBasic Plus, Minus Divide in Microsoft Excel SheetsRules 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.auMicrosoft Office Training Specialist2020-05-1401 min
Analir PisaniRemove Duplicates in Excel SpreadsheetsNeed 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 AustraliaAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1401 min
Analir PisaniApply Same Formatting repeatedly Excel SpreadsheetYou 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.Analir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1401 min
Analir PisaniPercentages in Microsoft Excel SpreadsheetsThere 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.com.auMicrosoft Office Training Specialist2020-05-1401 min
Analir PisaniApply Filters in Microsoft Excel by Colour, Date groups and morePlaying 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1402 min
Analir PisaniKeep Zeros in front of Figure in Excel SpreadsheetsKeeping 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1401 min
Analir PisaniWiden Columns in Microsoft Excel SpreadsheetsWiden 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.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniSimple Budget using Microsoft ExcelTalk 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.au2020-05-1412 min
Analir PisaniTime Saving Tips in Navigating Excel SpreadsheetsWhen 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniUnderstand Why Your Formulas aren't Working - Show All Formulas in ExcelStruggling 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniMerge and Centre Excel Cells TogetherJoin 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniFill Formulas in Microsoft Excel without Dragging for 100 yearsYou 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniClear Formatting in ExcelDate 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.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1402 min
Analir PisaniZoom in ExcelNeed to see the data closer and bigger. Zoom into the Microsoft Excel spreadsheet with these techniques. Watch YouTube Analir Pisani or attend a Virtual Classroom unless you prefer Face to Face Customised Microsoft Office Lessons in Sydney, NSW Australia. http:/azsolutions.com.auAnalir Pisani - www.azsolutions.com.auMicrosoft Office Training Specialist2020-05-1400 min
Analir PisaniUse Excel XLOOKUP Function to Compare, Refine Lists and Generate Pivot Table ReportsThe XLookup overcomes the limitations of the Vlookup Function in Microsoft Excel Spreadsheets. With the XLookup you are not bound by the lookup value being located in the first column of the table, you can return the nearest highest value and more. YouTube Analir Pisani https://youtu.be/II3XXd2uNZ8Customised Computer Courses in Sydney, Australia and Virtual Classes. http:www.azsolutions.com.au🎓Offer Microsoft Office Training: Virtual and F2F Sydney, NSWhttp://www.azsolutions.com.auMonthly Microsoft Office Tips & Tricks - you don't want to miss...2020-05-0412 min