Learners Galaxy
755 followers
- Report this post
𝐃𝐚𝐲 𝟏𝟐!XLOOKUP: The Ultimate Excel Function for Versatile Vertical and Horizontal Data Lookups.#ExcelTips #DataLookup #XLOOKUP #ExcelFunctions #DataAnalysis #Productivity #SpreadsheetSkills #DataManagement #ExcelMastery #TechSkills #LearnersGalaxyBy Ashish Uniyal
5
Transcript
Hello learners. Welcome back to Learners Galaxy. It's day 12 and today we will explore X Lookup, a versatile function in Excel that's even more powerful than VLOOKUP and H lookup. X Lookup allows you to search both vertically and horizontally, making it the goto function for modern data lookup needs. So today's target is understanding X Lookup. So let's jump into it. So unlike VLOOKUP and. Let's look up X lookup Looks value in any column or row and return the result from another range. No need to worry about data being in the first column or row. X lookup is flexible and simple to use. So let us first understand the syntax of X lookup. First is lookup value, the value you want to search for. After that the lookup array. The range where Excel will look for the lookup value. After that the return array. The range from where Excel will return a corresponding value next is if not found. It is optional. Here we can put a value to return if the lookup value is not found. Next is match mode. It is also optional. Here we can put zero for exact match which is default. After that we can put one for exact match or next smaller item. After that we one for exact match or next larger item. Next is search mode which is also optional. Here one is default which search from first to last. Then one search from last to 1st to is a binary search in ascending order and two is binary search in descending order. So let's say we want to find the stock quantity of product ID P-102. We can use X lookup to search for. Into in the product ID column and return the stock value from the stock column. To do that we have to put the formula equal to X looker then the value we are searching. After that the range and then the range from where Excel will return the matching result. So as you can see, we got our result. Now what if the value isn't found? With X lookup, we can specify a custom message for missing values. To do that, let's change the product ID from P-102 to 106 and add the last. We will put not found. So as you can see, we got not found because the product ID isn't in the list. So that's all for today. We will meet in our next video with another topic. Thank you.
To view or add a comment, sign in
More Relevant Posts
-
Learners Galaxy
755 followers
- Report this post
Transform your career with our Next Gen AI Pro Certification!Perfect for aspiring AI developers, software engineers, and tech innovators!Course Highlights:- Demystify GenAI and Foundation Models- Master in-context learning and prompt engineering- Explore Retrieval-Augmented Generation (RAG)- Implement LLM agents and agentic patterns- Learn LangChain, LlamaIndex, and other cutting-edge frameworks- Deploy AI applications using Flask, Streamlit, and cloud platformsCourse also covers:- Machine Learning Fundamentals- Deep Learning and advanced Natural Language Processing- Transform from AI novice to confident GenAI developer in just 5-6 months! Enroll now and shape the future of AI!- Program Duration: 88 hoursDon’t miss out! Limited seats only! Secure your spot today and be part of the Generative AI revolution!Click the link below to enroll:https://lnkd.in/gTpaU8SfFor more information:Call: +91 8532025435Email: connect@learnersgalaxy.ai
"𝐍𝐄𝐗𝐓 𝐆𝐄𝐍 𝐀𝐈 𝐏𝐑𝐎" certification course!
18
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
OpenAI's GPT-4 token prices have dropped 79% annually, now costing $4 per million tokens, down from $36 at launch in March 2023.Open-source models like Llama 3.1 and hardware innovations from companies such as Groq, Samba Nova, and Cerebras are driving rapid price reductions in the AI token market.Falling token prices make it feasible to build applications with high token usage, including agentic workloads, as they may become economically viable in the near future.At current rates ($4/million tokens), an application using 100 tokens per second would cost only $1.44/hour, significantly less than minimum wage in many countries.AI companies should focus on building useful applications rather than over-optimizing for current token costs, consider deploying marginally expensive applications in anticipation of lower future prices, and regularly evaluate new models for potential cost savings or increased capabilities.
1
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 𝐀𝐮𝐫𝐚𝐅𝐚𝐜𝐞: 𝐎𝐩𝐞𝐧-𝐒𝐨𝐮𝐫𝐜𝐞 𝐅𝐚𝐜𝐞 𝐑𝐞𝐜𝐨𝐠𝐧𝐢𝐭𝐢𝐨𝐧 𝐛𝐲 𝐇𝐮𝐠𝐠𝐢𝐧𝐠 𝐅𝐚𝐜𝐞Hugging Face has unveiled AuraFace, an open-source face recognition model designed for commercial use. Here’s what makes it stand out:🌐 Open-Source & Commercially Usable: Unlike other models, AuraFace is free from usage restrictions.📈 High Performance: Based on the ArcFace model, AuraFace delivers strong results, even with a smaller training dataset.🛡️ Identity Preservation: AuraFace IP-Adapter ensures consistent identity in image generation, perfect for avatars and digital content.🌍 Community-Driven: Hugging Face is calling for collaboration to enhance the model’s dataset, focusing on improving accuracy across diverse ethnicities.🛠️ Easy Integration: Available on Hugging Face, ready to be integrated into your projects.Read more at Hugging Facehttps://lnkd.in/eRdmxPSZ#AI #FaceRecognition #OpenSource #MachineLearning #AuraFace #HuggingFace #LearnersGalaxy
2
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
Revolutionizing Gaming: Introducing GameNGenThrilled to share a groundbreaking advancement in game technology: GameNGen, the world's first neural model-powered game engine. This innovative platform marks a significant milestone in real-time interaction within complex digital environments.Key features of GameNGen include:Exceptional Performance: Simulates the iconic DOOM at 20+ frames per second on a single TPUSuperior Visual Quality: Next-frame prediction boasts a PSNR of 29.4, rivaling lossy JPEG compressionUnparalleled Realism: In blind tests, human evaluators struggled to differentiate between actual gameplay and GameNGen simulationsThe development of GameNGen involved a sophisticated two-stage process:Training an RL agent to master gameplay, capturing these sessions for analysisUtilizing a diffusion model to generate subsequent frames based on historical data and player actionsThrough advanced conditioning techniques, GameNGen ensures consistent, high-fidelity auto-regressive generation throughout extended gaming sessions.This technology is poised to transform the gaming landscape. We're eager to see how developers and players alike will embrace this new frontier. What potential applications do you envision for GameNGen? Share your thoughts below!Check this link: https://lnkd.in/gXZFAktDhttps://lnkd.in/ggPUz_vi#GamingInnovation #AITechnology #FutureOfGaming #MachineLearning
GameNGen https://www.youtube.com/
3
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
𝐃𝐚𝐲 𝟏𝟏!HLOOKUP helps you find information across rows. If your data is structured horizontally, HLOOKUP will quickly locate the values you need. Let's dive in and see how this function can streamline your workflow!#ExcelTips #HLOOKUP #DataAnalysis #ExcelFunctions #SpreadsheetSkills #ExcelForBeginners #LearnersGalaxy #DataRetrieval #LearnExcel #ExcelMasteryBy Ashish Uniyal
5
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
💻 When you dig deeper into the world of AI... 🤖We often talk about the complexity of AI and Machine Learning, but at its essence, it often comes down to basic statistics and a bunch of "if" statements. 😂While AI and ML are transforming industries, it's crucial to remember the foundational principles powering these advancements.#ArtificialIntelligence #MachineLearning #AI #ML #DataScience #Technology #Innovation #TechTrends #AIInBusiness #FutureOfWork #Statistics #Programming #TechCommunity #AIRevolution #LearnersGalaxy #AITraining
3
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
Wishing you a joyful and blessed Janmashtami from Learners Galaxy! 🌼🙏May the divine blessings of Lord Krishna inspire you to learn, grow, and achieve all your aspirations. 🌠Let's celebrate the spirit of learning and growth, inspired by the wisdom and perseverance of Lord Krishna. 🌟#HappyJanmashtami #LearnersGalaxy #DreamChasers #AI #DataScience #MachineLearning #Innovation #Janmashtami2024 #GrowthMindset
15
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
"𝗙𝗶𝗻𝗮𝗹_𝗙𝗶𝗻𝗮𝗹_𝗩𝗲𝗿𝘀𝗶𝗼𝗻_𝘃𝟵𝟵𝟵𝟵_𝗙𝗜𝗡𝗔𝗟_𝗧𝗛𝗜𝗦_𝗧𝗜𝗠𝗘_𝗙𝗢𝗥_𝗥𝗘𝗔𝗟.𝗱𝗼𝗰𝘅" 😫📂#DataScience #AnalyticsLife #DataStruggles #DataAnalystProblems #ReportRevisions #FinalVersion #DataChallenges #ExcelLife #AI #DataVisualization #LearnersGalaxy
4
Like CommentTo view or add a comment, sign in
-
Learners Galaxy
755 followers
- Report this post
Data analytics reality: 90% of your work involves cleaning data, while 10% is dedicated to insights. Here’s how to tackle the daily cleaning grind:➡ Upgrade Your Tools: Automate tasks, use Regex, and leverage libraries like Pandas and NumPy.➡Develop a Process: Standardize, document, and use version control.➡Stay Curious: Question your data, explore patterns, and collaborate.➡Celebrate Wins: Track progress, share your successes, and improve efficiency.#DataCleaning #DataAnalytics #Automation #Python #Pandas #NumPy #DataScience #DataQuality #DataTools #AI #LearnersGalaxy
5
Like CommentTo view or add a comment, sign in
755 followers
View Profile
FollowExplore topics
- Sales
- Marketing
- IT Services
- Business Administration
- HR Management
- Engineering
- Soft Skills
- See All