Excel Assignments - Solve, Check, and Master
Assignment
Excel Assignments - Solve, Check, and Master
0%
Completed
Assignment 1
Use of Formulas – SUM, AVERAGE, IF, COUNTIF, COUNTIF, SUMIF, AVERAGE, COUNTA, , COUNTIFS
Assignment
Reading
Assignment Solution
Reading
Assignment 2
Use of Formulas – PRODUCT, IF, COUNTA, COUNTIF & SUMIF
Assignment
Reading
Assignment Solution
Reading
Assignment 3
Use of Formulas – SUM, AVERAGE, NESTED IF, COUNTA, COUNTIF, SUMIF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 4
Use of Formulas – SUM, Nested IF, COUNTA, COUNTIF, SUMIF & VLOOKUP
assignment
Reading
Assignment Solution
Reading
Assignment 5
Use of Formulas – SUM, IF, COUNTA, COUNTIF, SUMIF, VLOOKUP & LOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 6
Use of COUNTA, COUNTIF, SUMIF, HLOOKUP & Conditional Formatting
Assignment
Reading
Assignment Solution
Reading
Assignment 7
Use of Formulas – COUNTA, DAY, MONTH, YEAR, COUNTIF, SUMIF, IF & DATEDIF
Assignment
Reading
Assignment Solution
Reading
Assignment 8
Use of Formulas – SUM, AVERAGE, COUNTA, COUNTIF, SUMIF & Nested IF
Assignment
Reading
Assignment Solution
Reading
Assignment 9
Use of Formula – LOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 10
Use of Formulas – COUNTA, COUNTIF, SUMIF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 11
Use of Formulas – MATCH & VLOOKUP with MATCH
Assignment
Reading
Assignment Solution
Reading
Assignment 12
Create Pivot Table Using Data
Assignment
Reading
Assignment Solution
Reading
Assignment 13
Use of Formulas – COUNTIF, COUNTIFS & SUMIFS
Assignment
Reading
Assignment Solution
Reading
Assignment 14
Create Pivot Table Using Data – Separate Fruits and Vegetables
Assignment
Reading
Assignment Solution
Reading
Assignment 15
Use of Formulas – COUNTIF, COUNTIFS, SUMIFS & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 16
Use of Formula – VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 17
Use of Formula – HLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 18
Use of Formulas – SUM, COUNTA, COUNTIF, SUMIF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 19
Use of Formula – INDEX with MATCH
Assignment
Reading
Assignment Solution
Reading
Assignment 20
Use of Formulas – INDEX + MATCH (Employee Salary Database)
Assignment
Reading
Assignment Solution
Reading
Assignment 21
Use of Formulas – COUNTIF, SUMIF & VLOOKUP (Employee Salary Database)
Assignment
Reading
Assignment Solution
Reading
Assignment 22
Use of Formula – AND (Student Examination Report)
Assignment
Reading
Assignment Solution
Reading
Assignment 23
Use of Formula – AVERAGEIF
Assignment
Reading
Assignment Solution
Reading
Assignment 24
Use of Formulas – IF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 25
Use of Formula – CONCATENATE / CONCAT
Assignment
Reading
Assignment Solution
Reading
Assignment 26
Use of Formulas – COUNTA, COUNTIF, COUNTIFS, VLOOKUP & INDEX + MATCH
Assignment
Reading
Assignment Solution
Reading
Assignment 27
Use of Formula – VLOOKUP from One Sheet to Another Sheet
Assignment
Reading
Assignment Solution
Reading
Assignment 28
Create Pivot Table Using Data
Assignment
Reading
Assignment Solution
Reading
Assignment 29
Use of Formula – HLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 30
Use of Formula – NESTED IF
Assignment
Reading
Assignment Solution
Reading
Assignment 31
Merge Table 1, 2 & 3 Using VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 32
Use of Formulas – SUMIF & SUMIFS
Assignment
Reading
Assignment Solution
Reading
Assignment 33
Use of Formulas – VLOOKUP & IF
Assignment
Reading
Assignment Solution
Reading
Assignment 34
USE OF VLOOKUP WITH TRUE / FALSE
Assignment
Reading
Assignment Solution
Reading
Assignment 35
USE OF DATEDIF FORMULA
Assignment
Reading
Assignment Solution
Reading
Assignment 36
USE OF FIND & LARGE FORMULA
Assignment
Reading
Assignment Solution
Reading
Assignment 37
USE OF LEFT, FIND, LEN, LOWER & NETWORKDAYS
Assignment
Reading
Assignment Solution
Reading
Assignment 38
USE OF POWER, PRODUCT, PROPER & REPT
Assignment
Reading
Assignment Solution
Reading
Assignment 39
USE OF COUNTA, VLOOKUP, COUNTIF, COUNTIFS & IF
Assignment
Reading
Assignment Solution
Reading
Assignment 40
SALESMAN PERFORMANCE ANALYSIS
Assignment
Reading
Assignment Solution
Reading
Assignment 41
USE OF DATEDIF – AGE CALCULATION
Assignment
Reading
Assignment Solution
Reading
Assignment 42
COUNTIF & COUNTIFS – ADVANCED PRACTICE
Assignment
Reading
Assignment Solution
Reading
Assignment 43
USE OF SUMIF & SUMIFS – SALES ANALYSIS
Assignment
Reading
Assignment Solution
Reading
Assignment 44
USE OF AVERAGEIF & AVERAGEIFS – PERFORMANCE ANALYSIS
Assignment
Reading
Assignment Solution
Reading
Assignment 45
USE OF IF, AND & OR – EMPLOYEE ELIGIBILITY & PERFORMANCE ANALYSIS
Assignment
Reading
Assignment Solution
Reading
Assignment 46
USE OF IFERROR – ERROR HANDLING IN EXCEL
Assignment
Reading
Assignment Solution
Reading
Assignment 47
USE OF INDEX + MATCH – ADVANCED LOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 48
USE OF XLOOKUP – ADVANCED LOOKUP PRACTICE
Assignment
Reading
Assignment Solution
Reading
Assignment 49
NESTED IF + MULTIPLE CONDITIONS – EMPLOYEE PERFORMANCE ANALYSIS
Assignment
Reading
Assignment Solution
Reading
Assignment 50
FINAL EXCEL PRACTICAL PROJECT EMPLOYEE PERFORMANCE & SALARY ANALYSIS
Assignment
Reading
Assignment Solution
Reading
More
Announcements
Course Info
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway