5 Good Reason to use Excel "Format As Table" Feature - More than pretty colours

Analir Pisani

#Higher Education #Podcasting Education #Analir Pisani

1:16:55

On her son’s prom night, Mel Robbins fussed over details that didn’t matter. Her daughter grabbed her arm and said, “Let them. Let them run in the rain. Let them eat where they want. Let them.” Those two simple words hit Mel like a ton of bricks and completely changed how she thinks about control. In this episode, Mel shares some of the pivotal moments that shaped her career, her innovative strategies for overcoming adversity, and how the Let Them Theory can help you navigate business challenges, strengthen relationships, and unlock your true power. In this episode, Hala and Mel will discuss: (00:00) Introduction (02:57) The Power of Action (04:22) Mel's Unforgettable TED Talk Debut (07:00) The 5 Second Rule (07:52) Building Unshakable Confidence (12:04) Turning Adversity into Strength (22:00) The Power of Showing Up for Others (30:40) Why Details Matter in Business (42:32) Understanding the Let Them Theory (51:14) The Let Them Theory in Business Mel Robbins is a motivational speaker, the host of The Mel Robbins Podcast, and a bestselling author of several influential books, including her latest, The Let Them Theory. Known for her groundbreaking 5 Second Rule, she has helped millions of people take action and transform their lives. With 30 million views, her TEDx talk made her a recognized voice in behavior change. Mel is also the CEO of 143 Studios, a female-driven media company creating award-winning content for top brands like LinkedIn and Audible. She is a Forbes 50 Over 50 Honoree and one of USA Today’s Top 5 Mindset Coaches. Resources Mentioned: Mel’s Books: The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About : https://amzn.to/4h6quLh The 5 Second Rule: Transform your Life, Work, and Confidence with Everyday Courage : https://amzn.to/3WdAgTX Sponsored By: OpenPhone - Get 20% off 6 months at https://www.openphone.com/PROFITING Shopify - Sign up for a one-dollar-per-month trial period at https://www.youngandprofiting.co/shopify Airbnb - Your home might be worth more than you think. Find out how much at https://www.airbnb.com/host Rocket Money - Cancel your unwanted subscriptions and reach your financial goals faster with Rocket Money. Go to https://www.rocketmoney.com/profiting Indeed - Get a $75 job credit at indeed.com/profiting Active Deals - youngandprofiting.com/deals Key YAP Links Reviews - ratethispodcast.com/yap Youtube - youtube.com/c/YoungandProfiting LinkedIn - linkedin.com/in/htaha/ Instagram - instagram.com/yapwithhala/ Social + Podcast Services : yapmedia.com Transcripts - youngandprofiting.com/episodes-new All Show Keywords: Entrepreneurship, entrepreneurship podcast, Business, Business podcast, Self Improvement, Self-Improvement, Personal development, Starting a business, Strategy, Investing, Sales, Selling, Psychology, Productivity, Entrepreneurs, AI, Artificial Intelligence, Technology, Marketing, Negotiation, Money, Finance, Side hustle, Startup, mental health, Career, Leadership, Mindset, Health, Growth mindset. Career & Entrepreneurship Career, Success, Entrepreneurship, Productivity, Careers, Startup, Entrepreneurs, Business Ideas, Growth Hacks, Career Development, Money Management, Opportunities, Professionals, Workplace, Career podcast, Entrepreneurship podcast…

5年之前 3:41

MP3•单集首页

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

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

53集单集

5 Good Reason to use Excel "Format As Table" Feature - More than pretty colours

Analir Pisani

published 5年之前

MP3•单集首页

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

53集单集

#Higher Education #Podcasting Education #Analir Pisani

所有剧集

1
Power BI Data Driven Decisions 7:47

27 weeks之前7:47

7:47

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

1
Use Outlook Delivery Options To Your Benefit 2:42

33 weeks之前2:42

2:42

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

1
Pin Task, Run Simple Repairs and Customize Windows Workspace to Power Through your Work Today 6:46

48 weeks之前6:46

6:46

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…

1
Streamlining Spreadsheets Your Guide to Effective Excel Forms 2:23

2 years之前2:23

2:23

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

1
Unlocking Peace of Mind Safely Storing Chrome Bookmarks - A Podcast Tutorial 1:05

2 years之前1:05

1:05

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…

1
Mastering Outlook Templates with 3 Expert Tips 6:09

2 years之前6:09

6:09

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

1
5 Time Savers In Outlook Messages 5:52

2 years之前5:52

5:52

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 & Tricks https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545 🎓 Virtual Microsoft Office Courses https://azsolutions.com.au/virtual/ 👀 F2F Microsoft Office Courses https://azsolutions.com.au Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

1
Set Reminders in Outlook and More 8:09

2 years之前8:09

8:09

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 & Tricks https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545 🎓 Virtual Microsoft Office Courses https://azsolutions.com.au/virtual/ 👀 F2F Microsoft Office Courses https://azsolutions.com.au Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

1
How to Overcome Your Fear Of Technology 9:01

3 years之前9:01

9:01

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 & Tricks https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545 🎓 Virtual Microsoft Office Courses https://azsolutions.com.au/virtual/ 👀 F2F Microsoft Office Courses https://azsolutions.com.au Analir Pisani - www.azsolutions.com.au Microsoft Office Training Specialist…

1
Features You May Overlook In Microsoft Excel 16:26

3 years之前16:26

16:26

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

1
Understanding Microsoft OneNote 4:46

3 years之前4:46

4:46

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

1
What can you do to ease interruptions? 9:27

3 years之前9:27

9:27

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

1
Office 365 Explained 11:28

4 years之前11:28

11:28

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

1
F2F Virtual or Hybrid Microsoft Office Courses 20:46

4 years之前20:46

20:46

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

1
Working with Corporate Microsoft PowerPoint Template 4:29

4 years之前4:29