I will need expert pivot table and formulas consultations and answers on thursday Oct 14th 2-4 hours.
Using Excel «Contribution Database», analyze the data and determine if any ineligible contributions, loans and loan guarantees were received AND identify any errors in the reported data by:
• Manipulating the data into a table,
• Creating a visual representation of the data in excel
There are contriubtions by individuals. You can use advanced formulas or macros but leave in your formulas or macros in the document. If you are making any assumptions, detail your assumptions.
On the contributions database you will have to combine the individual name of the contirubitor 3 columns with the address to see if its over the 1,600.00 limit for 2019.
Loans and contributions are for individuals Canadian citizens and the limit is 1600 within 2019.
please make additional worksheet with the exceptions to the over contriubtions of loans and contributions over 1600.00
the exceptions for the dates after 2019 for the individuals .
please use pivot tables and document formulas and macros also . and document these items.