Verdexes
Hello Excel Fanatics! Here to help you become Instantly More Effective With Excel:
This channel has 100+ videos on Microsoft Excel spreadsheet tutorials, functions and tips - Vlookup, Sumifs, pivot tables, you name it. All the tools you need to make those data-driven decisions.
Origin: Did you know, in geometry, a vertex (or vertexes) is/are a point where two or more curves, lines, or edges meet? Well, a pleasure to meet you and welcome to Verdexes - Happy Learning!
If you buy from the Verdexes Merch Store, know that 25% of profits go towards the Wounded Warrior Project
If this sounds like something you fancy, subscribe and become a Fanatic!
#exceltips #excelpractice #exceltutorial #spreadsheets #excelfunctions #msexcel #excelformulas
Verdexes
You have a list of dates in column A.
You want to flag all dates that fall in the new year (2026) with the text "New Year" and all others as "Prior Year".
Which formula should you use in cell B2?
#excelhelp #exceltrivia #spreadsheets
1 month ago | [YT] | 1
View 0 replies
Verdexes
1 month ago | [YT] | 1
View 0 replies
Verdexes
You have a list of dates in column A.
You want to return today’s date and automatically update it every time the file is opened.
Which formula should you use?
#excelquiz #excelhelp #interviewquestions
1 month ago | [YT] | 1
View 0 replies
Verdexes
You have a list of sales amounts in column B.
You want to calculate the total sales for values greater than 5,000.
Which formula correctly does this?
1 month ago | [YT] | 1
View 0 replies
Verdexes
Which formula should you use? You have a dataset where:
Column A = Employee ID
Column B = Department
Column C = Salary
You need to return the average salary for the department entered in cell E2.
#excelhelp #spreadsheets #excelquiz
2 months ago | [YT] | 1
View 0 replies
Verdexes
You have numbers in column B (cells B2:B20) - You want to count how many of those numbers are greater than 50.
Which formula should you use?
#excelquiz #excelhelp #spreadsheets
2 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of product names in column A and you want to convert all names to UPPERCASE in column B
#excelhelp #excelquiz
2 months ago | [YT] | 1
View 0 replies
Verdexes
You have a start date in cell A2 and an end date in cell B2 - You want to calculate the number of complete months between the two dates.
Which formula should you use?
#excelhelp #excelquiz
2 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of full names in column A (e.g., John Smith).
You want to extract just the first name into column B.
#excelhelp #excelquiz
3 months ago | [YT] | 1
View 0 replies
Verdexes
You have employee IDs in column A, names in column B, and departments in column C. You want to find the department for the employee whose ID is entered in cell E2.
Which formula should you choose?
#excelquiz #exceltips #excelhelp
3 months ago | [YT] | 1
View 0 replies
Load more