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. 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
  3. Version 1.0.0

    5 downloads

    Download file
  4. 20 downloads

    Case Series 6 Summarizing Marketing Data with Excel Functions
  5. Histogram Frequency Mean Mode Median Subtotals large Small Download dataset for practice
  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

    23 downloads

    Download template file for practice
  12. Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
  13. Good day All, I am new here I want to improve my use of excel please I need your guidance . Thank you.
  14. In 2019 or office 365 https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
  15. 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
  16. 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.
  17. 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
  18. Can i directly start directly with advanced ms excel or is there any introductory excel course?
  19. 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
  20. Available to office 365 subscribers https://bi-analytics.org/topic/65-welcome-xlookup-the-successor-of-the-most-ever-powerful-vlookup/?do=findComment&comment=141
  21. Please let me know if we have to do something to make xlookup work in our excel. because the function is not available in my excel
  22.  



×
×
  • Create New...