Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 500,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Office. We’ve created Microsoft Excel courses for the last 5 versions and continue to help people get to grips with this essential database tool.

• Freeze Panes Option (3:46)
• Split Screen Option (2:35)
• Arranging Windows Option (2:16)
• Practice Exercise 03 (0:57)

• Headers and Footers (6:20)
• Print Titles (3:12)
• Comments (6:05)
• Page Setup Options (5:08)
• Printing Workbooks (3:32)
• Practice Exercise 04 (1:23)

• Adding and Deleting Rows, Columns and Cells (3:42)
• Changing Column and Row Widths (3:50)
• Practice Exercise 05 (1:07)

• Cut, Copy and Paste (7:38)
• Copying Formulas (6:01)
• Practice Exercise 06 (1:14)

• Overview of Formulas (8:40)
• Creating Formulas using Functions – Part 1 (13:25)
• Creating Formulas using Functions – Part 2 (14:16)
• Practice Exercise 07 (2:08)

• 3 Dimensional Formulas (6:25)
• Sheet Tab Options (6:08)
• Practice Exercise 08 (2:09)

• Formatting Cells – Part 1 (8:12)
• Formatting Cells – Part 2 (7:35)
• Number Formatting (7:13)
• Formatting as Table (9:45)
• Using Styles (8:15)
• Conditional Formatting (10:19)
• Using Format Painter (3:07)
• Protecting Sheets (6:05)
• Fill Handle and Custom Lists (4:43)

• Creating Charts (5:47)
• Editing Charts – Part 1 (9:11)
• Editing Charts – Part 2 (8:12)
• Practice Exercise 10 (1:25)

• Remove Duplicates (6:42)
• Sort Data (4:35)
• Filter Data (6:29)
• Advanced Filter (3:36)
• Practice Exercise 11 (1:08)