Highline Excel Class 40: VLOOKUP 11 Unusual Examples

Urgent.

Can someone provide me with examples of various nested vlookup/hlookup formulas.
Any document/links.............. etc will do.

thanks

does anyone can help me in this issues?
I just read the MS Training but i didn't get it.
Will be better if you can help me with examples and more simple explanations

i have a task of producing a spreadsheet that asks questions and takes figures then displays them as a report.

e.g how much is your energy bill? the user types a figure, its calculated in a formula, and the results displayed in a report.

I need it set out so it looks professional and user friendly. Has anyone got any examples of well laid out user friendly colourful spreadsheets?

Would appriciate it if some one could help me.

Thanks a great deal

hi, i would like to know the site or resource for mastering Loops like DO loops and other loops with examples.if any body knows some sites do list here.

Hello everybody,

Can anybody upload the
2500 Excel VBA Examples, if you have.

Hi,
I am looking for a good website specially a video tutorial that shows you how to create dashboards or charts. I am looking for similar website like http://www.datapigtechnologies.com/
this is very good website for those of you who need to do some fancy staff with excel. Any help will be appriciated. Thanks.

I have created quite a few mini excel apps/ tools to do various tasks eg querying and displaying text files, mainly for my own use and for a couple of colleagues.

While generally they do the job, they all look a bit naff and amateur.

Does anyone know of some good sample excel apps on the web that I could get some inspiration from? I'm not looking to do anything too fancy just make my spreadsheets look a little more professional.

Thanks

Hi to everyone.
I'm returning to work and need practice on Excel 2003 pivot charts.
i've downloaded Bill's 2007 book and found the download for earlier version pivot chart learning; however, i can't find downloads for the earlier book.

Does anyone have the link to download Excel 2003 pivot chart examples from Bill's first book?

Thank you so much,
Randa

I have an Excel chart that has an X axis like this:

Jan-09
Feb-09
...
Nov-09

When I paste this into a PowerPoint presentation, looks great.

When I save and reopen the presentation, the dates have been replaced with:

Dec-04
Jan-05
...
Oct-05

If I right click on the chart and click 'Edit Data" the dates immediately revert back to being correct.

But I have no idea where it's getting those 2004-2005 dates from. They don't appear anywhere either in the presentation or the orginal Excel workbook.

The only other thing I can see that is a bit unusual is that in the Excel Workbook, the axis is formatted as "Text Axis" and in PowerPoint it comes through as "Automatically Select based on data." That said, even after I changed it to Text Axis, the problem persists.

It repeats every time. If I click "Edit Data" it fixes it. Then I save. Then I exit and go back in... broke again.

I'm going to try creating the whole thing from scratch (the chart is rather small) and see if that fixes it... but even if it does I still wonder how this is even possible and where those dates are coming from.

I am as stumped as I've ever been by this.