offline
Last seen: Jun 11, 2013 11:53 PM EDT
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

Dr. PHIL_EXCEL

Excel Consultant and Subject Matter Expert

Username: epdailo

  • Has not made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Cainta, Philippines

Member since: January 2013

Reputation:

5.0/5

(2 reviews)

2.2
[see more]

No user has recommended this freelancer.

My projects:

  • $40 USD
    5.0
    Profile image for Seller cpjrdevelopment

    cpjrdevelopment

    Mar 8, 2013

    I would hire again?

    Project Description:I am looking to solve the problem with the count. I have learn that the count was not what they want. They saw that it was too clutter. Also, they wanted to show the BA Lead count. for the Triage. For example, you see two or three names...
    [more]
  • $35 USD
    5.0
    Profile image for Seller cpjrdevelopment

    cpjrdevelopment

    Jan 26, 2013

    The communication was excellent. The project was done in a timely manner. The freelancer explain why he used certain approach to solving a problem.. I would use again in a project.

    Project Description:Key Performance Indicators DASHBOARD EXCEL. Please read the attachment and give me your feedback. Key Performance Indicators DASHBOARD EXCEL. Please read the attachment and give me your feedback. Key Performance Indicators DASHBOARD EXCEL...
    [more]
    Dr. PHIL_EXCEL has not completed any projects.
  • $250 USD In Progress

    Analyzing data with the help of Excel expertise. With the help of my skill want to make life easy to understand the excel reports and data analysis to result correctly.

  • $100 USD In Progress

    Hello,I am using EXCEL for over ten years. I am still a novice, Anaree. I know most basic functions, still missing many short cuts. I use some of Intermediate level functions as well. I would like to get a command on EXCEL to an advanced level.I am looking for an EXCEL guru who can teach me EXCEL on skype. You would login to my PC and teach me. If needed, I can call you on your phone too. Please see the attached Word file and the course content. I want you to cover this content in 20 hours, 2 hours each day, Monday Thru Friday. I am flexible with your time, but would like to start this Monday February 18, 2013. Please keep the time difference in mind. I am in Canada and behind 9 to 10 hours from most of you guys.I can pay you $5.00/hour or $100.00 for the whole course mentioned in the word file. I will pay $100 milestone right away and will release $10 each day after the session.If you successfully teach this course, I would like you to teach me other courses as well:1.Microsoft EXCEL 2010: Data Analysis and Business Modeling, search this book on google/amazon just to get the feel of it.2.MS Word on advanced level3.MS Power Point Beginner to Advanced4.Outlook beginner to AdvancedYou do not have to bid less than $100.00. Nor bid over $100.00. This is a fixed price project for $100.00. Please review the Word file and bid with confidence if you have all the skills, English/Hindi/Urdu and EXCEL skills of course.The above mentioned four courses would be additional and separately bid for in near future.Thank you.Hasan Abedi

    [more]
  • $30 USD In Progress

    hi there,,i have a powerpoint that i need taken to the next level..the powerpoint is only about 12 slides..I can send you what we have and need it developed with better graphics, photos etcplease send price for this and I must see samples of your work..if you can"t show me sample power points you have done then do NOT respond.thanks

    [more]
  • $750 USD Feb 25, 2013

    Taking various excel spreadsheets, Develop a database using existing excel spreadsheet data. Write standard queries and reports.

  • $50 USD/hr Feb 21, 2013

    We are a global sourcing company. There are certain measurements to our productivity which I would like to be built into a model, then into a tool that can be utilized by our staff to determine if and how they are maximizing their work potential. Ultimately each project worked on should have a score, then a manager can aggregate the scores for each project and break it out (using the same tool) to determine a category score, a score for the respective company divisions, a total company score, etc.. Once the work is done in creating the model I would like to ideally have this be built into a locked Excel file as we currently use Microsoft Office at our company.

    [more]
  • $30 USD Feb 15, 2013

    This project will be in Google Drive as a Google Spreadsheet. You will be given shared access to it to perform the work inside the live spreadsheet in Google Drive.A sample is attached, but PLEASE do not do the work on this spreadsheet, because we would prefer the work be done directly into the original cloud-based Google spreadsheet. For now, just look at it for the general idea. See attached file. The spreadsheet has two tabs at the bottom: Items Sold, ResultsThe "Items Sold" tab currently has the following column headings:Date Sold, Owner, Rep, Item Name, Category, Size, # of items on ticket, Item Cost, Sold for, Day of Week, Time of Day, GenderThe information contained in this "Items Sold" tab will be used to complete calculations and graphs in the Results tab.In the Results tab, we need the following calculations and graphs printed:Store Total1. Total Sales:SUM all items in the "Sold for" column2. Average sale: Divide the "Sales" figure in step #1 by the number of items summed (in example file, 83 items were sold, so the function would sum the column and DYNAMICALLY count the number of items calculated and divide by that number. It MUST automatically calculate the number of items summed dynamically, so that calculations are always automated and the division averages the numbers correctly. So, this month 83 items were sold, and the function divided by 83. Next month, maybe it is 97 items sold, so it must properly divide by 97, automatically.3. Profits: SUM the "Item Cost" column and subtract it from #1 above. 4. Average profit: Divide "Profits" above by the number of items sold (similar to fuction in #2)5. Total Sales Minus Pinball Machines: SUM all items in Sold For column, but do not include any item labeled "Pinball Machine" in the "category" column. In the example, on 1/19/2013 there is one pinball machine sold and on 1/30/2013, there were two pinball machines sold. These should be excluded from this calculation. 6. Average minus pinball: The same function as #2 above, except using the result of #5 as the number to divide. This must also lower the divisor by however many pinball machine entries are removed. (In the example file, three machines were sold, so it would count all items but exclude those three "Pinball Machine" for a total of 80 items). 7. Profit minus pinball: The same function as #3 above, except using #5 as the number to divide. This must also lower the divisor by however many pinball machine entries are removed. (In the example file, three machines were sold, so it would count all items but those three for a total of 80 items). 8. Average profit minus pinball: The same as #2, except using #5 as the number to divide. This must also lower the divisor by however many pinball machine entries are removed. (In the example file, three machines were sold, so it would count all items but those three for a total of 80 items). Graphs - Then we need the following graphs under this section (see sample boxes in attached file): Pie Chart for Category: generates a pie chart based on percentages of items sold by categoryPie Chart for Size: generates a pie chart based on item size (small medium large, indicated by "S" "M" "L"Pie chart for Gender: generate a pie chart based on "M" or "F" in genderPie chart for age groups: Generate a pie chart based on Age Range column (no data right now)."Ben"Items # 1 - 4 above plus all four graphs above but calculated for ONLY the items marked with "B" in the "Owner" column. These four calculations must only include items that have B marked in the "Owner" column. One section for "Dean" Same functions and graphs as "Ben" but ONLY the items marked with "D" in the "Owner" column.One section for "Greta"Same functions and graphs as "Ben" but for ONLY the items marked with "G" in the "Owner" column.

    [more]
    Dr. PHIL_EXCEL does not have any open projects.
    Dr. PHIL_EXCEL does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Consultant/Analyst

Dec 1997 - Present (16 years)

Multinational Oil Company

Marketing Analysis

Education

MBA

De La Salle University

1991-1994

BS Electrical Engineering

Adamson University

1984-1989

Certifications

Lifetime Member IIEE

IIEE

Lifetime Member of IIEE

Publications

No Current Publication

None

Still work in progress