XelPlus

𝗟𝗲𝗮𝗿𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗳𝗼𝗿 𝗙𝗿𝗲𝗲 - 𝗵𝗲𝗿𝗲'𝘀 𝗵𝗼𝘄 👇 We have an exciting opportunity for Power BI newbies: A FREE Power BI QuickStart Course ➡️ https://lnkd.in/dDamzStc As you might have noticed by looking through our profile, we love celebrating the achievements of our "Fast Track to Power BI" learners. Your success inspires us everyday! 🤔 Curious About Power BI? We understand diving into a full Power BI course can be overwhelming. Maybe Power BI isn't the right skill for you to learn right now. But if you don't try, you don't know - right? That's why we've put together a QuickStart Power BI course that's not just easy - it's FREE! And it only takes 1 hour of your time. No more excuses! The free course is available for a limited time. Take this opportunity to dive into Power BI. Also please share this post with anyone who could benefit from learning this skill. #powerbi #learnpowerbi #freecourse

𝗘𝘃𝗲𝗿 𝘀𝗲𝗲𝗻 𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗶𝗻 𝗮 𝘁𝘂𝘁𝗼𝗿𝗶𝗮𝗹 𝗼𝗻𝗹𝘆 𝘁𝗼 𝗼𝗽𝗲𝗻 𝘆𝗼𝘂𝗿 𝗘𝘅𝗰𝗲𝗹 𝗮𝗻𝗱 𝗳𝗶𝗻𝗱 𝗶𝘁 𝗺𝗶𝘀𝘀𝗶𝗻𝗴? 😕 This is a common issue. Microsoft adds new functions and features only to Microsoft 365, the subscription version of Excel. But even with Microsoft 365, you might not see new features right away. It depends on your update channel: Current, Monthly, or Semi-Annual. Our article explains everything about Excel versions, update channels, and the Microsoft 365 Insider Program. Understand when you'll get the latest features and stay ahead. 📢 Read the full article and download the Cheat Sheet for a handy one-page PDF summary 👉 https://lnkd.in/d7a6NuNp #Excel #Microsoft365 #ExcelUpdates #Productivity #TechTips

𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗖𝗔𝗚𝗥 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹 𝗘𝗮𝘀𝗶𝗹𝘆! 📊 Learn how to calculate the Compound Annual Growth Rate (CAGR) in Excel with our easy guide. Understand the true growth of your investments quickly and effectively. 🔍 What You'll Learn: ⩥ What is CAGR? A simple explanation. ⩥ Why use CAGR? Discover its benefits. ⩥ How to calculate CAGR in Excel with step-by-step instructions. ⩥ CAGR vs. AAGR: Know the difference. ⩥ Practical Examples: Apply what you learn. This guide is perfect for finance professionals, freelancers, and anyone managing investments. Plus, download our free workbook to practice and enhance your skills here 👉 https://lnkd.in/dnjtdVQx #Excel #CAGR #Investment #FinancialAnalysis #DownloadNow

𝗖𝗼𝗺𝗶𝗻𝗴 𝘁𝗼 𝗘𝘅𝗰𝗲𝗹: 𝗣𝘆𝘁𝗵𝗼𝗻 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻! 🐍 Excel now includes Python, a powerful tool for data analysis and automation. Currently in Beta for Microsoft 365 Office Insider users, this feature is a big step for anyone working with data. With Python in Excel, you can: ⩥ Automate repetitive tasks. ⩥ Analyze large datasets quickly. ⩥ Create custom visualizations easily. Python in Excel comes with essential libraries like pandas for data manipulation and NumPy for numerical operations. You can also use many other Python libraries to handle specific tasks, such as using Regex for complex data extraction. This integration combines the power of Python with Excel’s familiar interface, making data analysis more efficient. Perfect for corporate professionals and freelancers looking to streamline their workflow. 📥 Read the blog post and download the practice file to follow along with hands-on examples and start exploring Python in Excel today 👉 https://lnkd.in/gF-9iET5 #PythonInExcel #DataAnalysis #ExcelTips #Python

BIG NEWS! Microsoft Excel just got a huge upgrade with new REGEX functions! 🎉 Think REGEX is just for the pros? Think again! 😲 In the video 👇 I show you how ANYONE can use these powerful new functions. (I took a shortcut, some might call it cheating - but it's our reality now) 🔍 Here's what you'll learn: - Grab email addresses from long text - even multiple ones. - Get website addresses - even messy ones from long text. - Extract dates hidden in text. - Clean up text by removing special characters. - Format numbers for readability - like phone or credit card numbers. - Remove those annoying leading zeros. - Break up words that are stuck together. - Extract data inside brackets. Watch the video and get ready for the time when these functions become available in your Office 365 version. They are currently in the beta version in Excel Insiders. #ExcelTips #Excel #MicrosoftExcel #Regex https://lnkd.in/d_3mxYF7

🤔 Thinking VLOOKUP is dead now that we have XLOOKUP?   no no! VLOOKUP is still used across thousands of spreadsheets. Thousands of reports still rely on VLOOKUP. It works in ANY version of Excel. It's important to understand how it works and what you need to watch out for. That's what today's tutorial is about: we're going back to basics.   I break down the VLOOKUP requirements and take you through multiple examples. You'll learn how to:   1️⃣ Make sure VLOOKUP returns the correct result 2️⃣ Lookup values on another sheet 3️⃣ Quickly find and return the closest values 4️⃣ Avoid and correct common errors like #NA    If your colleagues struggle with VLOOKUP, share this video with them.   And if you think you're a VLOOKUP expert, then jump to minute 9:10 of the video and check if you can figure out how to correct the formulas. Let me know how you do. https://lnkd.in/dKwmWKDi #msexcel #excel #microsoft365

Just had to share this! Love seeing this kind of growth. Paul, a seasoned business consultant, had an "aha" moment during our Excel Business Charts course. He thought he had charts all figured out, but realized there's a whole new level to explore. 🔎 It's not just about better charts; it’s about seeing things in a new way. Thanks for letting us be part of your journey, Paul! What about you? Have you ever had one of those moments where everything just clicks? Would love to hear about it!

If you feel frustrated by working with Excel charts and graphs... Or if you struggle to keep your skills up-to-date because Excel is always changing... Or maybe you know there’s a better way to show your data. But, you aren’t sure how to do it....   You need our new course, 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗖𝗵𝗮𝗿𝘁𝘀 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹  https://lnkd.in/dk4K_pzf 👉 Save 20% if you join the course before April 23. PLUS grab your special launch bonus Waterfall chart Excel templates. Apply the coupon code LINKEDIN on the checkout page. Excited to see you in the course! #excel #course #exceltips #datavisualization

How long do you think it will take you to make the McKinsey chart you see below? If it's anything longer than 90 seconds then you need to watch the video. This technique might just become your new go-to for impressive business reports. 𝗙𝘂𝗻 𝗳𝗮𝗰𝘁: The whole thing is created with an Excel Function. No charts were involved 🤯! It will look like a chart to everyone else, but only you'll know what it really is. Plus this method is fast, it’s flexible, and yes, it's fun! You can tweak it to your style. And finally break free of default Excel charts with this function. Let me know what you think. #excel #exceltrick #exelhack #corporatelife https://lnkd.in/gDGSqxwJ

I'm excited to share that my new course just launched 🎊 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗖𝗵𝗮𝗿𝘁𝘀 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹 teaches you to create charts that get noticed! Visuals that are as clear and engaging as those from The Economist or McKinsey. You'll get the skills to: ☑️ 𝗪𝗼𝘄 𝘆𝗼𝘂𝗿 𝗺𝗮𝗻𝗮𝗴𝗲𝗿𝘀: Create standout Excel charts that get noticed. Like those you admire from The Economist & McKinsey. (We've included templates for you too if you need to deliver fast results) ☑️ 𝗦𝗮𝘃𝗲 𝗮 𝘁𝗼𝗻 𝗼𝗳 𝘁𝗶𝗺𝗲: Learn to create responsive charts that auto-update. You might just discover some advanced formula combos to add to your existing reports. ☑️ 𝗚𝗲𝘁 𝗮𝗵𝗲𝗮𝗱: Finish the course, earn a digital badge, and add it to your LinkedIn profile. People who keep learning are more likely to get promotions. Creating professional looking charts in Excel SHOULD be easy! That's why I made this course. 🥳 And to celebrate there's a special launch discount - only until April 23. Use coupon code LINKEDIN on the checkout page to apply it. There is also another special bonus that will go away after April 23rd. More info on that is on the course page: 👉 https://lnkd.in/gmvu8pD2 Thank you for being the driving force behind this course. For inspiring me to create and share ❤️ I can't wait to see what you'll achieve with this course. #excel #charts #datavisualization #corporatelife