Канал: DSmart Exceller

CHARTS :X,Y Scatter with straight lines and markers

CHARTS :X,Y Scatter with straight lines and markers

CHARTS: Line with markers for selected data (PMP)

CHARTS: Line with markers for selected data (PMP)

CHARTS : Correlation types in excel graphs

CHARTS : Correlation types in excel graphs

CHARTS: Line Chart in two ways

CHARTS: Line Chart in two ways

Ratio Analysis : segregating partnership ratios

Ratio Analysis : segregating partnership ratios

Six Sigma-Anova Single factor to find F test

Six Sigma-Anova Single factor to find F test

R2 & regression analysis in excel

R2 & regression analysis in excel

Linear Regression: Calculate the point where x and y collide

Linear Regression: Calculate the point where x and y collide

Histogram: How to analyze data Histogram in Excel

Histogram: How to analyze data Histogram in Excel

Correlation: formula and Analysis tool pack usage

Correlation: formula and Analysis tool pack usage

Sumproduct: How to use and what is the use

Sumproduct: How to use and what is the use

Comparison without min qty on sheet and 3 variables

Comparison without min qty on sheet and 3 variables

Comparison for min amount on different columns

Comparison for min amount on different columns

Data entry restriction in cells -for template -vid 3

Data entry restriction in cells -for template -vid 3

Data entry restriction in cells -for template -vid 2

Data entry restriction in cells -for template -vid 2

Data entry restriction in cells -for template -vid 1

Data entry restriction in cells -for template -vid 1

Match or XMatch -The easy way to compile report from different sheets- vid 2

Match or XMatch -The easy way to compile report from different sheets- vid 2

Match or XMatch -The easy way to compile report from different sheets- vid 1

Match or XMatch -The easy way to compile report from different sheets- vid 1

Break Even Point :BEP How to get a break even Full Video -Vid 3

Break Even Point :BEP How to get a break even Full Video -Vid 3

Break Even Point :BEP How to get a break even -Vid 2

Break Even Point :BEP How to get a break even -Vid 2

Break Even Point (BEP) How to get a break even in Excel ? -Vid 1

Break Even Point (BEP) How to get a break even in Excel ? -Vid 1

Use of Subtotals and how to replace formats ?

Use of Subtotals and how to replace formats ?

Cond format :How to select whole row for single word inside two descriptions Vid 3

Cond format :How to select whole row for single word inside two descriptions Vid 3

Cond format: How to highlight a whole row for one word in a description vid 2

Cond format: How to highlight a whole row for one word in a description vid 2

Cond format: Highlighting specific text in color- Vid 1

Cond format: Highlighting specific text in color- Vid 1

Standard deviation and Variance- difference in Population & Sample

Standard deviation and Variance- difference in Population & Sample

What is Standard deviation or sigma in simple lay man terms?

What is Standard deviation or sigma in simple lay man terms?

Cond format :Highlight Rows Based on a Cell Value in Excel-Simple

Cond format :Highlight Rows Based on a Cell Value in Excel-Simple

Cond format :Highlight rows based on a cell value in excel -Standard formula

Cond format :Highlight rows based on a cell value in excel -Standard formula

SWOT Analysis- Excel made app

SWOT Analysis- Excel made app

Highlights Highest cell and lowest cell values for columns

Highlights Highest cell and lowest cell values for columns

Forecasting-Visionary Board , Decision making on Qty

Forecasting-Visionary Board , Decision making on Qty

Capital Budgeting ,Net Present Value(NPV),IRR,PI,PB

Capital Budgeting ,Net Present Value(NPV),IRR,PI,PB

Present Value PV #Financial Management#Capital Budgeting:

Present Value PV #Financial Management#Capital Budgeting:

Future Value FV calculation in Excel- vid 1

Future Value FV calculation in Excel- vid 1

Excel Resolving date format issue & aligning all data

Excel Resolving date format issue & aligning all data

Power Query-Resolving date format issue & aligning all data

Power Query-Resolving date format issue & aligning all data

Power Query: best of OR function converting custom to conditional column

Power Query: best of OR function converting custom to conditional column

Power Query: Searching multiple texts and copying the codes for other work book use

Power Query: Searching multiple texts and copying the codes for other work book use

Excel Formula:Search or Find a Multiple word texts in a cell and return a value

Excel Formula:Search or Find a Multiple word texts in a cell and return a value

Excel formula:Search or Find a single word text in a cell and return a value

Excel formula:Search or Find a single word text in a cell and return a value

Chess in excel-Algebraic Notations in excel for White pieces

Chess in excel-Algebraic Notations in excel for White pieces

BSE & NSE stock exchange index from excel video manage

BSE & NSE stock exchange index from excel video manage

Power Query:Smart work easy method to copy large file names to excel vid 2

Power Query:Smart work easy method to copy large file names to excel vid 2

Easy method to copy large file names of movies,songs to excel - vid 1

Easy method to copy large file names of movies,songs to excel - vid 1

Smart work-Easy method to copy small file names (pdf ,jpg,) to excel workbook to form a database.

Smart work-Easy method to copy small file names (pdf ,jpg,) to excel workbook to form a database.

VBA :Difference in Do while loop vs Do until loop

VBA :Difference in Do while loop vs Do until loop

VBA-Difference in For Loop and Do while loop with IF'S statements vid 4

VBA-Difference in For Loop and Do while loop with IF'S statements vid 4

VBA-Difference in For Loop and Do while loop -vid 3

VBA-Difference in For Loop and Do while loop -vid 3

VBA-Difference in For Loop and Do while loop -vid 2

VBA-Difference in For Loop and Do while loop -vid 2

VBA- Difference in For Loop and Do while loop with IF statements vid 1

VBA- Difference in For Loop and Do while loop with IF statements vid 1

VBA -Report card -How to replicate selected cell contents from one sheet to another sheet -Vid 1

VBA -Report card -How to replicate selected cell contents from one sheet to another sheet -Vid 1

VBA -Report card -How to replicate selected cell contents from one sheet to another sheet -Vid 1

VBA -Report card -How to replicate selected cell contents from one sheet to another sheet -Vid 1

Power Query : Pivoting a Power query table to combine data side by side

Power Query : Pivoting a Power query table to combine data side by side

Power Query :Tips to loading errors with rectification

Power Query :Tips to loading errors with rectification

Power Query :Tips in dealing with data type Errors

Power Query :Tips in dealing with data type Errors

ISNUMBER(SEARCH):How to search any text in a cell and conditional format it with specific color?

ISNUMBER(SEARCH):How to search any text in a cell and conditional format it with specific color?

Compare two workbooks with out using formula: find any difference in two excel books in a simple way

Compare two workbooks with out using formula: find any difference in two excel books in a simple way

Use of VAT in different types to calculate returns.How to calculate VAT on different tax ratios?

Use of VAT in different types to calculate returns.How to calculate VAT on different tax ratios?

How to recover, reverse paid VAT

How to recover, reverse paid VAT

Discount calculation on many items of a quotation

Discount calculation on many items of a quotation

Break Even Analysis: Scoring Matrix with simple objective formula

Break Even Analysis: Scoring Matrix with simple objective formula

Scoring Matrix- Use of INDIRECT#SUBSTITUTE formula

Scoring Matrix- Use of INDIRECT#SUBSTITUTE formula

Techno commercial Criteria’s-Data validation,Data Selection restriction

Techno commercial Criteria’s-Data validation,Data Selection restriction

Power Query & Power pivot : reducing formula writing by simple selection

Power Query & Power pivot : reducing formula writing by simple selection

Power query : reducing formula writing by simple selections

Power query : reducing formula writing by simple selections

Power query errors : Effects of selecting wrong data type, data type error rectification

Power query errors : Effects of selecting wrong data type, data type error rectification

Power Query Errors: On changing Table name

Power Query Errors: On changing Table name

Pivot table:Tips for Power query to pivot table reporting 2

Pivot table:Tips for Power query to pivot table reporting 2

Pivot table: Tips for Power query to pivot table reporting -vid 1

Pivot table: Tips for Power query to pivot table reporting -vid 1

Power query: Compiling workbooks,many sheets in a single sheet.Assembling all workbooks in 1 sheet.

Power query: Compiling workbooks,many sheets in a single sheet.Assembling all workbooks in 1 sheet.

Vacation planner,Project Execution ,Project Planner,Visionary Board

Vacation planner,Project Execution ,Project Planner,Visionary Board

Forecast:Milestone/ Project Management for the Whole year in Excel

Forecast:Milestone/ Project Management for the Whole year in Excel

Milestone: for YEAR'S calculation

Milestone: for YEAR'S calculation

Count colored cells in Excel

Count colored cells in Excel

Full Marks# for not applicable- vid 3

Full Marks# for not applicable- vid 3

Full Marks# for not applicable -vid 2

Full Marks# for not applicable -vid 2

Full Marks# for not applicable items- vid 1

Full Marks# for not applicable items- vid 1

How to copy Frame ,modules form from one workbook to another ?

How to copy Frame ,modules form from one workbook to another ?

3 way, 3 Dimension calculator for multiplication and division -vid 2

3 way, 3 Dimension calculator for multiplication and division -vid 2

3 way, 3D Calculator for multiplication and division -vid1

3 way, 3D Calculator for multiplication and division -vid1

VAT calculator - Percentage calculator- vid 2

VAT calculator - Percentage calculator- vid 2

VAT Calculator Simple way to create VAT calculator vid 1

VAT Calculator Simple way to create VAT calculator vid 1

Form Controls and Active X Controls in Developer Tab, is there any difference?

Form Controls and Active X Controls in Developer Tab, is there any difference?

VLOOKUP VS DGET-Which is the best function is excel?

VLOOKUP VS DGET-Which is the best function is excel?

COLUMN VS COLUMNS- Differences and Uniqueness

COLUMN VS COLUMNS- Differences and Uniqueness

ROW VS ROWS- Differences

ROW VS ROWS- Differences

POWER PIVOT RELATIONSHIPS

POWER PIVOT RELATIONSHIPS

COUNTIF VS COUNTIFS

COUNTIF VS COUNTIFS

IF VS IFS

IF VS IFS

SUMIF VS SUMIFS

SUMIF VS SUMIFS

Tips & Tricks:#ADVANCE FILTERS and data validation for customized data base

Tips & Tricks:#ADVANCE FILTERS and data validation for customized data base

Tips& Tricks:Categories :Grouping Categories with out group function

Tips& Tricks:Categories :Grouping Categories with out group function

Ultimate resolver to range errors with INDIRECT vs SUBSTITUTE function for Data validation

Ultimate resolver to range errors with INDIRECT vs SUBSTITUTE function for Data validation

INDIRECT# Data validation#Drop down simple method

INDIRECT# Data validation#Drop down simple method

RELATED vs VLOOKUP

RELATED vs VLOOKUP

RELATED# function in Power Pivot vs DAX,#Data models. vid 2

RELATED# function in Power Pivot vs DAX,#Data models. vid 2

#INDEX#MATCH VS # RELATED #DAX Formula -vid 1

#INDEX#MATCH VS # RELATED #DAX Formula -vid 1

Power Pivot :#KPI VS #MEASURE VS #DAX

Power Pivot :#KPI VS #MEASURE VS #DAX

Power Pivot vs Power Measures: How to handle errors

Power Pivot vs Power Measures: How to handle errors

Power Query vs power pivot-OR function difference

Power Query vs power pivot-OR function difference

Power Query vs power pivot-AND function difference

Power Query vs power pivot-AND function difference

Tips & Tricks:Cutting paragraph to table

Tips & Tricks:Cutting paragraph to table

#Error: Moving POWER QUERY to POWER PIVOT and deleting tables

#Error: Moving POWER QUERY to POWER PIVOT and deleting tables

#POWER QUERY:Attendance sheet for checking later comers and over timers

#POWER QUERY:Attendance sheet for checking later comers and over timers

Tips & Tricks:Consolidation of excel formulas- combine lengthy formulas

Tips & Tricks:Consolidation of excel formulas- combine lengthy formulas

Creating attendance sheet -Recording onetime,late comers and overtime systematically

Creating attendance sheet -Recording onetime,late comers and overtime systematically

Tips & Tricks:Formula Maker :Creating sum function inside sum in difference

Tips & Tricks:Formula Maker :Creating sum function inside sum in difference

Cell Reference: Types and examples Urdu/Hindi

Cell Reference: Types and examples Urdu/Hindi

Extract errors from adding MEASURES in DAX with simple technique (vid 2)

Extract errors from adding MEASURES in DAX with simple technique (vid 2)

#DAX FORUMULAS:Why Errors in Measures : different styles but correct ways -Video 1

#DAX FORUMULAS:Why Errors in Measures : different styles but correct ways -Video 1

#Power Pivot :Logical thinking-Simple ways to add and delete measures for Dax formula inputs

#Power Pivot :Logical thinking-Simple ways to add and delete measures for Dax formula inputs

Tips & Tricks :Links and Hyperlinks and its difference

Tips & Tricks :Links and Hyperlinks and its difference

Understanding Cell Reference :Relative,Absolute,Mixed with practicals

Understanding Cell Reference :Relative,Absolute,Mixed with practicals

#POWER PIVOT:Different Ways to create data models and delete

#POWER PIVOT:Different Ways to create data models and delete

#Power Pivot:How to arrange SETS- video no#3

#Power Pivot:How to arrange SETS- video no#3

POWER PIVOT: creating sets for DAX and arrange in any order or type- vid 2

POWER PIVOT: creating sets for DAX and arrange in any order or type- vid 2

Pivot tables : with out Power ,With out Dax formulas, with out adding to data models - vid 1

Pivot tables : with out Power ,With out Dax formulas, with out adding to data models - vid 1

#TIPS & TRICKS :Sum function ke alag faidey(hindi, urdu)

#TIPS & TRICKS :Sum function ke alag faidey(hindi, urdu)

#EXCELLENT TIP :Excel formula istemal karneka asaan tareekha(Hindi,Urdu)

#EXCELLENT TIP :Excel formula istemal karneka asaan tareekha(Hindi,Urdu)

Tips & Tricks:Excel for Beginners Use of VAT in different types to calculate returns

Tips & Tricks:Excel for Beginners Use of VAT in different types to calculate returns

Tips & Tricks:Simple book keeping for viewing total easily

Tips & Tricks:Simple book keeping for viewing total easily

Tips & Tricks:Excel for Beginners -Very Important logic to understand excel formulas better

Tips & Tricks:Excel for Beginners -Very Important logic to understand excel formulas better

Difference in TEXTJOIN against CONCATENATE against & " "& ?

Difference in TEXTJOIN against CONCATENATE against & " "& ?

Unique or duplicates: with ISNA MATCH & Conditional format

Unique or duplicates: with ISNA MATCH & Conditional format

Highlights :Largest and smallest values together in a row

Highlights :Largest and smallest values together in a row

Highlight :Lowest values in row with a conditional format

Highlight :Lowest values in row with a conditional format

Highlight :Large values in a row with a conditional format

Highlight :Large values in a row with a conditional format

Highlights Highest cell and lowest cell values for Rows

Highlights Highest cell and lowest cell values for Rows

Highlights: Minimum value or lowest cell value highlighted in a row

Highlights: Minimum value or lowest cell value highlighted in a row

Highlight :Highest value or Max cell holding values in a row

Highlight :Highest value or Max cell holding values in a row

Countif& Conditional format: To find common values in a row

Countif& Conditional format: To find common values in a row

Conditional format with countif :Simple step to change the sides in seconds

Conditional format with countif :Simple step to change the sides in seconds

Countif & Conditional format a common mistake in a cell ref

Countif & Conditional format a common mistake in a cell ref

Cond format on different work sheets to find common & uncommon values

Cond format on different work sheets to find common & uncommon values

Cond format :More than three or more columns to find difference- Part C

Cond format :More than three or more columns to find difference- Part C

Cond format: For More than three or more columns to find uniqueness- Part B

Cond format: For More than three or more columns to find uniqueness- Part B

Cond format : More than three or more columns to find "anything"- Part A

Cond format : More than three or more columns to find "anything"- Part A

Conditional & countif :Finding duplicates or uniqueness in two set of records

Conditional & countif :Finding duplicates or uniqueness in two set of records

Conditional format :finding differences in two database set colorfully

Conditional format :finding differences in two database set colorfully

Conditional format :find the common value for a dynamic ranges

Conditional format :find the common value for a dynamic ranges

SUMIF,COUNTIF,AVERAGEIF on table to table

SUMIF,COUNTIF,AVERAGEIF on table to table

Sumif,countif with header with out header

Sumif,countif with header with out header

SUMIF:Dynamic data with tables and range within a table

SUMIF:Dynamic data with tables and range within a table

SUMIF: Dynamic data with a new technique named xx:xx

SUMIF: Dynamic data with a new technique named xx:xx

SUMIF/COUNTIF/AVERAGEIF:In range for static database

SUMIF/COUNTIF/AVERAGEIF:In range for static database

SumIF :Sumif, Countif, Averageif for beginners

SumIF :Sumif, Countif, Averageif for beginners

Power Query IF Vesus Excel formula IF.

Power Query IF Vesus Excel formula IF.

Formulas :Right way to use a Nested IF or simple IF in DATEDIF

Formulas :Right way to use a Nested IF or simple IF in DATEDIF

Formulas :Right way to use a Nested if or simple IF

Formulas :Right way to use a Nested if or simple IF

Formulas: DATEDIF Vs simple way and common mistake of DATEDIF

Formulas: DATEDIF Vs simple way and common mistake of DATEDIF

Conditional formats: 3 way color for numerical values

Conditional formats: 3 way color for numerical values

Formulas :"False" False conditions in nested IF? TRUE OR FALSE?

Formulas :"False" False conditions in nested IF? TRUE OR FALSE?

Formulas: Dated IF Smart technique for dates and datings

Formulas: Dated IF Smart technique for dates and datings

Nested IF : Double quotes for Alpha numeric values

Nested IF : Double quotes for Alpha numeric values

Nested IF :Professional way with AND & OR functions for best results.

Nested IF :Professional way with AND & OR functions for best results.

Nested IF: For Beginners -Simple and easyTips and tricks in Nested IF

Nested IF: For Beginners -Simple and easyTips and tricks in Nested IF

RANK: Best formulas to calculate any ranks

RANK: Best formulas to calculate any ranks

Nested IF: Scoring Matrix and creating points -vid 1

Nested IF: Scoring Matrix and creating points -vid 1

FORMULAS: IF in COUNT IF with IFERROR

FORMULAS: IF in COUNT IF with IFERROR

SMALL VS LARGE :Best way to use for sales executive performance on sales report

SMALL VS LARGE :Best way to use for sales executive performance on sales report

Purchase formulas:Common Mistake In Nested IF's-Part 1

Purchase formulas:Common Mistake In Nested IF's-Part 1

PROCUREMENT: Lowest vendors with min and max function

PROCUREMENT: Lowest vendors with min and max function

FORMULAS: Nested if with Countif for procurement department

FORMULAS: Nested if with Countif for procurement department

FORMULAS: Nested if with Countif for purchase department

FORMULAS: Nested if with Countif for purchase department

Vendor Management :Nested IF for buyers

Vendor Management :Nested IF for buyers

Procurement Tips : Get rid of Large column and solve the space problems

Procurement Tips : Get rid of Large column and solve the space problems

Buyers: Get rid of Small column and pulling data with cell reference

Buyers: Get rid of Small column and pulling data with cell reference

Purchase/Sales :Remove a min or max column to save space in a XL sheet

Purchase/Sales :Remove a min or max column to save space in a XL sheet

Vendor : Comparative statement -Vid 3

Vendor : Comparative statement -Vid 3

Procurement/Sales: Comparison with Index Match Vid2

Procurement/Sales: Comparison with Index Match Vid2

Procurement v/s sales ,Highest v/s Lowest- Vid 1

Procurement v/s sales ,Highest v/s Lowest- Vid 1

Tips & Tricks :Common errors while copying work sheet, locking work sheet.

Tips & Tricks :Common errors while copying work sheet, locking work sheet.

Power Query- Segregate Merged /Lump sum data into columns for usage

Power Query- Segregate Merged /Lump sum data into columns for usage

Power Query -Codes,Data M Transpose,delimiter in Else

Power Query -Codes,Data M Transpose,delimiter in Else

Ranges : Apply names ,copy range names and various types in ranges

Ranges : Apply names ,copy range names and various types in ranges

Power Query :Error :fix error with right codes or replace function

Power Query :Error :fix error with right codes or replace function

Power Query: Split by delimiter and merge columns

Power Query: Split by delimiter and merge columns

Tips & Tricks:Power Query: Extract value before & after and merge clmns

Tips & Tricks:Power Query: Extract value before & after and merge clmns

APPEND Function in Power Query just like consolidating work sheets

APPEND Function in Power Query just like consolidating work sheets

Power Query: AND & OR functions in Power Query for filtering.

Power Query: AND & OR functions in Power Query for filtering.

Excel Magic Trick: in V lookup excel cells to cells -3 ways

Excel Magic Trick: in V lookup excel cells to cells -3 ways

Excel is fun: OR(-)(-)AND Together with IF(0)(0) Eng Part 3

Excel is fun: OR(-)(-)AND Together with IF(0)(0) Eng Part 3

ERROR : AND & OR in the Beginning which is most valuable or desirable ?

ERROR : AND & OR in the Beginning which is most valuable or desirable ?

AND & OR in the Beginning With AND and with OR? "="

AND & OR in the Beginning With AND and with OR? "="

Error : Power query append with codes and common mistake

Error : Power query append with codes and common mistake

Power Query : Append to combine datas of similar nature

Power Query : Append to combine datas of similar nature

Formulas:OR & AND Functions with IF Eng- Part 2

Formulas:OR & AND Functions with IF Eng- Part 2

Power Pivot :(Months)Convert with excel relationship(Part 3-B)

Power Pivot :(Months)Convert with excel relationship(Part 3-B)

Power Pivot :(Months) Convert with excel relation (Part 3 -A)

Power Pivot :(Months) Convert with excel relation (Part 3 -A)

Power Query: (Months)Convert with power query codes(Part 2-B)

Power Query: (Months)Convert with power query codes(Part 2-B)

Power Query:(Months): Merge/merging in Power Query(Part 2-A)

Power Query:(Months): Merge/merging in Power Query(Part 2-A)

Pivot Tables:(Months): Excel Relationship for creating Months:Eng (Part 1)

Pivot Tables:(Months): Excel Relationship for creating Months:Eng (Part 1)

Tips & Tricks:Lump sum data in cell split,cut ,segregate or divide into pieces.

Tips & Tricks:Lump sum data in cell split,cut ,segregate or divide into pieces.

Formulas: OR & AND Functions with IF :Eng- Part 1

Formulas: OR & AND Functions with IF :Eng- Part 1

Formulas :Simple & Basic (IF condition)vid 2

Formulas :Simple & Basic (IF condition)vid 2

Formulas:Simple & Basic (True or False)vid 1

Formulas:Simple & Basic (True or False)vid 1

PQ: Subtotal vs Power Query Grouping Simple Basic(vid 1)

PQ: Subtotal vs Power Query Grouping Simple Basic(vid 1)

PQ: Subtotal vs Power Query Group Simple Advance (vid 2)

PQ: Subtotal vs Power Query Group Simple Advance (vid 2)

Excel Subtotals vs Power Query Grouping Advance (vid 3)

Excel Subtotals vs Power Query Grouping Advance (vid 3)