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

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

Mark Nilson posted an event
Thumbnail

Excel: BI Reporting with Power Pivot and Power Query at Training Doyens 26468 E Walker Dr

October 23, 2018 from 1pm to 2:15pm
OVERVIEWIf 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- Excel PowerPivot and PowerQuery—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…See More
2 hours ago
Nakul Pratap posted a blog post

Why Choose Nebosh Course in Mumbai – Best Safety Training In Mumbai

NEBOSH stands for ‘National Examination Board in Occupational Safety and Health’. NEBOSH doesn’t produce health and safety training tutorials; in its place it presents syllabus, exams and assignment to Accredited Course Suppliers, such as GWG, who in turn give training courses to make prospects for NEBOSH educations. Each year over 30, 000 students / specialist take a course that leads to a…See More
3 hours ago
katherine katherine posted an event
Thumbnail

Enhance Your Career With MSBI Training from TekSlate and get certified at USA

September 29, 2018 at 7am to October 31, 2018 at 8am
Business Intelligence is a process or set of activities such as extracting the business data from various operational sources, transform, and load the data into a consolidated database or data warehouse systems. The three main components of MSBI is SSIS-integration tool, SSAS-analysis tool, SSRS-reporting tool. This tool speed used to access detailed information and work rapidly to take improved business opinion this upgrade business agility.Tekslate's Microsoft BI Training is designed to make…See More
3 hours ago
Adam Fleaming posted a blog post

Why compliance trainings are critical for organizations?

Trainings are a necessary ingredient for excellence in organizations. On-the-job training is almost a must for most employees at various levels in organizations. Trainings are necessary for a variety of reasons. Many employees who are just out of college may sometimes feel the need to get trained to help them understand the organization and the job better because the actual work the organization does may not be part of the curriculum they may have studied when at college or university.Others…See More
4 hours ago

Forum

safety equipments in breweries 4 Replies

safety equipments in breweries -- kindly provide detailsContinue

Started by ajit. Last reply by Jen McDade 6 hours ago.

Unusual Safety Tips 10 Replies

Please share some unusual but genuine safety precautions.My unusual safety tips - Don't drink sweet fruity juice while driving in the night as it contains sugar and sugar slows down your blood…Continue

Started by Arnold Brame. Last reply by Jen McDade 6 hours ago.

Safety products 9 Replies

While working or at some work stations, employees are exposed to threats or at times suffer severe injuries. The safety of the employee should be the foremost priority. Safety equipment aids help in…Continue

Tags: equipments, and, products

Started by Enna Henry. Last reply by Jen McDade 6 hours ago.

Talend Application Integration

APPLICATION INTEGRATION:Talend ESB and Application Integration delivers agile real-time integration of applications and data.Heterogeneous Application and Data IntegrationTalend’s open source ESB…Continue

Tags: york, new, certification, training, talend

Started by nicolewells on Friday.

Workplace health and safety Signs 4 Replies

You cannot ignore the importance of safety signs at your workplace. There is no scope to underestimate the important to health and…Continue

Tags: Prohibition, Workplace, Warning, Signs, Safety

Started by healthandsafetysigns. Last reply by Jen McDade Sep 17.

Badge

Loading…

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service