Jump to content
Business Intelligence & Analytics for Digital Transformation

About This Club

Business Intelligence & Analytics with Excel FREE Advanced Excel Course We are forming a community to enhance our spreadsheet skills In next couple of months, I'll be sharing tutorials and exercises in this club so whether f you want to learn from beginning or the advanced concepts....

More Info

All tutorials

 

FREE Advanced Excel Course

https://www.facebook.com/free.advanced.excel.course/

https://www.linkedin.com/company/2463855/

excel.jpg.ae6d1dfd53def355e2c0ec5342df8a90.jpg

do not miss this opportunity This is FREE course ... 
We will be starting soon....

For next batches the course FEE is expected to be around $450 . However this time  the course will be absolutely FREE.

How to Errol

  • 1 Join this website 
  • 2 Join this club
  • 3 Start with your introduction in Introduction Zone

Special Instruction - We recommend Office 365 or Excel 2019 - Get ready 

excel.jpg

  1. What's new in this club
  2. MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files
  3. Version 1.0.0

    6 downloads

    lambda helper finctions MAP Redude Scan Byrow ByCol makearray isomitted
  4. As-Salamu Alaikum (Peace be upon you), I am Ashrafu Alam, from Chittagong, Bangladesh. I worked at a steel industries as an Accounts officer. Now I am a lecturer at Kadalpur School and College.
  5. Hi team, I am trying to combine two simple excel files just to learn this power query and getting this massage: DataFormat.Error: External table is not in the expected format. Details: cd5hk2xn.XLS can you help please
  6. This is excellent tool for files in one folder. How can we do combining data from different worksheet in new worksheet within one file ? Is it possible.? I have attached the file. I want only coloured cells from worksheet - call , miss into follow up worksheet. combining data from differennt worksheet.xlsx
  7. hello, I was practicing scenario one - where change cell is unit price. Had a question. If I change the value in one of the unit price, doesnt it change the summary table by itself?
  8. Hello thanks for the idea. i tried this. Extracted postal code with mid( ). When i use vlookup giving reference to this extracted postal code, it gives me error. I cooy postal code and paste as value. Still it gives me an error. Its only when i type the postal code, vlookup gives me data. Is there any way around to overcome this problem. Thanks Kashmirs
  9. You need to extract postal code in a different column and then it can be applied
  10. Hi Can XLOOKUP / VLOOKUP be useful for the text in the cell. I have a city and postal code in B1 cell. And based on postal code in B1 cell, I want return - package center name . I have table for postal code and center name associated with that postal code. I tried using vlookup and xlookup, but I am not getting the result. Attached is the file. Thanks Kashmira XLOOKUP.xlsx
  11. Version 1.0.0

    32 downloads

    Download template file for practice
  12. Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
  13. In 2019 or office 365 https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
  14. Hi What function to use if I dont want every first letter of the word to be upper case. If it is paragraph want only first word , first letter to be upper case. Thanks Kashmira
  15. I just started learning from your tutorial and you really explain it very patiently. Learning a lot. Since I am not familiar with pivot table, I found this turotial little difficult to understand. I had to see it 2 to 3 times to understand it.
  16. Yes you can ...Start with tutorial 1 In this post we should always ask about Xlook up we have a question section for general questions
  17. I cannot see the formula and secondly this question not related to the tutorial pl ask your question https://bi-analytics.org/forum/50-your-questions/ Share the objective and formula you have applied so any 1 can chip in to help you
  18.  



×
×
  • Create New...