Dear all, can anyone please guide me on how to learn HLOOKUP, VLOOKUP, and PIVOT TABLE in Excel? I need to master these functions in Excel. Your assistance in this regard would be greatly appreciated.
Looking forward to your valuable response.
Best Regards,
Valan
From India, Madras
Acknowledge(0)
Amend(0)
1Looking forward to your valuable response.
Best Regards,
Valan
From India, Madras
Acknowledge(0)Amend(0)
What do you want? May I send you a formula in an Excel sheet showing some data, or do you have some data for which I can create a formula?
All three formulas are very easy once the concept is clear.
Regards,
Manjay
[Email Removed For Privacy Reasons]
[Phone Number Removed For Privacy Reasons]
Malay Gauri Consultants Pvt. Ltd.
www.malaygauri.com
From India, Mumbai
Acknowledge(0)Amend(0)
All three formulas are very easy once the concept is clear.
Regards,
Manjay
[Email Removed For Privacy Reasons]
[Phone Number Removed For Privacy Reasons]
Malay Gauri Consultants Pvt. Ltd.
www.malaygauri.com
From India, Mumbai
Acknowledge(0)Amend(0)
I received your email about the Pivot table. The thing is, your data shows the final result. Could you please explain the step-by-step process of Pivot, HLOOKUP, and VLOOKUP?
Regards,
Valan
From India, Madras
Acknowledge(0)Amend(0)
Regards,
Valan
From India, Madras
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Pivot Table Secrets.pdf
PIVOT TABLE SAMPLE.zip
Excel Formulas.xls