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
• 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