1
00:00:04,530 --> 00:00:09,970
In this section we're gonna get hands on. You'll be entering data and basic formulas in Excel.

2
00:00:10,020 --> 00:00:16,079
You're going to learn how to do basic formatting for cleaner and more professional reports.

3
00:00:16,079 --> 00:00:22,860
You're going to be able to use important features like dropdown lists in Excel and add data validation

4
00:00:22,860 --> 00:00:24,170
to the cells.

5
00:00:24,180 --> 00:00:31,140
This way you can restrict what's allowed to be input in each cell. Which is important to know specially

6
00:00:31,140 --> 00:00:36,040
if you're designing Excel templates that you want others to fill.

7
00:00:36,060 --> 00:00:42,930
You'll learn how to add comments to cells, timestamps to your reports and work with auto fill.

8
00:00:42,930 --> 00:00:48,420
In addition to this we're going to be covering some key features that aren't usually talked about in

9
00:00:48,420 --> 00:00:53,850
an Excel basics course. But they're going to help you become more efficient and they're also going to

10
00:00:53,940 --> 00:00:56,670
make your workbooks look more professional.

11
00:00:56,670 --> 00:01:00,630
For example you'll know how to add screen tips to your reports.

12
00:01:00,630 --> 00:01:06,750
This provides additional information on what's in the cell or what needs to be input in a cell.

13
00:01:06,810 --> 00:01:09,930
It's a more elegant version of a comment.

14
00:01:10,110 --> 00:01:16,230
If you receive a workbook from a colleague and you quickly want to see which cells have formulas and

15
00:01:16,230 --> 00:01:22,680
which don't, you're going to know how to do that by the end of this section. You'll also learn about

16
00:01:22,680 --> 00:01:23,370
FlashFill,

17
00:01:23,610 --> 00:01:28,470
adding custom lists and a hidden Excel feature for inputting data.

18
00:01:28,650 --> 00:01:30,330
Lots of fun stuff coming up.

19
00:01:30,380 --> 00:01:34,110
Just don't forget to do the challenge for this section before you move on.

20
00:01:34,200 --> 00:01:34,920
If you get stuck.

21
00:01:34,920 --> 00:01:38,700
Check out my version of the answer at the end of the section.

22
00:01:38,820 --> 00:01:39,600
All good.

23
00:01:39,660 --> 00:01:40,540
Let's get started.