Introduction
  • Introduction to the Course
Basics of Excel
  • Basics of Excel
  • Workbooks and Worksheets
  • Fundamentals
  • CHAPTER 2: Basics of Excel
Entering Data
  • How to Enter data
  • Auto Fit
  • Keyboard Navigation
  • Auto Complete
  • Entering Numbers
  • Navigating edges
  • Navigating - First and last used cells
  • Selecting cells - Introduction
  • Selecting cells - Shift + Arrow
  • Selecting cells - Ctrl + Shift + Arrow
  • Selecting cells - Mouse Click and Drag
  • Selecting cells - Mouse Click and Shift Click
  • Selecting cells - All Cells & Used Cells
  • Selecting cells - Rows and Columns
  • Selecting cells - Non-contiguous cells
  • Selecting cells - Summary
  • Number Formatting - Introduction
  • Number Formatting - General and Text
  • Number Formatting - Number and Fraction
  • Number Formatting - Currency
  • Number Formatting - Accounting
  • Number Formatting - Percentage
  • Number Formatting - Date
  • Number Formatting - Time
  • Number Formatting - Summary
  • Inserting and deleting Rows, Columns and Cells
  • CHAPTER 3: ENTERING DATA
Formatting
  • Formatting - Introduction
  • Formatting - Bold, Italics and Underline
  • Formatting - Border
  • Formatting - Fill and Font
  • Formatting - Alignment
  • Formatting - Format Painter and Clear Formats
  • CHAPTER 4: FORMATTING
Editing
  • Editing - Editing Cell Content
  • Editing - Multiple Lines of Text
  • Editing - Ctrl + Enter
  • Editing - Auto Fill
  • Editing - Copy and Paste
  • Editing - Cut and Paste
  • Editing - Auto Fill Series
  • Editing - Sort
  • Editing - Filter
  • Editing - Find and Replace
  • CHAPTER 5: EDITING
Saving
  • Saving - Saving Excel documents
  • CHAPTER 6: SAVING
Viewing
  • Viewing - Freeze Panes
Calculations
  • Calculations - Introduction to Formula
  • Editing Formula
  • Introduction to Functions
  • Entering Functions
  • Types of Functions
  • MIN, MAX and AVERAGE Functions
  • Copying Formula
  • Cell References
  • Paste Formula
  • Counting Functions
  • Lookup Functions
  • Date Functions
  • Text Functions
  • SUMIF Function
  • IF Function
  • Errors
  • Calculations - Summary
  • CHAPTER 8: CALCULATIONS
Visualizing
  • Introduction to Charts
  • Creating a Chart
  • Chart Components - Labels
  • Chart Components - Background
  • Chart Components - Axes
  • Chart Components - Format and Design
  • Chart Types
  • Introduction to Conditional Formatting
  • Conditional Formatting - Format All Cells
  • Conditional Formatting - Format Only Cells
  • Conditional Formatting - More Rule Types
  • Conditional Formatting - Formula Based
  • Conditional Formatting - Summary
  • Illustrations
  • CHAPTER 9: VISUALIZING
Analyzing
  • Introduction to PivotTables
  • Creating PivotTable
  • PivotTable Summarization Types
  • PivotTable Tools