Basic Moudles

Home
Basic Moudles

Basic Excel

Excel is a software program that allows users to organize, format and calculate data with formulas using a spreadsheet system.

Navigation with Rows and Columns
Copy Paste in Special way
Conditional Formatting
Manage Rule
Sort & Filter
Hyperlink
Error Checking
Formulas
Creating Formula

Advance Excel

Formulas
Creating Formula
Formula Reference
Relative Cell References
Absolute Cell References
Mixed Cell References
Using Functions
Built-in Functions
Settings Tab
Flash Fill
Filter
Group Outline
Analysis
Slicer
Goal Seek
Functions by Categories
Pivot Table
Pivot Table Example
Charts
Creating Chart
Editing Chart
Pivot Chart
Pivot Chart Example
Cross Referencing
Data Validation
Text to Columns
Protection
Protect Workbook
Share Workbook
Macro