About This Club
More Info
FREE Advanced Excel Course
https://www.facebook.com/free.advanced.excel.course/
https://www.linkedin.com/company/2463855/
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
- What's new in this club
-
Susan L joined the club -
rahu Ajmera joined the club -
Muhammad Waheed Iqbal joined the club -
wazir joined the club -
Sergio Narvasta joined the club -
Pooja Mukesh joined the club -
amarprajapati joined the club -
NabilaTabassum joined the club -
KM Gh joined the club -
Asraful islam joined the club -
Clementine Mosito joined the club -
mukilmubha joined the club -
Suri joined the club -
Karthik Krishna joined the club -
Md Sujan joined the club -
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
-
ELANA joined the club -
Ankit joined the club -
JulesFakr joined the club -
Mohamad viekry joined the club -
Abhinav207061001 joined the club -
Mechzedek joined the club -
Hassan Abouelwafa joined the club -
Jrazzle83VBAme joined the club -
Josh N Josiah Dhliwayo joined the club -
Patti joined the club -
Khent Khent joined the club -
Tamilkumaran joined the club -
Abelardo joined the club -
Renata Orucevic joined the club -
JOBY joined the club -
Thanks. Will try that.
-
GBH joined the club -
Solanki joined the club -
Muhammad Mazhar Hussain joined the club -
Gaurav joined the club -
Sudharshan joined the club -
Using XLOOKUP -
Saurabh Jain replied to Kashmira's topic in BI & Analytics with Excel's Your Questions
You need to extract postal code in a different column and then it can be applied -
Razak joined the club -
Snehal joined the club -
Mukund Chaware joined the club -
Munyaradzi Mutsvangwa joined the club -
Valar joined the club -
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
-
Omar Aaki joined the club -
Krishnendu Sahoo joined the club -
Kalyan joined the club -
Ishant Chhabra joined the club -
Anand joined the club -
Vinod Shinde joined the club -
Dipak joined the club -
Palanisamy Nachimuthu joined the club -
Ayub attar joined the club -
Binesh joined the club -
-
Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice
-
10 Quick Time-Saving Excel Shortcuts & Mouse Tricks
Manowar Hassan commented on Saurabh Jain's blog entry in BI & Analytics with Excel's Excel Shortcuts
excellent.......tips. thanks. -
Good day All, I am new here I want to improve my use of excel please I need your guidance . Thank you. -
-
-
-
-
Hi I am here to learn Advance Excel.
-
certificate
Saurabh Jain replied to Iyi-aguebor Esohe's topic in BI & Analytics with Excel's Your Questions
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 -
Good morning, please do you give certificate.
-
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. -
From basics to advanced
-
Tutorial 1 Sales Projection.xlsx
Emmanuel commented on Saurabh Jain's file in BI & Analytics with Excel's Files
-
-
Welcome
-
Its great to be here
-
-
-
formulas
Saurabh Jain replied to Bruno Miller's topic in BI & Analytics with Excel's Introduction Zone
with tutorial number 3 -
how can I understand and create formulas?
