skilldevelopment.cpe@lpu.co.in

What you'll learn

Description: This course designed to • Transform the Excel skills of participants from basic to advanced levels with the power of AI integration. • Equips participants with the ability to analyse big data sets. • Enable participants to convert complex data into meaningful visualizations and interactive dashboards. • Help participants in automate tasks with intelligent functions, and unlock the full potential of Excel for both personal and professional use. Learning Outcome: By the end of the course, participants will be proficient in leveraging Excel's capabilities alongside AI innovations to excel in data handling, visualization, and decision-making processes.

  • Introduction and General Utility Functions: Filters, Advance Filters, Sorting, Freeze Panes, Duplicates, Paste Special, Text to Column, Conditional Formatting: highlight cell rules, data bars, colour scales, icon sets, colour coding; Logical Functions: Sum, Count and Average functions (including IF and IFs). General Utility Functions using AI tools.
  • Protection of Data and Worksheet. Logical Functions: Left, Right, Trim, Upper, Lower, Proper, Min, Max, Large, Small, Concatenate, Text to Column, Text join, Date, Time, Month, Year, Dated if, Round off, Random, Unique, Relative and Absolute References, Cell Linking and Cell Freezing, IF Statement, Nested if, If error etc. Logical Functions using AI tools.
  • Data Validation, Lookup (Lookup, Hlookup, Xlookup); Whatif Analysis: Goal Seek, Data Table and Scenario Analysis. Charts and Graphs: Gantt Chart, Pie Chart, Line chart, Area Chart, Bar Graph, Stacked Bar chart, Heatmap, Treemap, Spider Chart, Combo Chart, Donut Chart etc. Lookup functions and other applications using AI tool.
  • Pivot Tables: Creation of pivot tables, Data Analysis and summarization, Filters in Pivot Table, Grouping of Data, Sorting, Calculations, Aggregate Functions, Pivot Charts
  • Power Query (Get & Transform): Import, Transform, Clean, Combine data and files. Power Pivot, Introduction to Macros and Recording of Macros. Text Mining: Frequency Analysis and Sentiment Analysis and Text Clustering.
  • Dashboards Building in Excel: Fundamentals, designing and interactivity through slicers.

Avatar
Dr. Harpreet Singh Bedi
Professor & Assistant Dean

Dr. Harpreet Singh Bedi