Excel Formulas

In this module, as the name suggests, we will see formulas. We’ll start with basic formulas and then move to builtiin functions in Excel.
We’ll learn how to audit formulas, add comments, validate data, use data tables and pivot tables to analyze Excel data.

Basic Formulas

In this chapter, we will cover basics of formulas in Excel. We will also have a look at some of the basic formulas in excel.

Built-in Functions

In this chapter, we will cover few built-in functions like SUM,COUNT,AVERAGE,MIN, MAX to name a few.

Comments

As the name suggests, in this chapter, we will see how to add/edit/delete comments in Excel..

Formula Auditing

In this chapter we will see how to check your models for errors by tracing them using precedents and dependents.

Circularity and Interations

In this chapter, we will have an overview of circular reference and also see the necessary settings required for iterative calculations.

Data Validation

In this chapter, we will learn how to remove duplicate entries and also to validate your data.

Data Tables

In this chapter, we will see how to create sensitivity tables using Data Tables feature in Excel.

Pivot Tables

In this chapter we will learn how to create/edit Pivot Tables, yet another very important feature in Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *