Joseph Wilcox's Blog – February 2020 Archive (12)

Power Query is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.

Power Query is a tool designed for Excel to handle repetitious steps specifically tied to data prep. We all know the drudgery of removing columns, shifting rows, correcting data formats all before we can actually do the work with the data!

The old alternative was to use macros for this redundant work; but even those were hard to edit and not…

Managers and Supervisors are taken to task everyday in managing their Non represented employees. It is important for them to learn the Initial warning signs of Union Organizing long before a Union gets the appropriate number of signed Authorization Cards and the NLRB Conducts a secret Election. Learn here the best Election is the one that is never held .

This course will delve into the 20 +  Initial Warning Signs of Union Organizing, What you Can Do and What you Cannot Do, Guidelines…

Managers and Supervisors are taken to task everyday in managing their Non represented employees. It is important for them to learn the Initial warning signs of Union Organizing long before a Union gets the appropriate number of signed Authorization Cards and the NLRB Conducts a secret Election. Learn here the best Election is the one that is never held .

This course will delve into the 20 +  Initial Warning Signs of Union Organizing, What you Can Do and What you Cannot Do, Guidelines…

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions in available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing…

This webinar will cover the latest updates for Form 1099-MISC, specific reporting requirements for various types of payments and payees, filing requirements, withholding requirements and reporting guidelines.

It will cover filing due dates including the accelerated due dates for 1099-MISC Forms with an entry in box 7, and the safe harbor requirements for de minimis dollar amount errors. It will cover penalty provisions due diligence procedures, and exceptions to penalties including…

The impact of marijuana use on the workplace is skyrocketing. State after state legalizes its use, not just for medicinal purposes, but for recreational ones too. At the same time, the Feds haven't legalized any of its use.

The two most common questions employers have are:

• Our company does drug screenings, and an employee has provided a medical marijuana card. How do we handle that?
• Our state allows recreational marijuana. What does this mean if we have a…

Work remotely is becoming more of a norm in the tech industry. Various studies have shown that it is more difficult to get virtual teams to bond, harder for informal leaders to emerge, tougher to create genuine dialogue, and easier for misunderstandings to escalate.

Leaders must deal with an array of cultural issues that can include differences in business protocol, decision-making, dealing with authority, the concept of time, negotiation styles, and the emotional reactions allowed –…

Work remotely is becoming more of a norm in the tech industry. Various studies have shown that it is more difficult to get virtual teams to bond, harder for informal leaders to emerge, tougher to create genuine dialogue, and easier for misunderstandings to escalate. Leaders must deal with an array of cultural issues that can include differences in business protocol, decision-making, dealing with authority, the concept of time, negotiation styles, and the emotional reactions allowed – or…

It is Important for Managers and Supervisors to understand the Importance of Documentation regarded their represented employees. It is critical for them to understand the Impact and depth that Documentation has on multiple areas of the workplace and operation of the business.

One Key area of impact is the Just Cause Standard and how the failure to properly Document will result in the costly loss of Grievances and Arbitration cases.

How Documentation impacts an Employees's Right…

Pivot Tables have been a mainstay of the Excel program for two decades, and yet they remain a daunting and little understood tool. If you are a daily user of Excel, then at some point you will be faced with the challenge of data summaries and analysis.

The 1st level of that process is sorting and filtering. And the 2nd level is Pivot Tables. Without them, you will be spinning your wheels trying to make sense of data.

In this crash course, Andy Lanning will take you from intro…

Lets be honest here you probably have people in your life that, if they would just go away! your life would be easier?

Interacting with them is exhausting and frustrating - even thinking about interacting with them is discouraging and causes you to despair the situation will never get any better.

We all have those people in our lives. The reality is, having them out of your life is not practical - they may be your boss, staff, colleague, customer, vendor, friend, or family…

Diversity and inclusion are common buzzwords these days but few understand what they really mean or entail. In this webinar, we will explore what diversity and inclusion REALLY are as well as common myths and misconceptions.

We will discuss everything from implicit and explicit bias, diversity in areas you haven't thought of, intent vs. impact, and calling in vs. calling out and more.

Participants will explore their personal relationship with systems of privilege and oppression…