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.
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.
In this chapter, we will cover few built-in functions like SUM,COUNT,AVERAGE,MIN, MAX to name a few.
As the name suggests, in this chapter, we will see how to add/edit/delete comments in Excel..
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.
In this chapter, we will learn how to remove duplicate entries and also to validate your data.
In this chapter, we will see how to create sensitivity tables using Data Tables feature in Excel.
In this chapter we will learn how to create/edit Pivot Tables, yet another very important feature in Excel.