Simon Sez IT
🌟 Welcome to our channel! 🚀 Get ready for a software training extravaganza brought to you by Simon Sez IT! 🤓
At Simon Sez IT, we're not just "IT"ching to help you succeed in Information Technology; we're thrilled about it! 😄💻 We've got an impressive collection of 200 training courses with over 10,000 training videos! 📚📹
But wait, there's more! 🎉 We keep the learning party going with new software training tutorials dropping every Tuesday, Wednesday, and Thursday! 📆🔥
These videos are just a tasty appetizer to the banquet of knowledge we serve up at www.SimonSezIT.com! 🍽️💡
At Simon Sez IT, we're about making software mastery easy and affordable! Our straightforward instructions will help you conquer various software skills, making you a pro in no time! 🚀💪
So why wait? Join the Simon Sez IT fun train, and let's level up your IT skills together! 🚂💼🌟
Simon Sez IT
🌿 We're halfway through May—how’s your learning journey going? Keep building momentum with this week’s must-watch tutorials! 💡📚
5 days ago | [YT] | 39
View 4 replies
Simon Sez IT
🕑 Quiz time: In cell A2, you have this invoice format: "Order ID: 45678 | Product: Monitor | Status: Shipped"
Your manager provided you with an existing formula. What value will this formula return?
=MID(A2, FIND("Product:", A2) + 8, FIND("|", A2, FIND("Product:", A2)) - FIND("Product:", A2) - 9)
1 week ago | [YT] | 23
View 0 replies
Simon Sez IT
🌼 New month, new mindset! What will you master this May? Start strong with this week’s lineup of tutorials—your next skill upgrade starts here! 🚀
1 week ago | [YT] | 47
View 0 replies
Simon Sez IT
🕑 Quiz time: You are reviewing whether an employee qualifies for a special assignment. In your Excel sheet, cell A2 contains the employee’s performance score, which must be 90 or higher. Cell B2 contains their certification status, which must be exactly "Certified", and cell C2 shows the number of late days, which must be less than 3. The employee is considered qualified only if all three of these conditions are met. Which formula correctly returns "Qualified" if all conditions are met?
2 weeks ago | [YT] | 42
View 6 replies
Simon Sez IT
🌟 Wrapping up April and stepping into May! What’s one skill you want to sharpen? Keep your momentum strong with this week's fresh tutorials! 🚀
2 weeks ago | [YT] | 51
View 3 replies
Simon Sez IT
🕑 Quiz time: In cell A2, you have the messy string " @MaRy - LOU ". It contains extra spaces, a special character (@), a dash separating the first and last name, and inconsistent capitalization. Your goal is to clean the text and return a properly formatted full name: Mary Lou.
Question: Which formula correctly cleans and formats the name?
3 weeks ago | [YT] | 28
View 3 replies
Simon Sez IT
☀️ A brand-new week, a brand-new chance to grow! Ready to pick up something new? Check out this week's tutorials and keep your progress going strong! 📘✨
3 weeks ago | [YT] | 57
View 5 replies
Simon Sez IT
🕑 Quiz time: If we have the following string, Red-Green-Blue in cell A3, what would the formula below extract?=LEFT(A3,FIND(“-“,A3)
1 month ago | [YT] | 24
View 7 replies
Simon Sez IT
🌸 We’re already halfway through April—how’s your learning going? Keep the momentum going with this week’s tutorial lineup. New skills, daily! 🚀
1 month ago | [YT] | 49
View 0 replies
Simon Sez IT
🕑 Quiz time: You are tasked with finding the email addresses associated with specific customer IDs from an Excel database. The database contains Customer IDs in column A and Email Addresses in column B.
Question: How should you use INDEX and MATCH to retrieve email addresses for a given customer ID in cell F1 and handle cases where the ID does not exist?
1 month ago | [YT] | 36
View 2 replies
Load more