What will you learn in Everyday Excel, Part 1 Course
Navigate Excel—open files, move between sheets, edit cells, and apply formatting.
Use formulas and built-in functions: logical, text, financial, and more.
Manage data: sort, filter, remove duplicates, consolidate, validate entries, and use lookups like VLOOKUP or INDEX/MATCH.
Visualize data with charts—scatter, column, pie charts—and dynamic elements like Slicers, Sparklines, and PivotTables.
Program Overview
Module 1: Navigating Excel
Duration: ~5 hours
Topics: Learn worksheet navigation, editing, formatting, cell referencing, relative vs absolute addressing, naming ranges, and basic VBA macro recording.
Hands-on: Quiz + in-Excel assignment for navigation, formatting, macros.
Module 2: Expression Entry & Common Functions
Duration: ~4 hours
Topics: Understand Excel syntax, order of operations, mathematical formulas, and basic functions like SUM, COUNT, AVERAGE, rounding, random, combinations/permutations.
Hands-on: Quiz + Excel assignment to master these functions.
Module 3: More Excel Functions
Duration: ~4 hours
Topics: Learn logical functions (IF, AND, OR, SUMIF, COUNTIF, AVERAGEIF), text functions, financial functions, array formulas, dynamic named ranges, and user-defined VBA functions.
Hands-on: Quiz + Excel assignment applying these advanced functions.
Module 4: Managing Data
Duration: ~4 hours
Topics: Apply filters, create tables, validate data, remove duplicates, consolidate data, and use lookup functions like VLOOKUP, INDEX/MATCH.
Hands-on: Quiz + in-Excel assignment for data cleaning and lookups.
Module 5: Plotting, Importing & File Export
Duration: ~4 hours
Topics: Create scatter plots, column/pie charts, slicers, sparklines, PivotTables; share data to Word/PowerPoint; export/print as PDF.
Hands-on: Quiz + Excel assignment to create visualizations and export results.
Get certificate
Job Outlook
Kickstarts skills valuable for roles such as Business Analyst, Operations Analyst, Data Entry Specialist, and Financial Analyst
Competence in Excel streamlines tasks like budgeting, reporting, and analysis across industries.
Often serves as a foundational step toward advanced data and analytics roles—from ₹5–10 LPA in India to $50,000–$90,000 USD globally.
Specification: Everyday Excel, Part 1
|
