Creating Email Id using Flash Fill in Excel by Pavan Lalwani | shorts
Creating Email Id using Flash Fill in Excel by Pavan Lalwani | shorts #shorts #exceltips
(In this video we'll see how to create an email ID of a person who has recently joined in the company and the information or the data what I have is just first name and the last name now the email ID can be into different formats for example if I just want to create an email ID for them so I'll just write as ** at the rate techno hls.com enter and control e using this method you can see all the email IDs are created but usually my manager is not happy with me always and he wants me to just modify the email ID so you want it as ** in the sense initial of the last name so I can just delete that everything and again I can type here as ** at the rate techno hls.com enter control e ** @ technoedgels.com and you see everywhere it has taken the initial of the last name and I've got the answer same way you can also type as a DOT try the rate company name.com enter and then press Ctrl E from a keyboard and you see it will understand the pattern and give it output.)
#businessintelligence, business intelligence, #pavanlalwani
Welcome to the world of data analysis and business intelligence! Whether you're a data analyst looking to sharpen your skills or a business professional looking to expand your knowledge, our online course led by Pavan Lalwani is the perfect choice. Learn everything from the basics of data analytics to advanced business intelligence techniques and take your career to the next level. Join our business intelligence online course and become a data analyst or a business intelligence analyst. Learn the latest trends and best practices of data analytics, business intelligence and data visualization on youtube with Pavan Lalwani, an expert in the field. Get ready to transform your data into actionable insights and make informed business decisions with our comprehensive business intelligence course.