Online Safety Community

Linking and Consolidating Data in Excel Workbooks

Event Details

Linking and Consolidating Data in Excel 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: http://tinyurl.com/y4voaslr
Phone: 7209961616
Event Type: online
Organized By: Training Doyens
Latest Activity: Apr 18

Export to Outlook or iCal (.ics)

Event Description

OVERVIEW

Excel provides the ability to connect a cell to data entered into another cell. A linked cell behaves as if it actually contains the data in the original cell.

A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern while cells on each worksheet contain the same type of data. Grouping worksheets is an important skill to have for many more reasons than creating 3-D formulas.

Creating names for cells can make formulas between worksheets and workbooks much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. A 3D named range is a name that spans more than one worksheet.

Although you can copy and paste data from one Excel file to another, you can also create a link between two files or workbooks. When you create a link between files, the copied data updates when the original data changes.

Once links between workbooks are created, the links have to be maintained if the source files are moved or renamed.

The consolidate function in Excel combines information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you.

WHY SHOULD YOU ATTEND

Linking and consolidating data in Excel workbooks is an important skill for those who use Excel on a regular basis. Linking data can be used to prevent holding many copies of the same data.

It is an excellent method of showing a summary of up to date data.

AREAS COVERED

  • Creating linked cells
  • Grouping worksheets
  • Understanding 3-D references
  • Using 3-D references in summary functions
  • Naming cells
  • Creating external reference formulas
  • Editing links
  • How to consolidate data in Excel from multiple worksheets

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

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

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

http://tinyurl.com/y4voaslr

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 Linking and Consolidating Data in Excel Workbooks to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

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
1 hour ago
Mark Nilson posted events
2 hours ago
Training Doyens posted events
yesterday
Mark Nilson posted events
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