Useful Excel for Beginners

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the Course

Chapter 2: Basics of Excel

Lecture 1: Basics of Excel

Lecture 2: Workbooks and Worksheets

Lecture 3: Fundamentals

Chapter 3: Entering Data

Lecture 1: How to Enter data

Lecture 2: Auto Fit

Lecture 3: Keyboard Navigation

Lecture 4: Auto Complete

Lecture 5: Entering Numbers

Lecture 6: Navigating edges

Lecture 7: Navigating – First and last used cells

Lecture 8: Selecting cells – Introduction

Lecture 9: Selecting cells – Shift + Arrow

Lecture 10: Selecting cells – Ctrl + Shift + Arrow

Lecture 11: Selecting cells – Mouse Click and Drag

Lecture 12: Selecting cells – Mouse Click and Shift Click

Lecture 13: Selecting cells – All Cells & Used Cells

Lecture 14: Selecting cells – Rows and Columns

Lecture 15: Selecting cells – Non-contiguous cells

Lecture 16: Selecting cells – Summary

Lecture 17: Number Formatting – Introduction

Lecture 18: Number Formatting – General and Text

Lecture 19: Number Formatting – Number and Fraction

Lecture 20: Number Formatting – Currency

Lecture 21: Number Formatting – Accounting

Lecture 22: Number Formatting – Percentage

Lecture 23: Number Formatting – Date

Lecture 24: Number Formatting – Time

Lecture 25: Number Formatting – Summary

Lecture 26: Inserting and deleting Rows, Columns and Cells

Chapter 4: Formatting

Lecture 1: Formatting – Introduction

Lecture 2: Formatting – Bold, Italics and Underline

Lecture 3: Formatting – Border

Lecture 4: Formatting – Fill and Font

Lecture 5: Formatting – Alignment

Lecture 6: Formatting – Format Painter and Clear Formats

Chapter 5: Editing

Lecture 1: Editing – Editing Cell Content

Lecture 2: Editing – Multiple Lines of Text

Lecture 3: Editing – Ctrl + Enter

Lecture 4: Editing – Auto Fill

Lecture 5: Editing – Copy and Paste

Lecture 6: Editing – Cut and Paste

Lecture 7: Editing – Auto Fill Series

Lecture 8: Editing – Sort

Lecture 9: Editing – Filter

Lecture 10: Editing – Find and Replace

Chapter 6: Saving

Lecture 1: Saving – Saving Excel documents

Chapter 7: Viewing

Lecture 1: Viewing – Freeze Panes

Chapter 8: Calculations

Lecture 1: Calculations – Introduction to Formula

Lecture 2: Editing Formula

Lecture 3: Introduction to Functions

Lecture 4: Entering Functions

Lecture 5: Types of Functions

Lecture 6: MIN, MAX and AVERAGE Functions

Lecture 7: Copying Formula

Lecture 8: Cell References

Lecture 9: Paste Formula

Lecture 10: Counting Functions

Lecture 11: Lookup Functions

Lecture 12: Date Functions

Lecture 13: Text Functions

Lecture 14: SUMIF Function

Lecture 15: IF Function

Lecture 16: Errors

Lecture 17: Calculations – Summary

Chapter 9: Visualizing

Lecture 1: Introduction to Charts

Lecture 2: Creating a Chart

Lecture 3: Chart Components – Labels

Lecture 4: Chart Components – Background

Lecture 5: Chart Components – Axes

Lecture 6: Chart Components – Format and Design

Lecture 7: Chart Types

Lecture 8: Introduction to Conditional Formatting

Lecture 9: Conditional Formatting – Format All Cells

Lecture 10: Conditional Formatting – Format Only Cells

Lecture 11: Conditional Formatting – More Rule Types

Lecture 12: Conditional Formatting – Formula Based

Lecture 13: Conditional Formatting – Summary

Lecture 14: Illustrations

Chapter 10: Analyzing

Lecture 1: Introduction to PivotTables

Lecture 2: Creating PivotTable

Lecture 3: PivotTable Summarization Types

Lecture 4: PivotTable Tools