This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace. To follow along with the content and activities in this course, you will need access to Microsoft Excel. This course features Excel 2019, which may differ from other versions of Excel.

For more information or to register please click the link.

This course examines some of the most significant federal statutes and legal cases relevant to human resource professionals. It also presents ethical and legal arguments to HR professionals for how proactive compliance can better support and protect their organizations. Human resource professionals must not only be able to identify federal and state law requirements, but also identify potential legal issues in their workplaces, assess what courses of legal action are possible, and know when to consult appropriate legal counsel.

For more information or to register click the link.

Mathematics is a foundational pillar of business and finance. It is necessary to understand how to apply math in different financial situations to have business success. This course will allow you to strengthen your math skills by providing examples of how basic math concepts apply in a variety of financial settings, including calculating interest, business expenses, and employee compensation.

For more information or to register click the link.

No matter where you are in your career, it is important to understand how the job you perform contributes to your sense of fulfillment in life. This course prompts you to examine various job settings and functions, comparing each against your own preferences, values, and expectations, in order to determine the best job fit for you.

For more information or to register please click the link.

Google Ads is the most widely-used advertising platform today. Due to the growing popularity of paid search, Google Ads is constantly evolving to help advertisers keep up with current marketing trends. Therefore, having a solid understanding of the platform is a key component of running a successful marketing campaign. This course will teach learners how to navigate through the platform, set up and optimize campaigns, improve performance, apply advanced techniques, and analyze performance data.

For more information or to register click the link.

Why do ethical people commit unethical acts? While individual morality certainly plays some role in ethical decision-making, the whole is larger than the sum of its parts. Corporate culture is integral to inspiring the best from employees and identifying any ethical problems immediately. HR professionals are critical for building and maintaining an ethical organization, as they are responsible for advertising jobs, screening applicants, and onboarding, training, and monitoring employees. This course lays out the components of an ethical organization with special attention on how HR facilitates the process of building and maintaining an ethical corporate culture.

For more information or to register click the link.

The people who make up your business are among your most valuable assets. Proper management of those human resources is critical for creating and sustaining a skilled and engaged workforce, developing a positive business culture, and generating a competitive advantage. Human resource personnel are involved in tasks like recruiting, selecting, compensating, training, developing, and disciplining employees. Who carries out these tasks varies depending on a business' size and organization. Large organizations may have a dedicated HR manager or even an entire HR department. In smaller businesses, on the other hand, HR responsibilities may be carried out by the CEO or business owner, delegated to staff, or outsourced.

Regardless of whether they will be responsible for carrying out HR tasks themselves, small business owners should be aware of important human resource issues, options, and controversies. This course reviews key areas in human resource management, like crafting job descriptions, finding the right people for those jobs, fairly compensating employees, and responding to performance issues. We also survey important employment laws and some best practices for creating a workplace that is safe and healthy for employees. Experts provide commentary and share their personal experiences relating to common HR issues.

For more information or to register please click the link.

Every organization encounters the occasional conflict. When dealt with effectively, it can make an organization stronger and more resilient. When left unchecked, it can affect the well-being of employees and the success of an organization. This course provides an overview of the benefits of conflict resolution. We discuss the role of HR in handling disputes and describe some common sources of workplace conflict. You will learn to identify different conflict styles along with strategies and best practices for responding to workplace conflict. We also discuss how to identify and respond to dangerous situations. Finally, you'll learn about organizational policies and legal considerations for handling conflict.

For more information or to register click the link.