“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

- CONDITIONAL FORMATTING
- PIVOT TABLES
- SUMIF
- VLOOKUP
- COUNTIF
- MATCH
- INDEX
- LIVE EXCEL HELP
- ONLINE EXCEL HELP
- EXCEL HELP CHAT
- FREE EXCEL HELP
- EXCEL EXPERT HELP
- IF
- COLUMN
- ROW
- COUNT
- LOOKUP
- AVERAGE
- SUM
- ABS
- BOX AND WHISKER
- PI
- RAND
- CONCATENATE
- IRR
- WORKDAY
- MAX
- SUMPRODUCT
- IF AND
- TEXT
- TIME AND DATE
- RANK
- AVERAGEIF
- PERCENTAGE
- RANGE
- DATA VALIDATION
- ROUND
- TABLES
- SHORTCUT
- DATE SERIES
- MAX AND MIN
- DATABASE
- ENGINEERING
- FINANCIAL
- STATISTICAL
- SMALL
- LARGE
- CHOOSE
- FIND
- SEARCH
- HOW TO

I need help with
Download "Population Historical" data from the government website.
Select the data for each continent and their populations and group together at the top of the spreadsheet. Use only population data from the last 10 years.
Create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b, c).
Create narratives based on the Excel Area Chartto discuss the following in a minimum of 1,400 words:
Interpret the historical trend in increase/decrease of population per continent.
Formulate a prediction on how the population would vary in the next decade. How did you arrive at this conclusion?
Investigate how Excel creates a forecast. Explain the steps involved.
Convert your area chart into a line chart in Excel, and add forecasted values. Include a screenshot in your paper.
Compare the forecasted output that Excel has provided with the conclusions you have arrived at in regards to the trend in the increase/decrease of population.
Recommend other Excel data analysis properties or chart types that could be used to demonstrate your data findings.

Solved by S. E. in 16 mins

My VLOOKUP does not work in Excel (though it seems to work in Google Sheets).
I have an internet-linked query on worksheet 'Strokes Gained' that can't be edited. I need the VLOOKUP on the 'Master Spreadsheet' to draw from this internet-linked query table.
I have sought help in the past from this site and the "fix" has been to edit the 'Strokes Gained' table -- this absolutely should not happen.
Can you please help?

Solved by G. J. in 12 mins

I am trying to categorise some deliveries by drop 1 or drop 2.
any item (row in excel) to the same postcode on the same day that are larger than 2 hours apart on the last scan need to be shown as a separate delivery (drop 2). I need help creating the "drop that day" column.
many thanks

Solved by B. L. in 30 mins

Hi, we have a multi sheet excel spreadsheet will missing job ID's. I have a separate spreadsheet with all of the job ID's. Is there a way of automatically populating the Job ID codes? Please help

Solved by M. B. in 29 mins

Hi,
I'm an excel novice and trying to work out how to get the below Sum into a spreadsheet. please help?
£7.00 x 13.8% + = x 14.8% + = x 33% + =x 1% + = Charge Rate

Solved by V. U. in 18 mins

Hi, I would like to get some help with excel macros/VBscript. Can someone help ?

Solved by M. B. in 17 mins

Hi there!
I'm basically really struggling with Excel VBA. I am trying to create an excel sheet which scrapes the code from a web page onto it. I then need this to refresh frequently using a timer, and then send me a notification if any changes have been made to the source code, letting me know that the website has been updated.. Could you help me with this? So far I have recorded a macro which pulls in the web data and have got that on a timer, but every time it runs the web info is put in a new column, rather than refreshing the old info.... Please help!!! Thanks

Solved by V. B. in 29 mins

Is it possible in a spreadsheet to enter the first date of any month (mm/dd/yy) in a column that has 31 cells and Excel (I'm guessing with the help of a formula) automatically filling in the rest of the days that are in that month only? For example, if I put 02/01/2017, will Excel only fill in the number of days for February without proceeding to the next few days of the next month?

Solved by M. U. in 16 mins

I need help figuring out this problem in excel. The second section of the dashboard should be a Monthly view. In the Monthly section of the dashboard, we want an input cell that allows us to put in a specific revenue amount. Then, we want to show the number of historical months that had revenue that was lower than the amount designated in the input cell.

Solved by A. U. in 27 mins

Hello
I'm trying to make a fretboard fraction calculator.
Here's what I have so far:
On The left ore the open string tunings expressed as fractions
I have a 3/2 being added to each of the open strings (by multiplying each integer) and then using the the GCD function to reduce the fraction.
So 3/2 + 5/4 = 15/8. Or 3/2 + 4/3 =2/1.
So far everything is working fine.
But In these fractions the numerator is always larger than, but cannot be more than twice the denominator.
So if 3/2+7/4 =21/8. I simply need to multiply the denominator by 2. 3/2+7/2=21/8, 8*2=16 =21/16. How can I get excel to double the denominator ONLY if the numerator is twice as much and leave it alone if it is not.
3/2+5/4=15/8 good *2=15/16= bad. I need to have the result in the same excel boxes not different ones.
Thanks for any possible help
-Matt

Solved by F. H. in 15 mins