Course Content
Excel Beginner Resources
-
Excel Beginner Resources
00:00 -
Excel – Beginner – Course Info
00:00
Section 1 – Excel Beginner
-
1 – Introduction
01:02
Section 2 – Excel Fundamentals
-
2 – Launching Excel
01:58 -
3 – Start Up Screen
02:53 -
4 – The Excel Interface
00:00 -
5 – The Quick Access Toolbar
02:12 -
6 – The Ribbon
04:43 -
7 – Creating New Excel Workbooks
01:26 -
8 – Saving Excel Files
02:22 -
9 – Opening Excel Files
01:37 -
10 – Beginner Shortcut Keys
01:36
Section 3 – Entering and Editing Text
-
11 – Entering Text
06:41 -
12 – Working with Numbers
06:54 -
13 – An Introduction to Dates
01:15 -
14 – Find and Replace
04:09 -
15 – Sorting Data
04:12 -
16 – Working with Cell References
06:04 -
17 – Relative Versus Absolute Cell Reference in Formulas
06:24 -
18 – Understanding the Order of Operation
02:41
Section 4 – Basic Excel Functions
-
19 – The structure of an Excel Function
00:00 -
20 – Working with the Sum Function
06:26 -
21 – Working with Min and Max
06:45 -
22 – Working with Averages
02:04 -
23 – Working with Count and CountA
02:05
Section 5 – Modifying an Excel Worksheet
-
24 – Moving and Copying Data
06:07 -
25 – Inserting and Deleting Rows and Columns
03:56 -
26 – Changing the Width and Height of Cells
02:41 -
27 – Hiding and Unhiding Rows, Columns and Sheets
04:30 -
28 – Renaming Worksheets
01:58 -
29 – Deleting Worksheets
02:48 -
30 – Moving and Copying Worksheets
01:37
Section 6 – Formatting Data
-
31 – Adding Borders to Cells
04:20 -
32 – Formatting Percentages
03:07 -
33 – Merging and Centering Cells
03:12 -
34 – A Quick look at Styles
02:30 -
35 – Basic Conditional Formatting
03:59
Section 7 – Images, Shapes and Smart Art
-
36 – Inserting Images and Shapes
04:32 -
37 – Working with SmartArt
02:39
Section 8 – Printing in Excel
-
38 – Print Preview
03:57 -
39 – Margins, Scaling and Orientation
03:33 -
40 – Printing
02:28
Section 9 – Templates
-
41 – Intro to Excel Templates
03:45 -
42 – Opening an Existing Template
01:18 -
43 – Creating a Custom Template
10:08
Section 10 – Excel Beginner – Conclusion
-
44 – Conclusion
03:11
