Online Safety Community

Master advanced Excel techniques: Consolidating data from different workbooks

Event Details

Master advanced Excel techniques: Consolidating data from different workbooks

Time: May 16, 2019 from 1pm to 2pm
Location: 26468 E Walker Dr, Aurora, Colorado 80016
Street: 26468 E Walker Dr,Aurora, Colorado
City/Town: Aurora
Website or Map: https://tinyurl.com/yxwrujy4
Phone: 7209961616
Event Type: online
Organized By: Training Doyens
Latest Activity: May 7

Export to Outlook or iCal (.ics)

Event Description

Linking and consolidating data in Excel workbooks is an important skill for those who use Excel on a regular basis. Our upcoming webinar discusses the Excel consolidate function which lets you select data from its various locations and creates a table to summarize the information for you.

The webinar covers the following key areas:

  • Creating linked cells and grouping worksheets
  • Using 3-D references in summary functions
  • Creating external reference formulas

LEARNING OBJECTIVES

We all collect data and store it in multiple workbooks and in multiple worksheets. Summarizing data within a single worksheet is done on a regular basis. But at times you may want to combine data from multiple workbooks and worksheets into a YTD summary or consolidate data from multiple worksheets in a single worksheet.

Excel has many options for linking and consolidating data in Excel workbooks that allow you to create these summary reports.

WHO WILL BENEFIT

Any professional who uses Excel will benefit from learning how to use linked data, create external reference formulas and consolidate data in Excel.

Project Manager

Administrator

Associate

Chief Financial Officer

Accountant

Treasurer

Document Control

Health Information Technician

Marketing Manager

Speaker Profile: Cathy Horwitz is an independent consultant specializing in Microsoft Office instruction. She has over 30 years of experience as a Microsoft Office instructor.

Use Promo Code MKT10N and get flat 10% discount on all purchases

To Register (or) for more details please click on this below link:

https://tinyurl.com/yxwrujy4

Email: support@trainingdoyens.com

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

 

Check out our popular webinars:  

Power of Prioritization: How to Protect Your Time and Get More Done - https://tinyurl.com/y3osp2q5

3 Hour Bootcamp on Human Error Prevention and Reduction: Practical Tools and Techniques - https://tinyurl.com/y27m82tb

Comment Wall

Comment

RSVP for Master advanced Excel techniques: Consolidating data from different workbooks to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

Mark Nilson posted events
24 minutes ago
Training Doyens posted events
36 minutes ago
swethakumar posted blog posts
23 hours ago
Kelly Wilson posted a blog post

Why Check Out The Best FUE Hair Transplantation Facility

 There's minimal uncertainty left that Follicular unit extraction (FUE) is just one of the important and impressive strategies for obtaining your hair strands back on your head again naturally. What's more, it furthermore took into consideration as one of the most sophisticated treatment these days. Despite the fact that this word appears very complicated, the technique is astonishingly perfect for your hair. If you need to understand even more about Follicular Unit Extraction, after that you…See More
yesterday

Forum

5 Ways to combat complacency in your Safety Program.

Complacency is a state of mind where a worker is out of touch with the hazards and risks around them. It can show up in a number of ways: over-confidence, lack of care, mindlessness, actual physical…Continue

Started by Drew stone yesterday.

Workplace safety for workers other than your own 3 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 Paul Lancaster May 28.

Imagine a technology which is an artificial muscle and is integrated into textiles...

Such a smart textile has huge application potential and can support people in many different ways. The garment would use haptic feedback (i.e. the use of touch to guide the user) or could serve as a…Continue

Started by Ulla Siegel May 28.

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.

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.

Badge

Loading…

© 2019   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service