Suljettu

excel pivot tables and formula analysis -- 3

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.

Taidot: Excel Macros

Näytä lisää: using excel pivot tables aspnet, writing excel pivot tables xml, create excel pivot tables aspnet, create excel pivot tables, excel pivot tables code, generate excel pivot tables cnet, generate excel pivot tables, code access excel pivot tables fields, vsto excel pivot tables, open xml excel pivot tables, dashboard excel pivot tables, automate excel pivot tables, excel pivot tables, hire a freelancer that does excel pivot tables, i need expert advice in excel, how to use excel pivot tables to analyze massive datasets, excel pivot table formula, data analysis with excel pivot tables, https www udemy com data analysis with excel pivot tables, microsoft excel data analysis with excel pivot tables

Tietoa työnantajasta:
( 0 arvostelua ) Ottawa, Canada

Projektin tunnus: #31815737

8 freelanceria on tarjonnut keskimäärin $21/tunti tähän työhön

(4 arvostelua)
5.8
(28 arvostelua)
5.5
faizanmaqbool695

Dear Client! I've read your all description carefully and understood your requirement, so i think i can do your project perfectly. Your project is very wonderful. I have good experience in this field. So far, I have ac Lisää

$25 CAD / tunti
(0 arvostelua)
0.0
(0 arvostelua)
0.0
(1 arvostelu)
0.0
osamawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

$15 CAD / tunti
(0 arvostelua)
0.0
WycOj

EXPERT IN EXCEL Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft Lisää

$25 CAD / tunti
(0 arvostelua)
0.0
VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010. I can handle your project in a very prudent manner. Give me a chance so Lisää

$25 CAD / tunti
(0 arvostelua)
0.0