In this section we're gonna get hands on. You'll be entering data and basic formulas in Excel.
You're going to learn how to do basic formatting for cleaner and more professional reports.
You're going to be able to use important features like dropdown lists in Excel and add data validation
to the cells.
This way you can restrict what's allowed to be input in each cell. Which is important to know specially
if you're designing Excel templates that you want others to fill.
You'll learn how to add comments to cells, timestamps to your reports and work with auto fill.
In addition to this we're going to be covering some key features that aren't usually talked about in
an Excel basics course. But they're going to help you become more efficient and they're also going to
make your workbooks look more professional.
For example you'll know how to add screen tips to your reports.
This provides additional information on what's in the cell or what needs to be input in a cell.
It's a more elegant version of a comment.
If you receive a workbook from a colleague and you quickly want to see which cells have formulas and
which don't, you're going to know how to do that by the end of this section. You'll also learn about
FlashFill,
adding custom lists and a hidden Excel feature for inputting data.
Lots of fun stuff coming up.
Just don't forget to do the challenge for this section before you move on.
If you get stuck.
Check out my version of the answer at the end of the section.
All good.
Let's get started.