• 01666-222229
  • info@practicise.com
  • Sircl Tech Pvt. Ltd, Street no. 4, Gobind Nagar, Near Bus Stand, Sirsa

Excel Assignments – Solve, Check, and Master

Wishlist Share

About Course

This course is straightforward: no long, boring video lectures or heavy theory, just pure practice. If you already know the basics of Excel and want to test your skills, you are in the right place.

It is designed to give you hands-on experience so you can get faster and smarter with spreadsheets for your school projects, college prep, or future jobs.

What Will You Learn?

  • Practice daily Excel tasks using real-world data tables.
  • Apply important formulas like SUM, IF, VLOOKUP, and COUNTIF accurately.
  • Solve practical problems for school projects, college, or future office jobs.
  • Check your own work against answer sheets to find and fix formula mistakes.

Course Content

Assignment 1
Use of Formulas – SUM, AVERAGE, IF, COUNTIF, COUNTIF, SUMIF, AVERAGE, COUNTA, , COUNTIFS

Assignment 2
Use of Formulas – PRODUCT, IF, COUNTA, COUNTIF & SUMIF

Assignment 3
Use of Formulas – SUM, AVERAGE, NESTED IF, COUNTA, COUNTIF, SUMIF & VLOOKUP

Assignment 4
Use of Formulas – SUM, Nested IF, COUNTA, COUNTIF, SUMIF & VLOOKUP

Assignment 5
Use of Formulas – SUM, IF, COUNTA, COUNTIF, SUMIF, VLOOKUP & LOOKUP

Assignment 6
Use of COUNTA, COUNTIF, SUMIF, HLOOKUP & Conditional Formatting

Assignment 7
Use of Formulas – COUNTA, DAY, MONTH, YEAR, COUNTIF, SUMIF, IF & DATEDIF

Assignment 8
Use of Formulas – SUM, AVERAGE, COUNTA, COUNTIF, SUMIF & Nested IF

Assignment 9
LOOKUP Function Syntax

Assignment 10
Use of Formulas – COUNTA, COUNTIF, SUMIF & VLOOKUP

Assignment 11
Use of Formulas – MATCH & VLOOKUP with MATCH

Assignment 12
Create Pivot Table Using Data