Jump to content
Install Mobile app ×
Business Intelligence & Analytics for Digital Transformation
Install Mobile app

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. Talal Butt
    Talal Butt joined the club
  3. Chetan Ramphul
    Chetan Ramphul joined the club
  4. Wasonga
    Wasonga joined the club
  5. shahid.ch
    shahid.ch joined the club
  6. Nilesh Maruti Mohite
    Nilesh Maruti Mohite joined the club
  7. Aprajita Singh
    Aprajita Singh joined the club
  8. Sapuni Adithya
    Sapuni Adithya joined the club
  9. Vivek Ambade
    Vivek Ambade joined the club
  10. Medha Patki
    Medha Patki joined the club
  11. Arifulla
    Arifulla joined the club
  12. simt
    simt joined the club
  13. Kanchi
    Kanchi joined the club
  14. Umme Kulsum
    Umme Kulsum joined the club
  15. Waliy
    Waliy joined the club
  16. Miloš
    Miloš joined the club
  17. Sivakumar
    Sivakumar joined the club
  18. Hanan
    Hanan joined the club
  19. hemant
    hemant joined the club
  20. Ajith Cutinho
    Ajith Cutinho joined the club
  21. Pyae Phyo Thu
    Pyae Phyo Thu joined the club
  22. Nishant
    Nishant joined the club
  23. Bhavatharhini
    Bhavatharhini joined the club
  24. Sujan
    Sujan joined the club
  25. botur
    botur joined the club
  26. MJ Mesa
    MJ Mesa joined the club
  27. Tajudeen Adebayo
    Tajudeen Adebayo joined the club
  28. Phyo Phyo
    Phyo Phyo joined the club
  29. Salvatore Scirè
    Salvatore Scirè joined the club
  30. Saurabh Jain
    MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files
  31. Saurabh Jain

    Version 1.0.0

    6 downloads

    lambda helper finctions MAP Redude Scan Byrow ByCol makearray isomitted
  32. Nisrina Athira
    Nisrina Athira joined the club
  33. SHRANG SINGH
    SHRANG SINGH joined the club
  34. Reham
    Reham joined the club
  35. Faisal Razzaq
    Faisal Razzaq joined the club
  36. Purushotham
    Purushotham joined the club
  37. Govi Gova
    Govi Gova joined the club
  38. Shariful Islam sojib
    Shariful Islam sojib joined the club
  39. PrathamS
    PrathamS joined the club
  40. Olive Bayani
    Olive Bayani joined the club
  41. agus
    agus joined the club
  42. harsha vardhan
    harsha vardhan joined the club
  43. ashrafulbright
    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.
  44. ashrafulbright
    ashrafulbright joined the club
  45. julien.tougma
    julien.tougma joined the club
  46. Sheenu
    Sheenu joined the club
  47. Satheesh Perumbily
    Satheesh Perumbily joined the club
  48. Onyekachi Deborah
    Onyekachi Deborah joined the club
  49. kalani
    kalani joined the club
  50. Ala H Hawamdeh
    Ala H Hawamdeh joined the club
  51. Chy2nice09
    Chy2nice09 joined the club
  52. Shrikant Badge
    Shrikant Badge joined the club
  53. Vic Kie
    Vic Kie joined the club
  54. Dimple dodiya
    Dimple dodiya joined the club
  55. Ganesh Nema
    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
  56. Saurabh Jain

    Version 1.0.0

    8 downloads

    Download file
  57. Saurabh Jain
    Download Excel file
  58. Saurabh Jain

    20 downloads

    Case Series 6 Summarizing Marketing Data with Excel Functions
  59. Saurabh Jain
    Histogram Frequency Mean Mode Median Subtotals large Small Download dataset for practice
  60. Kashmira
    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
  61. Kashmira
    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?
  62. Kashmira
    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
  63. Kashmira
    Thanks. Will try that.
  64. Saurabh Jain
    You need to extract postal code in a different column and then it can be applied
  65. Kashmira
    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
  66. Saurabh Jain

    Version 1.0.0

    31 downloads

    Download template file for practice
  67. Saurabh Jain
    Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
  68. Manowar Hassan
    excellent.......tips. thanks.
  69. Texman
    Good day All, I am new here I want to improve my use of excel please I need your guidance . Thank you.
  70. Saurabh Jain
    In 2019 or office 365 https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
  71. Kashmira
    Is TEXTJOIN feature is only in 2010 excel ?
  72. Kashmira
    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
  73. Kashmira
    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.
  74. Saurabh Jain
    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
  75. Nikhil Donadkar
    Can i directly start directly with advanced ms excel or is there any introductory excel course?
  76. Saurabh Jain
    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
  77.  


×
×
  • Create New...