MIS Support Junction
This is all about MIS Reporting and Analysis tools like - Excel, Adv. Excel, Macro, VBA - Automation, SQL and Power BI Tricks.
How to Answer Logical Interview Questions | IF, AND, OR | Nested IF | IF+AND
Data Sorting : The best way to Sort data in Excel | Sorting in Excel
Excel Logical Functions - IF, AND, OR | Nested IF | IF+AND | IF+OR
Left, Mid, Right Text Functions | LEFT | MID | RIGHT | Substitute | LEN Function in Excel
Text Function In Excel | Excel Text Function | Important Text Functions you *NEED* to know
COUNTIF and COUNTIFS Formula in excel | advanced excel tutorial #excel #exceltips #exceltutorial
Excel : Count Countif Countifs | Count Function | COUNTIF Function In HINDI
How to use TABLE FUNCTIONS in DAX // My Top Table Functions | Power Bi for beginner
Excel SumIF & SumIFs | SUMIF | SumIFs | SumIf in Excel | #MISSupportJunction
MIS & Reporting | Excel Sum Function | Tricks of SUM | #MISSupportJunction
VBA Filter | VBA Advanced Filter | Adv. Filter in Excel VBA | #MISSupportJunction
Paste Special in Excel | Paste Special Kya Hai | Power of Excel's Paste Special Feature
Time Intelligence Function - DateAdd | DatesMTD | DatesQTD | #MisSupportJunction
VBA Macro Filter | VBA Auto Filter | Auto Filter in Excel VBA | #MISSupportJunction
Time Intelligence Function | Opening & Closing Balance Power BI | #MisSupportJunction
Sum & Calculate Table, Calculate with KeepFilters in Power BI | DAX Tutorial
Summarize, Calculate Table, Calculate with All & AllExcept in Power BI | DAX Tutorial
SumX, CountX Vs Calculate with &&, IN, Operator in Power BI | DAX Tutorial
VBA code to Sort Data in Excel | Sorting in VBA | VBA sorting code | #MISSupportJunction
DAX Beginners - SUM Vs SUMX DAX in Power BI | Power BI DAX Tutorial
Bookmarks in Power BI | Bookmarks | Power BI Bookmark | Create Bookmark
Power BI Visuals Explained | Charts & Visualization | Chart Tutorial for Beginners
Filter on Visual in Power BI | Power BI Tutorial | Conditional columns
Power BI Tutorial for Beginners | Transforming Data with Power Query | Power Query | Power BI
Excel VBA | End xlup and end xldown using VBA | #MISSupportJunction
How to use Power Query Editor in Power BI | Power BI for Beginners | #MISSupportJunction
VBA.Inputbox Vs Application.Inputbox in Excel VBA | msgbox | sheet activation | #MISSupportJunction
Importing Data to Power BI | How to import excel data to power BI | #MISSupportJunction
Excel VBA to Combine Multiple Workbooks | VBA Project | #MISSupportJunction
Excel VBA Introduction | VBA Macro | VBA Vs Macro | #MISSupportJunction