Section outline

    • Session 2 Excel Formulas

      In this session you will learn how to enter a formula and several functions Excel has to offer. You will explore in more detail mathematical, logical and text functions. Examples of functions we are going to discuss are sum, round, exponential, logarithm and if.  

      Moreover, you will also see how to use cell references and check formulas by using auditing tools.  


    • Students must
      Mark as done



      Watch this video in which Claudio Vallar introduces the concepts of Excel Formulas and Functions and how to use them. 



    • Topic 2: Excel Formulas and Functions Video Presentations Book
      Students must
      Mark as done

      To continue to explore this topic, view and navigate the following Excel Formulas and Functions video presentations which take you through  Mathematical Functions, Logical Functions, Cell References, Cell Auditing and an Excel Example Application applying the skills developed in this section.

    • Students must
      Mark as done

      Topic 2 Review: Formulas and Functions

      You should now be able to: 

      • Understand formulas and functions in Excel 

      • Use the main mathematical functions in Excel 

      • Use the function IF and other logical functions 

      • Perform nested functions

      • Use the main text and date functions

      • Use cell references

      • Understand different formulas’ errors

      • Audit formulas