Ravi Sir's Cards › Excel
Event Management System in Excel (card 1 of 2)
Revision card 1 for Event Management System in Excel: Days to the event: =B5-B3 gives 34; Client price with margin: =ROUND(B5*(1+Setup!$B$7),0) gives ₹1,72,500; Spent from Expenses: =SUMIFS(Expenses!$D$5:$D$500,Expenses!$B$5:$B$500,A5) gives ₹1,25,000. Includes an example data table.
Read card text
What this card says
1 for Event Management System in Excel: Days to the event: =B5-B3 gives 34
Client price with margin: =ROUND(B5*(1+Setup!$B$7),0) gives ₹1,72,500
Spent from Expenses: =SUMIFS(Expenses!$D$5:$D$500,Expenses!$B$5:$B$500,A5) gives ₹1,25,000. Includes an
Example
data table
Learn this in the lesson: Event Management System in Excel: Budget vs Actual, Vendor Expenses, Task List, Quotation and Profit