Search   |     Toll free: +1-800-447-9407   |     support@s2mtrainings.com
Training Options
Offer Price: $820.00   Regular Price: $1,025.00

You Save: $205.00 (20%)*


Offer Price: $1,620.00   Regular Price: $2,025.00

You Save: $405.00 (20%)*

Webinar Packs Access recorded version unlimited viewing for 6 months.
(For Customize Webinar Packs Please Call Customer Care)

Instructor : Dennis Taylor
Product Id : 50018

Overview: PivotTable capabilities are enormous; among its many tools and features.

PivotTable capabilities are enormous; among its many tools and features.

You will learn the following in this webinar, The quickest and best ways to create PivotTables and Pivot Charts, including these capabilities: The following subjects will be covered in detail:

  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to deal with dynamic source data and the "refresh" concept
  • How to create a PivotTable based on data from multiple worksheets
Dennis Taylor has worked extensively with Microsoft Excel since the mid-1990s. He's traveled the United States and Canada presenting seminars and classes to help attendees unlock the full potential of Excel.

Accomplishments: Dennis has authored and presented nearly 700 webinars on various Excel topics in the past 11 years. He has also produced numerous Excel courses on video, CD, and DVD and has taught more than 500 seminars and over 5,000 classes on the subject. Dennis is the author/presenter of over 200 hours of online Excel courses available at LinkedIn Learning. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field.

He's taught for numerous corporations, government agencies and colleges and universities, including: Northrop-Grumman, Raytheon, Levi Strauss, Chevron, BP, IBM, Apple, Driscoll's, Amgen, AT&T, Qwest, Anheuser-Busch, Starz-Encore, University of Phoenix, University of Colorado, US Department of Labor, Bureau of Land Management, Great-West Life Insurance, Texaco, Lexmark, Time-Warner, Environmental Protection Agency, National Seminars, and the Cities of Denver, Boulder, Longmont, and Westminster, CO.
Instructor : Mandi Stanley
Product Id : 50018

Overview: This is the ideal webinar for anyone responsible for overseeing outgoing correspondence, paperwork, project proposals, and email throughout the course of the workday. You'll walk away with two tangible proofreading tools designed to make your job easier. This is the ideal webinar for anyone responsible for overseeing outgoing correspondence, paperwork, project proposals, and email throughout the course of the workday. You'll walk away with two tangible proofreading tools designed to make your job easier.
Mandi Stanley With more than 16 years of experience on the seminar circuit, Certified Speaking Professional Mandi Stanley works primarily with business leaders who want to boost their professional image and with people who want to be better speakers and writers.
In 2003, Mandi was designated a CSP, Certified Speaking Professional. Fewer than 9 percent of all worldwide speakers have earned this designation, and Mandi is the first Mississippian in history to receive this honor through the National Speakers Association.

She's a summa cum laude graduate with concentrations in English, communication, and management, and served as a faculty member of the American Management Association for five years. Mandi is the author of The No-Panic Plan for Presenters, which was named a Finalist in the Career category at the Independent Book Publishers Awards in New York. Audiences appreciate her platform enthusiasm, interactive style, and content-rich messages.
Instructor : Ronald Adler 
Product Id : 50018

Overview: Effective HR metrics are not developed in a vacuum. The "right or best" metrics require a detailed understanding of your organization:

Effective HR metrics are not developed in a vacuum. The "right or best" metrics require a detailed understanding of your organization: how it generates revenue, its business strategies and objectives, it business imperatives, the risks it faces, the opportunities to be seized, and what it already measures.

Thus, HR metrics should not be developed in a silo or owned exclusively by human resources. To be of value, HR metrics should measure the business factors that are important to the organization not just HR and should be co-owned by HR and the C-suite, other departments, and line managers. The right or best metrics are HR metrics that incorporate the input of stakeholders and contribute to informed decision-making.

From this perspective, HR metrics should be predictive and action oriented. HR metrics that do not assist organizational decision making are of little value. The issue is not the number of metrics. As Albert Einstein noted: "Everything that counts can't be measured and everything that can be measured does not count."

As noted, the measurement of business outcomes is a critical component of the HR auditing process. Thus your organization's HR metrics should help you assess the value and contribution of your organization's human capital; should focus your organization's attention on how human capital helps it achieve its business objectives; should help you measure and assess human capital management and employment practices liability related risks; and should help you assess individual and organizational performance.

Since HR metrics can assist your organization identify weaknesses and failures in its human resource management and employment practices compliance activities, your organization's selection and use of specific HR metrics is not only an indicator of what issues it considers important, but is also an indication of your organization's commitment to identify and ferret out ineffective or unlawful practices and processes.

Thus your organization may be scrutinized not only on the issues it chooses to measure, but also the issues it chooses to ignore. Thus your use of HR metrics considers both quantitative and qualitative methods and measurements, should help you assess your organization's performance, and should provide you with data that will allow you to evaluate human capital outcomes.

Ronald Adler is the president-CEO of Laurdan Associates, Inc., a veteran owned, human resource management consulting firm specializing in HR audits, employment practices liability risk management, HR metrics and benchmarking, strategic HR-business issues and unemployment insurance.He has more than 37 years of HR consulting experience working with U.S. and international firms, small businesses and non-profits, insurance companies and brokers, and employer organizations.

Mr. Adler is a co-developer of the Employment-Labor Law Audit (the nation’s leading HR auditing and employment practices liability risk assessment tool.

Mr. Adler is an adjunct professor at Villanova University’s Graduate Program in Human Resources Development and teaches a course on HR auditing. Mr. Adler is a certified instructor on employment practices for the CPCU Society and has conducted continuing education courses for the AICPA, the Institute of Internal Auditors, the Institute of Management Consultants, and the Society for Human Resource Management.
Instructor : David Rohlander
Product Id : 50018

Overview: Leadership is a noble profession. It all starts by mastering the leadership of self. Then you have the right to start to deliberately influence and lead others. The most effective way to lead is to set the example.

Leadership is a noble profession. It all starts by mastering the leadership of self. Then you have the right to start to deliberately influence and lead others. The most effective way to lead is to set the example.

You and I have deeply developed habits of behavior. First we must discover why and how we currently handle the critical behaviors of great leadership. What is our unconscious state of mind when it comes to each habit? What do other people see when they watch us? How do we change and develop new habits?

We will delve into each behavior that is needed for you to be a great leader. This will include tools to help you assess yourself, develop and design a system of follow up to insure you continue to improve.

David's passion is helping executives create a masterpiece personally and professionally. That's why he wrote, "The CEO Code," a Best Seller on AMAZON. That success resulted in Penguin/Alpha Books asking David to write "IDIOT'S GUIDES: Management Skills" released in December 2014.

David has "been there & done that" in the military, academia and business. His experience and expertise enable him to deliver for you:

IMPACT - When you survive bullets and missiles on 208 combat missions as a USAF fighter pilot it gives you an edge, a focus and a "can do" attitude.

RELEVANCE - Understanding people comes from knowledge, (MBA in Finance, grad work with Peter Drucker and years of university teaching.) Experience (Merrill Lynch, built three companies and coaching CEOs and executives.) Expertise (perpetual student, disciplined listener and professional speaking for over 30 years + lots of practice.)

RESULTS - 85% of David's new business comes from referrals. There is no higher tribute a client can give than to refer a friend or colleague. He is dedicated to getting you great results and believes that is the best marketing he could possibly do.
Instructor : David Rohlander
Product Id : 50018

Overview: Your biggest question should be: Why have a meeting? There needs to be a compelling reason. Your biggest question should be: Why have a meeting? There needs to be a compelling reason.

We will review various types of meetings and define the purpose of each as well as explore alternatives to holding meetings. Depending on your real purpose, a meeting may not be the best way to accomplish the goal.

Once you determine that a meeting is the best solution there are several questions that need to be answered during the planning process. It is critical to have a good plan.

How do you determine who should attend the meeting? How can you make the meeting memorable and impactful? What should be done to follow up and ensure everyone pulls their weight and fulfills their commitments?

How to build an agenda will be discussed and illustrated. The key ingredients and fundamentals of all meetings will be explained. People are all unique and need various types of interaction. We will share exactly how to deal with each major type of person in the meeting so that the good of the group is accomplished and everyone feels they have made a contribution and are valuable.
David's passion is helping executives create a masterpiece personally and professionally. That's why he wrote, "The CEO Code," a Best Seller on AMAZON. That success resulted in Penguin/Alpha Books asking David to write "IDIOT'S GUIDES: Management Skills" released in December 2014.

David has "been there & done that" in the military, academia and business. His experience and expertise enable him to deliver for you:

IMPACT - When you survive bullets and missiles on 208 combat missions as a USAF fighter pilot it gives you an edge, a focus and a "can do" attitude.

RELEVANCE - Understanding people comes from knowledge, (MBA in Finance, grad work with Peter Drucker and years of university teaching.) Experience (Merrill Lynch, built three companies and coaching CEOs and executives.) Expertise (perpetual student, disciplined listener and professional speaking for over 30 years + lots of practice.)

RESULTS - 85% of David's new business comes from referrals. There is no higher tribute a client can give than to refer a friend or colleague. He is dedicated to getting you great results and believes that is the best marketing he could possibly do.