Go To Lesson List What is Relative Referencing and Absolute Referencing-Lesson 1 What is Mixed Cell Referencing-Lesson 2? Bank Customer Interests Calculator-Excel Application How to Draw a Column Plot Graphy-Lesson 3? How to Draw a Pie Chart-Lesson 4 How To Connect Two EXCEL Sheets for Computation-Lesson 5? How To Use Hidden Tab to Hide Data formula-Lesson 6? Understanding LOGICAL FUNCTIONS-Lesson 7? How to Use LOGICAL IF function-Lesson 8? How to Use AND and OR function-Lesson 9? How to Use LOGICAL IF function to make Exemptions-Lesson 10? How to Use NESTED IF function-Lesson 11? How to Use COUNTIF function-Lesson 12? How to Use SUMIFS-Lesson 13?