Data connection in Microsoft excel file

Описание: From this video You will learn

Data connection in Microsoft excel file
Ms excel free tutorial,how to link data between multiple workbooks in excel,


WORKING FILE:
================================================================================
WORKING FILE: EMPLOYE SALARY FILE https://drive.google.com/file/d/15tZD...

SALES REPORT FILE https://drive.google.com/file/d/19TwB...

DATA CONNECTION FILE https://drive.google.com/file/d/1P7Ly...



GENERAL DESCRIPTION:
================================================================================
HOW TO DOWNLOAD AND USE THE WORKING FILE:
1. CLICK THE ABOVE LINKS
2. CLICK DOWNLOAD BUTTON ON THE TOP RIGHT CORNER
3. OPEN THE FILE AND CLICK ''Enable Editing" THEN YOU CAN USE IT.

WHAT YOU LEARN WITH THIS TUTORIAL:
In this video you will learn – how to USE “DATA CONNECTION IN MULTIPLE EXCEL SHEET”

TRAINING STEPS:

STEP-01:
DATA CONNECTION
-CONNECT MULTIPLE SHEET DATA
-A SINGLE FILE CONTAIN MULTIPLE SHEET DATA
-CHANGE THE DATA SOURCE FILE WILL AUTOMATICALLY CHANGE THE RESULTED FILE


STEP-02:
DATA CONNECTION
-THERE ARE THREE FILES HERE
1.EMPLOYEE SALARY
2.SALES REPORT
3.DATA CONNECTION

STEP-03:
DATA CONNECTION
WE HAVE TO CONNECT-
1.EMPLOYEE SALARY AND 2.SALES REPORT WITH --
3.DATA CONNECTION FILE

STEP-04:
DATA CONNECTION
-AND NOW OPEN THESE THREE FILE AND OBSERVE THE DATA
1.EMPLOYEE SALARY
2.SALES REPORT
3.DATA CONNECTION[ BLANK FILE]

STEP-05:
DATA CONNECTION
-AND NOW WE HAVE TO CONNECT THESE
1. AND 2. FILE WITH 3.
1.EMPLOYEE SALARY
2.SALES REPORT
3.DATA CONNECTION[ BLANK FILE]

STEP-06:
DATA CONNECTION
-AND NOW FOLLOW THESE STEPS
1.CLICK ANY BLANK SPACE
2.CLICK “DATA CONNECTIONS” UNDER “DATA”
3.CLICK “BROWSE FOR MORE”
4.LOCATE "1.EMPLOYEE SALARY" AND CLICK "OK"
5.CONFIRM "TABLE" AND "EXISTING "WORKSHEET" IS SELECTED UNDER
"IMPORT DATA"

STEP-07:
DATA CONNECTION
-AND NOW SAVE & CLOSE THE "DATA CONNECTION" FILE
-OPEN THE SOURCE FILE "1.EMPLOYEE SALARY''
-DELETE THE DATA UNDER ''SALARY'' AND "SAVE" THE FILE
-OPEN ''DATA CONNECTION" FILE
-LOOK DATA IS NOT UPDATED UNTIL CLICK
"REFRESH ALL''

STEP-08:
DATA CONNECTION
-AND NOW FOLLOW THE SAME STEPS FOR "SALES REPORT" FILE
1.CLICK ANY BLANK SPACE
2.CLICK “DATA CONNECTIONS” UNDER “DATA”
3.CLICK “BROWSE FOR MORE”
4.LOCATE "2.SALES REPORT" AND CLICK "OK"
5.CONFIRM "TABLE" AND "EXISTING "WORKSHEET" IS SELECTED UNDER "IMPORT DATA"

STEP-09:
DATA CONNECTION
-AND NOW SAVE & CLOSE THE "DATA CONNECTION" FILE
-OPEN THE SOURCE FILE "2.SALES REPORT''
-DELETE THE DATA UNDER ''TOTAL PRICE''
AND "SAVE" THE FILE
-OPEN ''DATA CONNECTION" FILE
-LOOK DATA IS NOT UPDATED UNTIL CLICK
"REFRESH ALL''

STEP-10:
DATA CONNECTION
HOW TO AVOID "REFRESH ALL"
-CLICK ANY DATA OF " DATA CONNECTION" FILE
-CLICK "CONNECTION PROPERTIES" UNDER " REFESH ALL"
CONFIRM THE FOLLOWING CRITERIA-
1.”ENABLE BACKGROUND REFRESH”
2.”REFRESH EVERY 1 MINUTE “
3.”REFRESH DATA WHEN OPENING THE FILE “
4.“REFESH THIS CONNECTION ON REFRESH ALL'' IS SELECTED

STEP-11:
DATA CONNECTION
HOW TO AVOID "REFRESH ALL"[CONTINUE]
-NOW CLOSE THE "DATA CONNECTION FILE"
-OPEN " SALES REPORT FILE"
-DELETE DATA UNDER "QUANTITY" AND "SAVE" IT
-OPEN "DATA CONNECTION FILE"
-NOW EVERYTHING IS AUTOMACTICALLY UPDATED VIA DATA CONNECTION


SAUNTER STUDIOS:
GENERAL INFORMATION:
================================================================================-This channel contains all about all Microsoft Word/Microsoft Excel/Basic Internet Tutorial Only. No other video will not publish here. Only the mention above; If you want any problem with the above category, We will solve any problem. Send your Query at [email protected].

-All the videos of this Channel contains associated music file but most of the people/some of the people may not like the music with video in terms of different issue. So it is desirable to on/off/silent/mute the Volume of the video based on your choice. All the accountability goes to viewers only in terms of music issue. This for your fair information only.

-This is a continue Microsoft Word/Microsoft Excel/Basic Internet Tutorial Channel so tutorial will be publish here sequentially & you will get the update immediately if you subscribe this channel. Stay with us & stay with new update. Thank you all.

MORE USEFUL EXCEL VIDEOS FOR YOU:
================================================================================►Microsoft Excel 3D Formula:
   • 3D formula in Microsoft excel  


CHANNEL JAMMING ON SOCIAL NETWORKING
================================================================================
►Subscribe to : SAUNTER STUDIOS
   / @saunterstudios  

►Instagram:
  / saunterstudios007  

►Facebook:
https://www.facebook.com/SStudios007/...

►LinkedIn:
  / saunter-studios-0779b11b3