SA Campus Online > IT and Computer Studies > Excel for Beginners

Excel for Beginners

Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs.

This course is perfect for anybody wanting to start learning the basics of Excel at a beginner level.

Wilkie Wilkinson

971 students enrolled

Microsoft Excel is the industry leading spreadsheet program used for data calculations, analysis, visualisation and much more; it also has many external programming features. Excel is one of the best programs available for data modeling, statistics and financial calculations. Having sound Excel knowledge is typically required for accounting, business analytics, data analysis and statistics jobs.

This course is perfect for anybody wanting to start learning the basics of Excel at a beginner level.

Session 1: Excel Interface

1

1. Quick Access Toolbar

0:49

2

2. Menu Tab

0:16

3

3. Groups

0:28

4

4. Ribbon

0:34

5

5. Formula Bar

0:24

6

6. Name Box

0:41

7

7. Select All

0:22

8

8. Scroll Bars

0:16

9

9. Sheet Tab Control Buttons

0:22

10

10. Status Bar

0:23

11

11. Page Views

0:31

12

12. Zoom

0:20

Session 2: Excel Options

1

13. Number of Sheets

0:36

2

14. R1C1 Reference Style

0:43

3

15. Move Selection after Enter

0:33

4

16. Hiding Formula Sheets Rows and Gridlines

0:41

5

17. Zero Values

0:31

Session 3: Mouse Pointer Shapes

1

18. Mouse Pointer Shapes

1:25

Session 4: Mouse Selection Techniques

1

19. Mouse Selection Techniques 1

0:41

2

20. Mouse Selection Technique 2

0:35

Session 5: Entering and Editing Data

1

21. Entering Data in a Cell

0:41

2

22. Edit Using the Formulae Bar

0:13

3

23. Edit Cell Content Directly in the Cell

0:37

4

24. Inserting a Note in a Cell

0:27

5

25. Inserting a Comment in a Cell

0:38

6

26. Delete Note and Comment

0:17

Session 6: Working with Sheets

1

27. Rename a Sheet

0:30

2

28. Hide and Unhide Sheets

0:45

3

29. Deleting a Worksheet

0:18

4

30. Sheet Selecting Techniques

0:48

5

31. Copy a Sheet

1:19

Session 7: Working with Rows and Columns

1

32. Hide and Unhide Rows

0:18

2

33. Hiding and Unhiding of Columns

0:24

3

34. Insert and Delete Columns

0:33

4

35. Inserting and Delete Rows

0:28

5

36. Resizing Columns

1:10

6

37. Row Height

0:36

Session 8: Copy Paste Move and Insert Text

1

38. Copy Move and Insert Text

0:50

2

39. Copy and Paste

0:47

Session 9: Autofill

1

40. Autofill

1:14

2

41. Custom List

1:03

Session 10: Formatting Cells

1

42. Wrap Text

0:15

2

43. Format Cells Currency

0:30

3

44. Merge and Centre

0:22

4

45. Format Cells Font

0:51

5

46. Format Cells Time

0:29

6

47. Format Cells Text

0:46

7

48. Format Borders and Fill

0:29

8

49. Format Cells Accounting

0:32

9

50. Custom Format

1:01

10

51. Format Overview

0:37

11

52. Autosum Custom Format Values

0:11

12

53. Format Painter

0:36

Session 11: Basic Calculations

1

54. Adding Non-Consecutive Cells

0:43

2

55. Addition Method 1

0:25

3

56. Addition Method 2

0:28

4

57. Addition Method 3

0:37

5

58. Division

0:25

6

59. Multiplication

0:28

7

60. Subtraction

0:16

Session 12: Working with Functions

1

61. Average

0:37

2

62. Max

0:34

3

63. Min

0:39

Session 13: Sorting

1

64. Sorting 1

0:28

2

65. Sorting 2

0:28

3

66. Sorting 3

0:26

4

67. Sorting 4

0:36

5

68. Sorting 5

0:22

Session 14: Paste Special

1

69. Value

0:32

2

70. Comment

0:29

3

71. Paste Link

0:40

4

72. Multiply

0:22

5

73. Transpose

0:27

ASSESSMENT

1

Excel for Beginners: Assessment

20 questions

Be the first to add a review.

Please, login to leave a review

Related Courses

Hot

advanced

IT and Computer Studies

Excel: An Advanced Level Course

R900

Wilkie Wilkinson

Excel: An Advanced Level Course

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Advanced Principles of ...

Advanced

39 Lectures

1 week

Preview this course

Add to Wishlist

R900

Hot

intermediate

IT and Computer Studies

Excel: An Intermediate Level Course

R800

Wilkie Wilkinson

Excel: An Intermediate Level Course

This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles...

Intermediate

69 Lectures

1 week

Preview this course

Add to Wishlist

R800

Hot

excel pre assessment

IT and Computer Studies

Excel: A Free Pre-Assessment Tool

Free

Wilkie Wilkinson

Excel: A Free Pre-Assessment Tool

The purpose of this FREE Excel Pre-Assessment is for you to understand the level of training you require, before enrolling in one of our comprehens...

Beginner

20 minutes

Preview this course

Add to Wishlist

Free