Online Safety Community

Excel - Creating High Impact Business Reports

Event Details

Excel - Creating High Impact Business Reports

Time: May 15, 2018 from 1pm to 2:30pm
Location: 26468 E Walker Dr, Aurora, Colorado 80016
Street: 26468 E Walker Dr, Aurora, Colorado 80016
City/Town: Aurora
Website or Map: https://goo.gl/YCrhFp
Phone: 18883008494
Event Type: online
Organized By: Training Doyens
Latest Activity: May 2, 2018

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a percentage (no formulas, arithmetic or programming required!), make the pivot table eye-catchingly appealing to read and then group the data (by month or numeric range).

In the visual communication (charts/graphs) section, you'll learn how to enhance and customize a standard chart ("from drab to fab") as well as how to create infographic-style charts using nothing but Excel.

With Excel's Power View addin (2013 and 2016 only) you'll learn how to create visual reports containing interactive charts, graphs, maps, and other visuals that bring your data to life.

The final part of the training will focus on Excel's Power Map tool (2013 and 2016 only) which lets you plot geographic (country, region, state etc) data on an interactive 3-D globe or custom map.

WHY SHOULD YOU ATTEND

In this training session, you'll learn not only how to turn raw data into meaningful information but also how to present that data in a visually attractive way. This training will provide you with a solid foundation that you can use to build your own reports.

AREAS COVERED

Session highlights include…

  • Charts: Style and design tips and tricks to tell your story / convince your audience
  • Charts: Creating powerful infographics using built-in Excel functionality
  • Pivot tables: Fundamentals
  • Pivot tables: Percentages in 5 clicks without formulas
  • Pivot tables: Fonts, number formatting and layout options
  • Pivot tables: Grouping data based on month or numeric range
  • Power View: Create a visually stunning interactive report (2013 & 2016 only)
  • PowerMap: An Excel addin that lets you display and analyse geographic data as a visual map (2013 & 2016 only)

LEARNING OBJECTIVES

Learn how to use four key features of Excel that will transform your report-creation abilities.

WHO WILL BENEFIT

This training is categorised as intermediate-to-advanced. It is aimed at existing users of Excel who need to learn how to create visually impactful Excel reports. 

The training will be delivered using Excel 2016 for Windows although for users of earlier versions, some of the functionality is available in Excel 2010 and much of the functionality is available in Excel 2013. 

IMPORTANT: PowerMap and Power View are not available in Excel 2010. Not all versions of Excel 2013/2016 include Power Map and Power View. If in doubt whether this training is relevant for your version of Excel, please check with your IT department.

 

For more detail please click on this below link:

https://bit.ly/2HWuX6n

 

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 - Creating High Impact Business Reports to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Joseph Wilcox posted events
1 hour ago
Morgan Franklin posted blog posts
1 hour ago
Mark Nilson posted an event

Managing Special Assignments: Advanced Best Practices for Administrative Professionals at Training Doyens 26468 E Walker Dr, Aurora, Colorado 80016

June 20, 2019 from 1pm to 2:30pm
OVERVIEWRefine your organizational skills to keep your projects on time, on budget, and on target. You've mastered the planning, executing, reviewing, and revising skills, making the difference between success and failure. You are good at getting the different stakeholders to provide information or direction and to show up for important milestones meetings.You're ready to hone your organizational and general administrative…See More
Friday
Training Doyens posted an event
Thumbnail

Optimize Your Employee Onboarding: Techniques to Improve and Enhance the New Employee Experience at 26468 E Walker Dr, Aurora, Colorado 80016

June 18, 2019 from 1pm to 2pm
OVERVIEWIn this webinar, we will learn the reasons onboarding experience for new hires is important today. We will learn that the terms orientation and onboarding new employees are not interchangeable. We will learn that orientation is in reality just one step in the onboarding process. We will learn that the HR onboarding process begins before the hire is made.WHY SHOULD…See More
Wednesday

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