Excel 101

Owned by Devi Singh
Dec 08, 2022
1 min read

Do you find Excel a challenge?  Don’t know how to organize your data?  Not getting the output you need?  Are formulas a mystery to you?  Let us show you how Excel can be the right tool to use for creating spreadsheets that work for you.  

  • Creating and formatting a basic spreadsheet

  • Letting Excel do the thinking with formulas

  • Printing out your masterpiece!

00:00 - Opening Credits
00:13 - Introduction
01:35 - Learning Goals
02:23 - Opening Excel
03:42 - Creating a Workbook
04:59 - Navigating The Spreadsheet
06:41 - Cell Structure and Names
07:43 - Entering Data in a Table
08:24 - Copying a Series
12:50 - The Clear Button
14:02 - Selecting, Copying and Pasting Data
16:08 - The Pasting Mistake (How to Crash Excel)
18:12 - Moving Rows/Columns
22:18 - Renaming & Coloring Sheets
23:38 - Making a New Sheet
24:14 - Autosave & OneDrive
27:38 - Auto-Resizing Columns
29:26 - Formatting Cells
31:25 - Copying Columns
31:52 - Formatting Numbers
33:38 - Manually Writing SUM Formulas
37:11 - The Sum Button
37:39 - Copying Formulas
38:46 - Printing Your Worksheet
41:41 - Repeat Table Headers
43:51 - Printing Gridlines
44:51 - Copying Sheets From One File to Another
46:09 - Contact Us