Data analytics using MS-Excel-Beginner

Utporul

Data analytics using MS-Excel-Beginner

deepikasri
7
8h
4
(0)

Course Curriculum

Introduction to Excel
• Overview of Excel interface • Understanding workbooks, worksheets, and cells • Navigating through rows and columns • Range • Basic keyboard shortcuts

Introduction to Excel

03:41
Take a look of Interface

02:50
Quiz 1

Data Entry and Formatting
• Introduction to basic formulas (Difference between Formula and Function) • Data Type • Auto Fill Option • Paste specials • Fill Without Formatting

Data Entry and formatting

23:51
Conditional formatting

11:15
Quiz 2

Statistical Function and Reference
• Functions: (SUM, MIN, MAX, AVG, COUNT, COUNTA, LARGE, SMALL) • Using cell references (relative and absolute)

Data Management
• Sorting data in Excel • Filtering data to display specific information • Data validation and drop-down lists • Introduction to tables (Table Properties, Table Styles, Difference between Range and Table)

Sort & Filter

14:45
If Condition

12:03
Data Validation

08:53

Charts and Graphs
• Creating basic charts (Column/bar, pie, line) • Formatting and customizing charts • Adding titles and labels to charts • Using chart templates

Pivot Table
• Introduction to PivotTables • Understanding PivotTables and Pivot Charts • Creating and formatting PivotTables • Analyzing and summarizing data with PivotTables

Assignment
Upload the assignment

Student Ratings & Reviews

No Review Yet

No Data Available in this Section

Enroll Now

Intermediate
4 Total Enrolled
English
8 hours Duration
July 10, 2025 Last Updated
Certificate of completion

Data analytics using MS-Excel-Beginner

Course Curriculum

Introduction to Excel
• Overview of Excel interface • Understanding workbooks, worksheets, and cells • Navigating through rows and columns • Range • Basic keyboard shortcuts

Introduction to Excel

Take a look of Interface

Quiz 1

Data Entry and Formatting
• Introduction to basic formulas (Difference between Formula and Function) • Data Type • Auto Fill Option • Paste specials • Fill Without Formatting

Data Entry and formatting

Conditional formatting

Quiz 2

Statistical Function and Reference
• Functions: (SUM, MIN, MAX, AVG, COUNT, COUNTA, LARGE, SMALL) • Using cell references (relative and absolute)

Statistical Functions

Relative and absolute references

Data Management
• Sorting data in Excel • Filtering data to display specific information • Data validation and drop-down lists • Introduction to tables (Table Properties, Table Styles, Difference between Range and Table)

Sort & Filter

If Condition

Data Validation

Charts and Graphs
• Creating basic charts (Column/bar, pie, line) • Formatting and customizing charts • Adding titles and labels to charts • Using chart templates

Charts & Graphs

Pivot Table
• Introduction to PivotTables • Understanding PivotTables and Pivot Charts • Creating and formatting PivotTables • Analyzing and summarizing data with PivotTables

Pivot Tables

Assignment
Upload the assignment

Practice assignment

Warning: Undefined variable $title in /www/wwwroot/sashainfinity.com/wp-content/themes/eduvalt/inc/common/eduvalt-breadcrumb.php on line 119

Data analytics using MS-Excel-Beginner

Course Curriculum

Introduction to Excel • Overview of Excel interface • Understanding workbooks, worksheets, and cells • Navigating through rows and columns • Range • Basic keyboard shortcuts

Introduction to Excel

Take a look of Interface

Quiz 1

Data Entry and Formatting • Introduction to basic formulas (Difference between Formula and Function) • Data Type • Auto Fill Option • Paste specials • Fill Without Formatting

Data Entry and formatting

Conditional formatting

Quiz 2

Statistical Function and Reference • Functions: (SUM, MIN, MAX, AVG, COUNT, COUNTA, LARGE, SMALL) • Using cell references (relative and absolute)

Statistical Functions

Relative and absolute references

Data Management • Sorting data in Excel • Filtering data to display specific information • Data validation and drop-down lists • Introduction to tables (Table Properties, Table Styles, Difference between Range and Table)

Sort & Filter

If Condition

Data Validation

Charts and Graphs • Creating basic charts (Column/bar, pie, line) • Formatting and customizing charts • Adding titles and labels to charts • Using chart templates

Charts & Graphs

Pivot Table • Introduction to PivotTables • Understanding PivotTables and Pivot Charts • Creating and formatting PivotTables • Analyzing and summarizing data with PivotTables

Pivot Tables

Assignment Upload the assignment

Practice assignment

Student Ratings & Reviews

Introduction to Excel
• Overview of Excel interface • Understanding workbooks, worksheets, and cells • Navigating through rows and columns • Range • Basic keyboard shortcuts

Data Entry and Formatting
• Introduction to basic formulas (Difference between Formula and Function) • Data Type • Auto Fill Option • Paste specials • Fill Without Formatting

Statistical Function and Reference
• Functions: (SUM, MIN, MAX, AVG, COUNT, COUNTA, LARGE, SMALL) • Using cell references (relative and absolute)

Data Management
• Sorting data in Excel • Filtering data to display specific information • Data validation and drop-down lists • Introduction to tables (Table Properties, Table Styles, Difference between Range and Table)

Charts and Graphs
• Creating basic charts (Column/bar, pie, line) • Formatting and customizing charts • Adding titles and labels to charts • Using chart templates

Pivot Table
• Introduction to PivotTables • Understanding PivotTables and Pivot Charts • Creating and formatting PivotTables • Analyzing and summarizing data with PivotTables

Assignment
Upload the assignment