XLTools 2.1 Features Overview Webinar (Free Excel Add-In)

For more information about free XLTools Add-In for Excel visit: http://xltools.net/

This webinar is a great introduction to XLTools for anyone who uses or wants to use our Excel Add-Ins collection. We will take you through our software and point out all the features you can use to speed up your daily routine work.

In this video you will lear about:
- Major XLTools features and how to use them
- New features in upcoming version
- Real use cases and scenarios
- New ways to automate your daily work

---

Closed Caption:

hello everybody and welcome to XO tools
features
over you are you ready now I hope you
have a good day today and
say ready to see some cool features
about execution going to show you
however before we start talking about XO
tools
let me edit introduce myself my name is
it a Latin and I am and the founder of
axle to that nap I also work for a
software company call
with when weighing did CSTO and
cofounder
where young company but our team it's a
great experience in
bus software development and business at
the mission areas
is that being said I think it would be
nice
Press anyone says it to use Microsoft
Excel about
actually area Commission project if ever
done
a step up from some sort of Excel
spreadsheet so
I can say its many expressed and despite
all the power of Microsoft Excel be of
107 cases
lamb some operations take a lot of time
to complete
in such cases VBA script or some such
but it didn't
helps asked to perform precious ice and
really that's the main goal of
excellent tools it helps you to perform
some corporations neck so
us fast as possible so you too few 3
at some point of time I just try to you
all of
hour work week if ever done in Excel and
pass out wanna to combine all those
internally developed tools and not to
publish them
for idly XO you dislike past it to us
end of 27 setting and that was the time
when
XO to sit down with them okay now
let's check had at least two features
who caffeine our
Ebdon can 2 a.m. if you install XO
tools on you computer you'll yet an
excellent book
which mill clare is similar to what you
see on my screen right now
you can use this were booked to play
this all major features
of axle tools and this medication tell
which can be used to jam specific or she
can
latest feature when they planned to
spend an hour
I want to start is the most lasting most
used
future cold Excel tool up handout but
you probably know we are currently
working honest
version and discussion has fun great to
share want to show you before the candor
I think many use of Excel few
this kind of problem when you catch many
work she saying you don't have an easy
way to navigate between them
of course you can use control PDF
and control page down yet getting sheets
and he's another option and a few
overall
third least included all right click
here little
penalties can be used to it similar way
to select she cuny but none of those
features
reliant say every year great user
experience
Lake for example you kept venues I stop
hinders he you can quickly
jump between most-used applications and
let's cool user experience in my opinion
so in our next version of actual 23
provided the same kind of experience far
you were saying
if you install exe to some leak
control I'll right you'll see
little pop up beach holds you to select
specific cutie need and more
this to Lil remember each sheets or used
before and the current one endfield jump
you right to the
sheet so as an example let's
a select repeat selection she'd
conditions used to shoot and
imagined it we need to jump back we
simply click control I'll try
and the event on its election and if you
need to mitigate
make maybe you have really lots of a
sheets and we can maybe use mouse to
scroll
she's hooking hey use contrail I suit to
write
mishandled initial up and you might be
given to a select some
quite cheap and if you kept many she
stayed with the scrolling
here and you can scroll so go back to
main street
and to acknowledge me he took
about Canada here have simple greed to
use
to date columns any one column says date
and time from
if you and a used just 60 and you need
to enter somewhat dates
here it would be question task at least
for me I can say it to they'd sitting
in Excel before we created our pup and
their with this tool you can
easily change any update in you
worksheet and you don't need to worry
about the former update
you know have to I'll write all
part so the date men a lake Mon state
and a year
and even better it can handle cases for
an
it sees it particular calling in dates
only in
it in propose you too and to date in
attempt to sell
additional fee change the option to
handle at times
well so I can this till you see date and
time
and issue Lee did P carrot it will
display
time editing option as well
so thats Isabel about going in there and
the next to share your show you this
national history
it's very useful when you work here
musica XO
looking well human if you have personal
world would miss you
been periodically F changes to it Amy
need some way to store history of
changes cleared up
in actual tools you as
option when you half you workbook had
already saved and shared drive
or a local drive a in
easily make a textual to see the new and
click
enable history he is an option to enable
he three and
additional a checkbox each hours you too
said the option when XO tools new
require
each user to at coleman's he saves a
document
we'll use this option enabled and in
English in history
so from this plan stein you save the
document
you'll be proposed use their special
window to
at Corinth and you can say fewer ships
I think simple it's headed this great so
a CCNA
Daily Grace trick that Snape and two can
at date
hate change some will use
hey say this version
after
musician his three hey lauren had some
russians
work because a a enables accused it
before in them
they will but a he here's
our first Russian and next and
in this heat Eric M open in your shin
Rosa
were will miss you seen before teach you
to
was save a UA maybe
week ago on months ago and even while
you can
cynical particular worksheet and few
changes
have been down in this particular reason
but this you select edition ps3
confidence again policy question used to
shoot and
show changes and he is their
to worksheets older one and never on
and a the changes highlighted in red
so its cool feature to see outlook has
changed
of course issue if you're change what
I've seen fake
at a you at new column so admirals
it a lot were quiet
with for such cases but so simple kiss
this lake is great
this billion a key
now let's move to another area some few
she reaches new
and will be available in Excel tools 2.1
nicollette repeat selection function
here girl so
the question if how do you select all
green
cells in this worksheet and
another question how do you select old
type Collins
here let's you visit we need to
to provide some data data validation for
this column
and it should show only tired and type
/strong
from shift I get less at this
first question and the answer is quick
and simple
it can use peace election tool to repeat
this
elections for this unit Jeff select a to
tell
be to check out the free cell and leak
repeat selection
it will show you a the wrench to fix
your selection tool way you want to
specify the range
to repeat account selection click OK
and old mean selfish neck you know you
can change the fellowships
to be right and so on
the same way you can select all white
cells and the
select a to a freebie 3
and Lee repeat selection
here at all
all-white self-inflicted and folk
question to
if you don't use any had been a and many
to snake columns like chef here
will meet to do it like men only
one by one and if fear by mistake
selected another call on this no way to
go
back and tissue selected again
and you can imagine if the f loss
froelich
to 2002 girls in this
hungry to be a real pain to select
although he has to
select one scroll down select in an
alarm
school up scroll down that span so
is sexual tools should be selection of
you sure you can snag just one column
and use use it out to
to apts next so here we go
week F I'll call on selected and now you
can go to date it up
and at something between a politician
illogic
which is was already fed me before and
all our field smoke in here Hillis Sep
Inc just
a final example and for better
understand cuz
show is somewhat complex a stuff
here some good example
we kept happy customer here and what if
want to care more customers that simple
usually this one as you see it quite
complex election
and a he can repeat it it
automatically selects fair you need and
here we kept many happy customers I made
the cake
in green so search
I repeat selection tool next they would
like to
move to someone specific tools and
you probably will not need just tools
right
maybe tomorrow or today after but
it's good to know that rushed through is
make a mainstream and the
next to is and P that cable
and its
so at when you collect some data from
I from your team of from
and I'll from somewhere else you
may often meet their types of great like
this
way have a bike day one day
three-day to some values in columns and
a.m. edited but if you want
to import such and updating some said
but a system said
sir really painful to come here today to
from size former to watching you
and that's why we created I'm cuticle
tool
way you can't select has agreed to issue
need
to transformed to flatten you than you
can
ass it's 508 me to put the result and
came and he is here for to you
so quick and simple and the next example
is sir they typically Inc
when you get to data from some sup buddy
system
yen or like maybe 12
at him pretty a emails from
outlook anxiously you can't
maybe you have some data from there
us and et cetera and
it's often the case when you have some
redundant
hairy information here data like white
space
and here for you if you have rights
basis in the beginning forces
and not so bath because you see them
but if you see have twice basis in
Vienna for Tue its
painful two innings in because Galaxy
and for this for such cases say created
date between to which can be used to
quickly removed all such redundant
informations from from here that new
data
you sling typically inching had tool
them as its final election issue 12
couldn't to process and click Apply
and all your date is fixed
and is numbers to text auction and
texting number us
the their also can be useful in certain
cases salutes
the channel weekend as well
a key the next she chased
on sorry combs much
to thats
house acquits this issue had tool but
if you craft data of
fresh and SEC but on my screen
and you probably might need to
compare what is a.m. similarity of
Carl dating columns and
cone smudge tool can be used to compare
dating
each column and today you met metrics
United see the percentage show for much
for
for each column like care you can
compare combs its
each out there are you can compare cones
says
and their columns and
get the result so this to Los quite
useful here
one of our projects as well and
term which most heavily
the last but it's really useful & really
powerful share want to show your
his the feature
which Colt no mediate automation
the basic AD roses future use to let
me use wood don't know UPA
some ability to obtain its airdrop
and has a simple example estimation the
case
way half some particular count and
email account way we get some date a
boat and it's a
downloaded from our website like I have
on actual tools
we didn't create any death race yet so
when you download
to New rushing from our website by
getting email
and which looks way
like this one have some date a neat
and invent I want to fires is data and
it should be automatically because hey
if I'd do it fairly it'll take a lot of
time
so outlook us cool option which
Alice you too expert all your emails
from your any books for example to a CSV
file
and this trial can be allocated the
near to the file he's used to
parcels data and Tre xl2
you mean auction to write some steps
Beach has to be done is did data in the
former
death simple table so I don't need to
write any
be a quote Shea needed to make
if I don't excellent will say I'll to
start to
program on the DA do some parsing
a and so on but is XO still sake and
Esther
right a simple table of contents as you
can see it he is the first
come which called extract table and
essay I need data from in books and two
should I'll should would dating you
should call downloads
and if you this inbox let me know
very carefully stuff email she chose
expect this from my outlook and
I need to parse them first
gone 26 truck table I can extract a.m.
table from she teaches a.m. in the same
or book
or it can be different for books right
at I'll name here
this one which should be placed in the
same an
place where this horrible kissed her so
the next
comment is stable futile because they
need to future only
emails huge new his chest San
but she coulda title and the last
comment is the play template which is
most useful commenting
as this tool because you can why some
s some kind of template 28 your data
and two it to up to magically transform
it
to some had particular view this you
need
so in this example I created some
formulas she can be a use to
yet date they need from my experts
file expert to trial and two
let's see how it works I just select
whole my comments go to excel tools say
regal Union and click execute
and he s see how all my data quickly
transform
to I S table which can be used to
analyze
like creature rushing of Excel his used
by must've customer since I'm
I think earth all I wanted to show you
today
and if you want to don't know it extra
tools
2.1 released to you you can do it on
our website Linkous right here
miss you Nick you can going to the
download preview version
and this my not be quite stable right
now
and keep going force you can I'm bucks
in it but
new releases stable Russian area so
maybe in the end of this
month so you'll be %um able to use it to
me
in full power and invent I would like to
personally thank you XO address members
for organizations
for garnishing his fader and
thank you for your attention I hope a.m.
to see you ask our have to cut them in
in the near future