Crispo Mwangi’s Post

On Spreadsheet Day, what are some of the features you enjoy using? How have spreadsheets improved your HR world? We are nerdy for Excel Formulas! We enjoy tracking performance metrics on spreadsheets! #SpreadsheetDay #SmallBusinessSuccess #MeithSolutions #NerdyHR

On Spreadsheet Day, what are some of the features you enjoy using? How have spreadsheets improved your HR world? We are nerdy for Excel Formulas! We enjoy tracking performance metrics on spreadsheets! #SpreadsheetDay #SmallBusinessSuccess #MeithSolutions #NerdyHR

Completed an excel course! I did an Excel Macro from what I learned here that's saving time to HRBP's as they can now generate employee documents automatically! #Excel #Tecnology #HR

By default, the Lookup functions search mode is from first to last, returning the 1st TRUE value. With some modifications, we can get VLOOKUP to look up from last to first. =VLOOKUP( LARGE((tblSale[Customer]=F3)*ROW(tblSale[Customer]),H3), IF({1,0},ROW(tblSale[Customer]),tblSale[Sales Date]),2,0) Watch and Learn.👇 ............................................. Follow for more tips & tricks.😎 ............................................. #Excel #hr #CrispExcel #Exceltips

I am pleased to share a comprehensive Compensation and Benefits Dashboard in the form of a PowerPoint presentation. This dynamic presentation is designed to provide clear insights and enhance the strategic decision-making process regarding employee compensation and benefits. 📊 Key Features: - Salary Range and Recommended Pay Range by Grade: Compare internal salary ranges to external market benchmarks. - Market Benchmark Pay Report: Detailed analysis of salary compared to the market. - Salary Structure and Employee Salary Data: Breakdown of employee salaries by grade and department. - Salary Structure and Employee Data Group: Summary of salary distributions categorized by department or job function. - Performance Rating Distribution (Bell Curve Chart): Visual representation of performance ratings following a bell curve. - Quadrant Matrix Chart: Visual representation of employee performance versus potential in a 2x2 matrix. - Quadrant Matrix Chart (3-Dimensional): Advanced visualization incorporating an additional dimension, such as team headcount. Reference Resource : AIHR,Capriso HR Analytics,HR Diary channels #HR #CompensationBenefits #ExcelDashboard #HRUAE

ABCs of MS Excel If you enjoy this content, repost to help others too ♻️ Follow Safeer U. Siddiqui - UCI (HR Analytics) for more excel tips. #dataanalysis #excelskills #efficiencyboost #productivity

How to VLOOKUP multiple tables. The only trick to learn is to use the IFS function to return the correct table dynamically. IFS([@Item ]=$G$2,Chairs_Disc,[@Item ]=$G$8,Laptops_Disc,[@Item ]=$J$2,Tables_Disc) .... Follow for more tips. .... #excel #spreadsheets #hr #CrispExcel #VLOOKUP

I am happy to share with you all that I Just completed the "HR Analytics using Excel" course on NPTEL! 📊 Excited to apply data-driven insights to enhance HR strategies and decision-making. #HRAnalytics #Excel #ContinuousLearning #NPTEL

🚀 Mastering the art of being an "Excel wizard" in HR not only boosts your employability but also empowers better decision-making on your journey to becoming a data-driven HR professional 📊 https://aihr.ac/4ahjdnR 👈 Explore essential HR formulas, tools, and functions in Excel! #HumanResources #PeopleAnalytics #HRanalytics #Excel #HR