Share Description
In this course, you will learn:-
- Learn how to use Excel at its most basic level.
- Develop your skills as a user.
Syllabus:-
- Introduction to the Course
- Basics of Excel
- Workbooks and Worksheets
- Fundamentals
- CHAPTER 2: Basics of Excel
- 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 - 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 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 Excel documents
- CHAPTER 6: SAVING
- Viewing - Freeze Panes
- Calculations - Introduction to Formula
- Editing Formula
- Introduction to Functions
- Entering Functions
- Types of 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
- 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
- Introduction to PivotTables
- Creating PivotTable
- PivotTable Summarization Types
- PivotTable Tools
- PivotCharts
