Loading Events

« All Events

Public Webinar: Excel Dashboards via Drop-Down Menus (Hosted by Aurora Training Advantage)

August 19 @ 1:00 pm - 2:30 pm

 
Need to churn out dozens of matching visual reports — one per company, school, program, city, etc — but don’t have the time or energy to copy and paste back and forth a million times between Excel and Word? First, I’ll give you a quick overview of the technique. Next, I’ll build a snapshot from scratch so that you’ll know what to do first, second, and third.

 

Agenda

Introduction to Dashboards

  • What is a dashboard?
  • Types
  • Value of automation process

Overview of 7-Step Automation Process

  • Designing the dashboard
  • Setting up the spreadsheet
  • Building drop-down menus
  • Building the data table
  • Building charts
  • Finalizing alignment
  • Printing or PDFing

Live Demo of Automation Process

 

Materials

Attendees will receive:

  • A 3-page guide that spells out the automation process in more detail
  • The primary dataset used during the webinar (population statistics for Virginia counties)
  • A secondary dataset that you can explore on your own (an organization’s social media statistics)

 

Examples

Trying to decide whether this automation process is ideal for your projects? Check out these examples.

Creating data tables for your appendices:

Creating one-page summaries with a mix of charts and text:

 

Level

Intermediate to advanced spreadsheet and data analysis knowledge. I suggest watching a few of my free tutorials prior to the webinar: annkemery.com/excel

Target Audience

Analysts, businesspeople, and social scientists who need to churn out a series of matching visual reports.

 

What People are Saying

“I did get a lot out of the webinar, but the support materials and videos make all the difference.  And it’s smart and generous of you to give us access to the webinar for review. You are offering something very special. I’m feel pretty skilled with analyzing, interpreting, and presenting data, but I’m going to be able to bump my skill set up to a whole new level with your help.”

 

Register

This public webinar is being generously hosted by Aurora Training Advantage. Registration will open in mid-July. Check back then for details.

 

Details

Date:
August 19
Time:
1:00 pm - 2:30 pm
Event Category:
Event Tags:
, , ,

Venue

Webinar

Organizer

Ann K. Emery in partnership with Aurora Training Advantage
Email:
Website:
http://auroratrainingadvantage.com/
Togel Togel Togel Togel Togel Togel Online Toto Slot Togel Online Togel178 Pedetogel Pedetogel Situs Togel Terpercaya Togel178 Togel279 Toto Macau Situs Togel Bandar Togel Agen Togel Bo Togel Daftar Togel Togel279 Toto Macau Colok178 Bo Togel Terpercaya Toto Togel Sabatoto Slot Server Luar Negeri rote4d rote4d rote4d togel158 togel158 togel279 togel279 pedetogel togel178 rote4d sabatoto Togel279 Rote4d Togel Online togel sabatoto pedetogel colok178 Slot88 Situs Togel Prize 123 Bo Togel Terpercaya Togel Online Daftar Akun Togel Resmi Toto Macau Toto Togel Situs Togel Terpercaya Situs Togel Via Pulsa Tanpa Potongan Daftar Togel Via Pulsa Tanpa Potongan Daftar Togel Via Dana Togel Via Dana Toto Slot Bandar Togel Hadiah 4D 10 Juta Terpercaya Bandar Togel Hadiah 4D Bo Togel Hadiah 2D bo togel terpercaya Togel279 Sabatoto togel158 pedetogel Pedetogel togel158 pedetogel togel178 sabatoto togel279 pedetogel pedetogel rote4d togel158 togel Togel Kingkong kingkong4d kingkongpools togel bolak balik pedetogel sabatoto pragmatic178 togel178 togel158 novaslot88 togel279 pedetogel sabatoto togel158 novaslot88 togel279 togel178 Togel Togel Dana Toto Situs Toto Result Toto Macau Result Toto Macau Toto Togel ladangtoto Bandar Togel Terbesar Togel Bet 100 badak188 Toto Slot Daftar Togel Togel Via Pulsa Kode Syair Sdy Aplikasi Togel Syair Toto Agen Togel Terbesar Bo Togel Daftar Akun Togel Situs Togel Bet 100 Perak toto togel dana toto toto macau Bandar Togel Hadiah 4D 10 Juta Terpercaya Toto Slot Situs Toto Bo Togel Terpercaya Togel Via Pulsa Togel Prize 123 Togel Bet 100 Agen Togel Situs Togel Hadiah Daftar Togel Daftar Bandar Togel Bo Togel Hadiah 2D Daftar Akun Togel Bandar Togel Bebas Invest 5 Situs Togel Resmi Terbaik Dan Terpercaya togel ewallet Situs Togel Terpercaya Bandar Togel Result Toto Macau Togel Diskon Bo Togel Bolak Balik Dibayar Aplikasi Togel Terpercaya Togel Via Dana Ovo Gopay Linkaja Bo Togel BBFS ladangtoto ladangtoto2 toto macau