Please wait...
Icon error

Some required information is missing or incorrect. Please correct the fields marked in red:

    Data Analysis Using Excel

    students enrolled · reviews
    • Icon star inactive
    • Icon star inactive
    • Icon star inactive
    • Icon star inactive
    • Icon star inactive

    Class Overview

    In this class, our focus will be on mathematics - especially concepts and methods of data analysis and not on Excel as an end in itself. We use Excel to perform our calculations, and all mathematical formulas are provided as Excel spreadsheets, but we do not attempt to cover Excel macros, Visual Basic, PivotTables, or other Excel features of Excel. Intermediate to advanced level.
    I will use this lesson to prepare you to design and implement realistic predictive models based on data. In the last part of this course, you will assume the role of an enterprise data analyst for a financial institution and develop two different predictive models to determine which candidates to use for credit cards and which ones to reject. Your first model will focus on reducing your risk of default, and you're second on maximizing bank profits. Both models must demonstrate in a practical way that your choice of business metrics guides the selection of an optimal model.
    You will explore Excel's core competencies to deal with the typical work situations you may encounter in the future.
    You will learn how to calculate and apply the potentially useful uncertainty metric known as entropy.

    20 Years old and above


    Class location1

    Book this class

    Select a package




    Day & Time

    When would you like to start?

    Total payment

    Book this class

    Book this class /