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.

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
Get course
30-Day Money-Back Guarantee

Includes

90 mins
Full lifetime access
Access on mobile and TV

Contact your Instructor