Advertisement
| excel training for hr professionals: M Is for (Data) Monkey Ken Puls, Miguel Escobar, 2015-06-01 Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and M is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting. |
| excel training for hr professionals: Excel University Volume 2 - Featuring Excel 2013 for Windows Jeff Lenning, Jeff Lenning Cpa, 2013-11-07 Building on the firm foundation established in the first volume, the second installment in the Excel University series continues to explore the Excel features, functions and techniques relevant to accounting and finance professionals. Volume 2 focuses on how to automate recurring-use reports. Amounts in hands-free reports update the instant updated data is inserted into the workbook, for example, when an updated trial balance is pasted into the data sheet. This volume covers the Excel items needed to build and automate reports, including lookups, dynamic headers, mapping tables, error trapping, conditional summing, and date related functions. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time. |
| excel training for hr professionals: Fundamentals of Human Resource Management Talya Bauer, Berrin Erdogan, David Caughlin, Donald Truxillo, 2019-12-10 Fundamentals of Human Resource Management: People, Data, and Analytics provides a current, succinct, and interesting introduction to the world of HRM with a special emphasis on how data can help managers make better decisions about the people in their organizations. Authors Talya Bauer, Berrin Erdogan, David Caughlin, and Donald Truxillo use cutting-edge case studies and contemporary examples to illustrate key concepts and trends. A variety of exercises give students hands-on opportunities to practice their problem-solving, ethical decision-making, and data literacy skills. Non-HR majors and HR majors alike will learn best practices for managing talent in today’s ever-evolving workplace. |
| excel training for hr professionals: Adobe Creative Cloud All-in-One For Dummies Jennifer Smith, Christopher Smith, 2021-03-10 Fly higher in your Creative Cloud Adobe Creative Cloud makes the most popular tools used by designers, photographers, and other creative professionals accessible in a single place. Adobe Creative Cloud All-in-One For Dummies is the ultimate one-stop reference guide for how to use them all. Whatever gets your creative juices flowing, you'll find the in-depth guidance required to deliver the results you want, from polishing-up photos and images to creating illustrations and designs. And once your assets are just how you want them, you can pick up best practices for managing and publishing via the amazing Adobe Bridge. Written by pro designers for those getting started with this powerful set of tools, this book gives you an overview of Creative Cloud and step-by-step coverage of the major applications—InDesign, Illustrator, Photoshop, Acrobat Pro, and Adobe XD, and Adobe Bridge—in seven mini-books that take you from the basics to more advanced topics. You'll also discover how to get your work noticed by building personal galleries and displaying your creative wares. Find the essentials on the top tools in Adobe Creative Cloud Build and enhance your design skills Protect your documents with Acrobat Pro Get the most out of each program with insider tips Whatever your skill level and project needs, you'll find the essentials you need to demystify these complex programs and the knowledge to make your work shine even more brightly through the Cloud! |
| excel training for hr professionals: Financial Analysis for HR Managers Steven Director, 2012-12-19 HR leaders and practitioners: master the financial analysis skills you need to become true strategic business partners, gain an equal seat at the table, and get boardroom and CFO buy-in for your initiatives! In this one-of-a-kind book, Dr. Steven Director covers everything mid-to-senior-level HR professionals need to formulate, model, and evaluate their HR initiatives from a financial perspective. Drawing on his unsurpassed expertise working with HR executives, he walks through each crucial financial issue associated with strategic talent management, including quantifiable links between workforces and business value, cost-benefit analyses of HR and strategic financial initiatives, and specific issues related to total rewards programs, including stock, stock options, and pension costs. Unlike other finance books for non-financial managers, Financial Analysis for HR Managers focuses entirely on core HR issues. Director helps you answer questions such as: How do you model HR's financial role in corporate strategic initiatives such as the introduction of a new product line? How do you select bonus drivers to send the right signals to managers (and uncover suboptimal hidden signals you might be sending now)? How do you design compensation packages that are fully consistent with your goals? How do you identify and manage pension-finance costs and risks that can dramatically impact the long-term financial health of the business? HR leaders and aspiring leaders are under unprecedented pressure to provide credible, quantitative answers to questions like these. This is the one and only book that will help them do so. |
| excel training for hr professionals: Excel University Jeff Lenning, Jeff Lenning Cpa, 2017-03-11 During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks. Written to reach those he won't have the opportunity to meet in one of his CPE sessions, Lenning's series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http: //www.excel-university.com to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow. |
| excel training for hr professionals: HR Analytics Manish Soni, 2024-11-14 The book then guides you through various analytical techniques, starting with Descriptive Analytics in HR, where you learn to perform basic statistical analysis and data interpretation. Performance Metrics provides insights into structuring and applying performance metrics effectively, while Compensation and HR Analytics delves into creating comprehensive compensation frameworks and policies. For those interested in more advanced topics, chapters like Diagnostic Analytics in HR, Predictive Analytics in HR, and Prescriptive Analytics in HR cover everything from regression analysis to predictive modelling and strategic planning using Excel. We also explore Advanced Excel Functions for HR Analytics for more seasoned Excel users, aiming to automate and enhance their data analysis. The book does not stop at analytics within Excel; Integrating Excel with Other HR Systems provides valuable insights into how Excel can interact with various HRIS and other tools, emphasizing the importance of integration in modern HR practices. |
| excel training for hr professionals: Excel Data Analysis Hector Guerrero, 2018-12-14 This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations. |
| excel training for hr professionals: Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel Dpg, Mong Shen Ng, 2019-06-30 A lot of organizational data is often untapped unstructured data in the form of text & numbers. You don't need to spend months learning R programming & you don't need to buy expensive SPSS statistical software. This is the only book that teaches you how to use Microsoft Excel for Predictive HR Analytics, Text Mining & Organizational Network Analysis (ONA) with step-by-step print-screen instructions: 1) Predictive HR Analytics: Use Excel's Statistical Analysis tools (Decision trees, Correlation, Multiple & Logistic Regression) to run Predictive HR Analytics. E.g. an employee is predicted to have a 60% probability of getting into accidents, if he is age 25, worked 1 year in the company & took 6 days sick leave. An employee is predicted to get rated 7 for Customer Service, if the training program that he attended has a training evaluation score of 8. An employee is predicted to resign if she is age 23, worked for 2 years, and takes 60 minutes to commute to work. 2) Organizational Network Analysis (ONA): Run ONA using Excel's network analysis tool. Learn how to convert an employee's organizational network into a score & then predict if they will be a high-potential (HiPo). E.g. an employee is predicted to be a HiPo with performance rating of 9, if his Social Network Size is 16, Social Network Diversity Index is 3 & Competency Score is 8. 3) Text Mining, Sentiment Analysis & Word Clouds: Mine text from social network posts, employee engagement surveys & Glassdoor comments, then run Sentiment Analysis using Excel & visualize the insights with Word Clouds. Learn how to predict a company's average employee attrition rate based on its sentiment. E.g. a company's average employee attrition rate is predicted to be 8%, if unemployment rate is 3%, GDP growth is 2%, Glassdoor public sentiment rating is 5, and engagement score is 7. |
| excel training for hr professionals: Ask a Manager Alison Green, 2018-05-01 From the creator of the popular website Ask a Manager and New York’s work-advice columnist comes a witty, practical guide to 200 difficult professional conversations—featuring all-new advice! There’s a reason Alison Green has been called “the Dear Abby of the work world.” Ten years as a workplace-advice columnist have taught her that people avoid awkward conversations in the office because they simply don’t know what to say. Thankfully, Green does—and in this incredibly helpful book, she tackles the tough discussions you may need to have during your career. You’ll learn what to say when • coworkers push their work on you—then take credit for it • you accidentally trash-talk someone in an email then hit “reply all” • you’re being micromanaged—or not being managed at all • you catch a colleague in a lie • your boss seems unhappy with your work • your cubemate’s loud speakerphone is making you homicidal • you got drunk at the holiday party Praise for Ask a Manager “A must-read for anyone who works . . . [Alison Green’s] advice boils down to the idea that you should be professional (even when others are not) and that communicating in a straightforward manner with candor and kindness will get you far, no matter where you work.”—Booklist (starred review) “The author’s friendly, warm, no-nonsense writing is a pleasure to read, and her advice can be widely applied to relationships in all areas of readers’ lives. Ideal for anyone new to the job market or new to management, or anyone hoping to improve their work experience.”—Library Journal (starred review) “I am a huge fan of Alison Green’s Ask a Manager column. This book is even better. It teaches us how to deal with many of the most vexing big and little problems in our workplaces—and to do so with grace, confidence, and a sense of humor.”—Robert Sutton, Stanford professor and author of The No Asshole Rule and The Asshole Survival Guide “Ask a Manager is the ultimate playbook for navigating the traditional workforce in a diplomatic but firm way.”—Erin Lowry, author of Broke Millennial: Stop Scraping By and Get Your Financial Life Together |
| excel training for hr professionals: Human Resource Management Essentials You Always Wanted To Know Jaquina Gilbert, 2020-05-01 The core of every company is its people, and Human Resources Management (HRM) is the key to handling all the complexities of human relations, compensation, conflict resolution, and much more. Strategies and tactics are needed to effectively manage the human resource potential that drives all companies to profitability and success. Human Resource Management Essentials You Always Wanted To Know guides readers through the challenges and provides tools to address those challenges. It provides an understanding of areas including: · The concept of HRM · Performance management strategies · Legal and regulatory compliance · Organizational development · Conflict management · Payroll and compensation · Information technology in HRM · Health and safety · Personnel development Human Resource Management Essentials is part of the Self-Learning Management Series focused on working professionals. The series addresses every aspect of business from HR to finance, marketing, and operations. Each book includes fundamentals, important concepts, and well-known principles, as well as practical applications of the subject matter. |
| excel training for hr professionals: Predictive HR Analytics Dr Martin R. Edwards, Kirsten Edwards, 2019-03-03 HR metrics and organizational people-related data are an invaluable source of information from which to identify trends and patterns in order to make effective business decisions. But HR practitioners often lack the statistical and analytical know-how to fully harness the potential of this data. Predictive HR Analytics provides a clear, accessible framework for understanding and working with people analytics and advanced statistical techniques. Using the statistical package SPSS (with R syntax included), it takes readers step by step through worked examples, showing them how to carry out and interpret analyses of HR data in areas such as employee engagement, performance and turnover. Readers are shown how to use the results to enable them to develop effective evidence-based HR strategies. This second edition has been updated to include the latest material on machine learning, biased algorithms, data protection and GDPR considerations, a new example using survival analyses, and up-to-the-minute screenshots and examples with SPSS version 25. It is supported by a new appendix showing main R coding, and online resources consisting of SPSS and Excel data sets and R syntax with worked case study examples. |
| excel training for hr professionals: The Basics of Achieving Professional Certification Willis H. Thomas, 2017-07-27 Professional certification has become a very popular topic and a significant number of individuals are making it a priority. Some people are torn on whether or not to obtain a certification to bolster their career. Others see the advantage of diversifying their professional portfolio and pursuing popular certifications in the areas of Project Management, Information Technology, Quality, or Human Resources. The Basics of Achieving Professional Certification: Enhancing Your Credentials provides clear-cut guidance on how to select a certification that is right for you and how you can continue to build your credentials in support of personal and professional goals. This easy-to-use guide can help anyone looking to achieve professional certification make informed decisions about the many options available. It can also help avoid the pitfalls of making the wrong choice as a result of being incorrectly informed. Examining the range of professional certifications offered by associations and organizations, it explains how to select the right professional certification and outlines best practices for completing the certification process. The book includes a CD that represents more than a year of development between resources in the U.S. and Europe. Packed with tools, it supplies permanent access to a suite of helpful training and development software, including:Library management system to track training material, books, and related items (created in MS Access)Learning management system to ensure training compliance (created in MS Access)A number of project management resources, including a comprehensive exam preparation programRoyalty free multimedia resources to add pizzazz to your e-learning programsForms, templates, and checklists to support training administrationTool |
| excel training for hr professionals: Training for Development R.K. Sahu, 2009 A comprehensive book from Dr R K Sahu, a passionate Corporate Trainer for all those who have passion for Training.A complete guide for Trainers, HR Professionals & Consultants, Professors of Human Resource Development & Management Students, Training Managers and all individuals who aspire to make a career as a Trainer or in Managing Training Function.A practical treatise covering all facets of Training including:v Managing Training Functionv Training Needs Identificationv Aligning training with organizational goalsv Designing Training Programmev Training Methodologiesv Delivery of Trainingv Measuring Impact of TrainingA masterpiece detailing all finer elements of Training with a practical approach. |
| excel training for hr professionals: Human Resources Management St. Clements University Academic Staff , Human Resources Management Talent Acquisition Employee Onboarding and Training Performance Management Compensation and Benefits Employee Relations HR Compliance and Risk Management The Future of HR |
| excel training for hr professionals: The HR Scorecard Brian E. Becker, David Ulrich, Mark A. Huselid, 2001-04-11 Three experts in Human Resources introduce a measurement system that convincingly showcases how HR impacts business performance. Drawing from the authors' ongoing study of nearly 3,000 firms, this book describes a seven-step process for embedding HR systems within the firm's overall strategy—what the authors describe as an HR Scorecard—and measuring its activities in terms that line managers and CEOs will find compelling. Analyzing how each element of the HR system can be designed to enhance firm performance and maximize the overall quality of human capital, this important book heralds the emergence of HR as a strategic powerhouse in today's organizations. |
| excel training for hr professionals: Lean Human Resources Cheryl M. Jekiel, 2017-08-09 Encouraging a long overdue shift in thinking, this book gives managers and executives the means to maximize employee potential by first showing them how to increase the improvement power of their HR departments. Cheryl M. Jekiel, who has been implementing Lean initiatives out of HR offices for 20 years, defines the people-related approaches and pra |
| excel training for hr professionals: Human Resource Management Study Guide , Welcome to the forefront of knowledge with Cybellium, your trusted partner in mastering the cutting-edge fields of IT, Artificial Intelligence, Cyber Security, Business, Economics and Science. Designed for professionals, students, and enthusiasts alike, our comprehensive books empower you to stay ahead in a rapidly evolving digital world. * Expert Insights: Our books provide deep, actionable insights that bridge the gap between theory and practical application. * Up-to-Date Content: Stay current with the latest advancements, trends, and best practices in IT, Al, Cybersecurity, Business, Economics and Science. Each guide is regularly updated to reflect the newest developments and challenges. * Comprehensive Coverage: Whether you're a beginner or an advanced learner, Cybellium books cover a wide range of topics, from foundational principles to specialized knowledge, tailored to your level of expertise. Become part of a global network of learners and professionals who trust Cybellium to guide their educational journey. www.cybellium.com |
| excel training for hr professionals: The HR Value Proposition David Ulrich, Wayne Brockbank, 2005-05-11 The international best seller Human Resource Champions helped set the HR agenda for the 1990s and enabled HR professionals to become strategic partners in their organizations. But earning a seat at the executive table was only the beginning. Today's HR leaders must also bring substantial value to that table. Drawing on their 16-year study of over 29,000 HR professionals and line managers, leading HR experts Dave Ulrich and Wayne Brockbank propose The HR Value Proposition. The authors argue that HR value creation requires a deep understanding of external business realities and how key stakeholders both inside and outside the company define value. Ulrich and Brockbank provide practical tools and worksheets for leveraging this knowledge to create HR practices, build organizational capabilities, design HR strategy, and marshal resources that create value for customers, investors, executives, and employees. Written by the field's premier trailblazers, this book charts the path HR professionals must take to help lead their organizations into the future. Ulrich is a professor at the University of Michigan School of Business and the author of 12 books and more than 100 articles on the subject of human resources. Brockbank is a clinical professor of business at the University of Michigan School of Business, the author of award-winning papers on HR strategy, and an adviser to top global organizations. |
| excel training for hr professionals: Essentials of HR Management "Dr. Prathamesh S Nadkarni Dr. Saylee Anil Karande Dr. Omkar Dange Mrs. Geeta Rohankar Adlinge", 2024-05-29 Essentials of Human Resource Management is a comprehensive book by experts in the field, providing a comprehensive overview of the fundamental concepts and practices of HR. It delves into the historical evolution of HR, its functions, and the challenges faced by HR professionals in the contemporary business landscape. The book covers workforce planning, recruitment strategies, diversity, inclusiveness, training programs, performance management systems, and fostering a culture of continuous learning. It also explores compensation strategies, benefits administration, and equitable pay structures. The book incorporates the latest industry trends and best practices, equipping readers with the knowledge to tackle contemporary HR challenges. The content is presented in a straightforward manner, allowing readers to grasp and apply the concepts effectively. In a world where human resources are crucial for successful organizations, Essentials of Human Resource Management is an indispensable guide. |
| excel training for hr professionals: Hr Analytics Essentials You Always Wanted To Know Vibrant Publishers, Dr. Michael Walsh, 2021-04-06 After reading this book, you will be able to: ● Define what HR Analytics can do for an organization ● Determine the best HR analytics role for you ● Assess the readiness of your organization for undergoing a study using HR analytics ● Apply HR Analytics in various HR disciplines, including recruiting and staffing, labor negotiations, incentives, and training ● Use Excel to efficiently manage data for your HR analytics Have you ever wondered if there is a science behind the people decisions businesses make? If you have ever been curious about the methods employed by human resources professionals, then HR Analytics Essentials You Always Wanted to Know is the resource guide you need! Part overview of the field, part handbook for getting started in HR Analytics yourself, HR Analytics Essentials You Always Wanted to Know walks readers through the many benefits of using analytics to make better people decisions. HR Analytics requires more than just strong gut instincts and a talent for talking with people. As this guide shows, HR Analytics is both an art and a science that can help your organization make informed decisions that benefit all stakeholders, including employees. Through a blend of theory and practice, you will learn how to think like an HR Analytics professional and apply your expertise in real-world scenarios. With case studies and online tutorials, including a step-by-step guide for using Excel to efficiently work with your data, HR Analytics Essentials You Always Wanted to Know will be the handbook you need to help steer your organization to success. About the Author Dr. Michael Walsh is an industrial and organizational psychologist with over 15 years of human resources and people analytics experience. Michael currently leads Global Talent Management and Organizational Effectiveness for Eaton Corporation’s Vehicle Group. He also teaches a Human Resources Analytics course for master’s level students at the University of Illinois and Wayne State University. Previously, Michael’s passion for People Analytics landed him at Bloomberg and Fiat Chrysler Automobiles where he started and led the Global People Strategy and Analytics and People Analytics and Insights functions, respectively. Michael began his professional career as a client facing consultant for Mercer’s Human Capital practice focused on HR Strategy, Organizational Design/Development and Human Capital Analytics. Michael worked for Mercer in Chicago, Dubai and New York. His master’s degree is in Human Resources and Industrial Relations from the University of Illinois and his PhD is in Industrial and Organizational Psychology. About Vibrant Publishers Vibrant Publishers is focused on presenting the best texts for learning about technology and business as well as books for test preparation. Categories include programming, operating systems and other texts focused on IT. In addition, a series of books helps professionals in their own disciplines learn the business skills needed in their professional growth. Vibrant Publishers has a standardized test preparation series covering the GMAT, GRE and SAT, providing ample study and practice material in a simple and well organized format, helping students get closer to their dream universities. |
| excel training for hr professionals: Excel 2016 All-in-One For Dummies Greg Harvey, 2015-11-16 Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easily Helps to increase productivity and efficiency when working in Excel Fully updated for the new version of Excel Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again. |
| excel training for hr professionals: MOS Study Guide for Microsoft Excel Expert Exam MO-201 Paul McFedries, 2020-03-06 Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Workbook Options and Settings Manage and Format Data Create Advanced Formulas and Macros Manage Advanced Charts and Tables About the MOS: Expert Certification A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market. See full details at: microsoft.com/learn Practice Files Available at: MicrosoftPressStore.com/ MOSExcelExpert201/downloads |
| excel training for hr professionals: Leadership-Driven HR David S. Weiss, 2013-01-04 Presents a new vision for HR's role in business Focusing on strategic solutions for HR, Leadership-Driven HR challenges the traditional view of HR as a service function and replaces it with a new vision of HR as an internal business accountable for the return on investment of essential corporate assets—people and organizational processes. Leadership-Driven HR provides practical strategies for leveraging HR's role, priorities, accountabilities, and organizational design. Focuses on strategic solutions for HR, addressing current and ongoing concerns in the world of HR Dr. David Weiss is President & CEO of Weiss International Ltd., which leads innovative consulting and HR projects that generate effective strategy, leadership, innovation, and HR solutions for leaders and employees HR serves a critical role in managing your most valuable assets. Discover new ways this department can create significant ROI for your business. |
| excel training for hr professionals: Let's Talk Therese Huston, 2021-01-26 A game-changing model for giving effective feedback to peers, employees, or even your boss--without offending or demotivating. How are you supposed to tell someone that they're not meeting expectations without crushing their spirit? Regular feedback, when delivered skillfully, can turn average performers into the hardest workers and stars into superstars. Yet many see it as an awkward chore: Recent studies have revealed 37% of managers dread giving feedback, and 65% of employees wish their managers gave more feedback. This trail-blazing new model eliminates the guesswork. Dr. Therese Huston, the founding director of the Center for Excellence in Teaching and Learning at Seattle University, discovered that the key to being listened to is to listen. First, find out what kind of feedback an employee wants most: appreciation, coaching, or evaluation. If they crave one, they'll be more receptive once their need has been satisfied. Then Huston lays out counterintuitive strategies for delivering each type of feedback successfully, including: Start by saying your good intentions out loud: it may feel unnecessary, but it makes all the difference. Side with the person, not the problem: a bad habit or behavior is probably less entrenched than you think. Give reports a chance to correct inaccurate feedback: they want an opportunity to talk more than they want you to be a good talker. This handbook will make a once-stressful ordeal feel natural, and, by greasing the wheels of regular feedback conversations, help managers improve performance, trust, and mutual understanding. |
| excel training for hr professionals: Predictive HR Analytics Mong Shen Ng, 2018-11-27 You don't need to spend months learning the Python, R or SQL programming language, and you don't need to buy expensive statistical software like SPSS or SAS. This is the only book that teaches you Predictive Analytics using Microsoft Excel (which you already have & know how to use)! This book not only share with you the analytics findings of other companies, but also teaches you how to derive it by yourself! It covers the ARHAT Predictive HR Analytics framework, teaches you data-storytelling & data-visualization techniques, and teaches you how to use Microsoft Excel's statistical tools (Decision trees, Correlation, Multiple Regression, Logistic Regression, Chi-Square) with step-by-step print-screen instructions. It is also the only book that covers the full HR Analytics scope (Benefits, Compensation, Culture, Diversity & Inclusion, Engagement, Leadership, Learning & Development, Payroll, Personality Traits, Performance Management, Recruitment, Sales Incentives) with numerous real-world Predictive HR Analytics examples, & shows how Predictive HR Analytics answers questions such as: (1) Predict who are the people at risk of leaving using Decision tree, Correlation, Excel Logistic Regression, etc. (e.g. employee aged 30, who stays more than xx km from the company, who is rated average for performance, has a 90% probability of resigning in her 3rd year.). (2) Identify where the best people come from and how successful a candidate will be if hired using simple correlation (E.g. Customer Service staff and Sales staff with x & y personality traits are likely to be good performers if hired). (3) Predict impact of Employee Engagement on customer satisfaction, revenue and Shareholder Returns, etc. using Excel Multiple Regression. (e.g. 1% increase in employee engagement leads to $100k increase in company revenue, 2% increase in customer satisfaction, 1% increase in Shareholders return, 1 day reduction in average sick leave, etc.). (4) Predict financial impact of training using Excel Multiple Regression (e.g. training satisfaction rating of xx leads to $y increase in company revenue). (5) Predict Diversity & Inclusion's impact on revenue and EBIT (e.g. convert your company's ethnic diversity mix to an index number, then use Excel Multiple Regression to predict if your company's diversity Index is x --> your company's Sales will be $y and EBIT will be z%). (6) Predict employee absenteeism and accident, using Chi-Square. |
| excel training for hr professionals: The HR Companion: Human Resource Management Dr. Lamin Tombekai Kamara, 2011-04-01 The problems that the human resource manager must solve in an organization are continuously diversifying. In his activity, the human resource manager confronts with a sea of challenges, especially stemming from the ever-changing workforce and the legislation in the field. Yet, taking into account the critical character of Human Resource Management, it benefits from special attention on the part of the leadership. Human resource managers develop and work in a human resource management system. In such a system, acknowledged as efficient, variable number of activities are associated, from four to nine, as identified by the American Society for Training and DevelopmentCASTD. Considering the increasing complexity of human resource management, some authors have added more activities, such as those included in this book, as well, reckoning that it is necessary for new domains to be developed, implemented and evaluated, such as work humanization, work programs and plans of rewards regarding performance and career planning. |
| excel training for hr professionals: The Essential HR Handbook Sharon Armstrong, Barbara Mitchell, 2008-08-15 Whether you are a newly promoted manager, a seasoned business owner, or a human resources professional, knowing the ins and outs of dealing with HR issues is critical to your success. The Essential HR Handbook is a quick-reference guide that sheds light on the issues that keep managers up at night. It is filled with information, tools, tips, checklists, and road maps to guide managers and HR professionals through the maze of people and legal issues, from recruiting and retaining the best employees to terminating poor performers. With this book, You'll learn how to effectively and efficiently: Individually manage each employee, starting on his or her first day. Manage a multi-generational workforce. Appraise job performance. Coach and counsel. Provide equitable pay, benefits, and total rewards strategies. Identify legal pitfalls and stay out of court. The Essential HR Handbook is the one HR guide every manager needs on his or her desk! |
| excel training for hr professionals: Human Resource Management Hasanraza Ansari, 2021-06-25 Human Resource Management is an operation in companies, designed to maximize employee performance in order to meet the employer's strategic goals and objectives. It is a process of recruiting, selecting employees, providing proper orientation, induction, and training, and developing skills. This is a brief introductory book that explains the methodologies applied in the rapidly growing area of Human Resource Management. In addition, it also explains the issues that we come across while managing workforce diversity and the major challenges faced by HRM. This book will be useful for students from management streams who aspire to learn the basics of Human Resource Management. Professionals, especially HR managers, regardless of which sector or industry they belong to, can use this book to learn how to apply the methods of Human Resource Management in their respective project environments. Human resource management (HRM or HR) is the strategic approach to the effective and efficient management of people in a company or organization such that they help their business gain a competitive advantage. ... HR professionals manage the human capital of an organization and focus on implementing policies and processes. Human Resource Management teaches HRM strategies and theories that any manager—not just those in HR needs to know about recruiting, selecting, training, and compensating people. |
| excel training for hr professionals: Excel 2019 Bible Michael Alexander, Richard Kusleika, John Walkenbach, 2018-09-20 The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance. |
| excel training for hr professionals: Dianne Auld's Excel Tips Dianne Auld, 2020-10-30 While the role of today's total rewards professionals has become more strategic and business-oriented, some fundamentals of the job will always hold true. One such fundamental is math. Focusing on how to use Excel for compensation work, Excel guru and WorldatWork faculty member, Dianne Auld continues to pack this latest edition full with powerful tools so you can tackle even your biggest data projects. This book includes the ever-useful compensation and benefits formulas presented in previous editions, PLUS discover how to put dynamic arrays and power query to work! This new edition reflects the most current versions of software: Excel 2019 and Microsoft 365. You'll gain tips, tricks and formulas so Excel works for you, employing ASAP utilities, array formulas, power queries, etc. when building charts, regression analyses, pivot tables and more. This book is a must-have, go-to resource for every compensation and benefits professional. Now with Power Query and Dynamic Arrays! Gain tips, tricks and formulas so Excel does the math for you when building charts, regression analyses, pivot tables and more. Reflects current versions of Excel 2019 and Microsoft 265 including Power Query and Dynamic Arrays. |
| excel training for hr professionals: ADKAR Jeff Hiatt, 2006 In his first complete text on the ADKAR model, Jeff Hiatt explains the origin of the model and explores what drives each building block of ADKAR. Learn how to build awareness, create desire, develop knowledge, foster ability and reinforce changes in your organization. The ADKAR Model is changing how we think about managing the people side of change, and provides a powerful foundation to help you succeed at change. |
| excel training for hr professionals: Predictive Analytics for Human Resources Jac Fitz-enz, John Mattox, II, 2014-07-09 Create and run a human resource analytics project with confidence For any human resource professional that wants to harness the power of analytics, this essential resource answers the questions: Where do I start? and What tools are available? Predictive Analytics for Human Resources is designed to answer these and other vital questions. The book explains the basics of every business—the vision, the brand, and the culture, and shows how predictive analytics supports them. The authors put the focus on the fundamentals of predictability and include a framework of logical questions to help set up an analytic program or project, then follow up by offering a clear explanation of statistical applications. Predictive Analytics for Human Resources is a how-to guide filled with practical and targeted advice. The book starts with the basic idea of engaging in predictive analytics and walks through case simulations showing statistical examples. In addition, this important resource addresses the topics of internal coaching, mentoring, and sponsoring and includes information on how to recruit a sponsor. In the book, you'll find: A comprehensive guide to developing and implementing a human resource analytics project Illustrative examples that show how to go to market, develop a leadership model, and link it to financial targets through causal modeling Explanations of the ten steps required in building an analytics function How to add value through analysis of systems such as staffing, training, and retention For anyone who wants to launch an analytics project or program for HR, this complete guide provides the information and instruction to get started the right way. |
| excel training for hr professionals: The HR Value Proposition David Ulrich, Wayne Brockbank, 2005 The authors provide practical tools to build organizational capabilities, design HR strategy, and marshal resources that create value for customers, investors, executives, and employees. |
| excel training for hr professionals: Strategic Human Resource Management and Development Richard Regis, 2008 Strategic Human Resource Management has been a topic familiar to many. But this book approaches the same topic in a current global economy with so many Indian business houses venturing into acquiring global giants and establishing themselves atop of the world of business in our growing economy. This means that with electronic communication making the world into a global village and virtual organizations and learning having made the distinction between 'place' and 'space' not a matter of importance, strategies to be adapted by the HR professionals should be totally new. That is where this book is having a new approach to SHRM. It is interspersed with contemporary Indian cases and experience to fall back on to illustrate the different strategies HR has to play as a business partner. Issues in employee privacy in case of virtual organizations have been vividly dealt with. Gone are the days of the fire-fighting role of HR professionals. They are required to play a vital role being part of the business strategy not only at the domestic arena but also in the global business. Challenges involved in building multicultural organizations, cross border merger and acquisition and repatriation and outsourcing are topics that are significant in the local as well as the global human resource management which are discussed extensively. The book explains career planning and development and compensation packages in the context of competencies and balanced scorecard. When speed and alacrity are demanded of all the employees to stay ahead of competition, the employees are required to put in extended hours and work in a stressful environment. Hence, the new-era HR professional has to resort to developmental activities through mentoring, coaching, counseling, stress management and emotional balance. The book is divided into five parts. Apart from the stories narrated within the text of the book, and some exercises, there is a separate section of cases at the end of the book to augment the concepts narrated in each part. It would not only fully meet the requirements of MBA students but would also give new direction to the practicing HR professionals. |
| excel training for hr professionals: Articles in ITJEMAST @ 13(9) 2022 , Published articles in ITJEMAST 13(9) 2022 |
| excel training for hr professionals: Introduction to Business Lawrence J. Gitman, Carl McDaniel, Amit Shah, Monique Reece, Linda Koffel, Bethann Talsma, James C. Hyatt, 2024-09-16 Introduction to Business covers the scope and sequence of most introductory business courses. The book provides detailed explanations in the context of core themes such as customer satisfaction, ethics, entrepreneurship, global business, and managing change. Introduction to Business includes hundreds of current business examples from a range of industries and geographic locations, which feature a variety of individuals. The outcome is a balanced approach to the theory and application of business concepts, with attention to the knowledge and skills necessary for student success in this course and beyond. This is an adaptation of Introduction to Business by OpenStax. You can access the textbook as pdf for free at openstax.org. Minor editorial changes were made to ensure a better ebook reading experience. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution 4.0 International License. |
| excel training for hr professionals: Managing Human Resource And Industrial Relations Tapomoy Deb, 2009 |
| excel training for hr professionals: The SAGE Glossary of the Social and Behavioral Sciences Larry E. Sullivan, 2009-08-31 The SAGE Glossary of the Social and Behavioral Sciences provides college and university students with a highly accessible, curriculum-driven reference work, both in print and on-line, defining the major terms needed to achieve fluency in the social and behavioral sciences. Comprehensive and inclusive, its interdisciplinary scope covers such varied fields as anthropology, communication and media studies, criminal justice, economics, education, geography, human services, management, political science, psychology, and sociology. In addition, while not a discipline, methodology is at the core of these fields and thus receives due and equal consideration. At the same time we strive to be comprehensive and broad in scope, we recognize a need to be compact, accessible, and affordable. Thus the work is organized in A-to-Z fashion and kept to a single volume of approximately 600 to 700 pages. |
| excel training for hr professionals: Human Resource Development R. Krishnaveni, 2008-05-31 Human Resource Development (HRD) is fundamental in generating and implementing the tools needed to manage and operate the organization right from the production, management, marketing and sales to research and development, in order to be more productive. This can be done by making people sufficiently motivated, trained, informed, managed, utilized and empowered. Thus, HRD forms a major part of human resource management activities in the organizations.This book has been carefully developed keeping in mind the requirements of all the varied segments that could use this book extensively and specifically for the students who have chosen HR elective and scholars pursuing research in the broad field of HR.The book is divided into nineteen chapters and each chapter is backed by illustrations, exercises and case studies, appropriately. The first two chapters start with the introduction to the field. The third and fourth chapters give an introduction to how HRD plays a role in learning the behavior of employees. Rest of the chapters - five to eighteen - deal with various functions of HRD. Finally, the last chapter brings out a detail methodology of how to develop a validated instrument which could be used for survey research in the HR field.The book has been written in very simple and easily understandable manner with relevant quoted references from earlier researches in this field. This will definitely help the readers to refer the source material, if detail reading is required. |
Excel for HR Training (26 Courses Bundle, Online Certification)
This Excel for HR Training is a comprehensive training of 26 courses with 187 hours of video tutorials and One year access and several mock tests for practice. Unlock the potential of …
Excel for HR Professionals - Rapid Computer Training Inc.
Jun 5, 2025 · Learn a variety of Excel functions for tackling quantitative tasks for effective decision making. Orient your approach towards automating tasks with logical functions and reducing …
Excel for HR Professionals: Human Resources Excel lence: A ...
Mar 30, 2025 · Excel is an indispensable tool for HR professionals, offering a versatile platform for organizing, analyzing, and reporting on employee data. Its robust features and functions can …
Excel Training for HR Professionals
Transform the way you manage HR data, support organizational decisions, and drive HR strategy with our Excel Training for HR Professionals. Whether you’re looking to streamline HR …
Excel Skills for HR and Admin Professionals |Meirc
Excel tools enable us to be more productive and efficient. By attending, participants will learn to leverage the powerful features of Excel for HR, auditing and other HR tasks. Explore the use …
The Modern Excel for HR Professionals
6.2 Excel Templates for HR Processes • Creating templates for HR documentation (e.g., employee records, performance reviews) • Automating routine HR tasks with templates
Hands-On Microsoft Excel Training for HR Professionals and ...
Jul 10, 2024 · High-quality Excel training for HR professionals can make it easier to record applicant information and interpret it, ensuring that they hire the perfect person for a particular …
Excel for HR Training (26 Courses Bundle, Online Certification)
This Excel for HR Training is a comprehensive training of 26 courses with 187 hours of video tutorials and One year access and several mock tests for practice. Unlock the …
Excel for HR Professionals - Rapid Computer Training Inc.
Jun 5, 2025 · Learn a variety of Excel functions for tackling quantitative tasks for effective decision making. Orient your approach towards automating tasks with logical …
Excel for HR Professionals: Human Resources Excel lence: A ...
Mar 30, 2025 · Excel is an indispensable tool for HR professionals, offering a versatile platform for organizing, analyzing, and reporting on employee data. Its robust …
Excel Training for HR Professionals
Transform the way you manage HR data, support organizational decisions, and drive HR strategy with our Excel Training for HR Professionals. Whether you’re looking to …
Excel Skills for HR and Admin Professionals |Meirc
Excel tools enable us to be more productive and efficient. By attending, participants will learn to leverage the powerful features of Excel for HR, auditing and other HR tasks. …
