Advertisement
| free 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. |
| free 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 |
| free 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. |
| free 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. |
| free 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! |
| free excel training for hr professionals: Credit Repair Organizations Act (H.R. 458) United States. Congress. House. Committee on Banking, Finance, and Urban Affairs. Subcommittee on Consumer Affairs and Coinage, 1988 |
| free 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 |
| free 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. |
| free 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. |
| free excel training for hr professionals: Manpower Development for Technological Change , |
| free excel training for hr professionals: HRM Core Concepts Jean Phillips, 2019-01-15 Formerly published by Chicago Business Press, now published by Sage In HRM Core Concepts, author Jean Phillips provides a concise yet comprehensive overview of human resource management. The central theme of this text is to prepare your students to effectively apply HRM concepts in the areas of hiring, developing, motivating, and retaining the right people, enabling them to become better managers and more effective leaders. |
| free 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. |
| free excel training for hr professionals: Introducing Microsoft Power BI Alberto Ferrari, Marco Russo, 2016-07-07 This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:http://aka.ms/analyzingdata/details. Learn more about Power BI at https://powerbi.microsoft.com/. |
| free excel training for hr professionals: Human Resource Management Talya Bauer, Berrin Erdogan, David Caughlin, Donald Truxillo, 2024-01-02 Human resources is rapidly evolving into a data-rich field but with big data comes big decisions. The best companies understand how to use data to make strategic workforce decisions and gain significant competitive advantage. Human Resource Management: People, Data, and Analytics, Second Edition by Talya Bauer, Berrin Erdogan, David Caughlin, and Donald Truxillo introduces students to the fundamentals of talent management with integrated coverage of analytics in every chapter. Features tied to SHRM competencies and data exercises give students hands-on opportunities to practice the analytical and decision-making skills they need to excel in today’s job market. Whether your students are future managers or future HR professionals, they will learn best practices for managing talent across the lifecycle in the changing workplace. |
| free excel training for hr professionals: Artificial Intelligence with Python Prateek Joshi, 2017-01-27 Build real-world Artificial Intelligence applications with Python to intelligently interact with the world around you About This Book Step into the amazing world of intelligent apps using this comprehensive guide Enter the world of Artificial Intelligence, explore it, and create your own applications Work through simple yet insightful examples that will get you up and running with Artificial Intelligence in no time Who This Book Is For This book is for Python developers who want to build real-world Artificial Intelligence applications. This book is friendly to Python beginners, but being familiar with Python would be useful to play around with the code. It will also be useful for experienced Python programmers who are looking to use Artificial Intelligence techniques in their existing technology stacks. What You Will Learn Realize different classification and regression techniques Understand the concept of clustering and how to use it to automatically segment data See how to build an intelligent recommender system Understand logic programming and how to use it Build automatic speech recognition systems Understand the basics of heuristic search and genetic programming Develop games using Artificial Intelligence Learn how reinforcement learning works Discover how to build intelligent applications centered on images, text, and time series data See how to use deep learning algorithms and build applications based on it In Detail Artificial Intelligence is becoming increasingly relevant in the modern world where everything is driven by technology and data. It is used extensively across many fields such as search engines, image recognition, robotics, finance, and so on. We will explore various real-world scenarios in this book and you'll learn about various algorithms that can be used to build Artificial Intelligence applications. During the course of this book, you will find out how to make informed decisions about what algorithms to use in a given context. Starting from the basics of Artificial Intelligence, you will learn how to develop various building blocks using different data mining techniques. You will see how to implement different algorithms to get the best possible results, and will understand how to apply them to real-world scenarios. If you want to add an intelligence layer to any application that's based on images, text, stock market, or some other form of data, this exciting book on Artificial Intelligence will definitely be your guide! Style and approach This highly practical book will show you how to implement Artificial Intelligence. The book provides multiple examples enabling you to create smart applications to meet the needs of your organization. In every chapter, we explain an algorithm, implement it, and then build a smart application. |
| free excel training for hr professionals: 101 Best Excel Tips & Tricks Bryan Hong, John Michaloudis, 2021-03-19 Learn the Best Excel Tips & Tricks Ever: FORMULAS, MACROS, PIVOT TABLES, FORMATTING, DATA, MICROSOFT OFFICE 365 plus Many More! With this book, you'll learn to apply the must know Excel features and tricks to make your data analysis & reporting easier and will save time in the process. With this book you get the following: ✔ 101 Best Excel Tips & Tricks To Advance Your Excel Skills & Save You Hours ✔ New Excel Tips & Tricks for Microsoft Office 365 ✔ Easy to Read Step by Step Guide with Screenshots ✔ Downloadable Practice Excel Workbooks for each Tip & Trick ✔ You also get a FREE BONUS downloadable PDF version of this book! This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Microsoft Excel FAST & stand out from the crowd! |
| free excel training for hr professionals: Training , 1991 |
| free excel training for hr professionals: VBA and Macros Bill Jelen, Tracy Syrstad, 2010 Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010. |
| free 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. |
| free excel training for hr professionals: 101 Most Popular Excel Formulas John Michaloudis, Bryan Hong, 2022-02-17 Learn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, plus Many More! You'll learn to apply the Top Excel Formulas to make your data analysis easier. |
| free excel training for hr professionals: Human Resource Management in Public Service Evan M. Berman, 2006 Effective human resource management is a critical function in today′s public workplace, and the authors have written a book that helps readers develop key skills for success while also reminding them of the complex puzzles and paradoxes of management in the public sector. The Second Edition has been completely revised and updated to reflect changes in practice, policy, law and scholarship and has been carefully crafted to be an effective learning tool, with learning objectives, chapter reviews, and three sets of end-chapter study questions (class discussion, team activities, and individual assignments). The book concludes with a comprehensive glossary, and interesting and illuminating examples are liberally scattered throughout the book. |
| free 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. |
| free 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 |
| free excel training for hr professionals: Human Resource Executive , 1996-07 |
| free excel training for hr professionals: 101 Ready To Use Microsoft Excel Macros John Michaloudis, Bryan Hong, 2022-03-09 Get access to 101 Ready To Use Excel Macros that you can use straight away to your Excel workbooks & reports so you can SAVE HOURS each day! With this book you get the following cool features: ✔ Access 101 Ready To Use Macros with VBA Code which your can Copy & Paste to your Workbook straight away & SAVE HOURS ✔ Easy to Read Step by Step Guide with Screenshots ✔ Downloadable Practice Workbooks with VBA Code included ✔ You get the following Macros: Chart, Formulas, Highlighting, Pivot Table, Printing, Workbook, Worksheet, PDF, Email & Advanced Macros! ✔ You also get a FREE BONUS downloadable PDF version of this book! ✔ Exclusive to Hardcover: You also get a FREE BONUS 20+ Hour Excel Course with 77 video tutorials! This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Excel Macros FAST & Stand Out From The Crowd! |
| free excel training for hr professionals: Selling Big to China Morry Morgan, 2011-03-10 This book is a complete sales and negotiating guide for mainland China and includes practical and measurable techniques that have been tested and proven to work with Fortune 500 companies operating in the 'Middle Kingdom'. It is divided into four main areas: The Knowledge The Sales Call The Negotiation The Maintenance The book is the result of my 8 years of training in sales and negotiation skills across mainland China, as well as running a multi-city, multicultural company in the 'World's Most Stressful Country' (according to Newsweek). The book includes a collection of anecdotes from this experience, as well as case studies developed by working closely with leading companies in China. Some of these companies include Rockwell Automation, Microsoft, Thomson, SAP, and NBC. Sales and negotiating is not easy, particularly when done in a country with completely new values and rules of engagement. The purpose of this book is to lay the rules out clearly, and provide the reader with an easy to understand strategy to doing business in mainland China. |
| free excel training for hr professionals: Human Resource Management Robert N. Lussier, John R. Hendon, 2017-11-30 Whether your students are HRM majors or general business majors, Human Resource Management: Functions, Applications, and Skill Development, Third Edition, will help them build the skills they need to recruit, select, train, and develop talent. Bestselling authors Robert N. Lussier and John R. Hendon explore the important strategic function HR plays in today′s organizations. A wide variety of applications, self-assessments, and experiential exercises keep students engaged and help them see the relevancy of HR as they learn skills they can use in their personal and professional lives. A Complete Teaching & Learning Package SAGE Premium Video Included in the interactive eBook! SAGE Premium Video tools and resources boost comprehension and bolster analysis and illustrate HRM in action. Watch this video on Culture Shock for a preview. Learn more. Interactive eBook Includes access to SAGE Premium Video, multimedia tools, and much more! Save when you bundle the interactive eBook with the new edition. Order using bundle ISBN: 978-1-5443-2106-6. Learn more. SAGE coursepacks FREE! Easily import our quality instructor and student resource content into your school’s learning management system (LMS) and save time. Learn more. SAGE edge FREE online resources for students that make learning easier. See how your students benefit. |
| free 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. |
| free 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. |
| free excel training for hr professionals: Assessment Centers in Human Resource Management George C. Thornton III, Deborah E. Rupp, 2006-08-15 Explores the evolution of the goals of assessment center programs and the ways in which assessment centers and their component parts have been used. This book differentiates between assessment centers used for prediction, diagnoses, and development. It also explores court cases involving assessment centers, assessor training, and more. |
| free 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. |
| free excel training for hr professionals: The Art of Statistics David Spiegelhalter, 2019-09-03 In this important and comprehensive guide to statistical thinking (New Yorker), discover how data literacy is changing the world and gives you a better understanding of life’s biggest problems. Statistics are everywhere, as integral to science as they are to business, and in the popular media hundreds of times a day. In this age of big data, a basic grasp of statistical literacy is more important than ever if we want to separate the fact from the fiction, the ostentatious embellishments from the raw evidence -- and even more so if we hope to participate in the future, rather than being simple bystanders. In The Art of Statistics, world-renowned statistician David Spiegelhalter shows readers how to derive knowledge from raw data by focusing on the concepts and connections behind the math. Drawing on real world examples to introduce complex issues, he shows us how statistics can help us determine the luckiest passenger on the Titanic, whether a notorious serial killer could have been caught earlier, and if screening for ovarian cancer is beneficial. The Art of Statistics not only shows us how mathematicians have used statistical science to solve these problems -- it teaches us how we too can think like statisticians. We learn how to clarify our questions, assumptions, and expectations when approaching a problem, and -- perhaps even more importantly -- we learn how to responsibly interpret the answers we receive. Combining the incomparable insight of an expert with the playful enthusiasm of an aficionado, The Art of Statistics is the definitive guide to stats that every modern person needs. |
| free excel training for hr professionals: Remote Work Revolution Tsedal Neeley, 2021-03-30 LONGLISTED FOR THE FINANCIAL TIMES & MCKINSEY BUSINESS BOOK OF THE YEAR “I often talk about the importance of trust when it comes to work: the trust of your employees and building trust with your customers. This book provides a blueprint for how to build and maintain that trust and connection in a digital environment.” —Eric S. Yuan, founder and CEO of Zoom A Harvard Business School professor and leading expert in virtual and global work provides remote workers and leaders with the best practices necessary to perform at the highest levels in their organizations. The rapid and unprecedented changes brought on by Covid-19 have accelerated the transition to remote working, requiring the wholesale migration of nearly entire companies to virtual work in just weeks, leaving managers and employees scrambling to adjust. This massive transition has forced companies to rapidly advance their digital footprint, using cloud, storage, cybersecurity, and device tools to accommodate their new remote workforce. Experiencing the benefits of remote working—including nonexistent commute times, lower operational costs, and a larger pool of global job applicants—many companies, including Twitter and Google, plan to permanently incorporate remote days or give employees the option to work from home full-time. But virtual work has it challenges. Employees feel lost, isolated, out of sync, and out of sight. They want to know how to build trust, maintain connections without in-person interactions, and a proper work/life balance. Managers want to know how to lead virtually, how to keep their teams motivated, what digital tools they’ll need, and how to keep employees productive. Providing compelling, evidence-based answers to these and other pressing issues, Remote Work Revolution is essential for navigating the enduring challenges teams and managers face. Filled with specific actionable steps and interactive tools, this timely book will help team members deliver results previously out of reach. Following Neeley’s advice, employees will be able to break through routine norms to successfully use remote work to benefit themselves, their groups, and ultimately their organizations. |
| free 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. |
| free excel training for hr professionals: Intermediate Microeconomics with Microsoft Excel Humberto Barreto, 2009-06-15 This unique text uses Microsoft Excel® workbooks to instruct students. In addition to explaining fundamental concepts in microeconomic theory, readers acquire a great deal of sophisticated Excel skills and gain the practical mathematics needed to succeed in advanced courses. In addition to the innovative pedagogical approach, the book features explicitly repeated use of a single central methodology, the economic approach. Students learn how economists think and how to think like an economist. With concrete, numerical examples and novel, engaging applications, interest for readers remains high as live graphs and data respond to manipulation by the user. Finally, clear writing and active learning are features sure to appeal to modern practitioners and their students. The website accompanying the text is found at www.depauw.edu/learn/microexcel. |
| free excel training for hr professionals: Managing Human Resource And Industrial Relations Tapomoy Deb, 2009 |
| free 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. |
| free excel training for hr professionals: Professional Excel Development Rob Bovey, 2009 The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications. |
| free excel training for hr professionals: Practical Guide to Project Planning Ricardo Viana Vargas, 2007-10-01 Practical Guide to Project Planning is filled with project documents and templates ready to use for planning and managing project. It explains project analysis and modeling techniques so these documents and templates can be used for effective project management. In addition, the book is also a guide to best practices that comply with the PMI |
| free excel training for hr professionals: Human Resources Kit For Dummies Max Messmer, 2012-11-08 Align HR practices with your objectives and keep your company competitive A company's ability to grow and stay on top of customer demand has always depended heavily on the quality of its people. Now, more than ever, businesses recognize that finding (and keeping) a highly skilled and motivated workforce is pivotal to success. Maybe you're a business owner and your company is growing, or you're an employee at a small- to midsize-company and management has asked you to take on some—or all—of their HR functions. Either way, knowing how to set up and implement successful HR practices (not to mention navigating the legal minefields in today's increasingly regulated environment) can be tricky. Human Resources Kit For Dummies is your one-stop resource for learning the nuts and bolts of HR. It gives you forms and templates that you can put to immediate and productive use. New information on anti-discrimination legislation; measuring performance; hiring, firing, and retaining employees; and training and development plans The latest info on online and social media policies Updated forms and contracts, from job application forms and sample employee policies to performance appraisals and benefit plan worksheets If you're currently working in Human Resources or are responsible for employees in your business, the tools presented here help you maximize the effectiveness of your own HR program. |
FreeCell - Play Online & 100% Free | Solitaired.com
Play FreeCell for free with no download or registration required. Similar to Solitaire, this game lets you to move cards to free open cells as you arrange them.
Play 100% Free Games | Instant & Online | FreeGames.org
The BAFTA nominated free games website. Play online Mahjong, Bubble Shooter, Solitaire, Unfold, Match Drop and so much more. Play now instantly!
Free Online Games at Poki - Play Now!
Poki has the best free online games selection and offers the most fun experience to play alone or with friends. We offer instant play to all our games without downloads, login, popups or other …
Best Free Games Online - MSN Play
Looking for the best free Card, Puzzle, Match 3, Arcade, Classic, Sports, Strategy, Racing, Family, Word games online? At MSN Play, play top-rated games like Video Poker Multihand, …
Freepik | Create great designs, faster
Millions of free graphic resources. Photos AI images Vectors Icons Templates Videos. Find out about our real-time AI art generator.
Canva Free | Design anything, together and for free
Design made easy with Canva Free. Find thousands of free templates and tools to create stunning visual content, no design experience needed.
TheFreeSite.com offers free stuff, freebies, free product samples ...
TheFreeSite.com offers freebies and freeware. We offer free stuff including free samples, fonts, games, graphics, mobile phone downloads, anonymous browsing services, Webmaster …
Free Stuff, Product Samples, Free Electronics & Deals | OFree
5 days ago · Get Free Appliances, Electronics, Household Goods, or Shopping Vouchers from Nielsen! Claim top product samples, free gadgets, trial products, discount codes & giveaways. …
Crackle - Streaming Free Movies & TV Shows Online
Crackle is one of the most popular free streaming services available today. Launched in 2004 as Grouper, it was later acquired by Sony and rebranded as Crackle, offering a vast library of …
Free Games
Epic Games Store gives you a free game every week. Come back often for the exclusive offers. Download a free game to play or join a free-to-play game community today. Get Aurora …
EXCEL FOR HUMAN RESOURCES - irp-cdn.multiscreensite.com
This course is ideal for Human Resource professionals who would like to improve their Excel skills. Objective To gain confidence in using Excel to manipulate and report on HR specific …
A PROJECT REPORT A study on HR Practices in Fortis …
Fortis Healthcare, Bangalore. Training is very important and very essential to each and every firm. Training helps to acquire new skill and knowledge, a sample of 100 employees taken for this …
LEARN VBA FOR EXCEL - Automate Excel
You can program VBA to do anything within Excel by referencing the appropriate objects, properties, and methods. You have now created a sub titled “HelloWorld”. You will notice that …
Bridging the gap: why, how and when HR analytics can impact ...
when HR analytics can impact organizational performance Steven McCartney School of Business, Maynooth University, Maynooth, Ireland, and Na Fu Trinity Business School, Trinity College …
50 Must-Know Excel Essentials - myonlinetraininghub.com
Excel shortcuts in one place!! Psst... shortcuts included... 7 Must-Know Data Validation Techniques Drop-down Lists: (Data tab > Data Validation > List) Use Case: Create a list of …
ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS - ResearchGate
Comprehensive Training: Implementing tailored AI training programs for HR professionals. Ethical AI Frameworks: Establishing ethical guidelines for AI deployment in HR.
Fundamentals of GD&T
7 Commonly Used GD&T Terms & Symbols: GD&T symbols are known universally as a method of specifying requirements without using notes or words on the drawing. The symbols are …
HUMAN RESOURCES ACADEMY - Kentucky
Human Resource Generalist (HRG) role as well as additional courses identified to grow them as HR professionals. These courses cover HR fundamentals and other critical HR functions, …
Excel University Volume 3 Featuring Excel 2013 For Windows …
2 A corresponding PivotChart can visually represent this data, making trends immediately apparent. Data Validation: This feature ensures data integrity by limiting input to specific …
Strategic Recruitment Plan Template - Partnership for Public …
HR professionals and hiring managers, and applicant tracking system optimization. DETERMINE ACCOUNTABILITY FOR THE STRATEGY Begin the strategic recruitment plan process by …
HEALTHCARE PROFESSIONALS MANUAL - Department of …
2.5.1. require all Healthcare Professionals to comply with certain requirements of best practice and to act in accordance with the highest ethical standards, 2.5.2. require Healthcare …
SHRM Body of Applied Skills and Knowledge
was designed primarily to meet the needs of HR professionals studying for the SHRM-CP and SHRM-SCP exams. Because the certification exams have been based on the SHRM BoCK, …
Annual Corporate Compliance Calendar (FY 2024-25) - Krayman
The due dates mentioned above are as per relevant Acts, Notifications, Circulars and Press Releases issued till 18 April 2024. The information contained in this document have been …
An Hr Dashboard Is A Series Of Indicators That
An Hr Dashboard Is A Series Of Indicators That Gaining Strategic Insights: How an HR Dashboard Transforms Your Workforce Data into Actionable Knowledge Problem: HR …
Excel Formulas & Functions for HR Professionals
%PDF-1.7 %µµµµ 1 0 obj >/Metadata 103 0 R/ViewerPreferences 104 0 R>> endobj 2 0 obj > endobj 3 0 obj >/ExtGState >/XObject >/ProcSet[/PDF/Text/ImageB/ImageC ...
US Employment Law and Compliance - SHRM
Intended Audience HR professionals at all levels Delivery Options 2-Day In-Person or Live Online HR Competencies • Ethical Practice • Communication • HR Expertise (HR Knowledge)
The SHRM Body of Competency and Knowledge
HR professionals apply to their jobs, and Behavioral Competencies reflect how they apply this knowledge. A competency model is a set of competencies that collectively defines the …
The Case for Employee Experience - SHRM
Arguably, this reflects HR professionals’ training in organizational strategy. HR PROFESSIONALS WORKERS The work that you do 17.7% The work that you do 19.8% Your manager Your …
HR Board Report Template Guide AIHR - AIHR | Academy to …
Effectively communicate HR priorities, impact, and risks to key stakeholders with this ready-to-use HR board report template! In this guide: 1 Executive summary Page 4. 2 Workforce profile ...
Professional Certificate Programme in HR Management and …
(HR) Manager with 10-19 years of experience earns an average total compensation of ... professionals. Fully Online Programme that avoids disturbing your current professional and …
Introduction to Advanced Excel Essentials
another name for this book could be A Contrarian’s Guide To Excel Development. You see, this book will push back against the wisdom of other terrific Excel books, including my favorite …
SHRM Total Rewards Specialty Credential
The goal of this eLearning course is to provide HR Professionals guidance on reviewing their rewards strategy by ensuring all employees are paid equitably and rewarded equally. By doing …
BUSINESS TRIP REPORT TEMPLATE - Smartsheet
business trip report template trip name / id participant(s) start date end date report prepared by date of report business trip overview departing from
Test Results and Interview Guide - hravatar.com
basic tasks using MS Office 365 Excel software. Interpretation: Candidate should achieve above average job performance in this area with little or no training. Scores indicate a good working …
Six Sigma: A Complete Step-by-Step Guide: A Complete …
In applying Six Sigma, organizations, teams, and project managers seek to implement strategies that are based on measurement and metrics. Historically, many business leaders
FUNDAMENTALS OF HR ANALYTICS - Emerald Insight
HR professionals but also for senior managers. — James Allan, CEO of Sable Metals & Minerals, South Africa ... Training and Development 121 7. Strategic Resourcing 143 8. Recruitment 167 …
HR Professional Training Program - Oregon.gov
HR Professional Training Program Functions of Human Resources in Oregon State Government Updated 10/24/24 Page 1. OVERVIEW: The purpose of this training program is to provide HR …
TO REGISTER: Simply go online to www.snef.org
To REGISTER, simply go online to Register and to reserve a seat for you or your people to obtain the Comp 101 for HR professionals. Or simply email SNEF at: darren_lim@snef.org.sg or …
Supplemental guide to the GDPR for HR professionals - g L
Jan 1, 2018 · for HR professionals Version 1.0, January 2018 The General Data Protection Regulation (GDPR) will come into force on 25 May 2018, representing the most significant …
AI IN THE WORKPLACE - Cloudinary
• “ChatGPT and HR: A Primer for HR Professionals.” • “Generative Artificial Intelligence and the Workforce” report from SHRM and The Burning Glass Institute. How AI is enhancing human …
HR analytics case study collection - AIHR
More HR Analytics resources Video: 5 HR Analytics Case Studies Cheat Sheet: 51 HR Metrics Watch now Download PDF In this 30-minute webinar, you will see HR Analytics in action at …
SHRM Workplace Investigations Specialty Credential
require careful attention from HR professionals including when and how to engage external counsel, what justifies a formal investigation, effective interviewing and data gathering, …
An Hr Dashboard Is A Series Of Indicators That
An Hr Dashboard Is A Series Of Indicators That Gaining Strategic Insights: How an HR Dashboard Transforms Your Workforce Data into Actionable Knowledge Problem: HR …
Build and develop HR skills and capabilities. - U.S. Office of ...
Specialized Training for HR Professionals Build HR knowledge and skills with specialized courses from OPM’s Federal HR Institute. Our comprehensive HR development program is the only …
HR METRICS DASHBOARD: A TOOLKIT
An HR metrics dashboard can contribute to evidencing progress against key aspects of the CHS which relate to HR strategy and outcomes relating to staff and volunteer resourcing and …
1 30% 2 50% 3 70% 4 50% 5 50% - dynamicssquare.com
In July 2011, Project Crescent was available free to download for the public, combined with the SQL Server Codename Denali. In September 2013, Project Crescent was renamed Power BI …
The Diversity, Equity and Inclusion (DEI) Metrics Inventory - MI …
DEI Training • Percentage of employees participating in DEI-specific training • Percentage of managers participating in DEI-specific training • Scores or ratings of trainings • Number of DEI …
Excel 2016 Level 1 - tcworkshop.com
Page 4 Excel 2016: Level 1, Rel. 2.0, 10/01/2018 Starting Excel There are a number of ways to start the Excel program: Using the Shortcut on the Desktop Look for the Excel 2016 icon on …
HR salary guide UK - Frazer Jones
HR metrics are becoming more important within HR, businesses have looked to hire HRIS professionals, with salaries reflecting demand. Conversely, demand for talent acquisition …
Successful HR Strategies for Building an Ethical Workplace …
HR Ethical Culture Strategies 30 Ethics and Compliance Programs The most effective ethics and compliance programs are integrated closely with training and development departments and …
HR for NON-HR Professionals Guide - h3hr.com
4. Provide Training and Resources: Offer structured training. tailored to the employee’s role, such as software tutorials, product. knowledge, and compliance training. Make sure they have …
Nursing Home Staffing Study - Centers for Medicare
LIST OF EXHIBITS . Abt Associates Nursing Home Staffing Study Comprehensive Report June 2023 v . Exhibit 4.9: Predicted Probability of Exceeding Minimum Acceptable Standards for
How Microsoft is reinventing Human Resources with …
HR Business Partners. Priority use cases that have delivered impactful results across roles and processes include: AskHR Virtual Agent (HR Support)— An employee self-service tool that …
Free Training Available for State of Georgia Employees
Free Training Available for State of Georgia Employees The Department of Administrative Services (DOAS), Human Resources Administration (HRA), in collaboration with Enterprise …
Example CPD plan and record - HR Manager - Agile Business
If your organisation doesn't have regular performance appraisals or plan training, you can find advice on planning your CPD here Dates covered: December 2022 - November 2023 Name: …
101 Ready-to-Use Excel Formulas - Archive.org
Apr 5, 2017 · Chapter 1: Introducing Excel Formulas 1. Creating and Editing Excel Formulas 1. Methods for entering formulas 2. Editing a formula 2. Using Formula Operators 1. …
CERTIFIED HUMAN RESOURCE PROFESSIONALS (CHRP) …
governing the HR profession 2.2 The Constitution 2.3 Labour Laws 2.4 Role of Ministry of Labour, IHRM, SCAC, SRC, HRMPEB 2.5 Code of conduct for HR professionals 3. Theories and …
Essential soft skills for workplace success
Workplace Essentials Essential soft skills for workplace success This guide will help you: • understand what employability skills are • learn about the Employability Skills: Workplace …
Business Acumen for HR Professionals
important for HR professionals to purposefully focus on the cultivation of business acumen. This is a book designed for HR leaders and managers who have a desire to revitalize this profession …
Change Management Toolkit - University of California, Berkeley
Why is a change management toolkit necessary? In the 21st century we are surrounded by constant innovation, technology enhancements, and a connection to a global network, all of …
