If you work with data, you're likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft tools- Power Pivot and Power Query - that solve ALL of these issues, right inside Excel. No Access databases or IT department help needed. With imports of 1-million-plus rows of data sets from virtually any source and the ability to sav........

Excel Pivot Tables Pivots were designed to summarize big data as an alternative to complicated formulas. But Pivots can be a little confusing unless you learn a couple handy tips that will bolster your confidence when summarizing data. Attend this webinar for a crash course in Pivot Tables and you'll be amazed how often you use Pivots afterwards.

As business professional, we are always typing letters of all kinds. Sometimes, an email just won't do it. We need to create and manage nice-looking letters and documents. Microsoft Word is the software program that almost everybody uses to do this. This webinar is about how to make great looking, professional documents in Microsoft Word. 

Crystal Reports is a very powerful tool that can allow you to take many different types of data and combine that data into great reports. However, it requires a little training so you can use it properly and efficiently and to its maximum potential. In this webinar, you will learn how to take your raw data and create meaningful reports using the powerful SAP Crystal Reports software.

"They are often known as narcissists, bullies, and clever chameleons who knock down, but kiss up," said Dr. Mitchell Kusy, author of his newly released book, Why I Don't Work Here Anymore: A Leader's Guide to Offset the Financial and Emotional Costs of Toxic Employees. They shame, manipulate, and belittle in public and private as their modus operandi. Working with organizational leaders, HR feels the angst they cause, but are often unaw........

In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn........

Change is the only constant in business. Yet, most of us were never taught how to navigate change successfully. Learn once and for all how to get the results you want without experiencing the pitfalls you don't want.

Microsoft Excel is still the main software program used by bankers and financial professionals to manage large amounts of data, and to create and manage financial spreadsheets. Many people do not use Excel properly, or to its full potential. This webinar will show many ways to use Excel formulas, functions, and other tools to make spreadsheets more efficient for the banking and financial professional. It will also show ways to retrieve ........

A winning team will out produce any individual and most other teams. There is an amazing strength, resilience and ability to perform at heroic levels when a quality team is in synch and working together. A good team will improve your results far beyond anything you try to accomplish alone.

In order to communicate and create compelling messages you first want to reflect on the desired outcome. When you know what you want, you want to apply the Outcome Cycle starting with: Data/Information: What do you want the person you are creating the message for to know? Which data, information, facts, values are relevant for you to prov........

In order to create an environment for high performing teams, many organizations are moving from managing their organization in the traditional vertical format to managing their organization in a horizontal format. The horizontal format is much more effective in building high performing teams because the organization is able to........

This webinar training will explain the process to effectively manage construction projects. The Instructor will discuss reviews of plans and specification, inspection program, order of operations, identification of hazards and safety controls.

The balanced scorecard is not new. However, not enough companies are using it. This session will go cover how to construct a balanced scorecard. We will cover how to survey the key deliverables for success, how to measure them, how to set standards, and how to assign values to each. We will discuss using the balanced scorecard as a basis for a manager and executive bonus system. We will use an actual example highlighting the restaurant/........

Today's 24/7, "always on" world often cycles between "do more with less" downsizing and ever faster upgrading and can even appear to be spinning out of control. How do you harness the problem-solving support, resiliency and creativity in your work team. Are you ready to cultivate communication and conflict resolution skills that affirm your integrity and also set appropriate boundaries while being collaborative and compassionate.Learn k........

Today's always on,TNT- Time-Numbers-Techno-Transition - Driven & Distracted World can breed tension and conflict. Challenge the notion that all anger is destructive. Discover the Four Angry ?I?s and the Stress Doc?s "Four Faces of Anger"Model for transforming anger, rage, and conflict. Learn and practice skills and strategies for: disarming power struggles by asking trust-and disarming all kinds of hostile feedback, even how to deal con........

The fundamental question is, "Are good leaders born that way or developed?" More and more research is validating the fact that leadership and all human behavioral characteristics have the potential to be developed. Everyone's life experience has a significant impact on their point of view, abilities and behavior. We are now able to influe........

All great leaders have common amongst themselves certain ingrained habits of behavior that help them separate from the pack and achieve at the highest levels. These habits are learned and developed in a very deliberate way. We will show you how.

The way you write and respond to emails and other documentation reveals much about your credibility and professionalism. It can make a difference between someone understanding your point of view, and agreeing with you, or not. It can also make the difference between someone interpreting your message the way you intended, and completely mi........

We all do it. We jot down a To-Do List sometimes at the beginning of the day, then check off the items as we do them. This is convenient and universal?And it's the worst way to plan and get things done! Heresy? Yes. Wrong? No. To-Do Lists are tactical, arbitrary, and miss some important strategic initiatives. Learn to transform your To-Do........

With today's ever changing business environment, it's hard not to focus on obtaining and keeping strong business client and customer relationships. But is this enough? The answer is no. This is because some things in business have stayed the same for centuries: Business is still about relationships and building trust. How many times have your highly talented employees, managers, leaders and sales representatives and services staff prese........

Many organizations are far from where they want and need to be with improving performance, and they apply intuition, rather than hard data, when making decisions. Enterprise performance management (EPM) is now viewed as the seamless integration of managerial methods such as strategy execution with a strategy map and its companion balanced scorecard (KPIs) and operational dashboards (PIs); enterprise risk management (ERM); capacity-sensi........

P-Card usage is on the rise and so are the cases of P-Card fraud! Many companies have implemented P-Cards as a means to reduce invoice volume and increase efficiency within accounts payable department and within the procure to pay (P2P) cycle. But the increased use of P-Cards has resulted in additional risk which creates an enhanced focus on internal controls and spotlights the role of the P-Card Administrator. The instructor will ident........

Does poor writing stifle your productivity? Learn to instantly improve emails, proposals, reports, social media and more in a dynamic, fast-paced webinar led by Jack Appleman, author of the top-selling 10 Steps to Successful Business Writing. Apply his time-tested strategies by completing challenging exercises-which you can submit for his feedback. Gain more confidence to write concise, explicit and well-organized text that will produce........

This program examines the challenge for all leaders and that is being an ethical person, having good moral character and being accountable to the people and organizations they lead. It also provides some strategies and tips for leaders to meet the leadership challenges of Ethics, Character and Accountability in their organization.

Accounts payable is not only responsible for control of cash paid by the business, but also handles sensitive vendor information such as tax ID numbers. Adequate internal control is an essential element of accounts payable operations. Controls serve to protect company assets including company reputation through protection of sensitive information and processes. Controls provide assurance that company records are accurate and complete. T........

This workshop is a one-hour program that prepares individuals who will be members of a diverse team to participate effectively to maximize their contributions to the team by using their collective intelligence toward a common team objective. We look at team building issues and diversity not only in relation to race, ethnicity, gender, etc. but also across business functions, geographic areas, managerial levels and we explore how all the........

The current technology driven turbulent business environment present many challenges to business manager. One primary challenge is the ability to predict and plan for the future which is unexpectedly unpredictable. Changes are constant. Companies struggle to find ways to find manage resources and find ways to thrive and survive in this turbulent business environment. Traditional budgeting has been overtaken by these constantly changing ........

The United States Citizenship and Immigration Services (USCIS) has recently released the second updated Form I-9 in less than 1 year. Employers will need to adapt to the change and use the new form by no later than September 18, 2017 or face the possibility of large fines. Although the changes to the Form I-9 are slight, failure to use the new form and comply with the Form I-9 by the September 18 deadline can result in large fines. Just........

Regulatory Compliance Audits can be taxing and worrisome for anyone. Having an EPA Audit can open an organization up to receiving regulatory citations, monetary fines, negative company press, etc. The purpose of this webinar is to cover the key concepts of how to successfully navigate through an EPA Audit. Being prepared ahead of time and knowing the right protocols can help turn a negative situation of being involved in a compliance au........

The Purchasing and Accounts Payable cycles create a multitude of data that can be analyzed and tested for certain elements of possible fraud. Accounts Payable is considered the "checkbook" of the organization and therefore creates an area that without the proper control environment can be ripe for fraud. Internal Audit organizations have the ability to spend resources to analyze the data that comes out of the process to enable the organ........

Alcohol and drug addictions cost employers billions of dollars every year. Addictions are a growing problem in our country, and every employer will likely have an employee struggling through this common disease.

After participating in this informative webcast presented by Excel expert David Ringstrom, CPA, you'll have the skills needed to go beyond Excel's VLOOKUP function to master complicated formulas. VLOOKUP is the function many Excel users rely on to return data from other locations in a worksheet; however, utilizing VLOOKUP isn't always the........

Let us bring you the latest in accounting and auditing issues. The webcast is devoted to new accounting issues, new audit issues, new compilation and review issues and other issues affecting the profession. Every update is different, so plan to join us each time the update is broadcast for a concise look at the hottest topics affecting every accounting and finance professional.

A prevalent fraud that occurs is improper payments to vendors, fictitious vendors, and related party vendors. A dishonest employee can easily manipulate vendor and accounts payable records to facilitate fraudulent disbursements. The Association of Certified Fraud Examiners claims that nearly two thirds of an entity?s fraud exposure involves fraudulent disbursements.

The processing of an employee?s paycheck from gross to net must be done in a strict yet varying regulatory environment. This webinar focuses on the account standard best practices for the payroll process with valuable information that will help your company avoid compliance issues and potential fines. Accounting payroll procedures help senior managers ensure that staff compensation amounts included in financial statements are accurate a........

Every business that purchases and contracts for goods or services is vulnerable to a wide variety of procurement fraud hazards. Many of the fraud schemes involve vendors and contractors in collusion with employees responsible for making purchases and administrating contracts, as well as with the employee who requests the purchase of goods or services. Procurement fraud is costly to a company and costly to investigate. Preventing this ac........

The Purchasing and Accounts Payable cycles create a multitude of data that can be analyzed and tested for certain elements of possible fraud. Accounts Payable is considered the ''checkbook'' of the organization and therefore creates an area that without the proper control environment can be ripe for fraud. Internal Audit organizations have the ability to spend resources to analyze the data that comes out of the process to enable the org........

Collection and enforcement of federal employment taxes is a current priority for the IRS. The quarterly Form 941 reports employee headcount, wages and tips, taxes withheld from employee pay and employer taxes, and tax liability dates that establish due dates for tax deposits. It is the basis for IRS determination of employer compliance with the requirement to withhold and deposit employee income tax and Social Security and Medicare taxe........

This course is designed to review the issue of fake checks and counterfeit currency. Examples of actual frauds will be provided so participants can understand how the frauds are being committed and how they were uncovered. We will review various methodologies for detecting these types of fraud and will discuss developing internal controls to help prevent and detect these frauds.

Accounts payable is not only responsible for control of cash paid by the business, but also handles sensitive vendor information such as tax ID numbers. Adequate internal control is an essential element of accounts payable operations. Controls serve to protect company assets including company reputation through protection of sensitive information and processes. Controls provide assurance that company records are accurate and complete. T........

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 also cover important changes to the filing due dates and the new safe harbour requirements for de minimis dollar amount errors.

The reality of any professional discipline is this: If it is not in writing, it never happened. All the professional observation and objective review that a clinician puts into an analysis are meaningless unless the work appears in a complete, objective clear, and concise evaluation report. Knowing this truth is obvious; getting there is the challenge.

This training on credit card surcharge compliance issues will discuss how the recent changes in the law will affect end-user organizations. It will also provide attendees with the tools necessary to review and deal with any potential surcharge/checkout fee situations.Credit card surcharging is prohibited in ten (10) states while another dozen states are considering legislation Surcharging had been historically prohibited in the U.S. per........

This webinar is created to equip young risk and compliance professionals with the skills necessary to prepare a Risk and Controls Matrix, including the following: Discover the objectives, components and requirements of effective internal controls Leveraging internal control frameworks to create a risk and controls matrix Developing risk identification and management strategies to implement now Learning how to design internal controls Le........

The passage of Sarbanes-Oxley back in 2002 forced many companies to look deeper into internal Accounts Payable controls. They realized that is was not an easy task. Implementing internal controls takes time, money, and effort. However, if fraud or missteps are uncovered, it will be worth the investment. If not, you have the knowledge that your ship is tight. There are several approaches you can try to tighten up your A/P operations and ........

The purpose of income tax withholding is to approximate the amount of the employee's tax for the year based on wage payments made during the year. The wage bracket and percentage methods are the primary methods used to compute withholding based on the employee's marital status and allowances claimed on Form W-4. Generally thos........

The role of the compliance officer is changing because banks are struggling to serve many masters; some with like goals and others with contradictory ones. Regulators, corporate clients, Board of Directors, and shareholders are pulling in their own directions. Fraud in some payment types are declining while others are picking up that slack. ACH, CHIPS, and Fedwire payments are taking the place of B2B checks but there exists compliance a........

Although writing at work can be relatively easy when using templates for standard reporting, many situations call for a more complex, argumentative approach. Once you move away from a business-as-usual approach, you will want to ensure that you collect data efficiently, assess it objectively, organize ideas to focus readers on your message, argue persuasively yet honestly, and avoid flawed thinking that can demolish your argument.

If you are working in the forensic accounting field at some time in your career it may be necessary to search for hidden assets. This course is designed to review why people hide assets and how they commonly hide them. We will discuss the methods for searching for hidden assets as part of a forensic accounting engagement and how to confiscate the assets once they are located. We will also review some of the legal issues involved with se........

Fail to Plan; Plan to Fail. Learn proven approaches to create or adapt your current mission to guide robust planning, execution, and daily decision making to get the results you need to assure your organizations growth. These extraordinary times require extraordinary performance by every leader and manager throughout the organization whet........