munotes®
Sign in
Home / Syllabus / Bachelor of Arts (B.A.) / FY BA / Semester 2 / Economics / Economic Data Visualization with Excel

Bachelor of Arts (B.A.) Economic Data Visualization with Excel Syllabus - Mumbai University 2026

Syllabus for Economic Data Visualization with Excel

Skill enhancement course · Economics · Semester 2 · FY BA · 2 credits · 50 marks · 30 hours

Module 1: Introduction to data Visualisation and MS-Excel (15 hours) (1 Credit)

  • 1 Introduction: Importance, Need and principles of data visualization
  • 2 Basic features of MS-Excel: Excel interface overview, shortcuts, standard toolbar, customizing the quick access toolbar, Excel self help
  • 3 Basic formatting: Data Import, formatting and cleaning in excel, conditional function and other functions
  • 4 Data Processing and Data Lookups: sorting and filtering, Data validation with lists, table, text to column
  • 5 Data Analysis in Excel: Data Analysis tools, formulas

Module 2: Data Visualization in Excel (15 hours) (1 Credit)

  • 1 Introduction to chart: Numerical charts and non-numerical charts, sparklines
  • 2 Visualization with excel charts: creating charts from data
  • 3 Pivot tables: Creating Pivot tables, Using the pivot table toolbar, slicers, pivot charts
  • 4 Introduction and use of dashboard and infographics and KPI
  • 5 Analyzing real-word dataset: Data Visualization and Statistical analysis

Reference Books

  • 1 Manning, Patrick. Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and PivotTables. Wiley, 2015
  • 2 Arora, ritu. Mastering Advanced Excel. BPB Publications , 2023.
  • 3 Camoes, Jorge. Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel. New Riders; 1st edition, 2016.
  • 4 Few, Stephen. Now You See It: Simple Visualization Techniques for Quantitative Analysis First. Analytics Press; First Edition , 2009.
  • 5 Kirk, andy. Data Visualisation: A Handbook for Data Driven Design. SAGE Publications Ltd; First Edition , 2016.
  • 6 Knaflic, cole nussbaumer. Storytelling with Data: A Data Visualization Guide for Business Professionals. Wiley; 1st edition , 2015.
  • 7 O.A, Sam. Excel: Mastering Data Analysis, Visualization, and Automation for Success with Microsoft 365. SA-Publishing, 2023.
  • 8 Ranganathan, Kavita. Impactful Data Visualization. Penguin Business, 2023.
  • 9 Roy, Dr. Shrishendu. Data Visualization : Using Power BI, Orange and Excel. Notion Press; 1st edition, 2021. Schwabish, Jonathan. Data Visualization in Excel: A Guide for Beginners, Intermediates, and Wonks. A K Peters/CRC Press; 1st edition, 2023
Report or request
Done!