How to Slice Text in Excel (Like a Pro!) #datacleaning #excelhacks #excelformula #excelforbeginners
0:0:57 The Freelancing Studio
Excel Tips
10 common Excel mistakes – How to avoid them
Here are 10 common Excel mistakes. Avoiding them will save lot of rework and duplicated efforts. Let’s start with very common Excel mistakes – Usage of “Merged cells” Habituating these tips and avoiding these Excel mistakes will make life easier while cleaning the data. Take look at other Excel posts Click here for some Excel
10 common Excel mistakes – How to avoid them Read More »
VLOOKUP or XLOOKUP – End of VLOOKUP?
Are you using vlookup for looking up the values across the data sheets? Why not a comparison between Vlookup & Xlookup? I certainly used to do Vlookup until I wasn’t aware of XLOOKUP. After being a very handful expertise on on both these formulas here is my take comparing both Xlookup and Vlookup. Firstly why
VLOOKUP or XLOOKUP – End of VLOOKUP? Read More »