Back

If you still use VLOOKUP... you're suffering for no reason Had this classic moment: "Why did my lookup change after I inserted a column?" 😭 That's why I stopped using VLOOKUP for most things. ✅ XLOOKUP doesn't care if columns shift ✅ It can retu

How can you quickly insert a new row or column in Excel using a shortcut? A) Ctrl + Alt + N B) Ctrl + Shift + "+" C) Shift + Enter #excel #dataanalyst #dataanalytics ##dataanalysis #googlesheets

What is the most efficient way to combine text from multiple cells into one cell without using the CONCATENATE function? A) Using the TEXTJOIN function B) Using the LEFT function C) Using the SUBSTITUTE function #excel #msexcel #dataanalyst #dataan

How do you open the "Go To" dialog box in Excel? #excel #data #dataanalyst #dataanalytics #msexcel #googlesheets

Day 2 of learning mathematics for AI/ML as a no math person. Topic: vectors and matrices. We use NumPy python library for these. I got introduced to the concept of vectors and matrices. Vectors are like lists and are divided Vectors are divided in

Day 2 of learning mathematics for AI/ML as a no math person. Topic: vectors and matrices. We use NumPy python library for these. I got introduced to the concept of vectors and matrices. Vectors are like lists and are divided Vectors are divided in

Which feature allows you yo Freeze both the top row and the first column simultaneously in excel? #data #dataanalytics #dataanalysis ##googlesheets

How do you quickly apply the AutoSum function to a range of cells? A) Alt + A B) Alt + "=" C) Ctrl + Shift + S #excel #dataanalyst #dataanalytics #data #dataanalysis

Which function can be used to combine text from different cells into one cell without using the CONCATENATE function? A) TEXTJOIN B) CONCAT C) JOIN #excel #dataanalyst #data #dataanalysis #dataanalytics

Which function allows you to count the number of cells that meet a specific condition? #excel #msexcel #data #dataanalytics #googlesheets #functions