How to use UPPER Function/Formula in Excel?

Professional's Legacy · Intermediate ·💰 FinTech & AI for Finance Professionals ·4mo ago

Key Takeaways

The video demonstrates how to use the UPPER function/formula in Excel to convert text to uppercase, specifically for formatting employee names in a dataset.

Full Transcript

Like here I have given data of some employees. His sales amount is given. Now what I want to do is see that the name of the employees is written as Hamza Malik Saad Qureshi, it is written in the lower [sound of clearing throat] case. I wish I could write these in upper case. So what do we have to do for that ? First of all you have to select your cell. Normally we should not do this that here we have to write Saheb Ali like this. No, it will take us a lot of time. So for this we use Fula. Pressed the upper tab of the upper. Now here we will select our text. We have selected all the names that we had to select by holding down the shift control. I will close my bracket. If we enter, he has given us all the names written here in upper case. Like Sahab Ali, Mohammad Ali, Hasan Sheikh. So this is how we use the upper formula.

Original Description

Professional’s Legacy is a platform which provides following services: 1. For Professional Trainings Fill this form: https://forms.gle/e8CFWLrppCpNNrTQ6 Trainings Include: - Data Analysis with Excel - Preparation of Financial Statements - Audit of Financial Statements - Financial Modeling & Valuation Analysis - Financial Reporting & Analysis with PowerBi - Income Tax Pakistan - Sales Tax Pakistan - Accounting Software - Value Added Tax for Gulf Countries - Freelancing Master-Class 2. For Career Guidance or meeting Fill this Form: https://forms.gle/m4cENmdZHKgLDkF37 Contact: - Admin: +92300-0855025 WhatsApp Only - Email us: info@professionallegacy.org - Website: Professionallegacy.org Disclaimer: Our platform does not intend to exploit society and complies with all government/entity/public or private organization and individual rules and regulations. We provide our views for educational purposes only, and all decisions remain in the audience/viewer's hands.
☆ Save to playlist Watch on YouTube ↗
Sign in to unlock AI tutor explanation · ⚡30

The video teaches how to use the UPPER function in Excel to convert text to uppercase, which is useful for formatting employee names and other text data in financial analysis. This skill is essential for data analysis and financial reporting.

Key Takeaways
  1. Select the cell containing the text to be converted
  2. Press the formula tab in Excel
  3. Select the UPPER function
  4. Enter the text range to be converted
  5. Press enter to apply the formula
💡 The UPPER function in Excel can save time and effort in formatting text data, especially when working with large datasets.

Related Reads

📰
Kenyan fintech Payd to resume services after FX losses disrupt customer payouts
Kenyan fintech Payd to resume services after resolving FX losses issues, learn how to handle similar disruptions in your fintech business
TechCabal
 📰
SAP FICO Training: How to Build a Career in SAP Finance
Learn how SAP FICO training can kickstart a career in SAP Finance and ERP, enabling professionals to manage financial transactions and processes
Dev.to AI
 📰
Francophone Africa’s fintech boom solved access, not financial inclusion
Fintechs in Francophone Africa have increased access to financial services, but still struggle with true financial inclusion, highlighting a new battle for control of financial infrastructure
TechCabal
 📰
Fintech Innovation 2026: Essential Portfolio Access
Fintech innovation expands market access to professional portfolio management for individual investors, enabling them to use institutional techniques like factor diversification and risk-constrained optimization
Dev.to AI
Up next
XRP Price: What Ripple's Legal Win REALLY Means #shorts
Martyn Lucas INVESTOR
Watch →