how can you easily automate your work in Microsoft Excel without using macros or
programming hi I'm dawn Bjork the software Pro I'm also a Microsoft
certified trainer and certified Excel expert Microsoft Excel includes a number
of built-in automation features including autocomplete autocorrect and
Auto calculate you've likely used the autocomplete feature anytime you're
filling in a list of data for example when you start typing an entry here I
want the supply room Excel will try to autocomplete that is suggest from the
available responses that are already in that column and if this is what I want I
can simply hit enter if it's not we can keep typing that works great when these
are unique entries what happens when you have really similar entries this might
mean that you're having to type a lot of characters for you to finally get to
that unique entry and this can be very time-consuming especially when you have
lengthy notes for comments let's say for instance we want to reference a
particular conference room well there's multiple conference rooms and they all
begin with that phrase so here's the other way to approach it to get that
list of options rather than trying to type press Alt + the down arrow key all
you have to do Alton the down arrow key here's a list of all of the unique
entries in that column we can simply select the one we want and we're done
another way to get that list is to instead right-click on the cell and
choose pick from drop down list it's the same as pressing alt in the down arrow
key you can either use your mouse to navigate to it or you can use your arrow
keys and then simply enter or select the one that you want and that's how we can
leverage the autocomplete for faster data entry autocorrect is another quick
way for us to be able to easily enter in data
you may have noticed this as you start typing for instance I'll do teh as in
the and as soon as we hit a space punctuation or the Enter key then Excel
will check this against its list of already existing Corrections now most of
these are spelling errors and it will fix it for us and in this case now we
have then the corrected entry for this word but we can also leverage this to
create like a shorthand for lengthy entries we might enter in such as our
department name or organization name let's look at how we can work with the
autocorrect feature we'll find this under the file tab next move to options
from here select proofing and then autocorrect options proofing is not only
for spelling but also for some of these other built-in features you'll notice
here some of the characteristics here where Excel will try to fix some of your
entry in terms of capitalization but the autocorrect feature that we're going to
focus on is replace text as you type the list on the left hand side tends to be
spelling errors that here's what you might type and here is what we'll fix
and we've got over 500 entries that are built in but we can put in our own
variations here I'm going to create just a shorthand here now be careful not to
use any acronyms that you might actually use but it could be a variation your own
version of that shorthand and this is what I want Excel to do that is every
time I type in the shorthand replace it with the century I'll add it and we
could build others for now though I'll simply okay out come back to my
worksheet and keep in mind that this is something that's used by the
entire system so it's not just for this one worksheet now I'll put in that
shorthand and it can be included in a larger entry and as soon as I hit enter
or a spacebar Excel will spell it out for me
how could you save time with data entry by using autocorrect Auto calculate is a
great Excel feature that lets you quickly check totals averages and much
more although it doesn't actually build calculations or formulas it can be a
quick auditing tool simply select the range that you want to work with next
look in your status bar at the bottom here and you will see the average count
and some of the selected range if this isn't displaying for some reason or you
even want to leverage more from Auto calculate simply right-click on your
status bar and notice near the bottom here we have additional options the
check mark indicates which of these are currently enabled and so if you wanted
to for instance also see the minimum you could select that and it becomes another
part of this Auto calculate so this is not something you have to turn on it is
just automatically there as part of how you are viewing that selected range how
can you take advantage of these automatic features in Excel now you've
seen how to save time and effort by leveraging the automation tricks in
Excel or more tips and shortcuts on being productive with Excel head to the
software procom slash excel if this training was helpful please like and
comment on this video and subscribe to this channel this is dawn björk the
software pro thanks for watching
you