I will do advanced excel tasks for you

Sommige informatie wordt in het Engels weergegeven.
5,0
5,0

Kenia

Ik spreek Engels, Swahili

80 bestellingen voltooid

Accountant, Forensic Auditor, Financial Analyst, Business Strategist

I am an astute accountant, financial analyst and forensic auditor. I have over 10 years of experience. I am a qualified Certified Public Accountant (CPA), Certified Fraud Examiner (CFE) and a Certifie...
Over deze dienst

Having been trained in Advanced Excel and with over 5 years of exprience, I offer the following services relating to advanced tools in Excel:

  • Building and applying advanced formulas, such as SUMPRODUCT, INDIRECT, INDEX MATCH, and OFFSET. These formulas can be used to perform complex calculations on data that is spread across multiple worksheets or workbooks.
  • Using Pivot Tables and Pivot Charts to analyze large datasets. PivotTables and PivotCharts allow you to summarize and visualize data in a variety of ways, making it easier to identify trends and patterns.
  • INDEX MATCH
  • IF combined with AND/OR
  • OFFSET combined with SUM/AVERAGE
  • XNPV and XNPV
  • SUMIF and COUNTIF
  • PMT and IPMT
  • LEN and TRIM
  • CONCATENATE
  • CELL, LEFT and RIGHT FUNCTIONS
  • VLOOKUP and XLOOKUP
  • PIVOT Tables
  • IF ERROR
  • ROUND
  • CHARTS
  • Power Query and Power Pivot
  • Macabacus
  • Dynamic Arrays and Excel Tables
  • Sensitivity Analysis using Data Tables, Goal Seek and What IF Analysis
  • Bullet Charts, Tornado Charts, Gauge Charts, Waterfall Charts.

Kindly contact me first before ordering!

Technologie:

Atlas.ti

Excel

Google Analytics

Google Data Studio

Type analyse:

Kwantitatieve analyse

Kwalitatieve analyse

Expertise:

Zakelijke inzichten

Voorspelling

Forecasting

Programmeertaal:

Python

R

SPSS

SQL

Overige

Tools:

QuickBooks

TradingView

eMoney

zoho

Cube

Mijn portfolio

Reviews

7 reviews van deze dienst
5,0

(7)
(0)
(0)
(0)
(0)
Specificering van de beoordeling
  • Communicatieniveau van de freelancer
    5
  • Aanbevelingswaardig
    5
  • Dienst zoals beschreven
    5
Sorteer op
Meest relevant
  • O

    ogollajackton

    KE

    Kenia

    5

    The seller exceeded my expectations. He even went ahead and provided me with pivot tables that had data just to show me how the pivot tables work.

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • M

    malomeochieng

    KE

    Kenia

    5

    Thank you very much for the detailed excel data analysis. I also like the way you were able to come up with the loan amortization schedule. Elimem is a real expert in Excel. Espcially using tools like PYMT and other formulas.

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • M

    malomeochieng

    KE

    Kenia

    5

    He is very good at PIVOT Tables and regression. I will definitely work with him again!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • L
    image-docs

    linet68

    KE

    Kenia

    5

    He is good in all excel tasks no matter how complex they are! Perfect job!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • L
    image-docs

    linet68

    KE

    Kenia

    5

    He is skilled in VLOOKUP and other advanced excel tools. I will definitely order again. Fast delivery!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
Reviews

7 reviews van deze dienst
5,0

(7)
(0)
(0)
(0)
(0)
Specificering van de beoordeling
  • Communicatieniveau van de freelancer
    5
  • Aanbevelingswaardig
    5
  • Dienst zoals beschreven
    5
Sorteer op
Meest relevant
  • O

    ogollajackton

    KE

    Kenia

    5

    The seller exceeded my expectations. He even went ahead and provided me with pivot tables that had data just to show me how the pivot tables work.

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • M

    malomeochieng

    KE

    Kenia

    5

    Thank you very much for the detailed excel data analysis. I also like the way you were able to come up with the loan amortization schedule. Elimem is a real expert in Excel. Espcially using tools like PYMT and other formulas.

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • M

    malomeochieng

    KE

    Kenia

    5

    He is very good at PIVOT Tables and regression. I will definitely work with him again!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • L
    image-docs

    linet68

    KE

    Kenia

    5

    He is good in all excel tasks no matter how complex they are! Perfect job!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee
  • L
    image-docs

    linet68

    KE

    Kenia

    5

    He is skilled in VLOOKUP and other advanced excel tools. I will definitely order again. Fast delivery!

    US$ 50

    Prijs

    1 dag

    Looptijd

    Nuttig?
    Ja
    Nee