You have successfully registered
WEEK 1 — WORKPLACE EXCEL AND DATA CLEANING
Session 1: Excel for the Workplace
• Efficient workbook and worksheet navigation
• Professional workbook structure
• Essential keyboard shortcuts
• Relative and absolute cell references
Session 2: Organizing Data Professionally
• Converting raw ranges into Excel tables
• Sorting and filtering
• Structured data layout
• Common data-entry mistakes
Session 3: Cleaning Messy Data
• Removing duplicates and blank records
• Text to Columns and Flash Fill
• TRIM, CLEAN and text-cleaning techniques
• Finding and correcting data errors
Session 4: Data Quality and Visual Controls
• Data validation and dropdown lists
• Conditional formatting
• Duplicate and exception highlighting
• Creating consistent data-entry systems
WEEK 2 — ESSENTIAL BUSINESS FORMULAS
Session 5: Core Workplace Formulas
• SUM, AVERAGE, MIN, MAX and COUNT
• COUNTA and ROUND
• Formula copying
• Relative, absolute and mixed references
Session 6: Logical Formulas
• IF and nested conditions
• IFS, AND and OR
• IFERROR
• Practical decision-making examples
Session 7: Conditional Calculations
• SUMIF and SUMIFS
• COUNTIF and COUNTIFS
• Multiple-condition summaries
• Department, product and region analysis
Session 8: Text and Date Functions
• Combining and separating text
• LEFT, RIGHT, MID and LEN
• TODAY, YEAR, MONTH and date calculations
• Ageing and period-based analysis
WEEK 3 — LOOKUPS AND BUSINESS REPORTING
Session 9: XLOOKUP for Workplace Data
• Exact-match lookups
• Retrieving information from master tables
• Handling missing values
• Reverse lookups
Session 10: Advanced Lookup Situations
• Multi-criteria lookups
• Two-way lookups
• Lookup error handling
• Alternative techniques for older Excel versions
Session 11: PivotTables
• Creating and formatting PivotTables
• Grouping and summarizing data
• Calculated business summaries
• Filtering and drill-down analysis
Session 12: PivotCharts and Interactive Reports
• Creating PivotCharts
• Using slicers and timelines
• Connecting filters to reports
• Building management-ready summaries
WEEK 4 — POWER QUERY AND DASHBOARD PROJECT
Session 13: Introduction to Power Query
• Importing data into Power Query
• Cleaning and transforming data
• Changing data types
• Loading and refreshing results
Session 14: Combining and Automating Data
• Appending multiple tables
• Merging related datasets
• Combining recurring files
• Creating a refreshable reporting process
Session 15: Building an Excel Dashboard
• Selecting appropriate KPIs
• Choosing effective charts
• Adding slicers and interactive controls
• Creating a clean one-page dashboard
Session 16: Final Business Project
• Cleaning a realistic raw dataset
• Applying formulas and lookup techniques
• Building summaries and visualizations
• Completing a management dashboard
• Final review and improvement recommendations
Course fee: ₹6,999 per student for the complete four-week program.
Seat-registration amount: ₹1,399.
Balance amount: ₹5,600, payable before the first class.
The registration amount reserves one of the 10 available seats and forms part of the total course fee. It is not an additional charge.
All payments must be completed through UrbanPro SecurePay. The seat is confirmed only after the registration payment is received.
View this Course
Top Tutor
Teacher's Knowledge
Certified
