Jump to content
Business Intelligence & Analytics for Digital Transformation

About This Club

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




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 

  1. What's new in this club
  2. 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
  3. You need to extract postal code in a different column and then it can be applied
  4. 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
  5. Version 1.0.0


    Download template file for practice
  6. Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
  7. Good day All, I am new here I want to improve my use of excel please I need your guidance . Thank you.
  8. Version 1.0.0


    Tutorial 17 is data file Tutorial 17 case is the final outcome
  9. Version 1.0.0


    Download template file for data
  10. Hi I am here to learn Advance Excel.
  11. Very Good morning Right now No certificates... but for sure pure learning that develops fundamental concepts ...It is the skill and confidence that will speak for you
  12. Good morning, please do you give certificate.
  13. Hello My name is Iyi-Aguebor Esohe Gift, am from Nigeria, Am a Bachelor's degree holder. Have being working for a not for profit sector for almost 4 years now. Currently am a Business Development Strategist at Ignite Africa Leadership Foundation. I love business and data analysis / analyst. also I love using excel as a tool. So I want to know more about excel to boost my change in career to business intelligence analyst.
  14. 16 downloads

    Download template files
  15. Version 1.0.0


    Download template file for practice
  16. Version 1.0.0


    Counting formulas in excel
  17. how can I understand and create formulas?

  • Create New...