Calculate Bonus and Increment by Performance Grading for Human Resources | Excel Sifu

Using Microsoft Excel to performance performance bonus and increment calculation. This uses three different methods to accomplish this task.

DOWNLOAD FILE https://docs.google.com/spreadsheets/d/1KZClH13r54IRAasQb-n_bJCdfbKT-CUZ/edit?usp=sharing&ouid=116068563422181575654&rtpof=true&sd=true

TIMESTAMP 0:00 Welcoming and Introduction 0:14 Understanding the data 0:58 Using Excel Table for Reference Table 1:44 Calculating Increment and Bonus with VLOOKUP Approximate Match 4:40 Calculating Increment and Bonus with INDEX MATCH Approximate Match 7:17 Calculating Increment and Bonus with XLOOKUP Approximate Match 9:56 The Beauty of using XLOOKUP Approximate Match 10:29 Summarizing & Closing

Download eBook: The 5 Magic to Master Business Data 👉 https://5-secrets-biz-data.mailerpage.com

Follow Me in Odyess 👉 https://odysee.com/@ExcelSifu

Join Me in Odyess 👉 https://odysee.com/$/invite/HuxeoXKaUnv7eyTNkiYmNxUamL7rJjhT

Connect to me in LinkedIn https://www.linkedin.com/in/excelsifu

Like our Facebook https://www.facebook.com/WhyExcel/

Hash Tag #ExcelSifu #MicrosoftExcel #HumanResources ... https://www.youtube.com/watch?v=uMHegLpoOkg