Look Ups in Excel
We all use Excel, and searching for data from another sheet or Excel file is unavoidable. This is where you begin to become an advanced...
top of page
SOLVE THAT QUERY STQ
Welcome to Solve that Query - STQ, my very own way of working on tools. Explore my site and all that I have to offer; perhaps Solve that Query - STQ will help you to understand or simplify your work as well.
 |  |  |
|---|---|---|
 |
Home: Welcome
Search
Dynamic Drop-down List - Stop scrolling to search for options in the list.
No more scrolling through 100 of options in data validation drop down.
Say No To Standard Comments Inside A Formula!
Have you ever used a formula in excel to give a standard comment! If yes then you must have noticed that the formula becomes too bulky...
How to reconcile two data sets (One is subset or copy of another)
Are you still spending lot of time comparing the data in multiple columns in two data sets? Do you need a quicker way to validate the...
Using Multiple Columns to Sort Matrix in Power BI
So one of the majorly faced issue while using Power BI matrix visual is the sorting, as matrix only allows sorting by one column, so how...
Index & Match - a better alternative to VLOOKUP
Index and match are two different function in excel, and both have different and limited uses. However, together they create a function...
Which & how to use SUM functions in MS Excel
MS Excel is a powerful and one of the most extensively used tool in any professional job. This blog covers the different types of SUMs...
Home: Blog2
Home: Subscribe
Home: Contact
bottom of page