• 3.5 (3k reviews)

₹ 2499

Get Course Get Course

• Level Beginner
• Duration 1 Month

Course Content

1. Overview of Excel
   1. Introduction to Excel Interface (Ribbon, Quick Access Toolbar, Formula Bar, and Status Bar)
   2. Understanding Workbooks, Worksheets, and Cells
   3. Navigating a Worksheet (Scroll Bars, Mouse Actions, Keyboard Shortcuts)
   4. Creating, Saving, and Opening Workbooks
   5. Basic File Management (Save, Save As, Export to PDF)
   6. Understanding Excel File Formats (XLSX, CSV, XLS)
2. Data Entry and Basic Formatting
   1. Entering and editing data in cells
   2. Formatting text (font style, size, color, bold, italics, underline)
   3. Number formatting (currency, percentage, dates, time)
   4. Adjusting column width and row height
   5. Merging and centering text
3. Basic Formulas
   1. Introduction to formulas and functions
   2. Basic arithmetic operations (addition, subtraction, multiplication, division)
   3. Using SUM, AVERAGE, MIN, MAX, COUNT functions
   4. AutoSum and AutoFill features
   5. Relative and absolute references in formulas
4. Data Editing and Management
   1. Inserting, deleting, and moving cells, rows, and columns
   2. Copy, Cut, Paste (including Paste Special)
   3. Using Find and Replace
   4. Using Undo and Redo
5. Sorting and Filtering Data
   1. Sorting data by one or more columns (ascending, descending, custom sorting)
   2. Applying filters to data (AutoFilter, Text Filters, Number Filters)
   3. Using Advanced Filters for complex criteria
6. Data Validation
   1. Setting up data validation rules (drop-down lists, range restrictions)
   2. Error messages and input messages
   3. Using the Data Validation tool to restrict data entry
7. Conditional Formatting
   1. Introduction to Conditional Formatting (highlighting cells based on values)
   2. Using built-in conditional formatting rules (color scales, data bars, icon sets)
   3. Creating custom rules and formulas for conditional formatting
8. Cell Styles and Themes
   1. Applying and modifying cell styles
   2. Using themes and customizing workbook design
9. Number Formatting
   1. Custom number formats (dates, currency, percentages, etc.)
   2. Using Format Painter to apply formatting
10. Creating and Formatting Tables
    1. Converting ranges to tables
    2. Table styles and formatting options
    3. Using structured references in formulas
11. Sorting and Filtering within Tables
    1. Sorting and filtering data within tables
12. Using Named Ranges
    1. Defining and managing named ranges
    2. Using named ranges in formulas for clarity and efficiency
13. Text Functions
    1. CONCATENATE, LEFT, RIGHT, MID, FIND, LEN
    2. UPPER, LOWER, PROPER
    3. TEXT function for formatting numbers and dates as text
14. Logical Functions
    1. IF function and nested IF statements
    2. Using AND, OR, NOT with IF for complex conditions
    3. SWITCH function for multiple conditions
15. Date and Time Functions
    1. TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY
    2. NETWORKDAYS, WORKDAY functions
16. Charts and Graphs
    1. Introduction to chart types (column, line, pie, bar, scatter, etc.)
    2. Creating, modifying, and formatting charts
    3. Using chart tools for layout and design
    4. Adding and formatting chart titles, axis labels, and legends
    5. Changing chart types and switching rows/columns
17. Creating PivotTables & Charts
    1. Introduction to PivotTables and their purpose
    2. Creating and arranging PivotTables
18. Excel Workbooks security
    1. Tracking changes and reviewing comments
    2. Protecting worksheets and workbooks with passwords
    3. Restricting editing and permissions
    4. Adding encryption and password protection to workbooks
    5. Locking and unlocking cells for protection
19. Project and Evaluation
    1. Practical Project
       1. Apply all learned skills to a real-world project (Database creation, report generation, office automation)
    2. Assessment
       1. Written exams and practical assessments
       2. Project evaluation and presentation
20. Certification and Conclusion
    1. Course completion certificate
    2. Feedback and recommendations for further studies