Download "Excel INQUIRE Add-in"

"videoThumbnail Excel INQUIRE Add-in

0:00

Contents

0:15

Get the Add-in

1:05

Compare Two Spreadsheets

3:15

Workbook Analysis

4:10

Clean Excess Cell Formatting

4:57

Workbook Passwords

5:27

Conclusion

How to Use Excel Formulas

How to Use Excel Formulas

Channel: Sele Training

Импорт данных множества интернет-страниц в Excel с помощью Power Query

Импорт данных множества интернет-страниц в Excel с помощью Power Query

Channel: Билял Хасенов – Excel, VBA & More

Crear APP de Gestión de Inventario en EXCEL: control de existencias, stock mínimo (DESCARGA Archivo)

Crear APP de Gestión de Inventario en EXCEL: control de existencias, stock mínimo (DESCARGA Archivo)

Channel: SMARTpro Academy

Outlook Проверка орфографии в сообщениях электронной почты

Outlook Проверка орфографии в сообщениях электронной почты

Channel: By Powerful

Сортировка данных в MS Excel

Сортировка данных в MS Excel

Channel: Езепов Дмитрий

20 приемов и трюков MS Excel для продвинутых

20 приемов и трюков MS Excel для продвинутых

Channel: Езепов Дмитрий

8 инструментов в Excel, которыми каждый должен уметь пользоваться

8 инструментов в Excel, которыми каждый должен уметь пользоваться

Channel: Билял Хасенов – Excel, VBA & More

Условное форматирование в Excel

Условное форматирование в Excel

Channel: Езепов Дмитрий

Cómo crear un DASHBOARD super fácil en Excel (Clase #4)

Cómo crear un DASHBOARD super fácil en Excel (Clase #4)

Channel: SMARTpro Academy

Введение в базовый экспресс-курс Excel для начинающих

Введение в базовый экспресс-курс Excel для начинающих

Channel: Езепов Дмитрий

excel addin

excel inquire addin

excel formulas

compare spreadsheets for differences

compare two spreadsheets

worksheet relationship

compare files

clean excess cell formatting

clean formatting

workbook analysis

excel

excel 2013

excel 2016

excel 2019

microsoft 365 excel

sele training

seletraining

00:00:00

did you know you can use the excel

00:00:02

inquire add-in to compare the

00:00:04

differences between two spreadsheets and

00:00:06

it provides a whole bunch of other

00:00:07

information let's take a

00:00:11

[Music]

00:00:14

look sometimes you need to compare one

00:00:17

spreadsheet to another and see if

00:00:19

there's differences between the two a

00:00:21

great tool to be able to do this is the

00:00:23

inquire add-in you can access it by

00:00:25

going up to file

00:00:27

options

00:00:29

add-ins

00:00:30

and at the bottom

00:00:31

select com add-ins from this list and

00:00:34

hit go

00:00:35

here there's a check mark next to

00:00:37

inquire so check that and hit ok

00:00:40

and now you'll have this inquire tab

00:00:42

available on your excel menu

00:00:44

now what i've done is i've created a

00:00:47

spreadsheet of sample data i made a few

00:00:49

changes and i saved it out as another

00:00:52

modified spreadsheet and i can go up

00:00:54

here to view

00:00:55

and see that i have both of those files

00:00:57

loaded into excel at the same time and i

00:01:00

can switch between them

00:01:02

in order to do a comparison between

00:01:04

those two spreadsheets i can go to the

00:01:06

inquire tab

00:01:07

and click compare files and it brings up

00:01:10

the two files i have loaded in excel and

00:01:12

i can compare one to the other

00:01:14

click this compare button and it brings

00:01:17

up this comparison window

00:01:19

you can see the two spreadsheets right

00:01:21

here side by side

00:01:23

and the green highlights are the areas

00:01:25

where there are changes between those

00:01:27

two spreadsheets

00:01:29

you can scroll down through each and

00:01:30

look at different areas if you need to

00:01:33

but you also have a list right here of

00:01:35

all the cells that have changes and it

00:01:37

shows the value of the old and the new

00:01:40

so you can see the differences when you

00:01:42

click on one it actually brings it up in

00:01:44

the list so you can see where those

00:01:46

values are while you're in this window

00:01:48

you can move these bars around slide

00:01:51

open areas if you want to see things a

00:01:53

little bit better

00:01:55

and if you click on one of these sheets

00:01:57

you can resize the cells to fit you'll

00:02:00

also notice over here there are several

00:02:02

different areas of data that you can

00:02:04

check for so you could turn on and off

00:02:05

these different check box depending on

00:02:07

what you're trying to compare between

00:02:09

the two spreadsheets you also have a few

00:02:11

options up here on the menu showing

00:02:13

details show just formulas you can also

00:02:16

export the results out to an excel

00:02:18

spreadsheet and you can copy the results

00:02:21

to the clipboard so let's try this one

00:02:24

and we'll go ahead and copy and paste

00:02:26

those results into notepad so you can

00:02:28

see what it looks like as you can see it

00:02:30

shows each one of the spreadsheets the

00:02:33

cell location and the old and new values

00:02:36

this could be helpful if you want to

00:02:37

send somebody a note just telling them

00:02:39

here's the values that change from the

00:02:41

old to the new spreadsheet we'll go

00:02:42

ahead and close these windows

00:02:46

and going back to the inquire tab

00:02:49

not only can you compare files but

00:02:51

there's some other options here as well

00:02:53

like the worksheet relationship and as

00:02:55

you can see down here at the bottom i

00:02:57

have a sheet 1 sheet 2 and sheet 3 so if

00:02:59

i look at the relationship it shows a

00:03:01

visual graph

00:03:04

of the main spreadsheet and how it

00:03:06

relates to the individual worksheets

00:03:09

you can also do a comparison of the

00:03:11

actual workbook relationships if you

00:03:13

have a bunch of links between different

00:03:15

sheets

00:03:16

and another wealth of information can be

00:03:18

found by clicking on this workbook

00:03:19

analysis

00:03:22

here you have a list of all the

00:03:23

different categories of workbook data

00:03:26

links

00:03:27

formulas

00:03:30

cells ranges warnings so there's all

00:03:33

kinds of information that you can zero

00:03:35

in on about your spreadsheet

00:03:38

let's take a look at the visible sheets

00:03:39

and it shows sheet one two and three in

00:03:41

there

00:03:44

if you take a look at textual constants

00:03:47

that shows all the data values that have

00:03:49

been entered into the different cells

00:03:52

and the numeric values in their cells as

00:03:54

well so there's tons of information you

00:03:56

can look for in this analysis report to

00:03:59

help you work with different formulas or

00:04:01

different cell locations in your

00:04:02

spreadsheet and again this information

00:04:04

can be exported out to excel so you can

00:04:07

share it with someone else

00:04:10

another nice feature in the inquire tab

00:04:12

is the clean excess cell formatting when

00:04:15

you click this option it asks you if you

00:04:17

want to do the active sheet or all

00:04:19

sheets

00:04:20

i'll do it for the active sheet hit ok

00:04:23

and it asks if you want to save your

00:04:25

clean sheet i'll say yes what that does

00:04:28

is it cleans excess formatting by

00:04:31

removing cells from the worksheet that

00:04:33

are beyond your data element area so if

00:04:36

you do conditional formatting or some

00:04:38

other kind of cell formatting across a

00:04:40

wide area of data but your data only

00:04:43

accesses up to a certain point

00:04:45

everything outside of that where you've

00:04:47

formatted the cells will get cleared out

00:04:49

this can help reduce the amount of data

00:04:51

you have in your file reduce the file

00:04:53

size and the speed of your excel

00:04:55

worksheet as it does calculations

00:04:57

there's also an option here for workbook

00:04:59

passwords and that brings up a list of

00:05:02

passwords for your spreadsheets that you

00:05:04

want to analyze using the inquire tab

00:05:07

what you can do here is you can add any

00:05:09

password that you've set on a particular

00:05:12

spreadsheet file and when the inquire

00:05:14

tab tries to open that for comparing

00:05:16

files or other functions over here on

00:05:18

the menu it will use this password to

00:05:20

open those files the nice thing is this

00:05:22

data is stored and encrypted so nobody

00:05:24

can have access to it other than you

00:05:28

the inquire add-in is not available in

00:05:30

every version of excel but it goes back

00:05:32

quite a while so if we come back into

00:05:34

options add-ins and go down to com

00:05:36

add-ins hit go

00:05:38

you'll see this inquire checkbox here if

00:05:41

you have a valid version of excel that

00:05:44

contains that add-in it works in 2013

00:05:47

and newer versions of excel so if you

00:05:49

have excel for microsoft 365 excel 2019

00:05:53

excel 2016 or excel 2013 you'll be able

00:05:57

to use the inquire add-in

00:05:59

so if you're in need of doing some

00:06:01

analysis on the data elements in your

00:06:02

worksheets or to do a comparison between

00:06:05

one worksheet and another make sure to

00:06:07

check out the inquire add-in

00:06:09

and while you're at it wait to the end

00:06:11

of this video or look in the description

00:06:13

of this video to find links to other

00:06:15

great excel training videos on sealy

00:06:18

training

00:06:19

hey if you want to see more videos like

00:06:21

this one please subscribe and if you've

00:06:23

enjoyed this video be sure to click the

00:06:25

thumbs up and leave a comment i really

00:06:27

do appreciate your support

Description:

A hidden Excel add-in to compare one spreadsheet to another. This tool is available in Excel 2013 or newer and shows you the differences between two spreadsheets. The tool also shows formulas, links and other data contained in your spreadsheet and helps you clean excess cell formatting to speed up calculations. Support me with your Amazon purchases, click here: https://www.amazon.com?ie=UTF8&language=en_US Excel 2020 Best Tips and Tricks: https://www.youtube.com/watch?v=JPBkH8EjBNw Excel LAMBDA Function: https://www.youtube.com/watch?v=Ayc7QOadBa4 Top 10 Excel Formatting Tips and Tricks: https://www.youtube.com/watch?v=wT7NBdAoHo4 Introduction to Excel: https://www.youtube.com/watch?v=c2dcRy1X9AA Contents 0:00 Get the Add-in 0:15 Compare Two Spreadsheets 1:05 Workbook Analysis 3:15 Clean Excess Cell Formatting 4:10 Workbook Passwords 4:57 Conclusion 5:27

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Excel INQUIRE Add-in" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Excel INQUIRE Add-in" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Excel INQUIRE Add-in" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Excel INQUIRE Add-in" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Excel INQUIRE Add-in"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Excel INQUIRE Add-in"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.