Загрузка...

Excel Text Surgery! Master LEFT, RIGHT, and MID | Day 37: 90-Day Mastery Expanded

Information is often hidden inside long, complex codes. Whether it’s a Ghana Card number, a Student ID, or a Bank Transaction reference, you need to know how to pull out specific details like birth years, region codes, or department tags without re-typing them.
In this 15-minute "Text Surgery" session, I’m teaching you how to use LEFT, RIGHT, and MID to dissect data with surgical precision. As a Chartered Data Analyst, I’ve seen how these three functions save hours of manual labor in Admissions, HR, and Finance departments.
What You Will Learn Today:
✅ The LEFT Function: Extracting categories from the start of a code (e.g., "STU" from "STU-100").
✅ The RIGHT Function: Pulling unique identifiers from the end of a string.
✅ The MID Function: The most powerful of the three! Learn to "reach into" the middle of a code to extract specific data like years or regions.
✅ Workplace Reality: How to handle 200+ records instantly using the 90-Day Excel Skills Mastery framework.
channel "About" section to get daily feedback on your assignments!
RESOURCES:
•Join our Learning Group: https://whatsapp.com/channel/0029Vb6gR3nDZ4LcspSiiT2z
•Download Practice Files: https://drive.google.com/drive/folders/1kYrx3XmjXyjXrO_itbwE7LN66g3gldhJ?usp=sharing
•Email: tech4uconcult.gh@gmail.com
About Your Facilitator: Samuel Krow Anim (CDA, MOS) is a professional Excel trainer and content creator dedicated to building a broader ecosystem of data literacy across Ghana and beyond.
#ExcelMastery #SamuelKrowAnim #TextFunctions #DataAnalytics #MicrosoftExcel #GhanaDataAnalyst #90DayChallenge

Видео Excel Text Surgery! Master LEFT, RIGHT, and MID | Day 37: 90-Day Mastery Expanded канала Tech4U-Gh Consulting _ Samuel Krow Anim
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять