• 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

Assignment 13
Use of Formulas – COUNTIF, COUNTIFS & SUMIFS

Assignment 14
Create Pivot Table Using Data – Separate Fruits and Vegetables

Assignment 15
Use of Formulas – COUNTIF, COUNTIFS, SUMIFS & VLOOKUP

Assignment 16
Use of Formula – VLOOKUP

Assignment 17
Use of Formula – HLOOKUP

Assignment 18
Use of Formula – HLOOKUP

Assignment 19
Use of Formula – INDEX with MATCH

Assignment 20
Use of Formulas – INDEX + MATCH

Assignment 21
Use of Formulas – COUNTIF, SUMIF & VLOOKUP

Assignment 22
Use of Formula – AND

Assignment 23
Use of Formula – AVERAGEIF

Assignment 24
Use of Formulas – IF & VLOOKUP

Assignment 25
Use of Formula – CONCATENATE / CONCAT

Assignment 26
Use of Formulas – COUNTA, COUNTIF, COUNTIFS, VLOOKUP & INDEX + MATCH

Assignment 27
Use of Formula – VLOOKUP from One Sheet to Another Sheet

Assignment 28
Create Pivot Table Using Data

Assignment 29
Use of Formula – HLOOKUP

Assignment 30
Use of Formula – NESTED IF

Assignment 31
Merge Table 1, 2 & 3 Using VLOOKUP

Assignment 32
Use of Formulas – SUMIF & SUMIFS

Assignment 33
Use of Formulas – VLOOKUP & IF

Assignment 34
USE OF VLOOKUP WITH TRUE / FALSE

Assignment 35
USE OF DATEDIF FORMULA

Assignment 36
USE OF FIND & LARGE FORMULA

Assignment 37
USE OF LEFT, FIND, LEN, LOWER & NETWORKDAYS

Assignment 38
USE OF POWER, PRODUCT, PROPER & REPT

Assignment 39
USE OF COUNTA, VLOOKUP, COUNTIF, COUNTIFS & IF

Assignment 40
SALESMAN PERFORMANCE ANALYSIS

Assignment 41
USE OF DATEDIF – AGE CALCULATION

Assignment 42
COUNTIF & COUNTIFS – ADVANCED PRACTICE

Assignment 43
USE OF SUMIF & SUMIFS – SALES ANALYSIS

Assignment 44
USE OF AVERAGEIF & AVERAGEIFS – PERFORMANCE ANALYSIS

Assignment 45
USE OF IF, AND & OR – EMPLOYEE ELIGIBILITY & PERFORMANCE ANALYSIS

Assignment 46
USE OF IFERROR – ERROR HANDLING IN EXCEL

Assignment 47
USE OF INDEX + MATCH – ADVANCED LOOKUP

Assignment 48
USE OF XLOOKUP – ADVANCED LOOKUP PRACTICE

Assignment 49
NESTED IF + MULTIPLE CONDITIONS – EMPLOYEE PERFORMANCE ANALYSIS

Assignment 50
FINAL EXCEL PRACTICAL PROJECT EMPLOYEE PERFORMANCE & SALARY ANALYSIS