Microsoft Excel Beginner: Learn Excel Basics at just ₹499
Trained by working IT professionals from leading companies
7 HOUR Microsoft Excel Beginner SYLLABUS
This Microsoft Excel Beginner course is designed for absolute beginners who want to
learn the foundations of Excel. By the end of this course, you will be confident with data entry,
formatting, formulas, and functions essential for office productivity.
Fee: ₹499
Training Mode: Instructor-led live
class
Duration: 7 hours
Next Batch: Loading...
What you will learn from this course?
- Excel Interface & Basic Data Management
- Introduction to Excel
- What it is
- Key uses in various professions
- The Excel Interface
- Ribbon
- Tabs
- Groups
- Worksheets
- Cells, Rows, Columns
- Name Box
- Formula Bar
- Navigating Worksheets
- Keyboard shortcuts
- Using mouse
- Go To function
- Basic Data Entry
- Text
- Numbers
- Dates
- Times
- Understanding data types
- AutoFill Feature
- Filling series (numbers, dates, custom lists)
- Copying formulas
- Selecting Cells, Ranges, Rows, Columns
- Mouse methods
- Keyboard shortcuts
- Saving and Opening Workbooks
- .xlsx
- .csv
- Other formats
- Compatibility mode
- Formatting & Organization
- Cell Formatting
- Font, size, color
- Fill
- Borders (styles, colors)
- Number Formatting
- General
- Number
- Currency
- Accounting
- Percentage
- Date
- Time
- Custom formats
- Alignment & Text Control
- Horizontal/Vertical alignment
- Wrap Text
- Merge & Center
- Shrink to Fit
- Conditional Formatting
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Column Width & Row Height
- Manual adjustment
- AutoFit
- Inserting/Deleting Rows, Columns, Cells
- Working with Worksheets
- Renaming
- Moving
- Copying
- Hiding/Unhiding
- Basic Formulas & Functions
- Understanding Formulas
- Structure
- Arithmetic operations (+, -, *, /, ^)
- Order of operations (PEMDAS/BODMAS)
- Cell References
- Relative
- Absolute ($)
- Mixed references
- Basic Statistical Functions
- SUM()
- AVERAGE()
- COUNT()
- MAX()
- MIN()
- Data Management & Text/Date Functions
- Sorting Data
- Single-level (A-Z, Z-A)
- Multi-level (adding levels, custom lists)
- Filtering Data
- AutoFilter
- Text Filters
- Number Filters
- Date Filters
- Find & Replace
- Basic
- Advanced (formatting, wildcards)
- Freeze Panes
- Top Row
- First Column
- Custom
- Text Functions
- CONCATENATE / &
- LEFT(), RIGHT(), MID()
- LEN(), TRIM()
- UPPER(), LOWER(), PROPER()
- Date & Time Functions
- TODAY(), NOW()
- DAY(), MONTH(), YEAR()
- DATE(), TIME(), WEEKDAY()
- Calculating differences between dates
- Introduction to Data Validation
- Restricting data entry
- Creating drop-down lists
