#6 - The Sheet 📃
Free 1:1 Masterclass competition
Hey Friends,
Welcome back to The Sheet, your go-to resource for all things Excel! We're excited to bring you another edition packed with valuable tips, insightful recommendations, and an exciting opportunity. Let's dive in!
📋 Summary:
💡 The Sheet Tip: Text Formatting Made Easy. Learn how to use the TRIM and PROPER functions in Excel to clean up and format your text effortlessly.
📚 What We're Reading: "Atomic Habits" by James Clear. Discover the power of building small habits that lead to remarkable results.
📣 Exciting News: Masterclass Competition and Free Cheatsheet. Get a chance to win a free 30-minute masterclass session with a member of the Functional Excel team! Plus, grab our free ‘cheatsheet’ featuring Functional Excel's "most used" shortcuts.
=💡 The Sheet Tip (Text Formatting Made Easy)
Have you ever encountered messy data with extra spaces or improperly capitalised names? Well, fret no more! We have a solution for you. This week, we'll explore how to use the TRIM and PROPER functions in Excel to clean up and format your text effortlessly.
Step-by-Step Guide:
Open your Excel worksheet and locate the cell containing the messy text, such as " JUstINe FAVor ".
To remove excess spaces, use the TRIM function. In a new cell, enter the following formula: =TRIM(A2) (Assuming the name is in cell A2)
Press Enter to see the trimmed text. The formula will remove leading, trailing, and excessive spaces, resulting in "JUstINe FAVor".
Next, let's use the PROPER function to convert the text to ‘proper case’. In another cell, enter the formula: =PROPER(B2) (Assuming the trimmed name is in cell B2)
Press Enter to apply the formula and witness the transformation. The PROPER function will capitalise the first letter of each word, giving us the desired result: "Justine Favor".
By utilising the TRIM and PROPER functions, you can quickly fix and format messy text in Excel, ensuring consistent and professional data presentation.
=📚 What We're Reading: "Atomic Habits" by James Clear
In our quest for personal and professional growth, building effective habits plays a crucial role. That's why we're diving into "Atomic Habits" by James Clear, a game-changing book that reveals the power of small habits and their compounding impact on success.
"Atomic Habits" offers practical strategies and actionable insights to help you transform your habits and achieve remarkable results. Discover the science behind habit formation, learn how to break bad habits, and cultivate positive behaviors that align with your goals.
Whether you want to improve your Excel skills, boost productivity, or enhance your personal life, "Atomic Habits" provides a roadmap to success.
🖇️Amazon link [Not an affiliate link]
📣 Exciting News: Masterclass Competition and Free Cheatsheet
We have some exciting news to share! We're offering five lucky readers of ‘The Sheet’ the chance to win a free 30-minute masterclass with a member of the Functional Excel team. These sessions will take place online and will be conducted in English. They are designed to help you build your Excel skills and achieve your professional or academic goals.
To participate, simply fill out our questionnaire. By doing so, you'll help us understand your current level of experience with Excel, your learning preferences, and the areas where you could use some extra support. We'll use this information to tailor our coaching services to meet your unique needs, so you can get the most value out of our one-on-one masterclass session.
But that's not all! As a bonus, we're also providing you a free ‘cheatsheet’ featuring Functional Excel's "most used" shortcuts. This handy resource will help you save time and work more efficiently in Excel.
Don't miss out on this exciting opportunity – fill out the questionnaire today for your chance to win!
Click here to fill in the questionnaire
That's it for this edition of The Sheet. We hope you found these insights valuable. Remember, you can always reach out to us with your questions, feedback, or suggestions. We're here to support you on your Excel journey.
If you found this useful, please consider sharing it with a friend or colleague!
Wishing you success and productivity,
The Functional Excel Team