1.1 Exploring excel interface

#1

1.1 Exploring excel interface

#2

1.2 Excel backstage view

#3

2.1 Manage workbooks

#4

2.2 Manage worksheets

#5

2.3 Working rows and columns

#6

2.4 working with cells

#7

3.1 Entering data into cell

#8

3.2 Entering time and multiple values

#9

3.3 Formatting values

#10

3.4 Applying custom formatting

#11

3.5 Auto Fill

#12

3.6 Creating custom list

#13

3.6 Undo and redo

#14

5.1 Introduction to Excel charts

#15

5.9 Working with recommended charts

#16

5.2 Working with column charts

#17

5.4 Stack column chart

#18

5.3 Clustered column chart

#19

5.5 Bar chart

#20

5.6 Line chart

#21

5.7 Working with Pie chart

#22

5.8 Protips for working with pie charts

#23

6.1 Sort data chronologically

#24

6.2 Sort data alphabetically

#25

6.3 Sort data numerically

#26

6.4 Sort data by color

#27

6.6 Filter data by date

#28

6.8 Filter data by text pattern

#29

6.7 Filter numeric data

#30

Introduction to Data validation

#31

6.9 Advanced Filter

#32

Creating a drop down list

#33

6.5 Multi-level sorting

#34

Creating expandable drop down list

#35

6.10 Freeze panes

#36

Whole numbers restriction

#37

6.11 Split window

#38

Decimals

#39

Introduction to the course

#40

Text validation

#41

Date validation

#42

Custom option

#43

Error Alert and input message

#44

Module conclusion

#45

Download exercise file

#46

Download the exercise files

#47

Introduction to Basic Excel formulas

#48

Introduction to basic functions

#49

Download sample practice workbooks

#50

The IF Function

#51

Introduction to Date functions

#52

Using case functions

#53

Extracting Text

#54

Extract Text with TEXTBEFORE, TEXTAFTER

#55

Combining Text

#56

6 Using the TRIM and REPT Functions

#57

Project 1

#58

Project 2

#59

Project 3

#60

Final capstone

#61

6.12 Remove duplicates from datasets

#62

What you need for this course

#63

Conclusion

View full lessons Check course learning page