MNK_Excel

Learn How to Solve your Business Problems & Questions Using Excel Making you awesome in excel,data analytics & charting.
follow me on Instagram
@mnkexceltips

[MNK_Excel @Mnkexceltips]

@Mitesh_Engr @ITRADE191 @_GauravVashisth @imratilal Pawagad area che Sir

[MNK_Excel @Mnkexceltips]

how can I have continuous numbering when a merged cell occurs in between?

Once you apply the formula the data will look like left side
Column A should be formatted in the same way as Column B

Please keep in mind that this formula only works if the next column contains "Text."

[MNK_Excel @Mnkexceltips]

Excel Tips of the day

#msexcel #Excel #learnexcelwithalok #ExcelVibez #Excelfunctions#data #excel #learning #DataAnalytics #DataScience

[MNK_Excel @Mnkexceltips]

What is the shortcut to dragging formulas in Excel?

#msexcel #excel #microsoftexcel #microsoft #exceltips #exceltraining #office #msword #msexceltraining #exceltricks #data #msoffice #excelfunctions #microsoftoffice #business #learnexcel #excelshortcuts #msexceltips #dataentr

[MNK_Excel @Mnkexceltips]

How do you copy a formula in excel but keep one cell constant

#data #dataanalytics #excel #msexcel #msoffice #dataanalysis #bianalytics #dataentry #tipsandtricks #excelskills #exceltips #exceltipsandtricks #dataanalyst #microsoftexcel #miscrosoft #Windows #INDvsPAK

[MNK_Excel @Mnkexceltips]

We will simply use CountA formula with a range of cells from where we need the count of non-blank / non-empty cells.

#msexcel #Excel #learnexcelwithalok #ExcelVibez #data #excel #learning #DataAnalytics #DataScience

[MNK_Excel @Mnkexceltips]

Fill in the black cells in Excel with the value from above

Choose the cells that include blank cells > Ctrl + G > Select > Select Blanks > from the Go To Special dialogue. Click OK > Enter = > Choose the cell above

[MNK_Excel @Mnkexceltips]

VLOOKUP without #N/A error

#msexcel #excel@Mrexcel #learnexcelwithalok #ExcelVibez #Excelfunctions#data #excel #learning #DataAnalytics #DataScience

[MNK_Excel @Mnkexceltips]

Clearing Contents
#data #dataanalytics #excel #msexcel #msoffice #dataanalysis #datatransformation #bianalytics #dataentry #tipsandtricks #excelskills #exceltips #exceltipsandtricks #dataanalyst #microsoftexcel #microsoft #bianalyst #datacleaning #datacareers

[MNK_Excel @Mnkexceltips]

#data #dataanalytics #excel #msexcel #msoffice #dataanalysis #datatransformation #bianalytics #dataentry #tipsandtricks #excelskills #exceltips #exceltipsandtricks #dataanalyst #microsoftexcel #microsoft #bianalyst #datacleaning #datacareers #exceltraining #exceltricks

[MNK_Excel @Mnkexceltips]

@blakeaburge Useful tips

[MNK_Excel @Mnkexceltips]

In this example, insert your starting dates in column B.

In column C, enter the number of months to add or delete. You can enter a minus sign (-) before the number to indicate that a month should be deducted (e.g. -1).

In cell D4, enter =EDATE(B4,C4) and copy down as needed.

[MNK_Excel @Mnkexceltips]

#msexcel #excel #learnexcelwithalok #ExcelVibez #Excelfunctions #data #excel #learning #DataAnalytics #DataScience

[MNK_Excel @Mnkexceltips]

Copy the Folder's filename list into excel

[MNK_Excel @Mnkexceltips]

Add text and Formula in the same cell in excel

#msexcel #excel@Mrexcel #learnexcelwithalok #ExcelVibez #Excelfunctions#data #excel #learning #DataAnalytics #DataScience

[MNK_Excel @Mnkexceltips]

Hello buddies, this formula will be quite beneficial to you. Some activities are really tough to complete, so this function simplifies them.

Try that and see what happens.

Save this for the future.

[MNK_Excel @Mnkexceltips]

Excel tips of the day

Sumproduct
#data #dataanalytics #excel #msexcel #msoffice #dataanalysis #datatransformation #bianalytics #dataentry #tipsandtricks #excelskills #exceltips #exceltipsandtricks #dataanalyst #microsoftexcel #microsoft #bianalyst #datacleaning #datacareers

[MNK_Excel @Mnkexceltips]

How to Add,Remove,Change and Print Gridlines

#msexcel #excel@Mrexcel #learnexcelwithalok #ExcelVibez #Excelfunctions#data #excel #learning #DataAnalytics #DataScience

[Mukesh Katara @mukeshkatara]

The 8 Steps Challenge

#thoughtoftheday #ThoughtsAndPrayers
#thoughtleadership