Online Safety Community

Excel as a Business Intelligence Tool –Pivot Tables and Charts

Event Details

Excel as a Business Intelligence Tool –Pivot Tables and Charts

Time: July 16, 2018 from 2:30pm to 7pm
Location: Training Doyens 26468 E Walker Dr
Street: 26468 E Walker Dr, Aurora, Colorado 80016
City/Town: Aurora
Website or Map: https://goo.gl/ysLNef
Phone: +1-720-996-1616
Event Type: online
Organized By: Training Doyens
Latest Activity: Jun 7, 2018

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what they, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way. You and your staff will be instantly more productive in Excel. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session.

WHY SHOULD YOU ATTEND

Attend this webinar if you use Microsoft Excel on a regular basis and want to take your knowledge to the next level.

AREAS COVERED

  • Creating and managing Pivot Tables.
  • Changing the calculation type
  • Adding additional calculations
  • Creating custom calculations
  • Multilayer reports
  • Creating Daily, Monthly, quarterly and yearly summaries
  • Adding A pivot chart
  • Adding Slicers
  • Adding timelines

LEARNING OBJECTIVES

In this webinar, you will learn how to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up to more complex pivot tables.

WHO WILL BENEFIT

  • Business owners
  • CEO's / CFO's / CTO's
  • Managers of all levels
  • Anybody with large amounts of data
  • Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
  • Accountants
  • CPAs
  • Controllers
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Admins
  • Secretaries

 

For more detail please click on this below link:

https://goo.gl/FGWXo5

 

Email: support@trainingdoyens.com

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

 

 

 

Comment Wall

Comment

RSVP for Excel as a Business Intelligence Tool –Pivot Tables and Charts to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Mark Nilson posted events
18 hours ago
Training Doyens posted an event
Thumbnail

Employee Investigations and Witness Interviews - 3 Hour Virtual Boot Camp at 26468 E Walker Dr, Aurora, Colorado 80016

June 19, 2019 from 1pm to 4pm
OVERVIEWEmployers conduct investigations for a variety of reasons; employee or customer complaints, background checks, regulatory or audit requirement(s), allegations of misconduct, and losses of various types. The shared primary purpose of these investigations is the same — to find out the facts of a situation to determine a course of action to take — or not to take.WHY…See More
22 hours ago
Adam Fleming posted events
22 hours ago
Sandy Funches posted a blog post

5 Common Forms of Car Dealership Trickery, And How You Can Outsmart Them!

The unfortunate reality of buying a vehicle is you always need to be on your toes to spot potential scams. This is especially true when buying used cars. The truth is that the automobile industry has TONs of variables, of which some are gigantic and others are miniscule. Many of these variables can be manipulated to the advantage of the dealership.Now, it’s important to note that not…See More
yesterday

Forum

Green Smart Technical 800+ Turnkey Projects in UAE – Rope Access Company in Dubai

Green smart is an ISO 9001: 2015 QMS, OHSAS 18001: 2017 OHSMS, ISO 14001: …Continue

Tags: window, cleaning, services, facade, companies

Started by Manikandan Apr 23.

Workplace safety for workers other than your own 2 Replies

Do your workplace/traffic safety plans include safety measures for workers who are not your own employees? Do they take into account the safety of those who will be - or could be - at your workplace,…Continue

Tags: emt, paramedics, emergency, occupational, health

Started by John Petropoulos Memorial Fund. Last reply by Tara safe Mar 1.

What % of Dollars should be bugeted for All Safety Training for a "Heavy Equipment Road Construction" company with 100 employees? 1 Reply

I have been at a Highway and Road Construction company for six months. I am developing a (first) complete training program. I am the 1st full time safety hire for this company. I need to develop a…Continue

Started by JTurpening. Last reply by Jen McDade Feb 19.

Technology and Safety 1 Reply

What are the most useful tools to have at your fingertips? -Toolbox Talks-JSA-JHA-Daily Reports, etc. What is falling through the cracks that could be an easy fix? Safety Managers, Coordinators and…Continue

Tags: safety

Started by Drew stone. Last reply by Jen McDade Feb 15.

Important of Warning sign 1 Reply

Warning sign is a type of traffic sign that guide a hazard ahead on the road. Having proper warning sign on the road provide a healthy environment.Continue

Tags: Signs, Workplace, Safety, Sign, Warning

Started by healthandsafetysigns. Last reply by Jen McDade Jan 14.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service