Analir Pisani: Recent Episodes
Analir Pisani
Microsoft Office Tips. Lessons on YouTube, Virtual Training Classes and Face to Face Customised courses Sydney, NSW Australia. www.azsolutions.com.au
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
info@azsolutions.com.au
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
Backup Google Chrome BookmarksBookmarks are exported as HTML File.
-
Three dots top right (more command)
-
Bookmarks>Bookmark Manager
-
Three dots top right
-
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
MS 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 & 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.au
MS 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 & 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.au
MS 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 & 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
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/
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 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/
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.
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, NSW
www.azsolutions.com.au
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 miss
www.azsolutions.com.au
Look out for Free Webinars
🎓
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/
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-9539a749
For 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
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.
🎓
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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
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 with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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
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 Exercises
YT: https://youtu.be/h_9cRrdY78g
https://azsolutions.com.au/how-to-microsoft-office
🎓
Offer Microsoft Office Training: Virtual and F2F Sydney, NSW
www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/
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.
🎓
Offer Microsoft Office Training: Virtual and F2F Sydney, NSW
http://www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/
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
http://www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/
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, NSW
http://www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/
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 LinkedIn
Microsoft 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 LinkedIn
YouTube 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 059
Subscribe 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.au
Subscribe 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.
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.
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
Change Case using Shortcut keys. YouTube Analir Pisani. http:azsolutions.com.au. Face to Face Microsoft Office Computer Courses 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
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.
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
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
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
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
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
Need 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.au
The 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/II3XXd2uNZ8
Customised Computer Courses in Sydney, Australia and Virtual Classes. http:www.azsolutions.com.au
🎓
Offer Microsoft Office Training: Virtual and F2F Sydney, NSW
http://www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For 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/