Канал: Excel BI Analytics

Power Query - Find Uncommon between Two Lists

Power Query - Find Uncommon between Two Lists

Power Query - Remove blank rows and columns from your data

Power Query - Remove blank rows and columns from your data

Excel - Convert a Weekday Name to Number

Excel - Convert a Weekday Name to Number

Power BI - Multi Column Exact Match XLOOKUP / VLOOKUP in Power Query

Power BI - Multi Column Exact Match XLOOKUP / VLOOKUP in Power Query

Power BI - Exact Match XLOOKUP/VLOOKUP in Power Query

Power BI - Exact Match XLOOKUP/VLOOKUP in Power Query

Excel - Filter Text and Numbers from a Range

Excel - Filter Text and Numbers from a Range

Power BI - New DAX functions launched in 2022

Power BI - New DAX functions launched in 2022

Excel - Create Any Level of Dependent Drop Downs using Dynamic Arrays

Excel - Create Any Level of Dependent Drop Downs using Dynamic Arrays

Excel - Dynamic Chart with Drop Down Selection

Excel - Dynamic Chart with Drop Down Selection

Excel - Search As You Type

Excel - Search As You Type

Excel - Create In Cell Tornado Chart like Sparklines

Excel - Create In Cell Tornado Chart like Sparklines

Excel - How to calculate income tax, electricity bill based on slabs

Excel - How to calculate income tax, electricity bill based on slabs

Date.IsInQuarterToDate, Date.IsInMonthToDate and Date.IsInWeekToDate functions in Power Query

Date.IsInQuarterToDate, Date.IsInMonthToDate and Date.IsInWeekToDate functions in Power Query

Excel Quick Tip - Sort on the basis of alternate rows

Excel Quick Tip - Sort on the basis of alternate rows

SQL - Top 10 Free Online SQL Editors

SQL - Top 10 Free Online SQL Editors

Power Query - Make Text.ExcelTrim Function

Power Query - Make Text.ExcelTrim Function

Excel Quick Tip - Use F4 to insert / remove $ in your references

Excel Quick Tip - Use F4 to insert / remove $ in your references

Excel - Create Thermometer Chart

Excel - Create Thermometer Chart

Excel - Generate Abbreviations from give Words

Excel - Generate Abbreviations from give Words

Excel - Get the last non blank value in a range

Excel - Get the last non blank value in a range

Excel - Insert Sequence Numbers like 1st, 2nd....9th, 10th

Excel - Insert Sequence Numbers like 1st, 2nd....9th, 10th

Excel - Extract the last number in a range

Excel - Extract the last number in a range

Excel - Insert a Sequence Number or Index or Rank in a Pivot Table

Excel - Insert a Sequence Number or Index or Rank in a Pivot Table

Excel - Create a 5 Star Rating System for your Data

Excel - Create a 5 Star Rating System for your Data

Excel - Find the position of First & Last blank cell

Excel - Find the position of First & Last blank cell

Excel - SUM, AVERAGE, MAX & MIN without Writing Formulas

Excel - SUM, AVERAGE, MAX & MIN without Writing Formulas

Excel - Highlight Max & Min in your Data Simplified

Excel - Highlight Max & Min in your Data Simplified

Excel - Add a Target Line to a Bar Chart

Excel - Add a Target Line to a Bar Chart

Excel - Add a Target line in your Charts

Excel - Add a Target line in your Charts

Excel - Be Super Smart at Work, use SMART LOOKUP

Excel - Be Super Smart at Work, use SMART LOOKUP

Excel-Blazing fast way to convert text numbers into numeric numbers

Excel-Blazing fast way to convert text numbers into numeric numbers

Extract First and Last Name in a Super Fast Way - No Formula Required

Extract First and Last Name in a Super Fast Way - No Formula Required

Excel - Running Total and Percentage Total without Formulas

Excel - Running Total and Percentage Total without Formulas

Excel - Give Smilie Faces to Ratings in Dashboards / Reports

Excel - Give Smilie Faces to Ratings in Dashboards / Reports

Excel - How to Perform Multi Column VLookup/XLOOKUP

Excel - How to Perform Multi Column VLookup/XLOOKUP