Conteúdo do Curso
Excel Essentials
Excel Essentials
Entering Data
Efficient data entry is crucial for using Excel effectively. While basic text and number entries are straightforward, Excel's powerful features like AutoFill and Flash Fill save time by automating data patterns and extending series like numbers or dates.
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tudo estava claro?
Escolha seu plano
Entering Data
Efficient data entry is crucial for using Excel effectively. While basic text and number entries are straightforward, Excel's powerful features like AutoFill and Flash Fill save time by automating data patterns and extending series like numbers or dates.
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tudo estava claro?
Escolha seu plano
Entering Data
Efficient data entry is crucial for using Excel effectively. While basic text and number entries are straightforward, Excel's powerful features like AutoFill and Flash Fill save time by automating data patterns and extending series like numbers or dates.
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..
Tudo estava claro?
Efficient data entry is crucial for using Excel effectively. While basic text and number entries are straightforward, Excel's powerful features like AutoFill and Flash Fill save time by automating data patterns and extending series like numbers or dates.
Tarefa
- Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill in the Data tab, in Data tools. - Highlight the cells from
L7
toL18
& click on Flash Fill in the Data tab, in Data tools..