Join the conversation
Introduction to Excel
• Overview of Excel interface
• Understanding workbooks, worksheets, and cells
• Navigating through rows and columns
• Range
• Basic keyboard shortcuts
0/3
Data Entry and Formatting
• Introduction to basic formulas (Difference between Formula and Function)
• Data Type
• Auto Fill Option
• Paste specials
• Fill Without Formatting
0/3
Statistical Function and Reference
• Functions: (SUM, MIN, MAX, AVG, COUNT, COUNTA, LARGE, SMALL)
• Using cell references (relative and absolute)
0/2
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)
0/3
Charts and Graphs
• Creating basic charts (Column/bar, pie, line)
• Formatting and customizing charts
• Adding titles and labels to charts
• Using chart templates
0/1
Pivot Table
• Introduction to PivotTables
• Understanding PivotTables and Pivot Charts
• Creating and formatting PivotTables
• Analyzing and summarizing data with PivotTables
0/1
Assignment
Upload the assignment
0/1