Data Analysis with Excel (Minor Degree ISE)

sa.jpgsa.jpg

Course Overview

This course provides a comprehensive introduction to Microsoft Excel, covering fundamental spreadsheet functionalities, essential formulas, data analysis techniques, and PivotTables. Participants will learn how to manipulate data effectively, use advanced formulas, create charts, and generate insightful reports.

Learning Objectives

By the end of this course, students will be able to:

  1. Understand the basic functionalities of Excel, including the interface, toolbars, and spreadsheet organization.
  2. Use formulas and functions such as SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, MATCH, COUNTIF, and TEXT functions.
  3. Perform data analysis using sorting, filtering, data validation, and text-to-columns features.
  4. Create and format PivotTables for dynamic data visualization and analysis.
  5. Generate charts and graphs to present data effectively.
  6. Utilize advanced Excel tools like AutoFill, Named Ranges, Freeze Panes, and Conditional Formatting.

Course Structure

The course consists of three major units:

  1. Introduction to Excel

    • Spreadsheet Basics, Toolbars, Formatting, and Navigation
    • Working with Rows, Columns, and Cells
    • Using AutoFill and Special Paste Features

  2. Formulas, Functions, and Charts

    • Basic and Advanced Formulas (SUM, COUNTIF, VLOOKUP, TRIM, etc.)
    • Data Analysis with Sorting, Filtering, and Validation
    • Creating and Formatting Charts

  3. PivotTables and Data Visualization

    • Building and Manipulating PivotTables
    • Using the PivotTable Toolbar and Customizing Layouts
    • Creating PivotCharts and Adding Subtotals

Assessment and Certification

  • Weekly hands-on assignments and quizzes
  • Final project involving real-world data analysis
  • Upon successful completion, students receive a certificate of completion

Prerequisites

No prior Excel experience is required. Basic knowledge of spreadsheets is beneficial but not mandatory.

Target Audience

  • Students and professionals seeking proficiency in Excel
  • Business analysts, accountants, and data enthusiasts
  • Individuals aiming to improve data management and reporting skills