Excel functions practice data

Here MS Excel related topics will be posted.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Excel functions practice data

Post by admin »

Please download to practice Excel function as per our youtube videos.

Youtube video,

ERPstuff Excel vlookup composite key
If we don't have single column primary key in our data so we need to add more column to make it unique is called composite key. This video will show how to concatenate two column to make a composite key and then search using vlookup. It is handy while searching sales data of customer where customer will have different sites so customer + site will be composite key.

https://youtu.be/KqiO_QiRcsc

ERPstuff Excel Advance Functions for Consultants
This video will cover following functions of MS Excel specially for ERP Consultants who are always busy in preparing data for migrations,

vlookup() Search vertically
sumif() Total based on condition
countif() Count based on condition
iferror() Suppress error like NA
remove duplicates Remove duplicates and return distinct values

https://youtu.be/Db3QUn-h9lE

To practice data file is attached which is normally data taken from wikipedia.
Attachments
ERPstuff Excel Data.rar
(105.72 KiB) Downloaded 256 times
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests