EXCEL: Microsoft Excel Basic to Advanced Excel
-
By
Krishna Kumar
- 03/Jul/2024
- 1 Students
Course Description
Chapter 1: Introduction to Excel
- Excel interface & navigation
- Creating, saving, and formatting workbooks
- Basic data entry & editing
Chapter 2: Formatting & Data Management
- Cell formatting, number formats, conditional formatting
- Sorting, filtering, and data validation
Chapter 3: Formulas & Functions
- Basic formulas, operators, and cell references
- Essential functions: SUM, AVERAGE, IF, COUNTIF, VLOOKUP, HLOOKUP
Chapter 4: Advanced Functions & Data Analysis
- Logical, text, date, and lookup functions
- Advanced formulas: INDEX-MATCH, OFFSET, INDIRECT
- Data analysis with PivotTables & PivotCharts
Chapter 5: Charts & Visualization
- Creating and formatting charts
- Advanced chart techniques & dashboards
Chapter 6: Data Tools & Automation
- Goal Seek, Data Tables, Solver
- Macros & VBA basics for automation
Chapter 7: Advanced Excel Features
- Power Query, Power Pivot, What-If Analysis
- Protecting & securing workbooks
Chapter 8: Collaboration & Integration
- Sharing, commenting, and co-authoring
- Importing/exporting data with other applications
Course Curriculum
-
Overview of Microsoft Excel & its applications
-
Understanding the Excel interface (Ribbon, Tabs, Quick Access Toolbar)
-
Creating, opening, saving, and closing workbooks
-
Working with spreadsheets (rows, columns, and cells)
-
Data entry and basic editing (copy, paste, undo, redo)
-
Customizing the Excel environment
-
Cell formatting (font, alignment, borders, colors)
-
Number formatting (currency, percentage, date, custom formats)
-
Conditional formatting (rules, color scales, data bars, icon sets)
-
Data validation (drop-down lists, input messages, error alerts)
-
Sorting and filtering data
-
Freeze panes, split windows, and hiding/unhiding rows/columns
-
Introduction to formulas and functions
-
Cell referencing (relative, absolute, and mixed references)
-
Arithmetic operations and logical operators
-
Basic functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
-
Conditional functions: IF, IFERROR, COUNTIF, SUMIF, AVERAGEIF
-
Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
-
Text functions: LEFT, RIGHT, MID, CONCATENATE, TEXT, TRIM, LEN, FIND, SEARCH
-
Date & time functions: TODAY, NOW, DAY, MONTH, YEAR, DATEDIF, NETWORKDAYS
-
Nested IF and advanced logical functions (IFS, SWITCH)
-
Advanced lookup: INDEX-MATCH vs. VLOOKUP
-
Array formulas and dynamic arrays
-
Working with named ranges
-
Error handling functions (IFERROR, ISERROR, ISBLANK)
-
Advanced data analysis using PivotTables & PivotCharts
-
Slicers & Timelines in PivotTables
-
Data summarization & grouping
-
Advanced filtering techniques
Krishna Kumar
Founder, AICT PVT LTD, IoT & Embedded System Academic Trainer, Data ScientistI am a web developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices
This Course Fee:
₹8500
₹8500
₹10500
Course includes:
-
Level
-
Expert
-
Duration
50h
-
Lessons
52
-
Quizzes
0
-
Certifications
Yes
-
Language
-
English
Hindi