In this video, you will learn how to use XMATCH.

In this video, you will learn how to use XLOOKUP to perform complex lookups.

In this video, we will get introduced to Spills and Arrays.

In this video, you will learn how to split data using text to columns.

In this video, you will learn how to control data input.

In this video, we will discover how to use DAX to show the top three employees and aggregate the rest into an “Others” category. You will learn to rank and filter data based on specific criteria, such as sales performance or key...

Equity compensation like stock options used to be reserved only for C-suite executives. But today it seems like most employers are offering them to their workers... but are these "golden handcuffs" worth the tax headache?

What is House's Path Goal Theory (Situational Leadership)? Robert J. House, founder of Path-Goal theory, believes that a leader's behavior is contingent to employee satisfaction, employee motivation and employee performance. Path-Goal...

When and how does a startup grant equity interests to startup advisors? When to Grant Equity. If the startup does decide to compensate its advisors with equity, it must decide how much equity to offer. This decision is generally based...

What is equity compensation for early employees of a startup business venture? Equity compensation is a method of non-cash payment in exchange for services to a business. Based on the role and contribution, company shares are offered in...

What is an Employee Stock Option Plan? Employee stock ownership, or employee share ownership, is where a company's employees own shares in that company. US employees typically acquire shares through a share option plan. In the UK,...

What is Egocentrism? Egocentrism is the inability to differentiate between self and other. More specifically, it is the inability to accurately assume or understand any perspective other than one's own. Egocentrism is found across the...

How should you structure Compensation within a Startup? How much debt should the company incur? How much equity should the company sell? This may include incentives on top of a base salary, so that your employees do well financially as...

When setting up a business, what are the major Employee and Intellectual Property Matters that must be addressed? n important part of your intellectual property strategy is implementing best practices in the area of employee policies and...

What is an 83b Election? How does th e83b election relate to Stock Options? When making an 83(b) election, you request that the IRS recognize income and levy income taxes on the acquisition of company shares when granted, rather than...

What are the Special Employee Provisions in a Term Sheet? The parties often negotiate numerous employee-related provisions into the term sheet. These provisions serve as control mechanisms to either incentivize current management or...

What is Performance Evaluation for managers? A manager performance evaluation is an assessment that a supervisor conducts to determine how well a manager is fulfilling their duties. This kind of performance evaluation can consist of a...

What is Management by Objective? Management by objectives, also known as management by planning, was first popularized by Peter Drucker in his 1954 book The Practice of Management.

Taxation in the Federal System recognizes that the largest source of income for the federal government is taxes by describing various types of taxes and the role of the IRS.

"Prefixes and Suffixes" explores how to determine the meanings of unfamiliar complex words by analyzing the words’ prefixes and suffixes.

Taxes are withheld from employees’ gross earnings each pay period. The taxes are sent by the employer to the respective government agencies. Additional calculations are required to determine the amount the employer must send to the IRS.

Karl Weick's Partial Inclusion is a useful concept to explain the various degrees to which organizational employees are committed to their workplaces. Weick explained this in his 1979 book, The Social Psychology of Organizing.

This video explores the concept of servant leadership, an alternative leadership model that focuses on empowering others and serving employees as a means to achieve organizational goals. The video discusses the history of servant...

This video discusses the concept of a matrix organization, a management structure where employees have multiple bosses and are accountable to different chains of command. It explores the benefits and challenges of this structure, and...