Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase

[bodrulm1]

Did the last example require a VLOOKUP at all? Could we not just reference the cells e.g. on the %Increase sheet in cell D3 type "=Assumptions!B3" (the cell B3 in Assumptions sheet. Then copy to all other cells. That would take about 10 seconds at most.

I like the Columns function, thanks

[nnt1999]

hello Mike!

I saw couple of urs excel youtube video....I’ve advance knowledge of excel...can u recommend me any book/CD/online for excel (for expert knowledge like u) for advance function/form/query /VB/ advance macro/ relationship

thanks

[ExcelIsFun]

I do not have an advanced book, however, if you watch this Highline Series (videos 1 - 53), you will see most of what I know presneted in logical order. The advantage of the Highline Excel series is that the ideas are presnted in a logical and cumulative order. One GREAT Advanced Excel book is: "Excel Hacks".

[aman1245singh]

Thanks again for the kind video. Moreover, I have a query.

While I am editing a formula, and I use a cell reference, how can I make out the format of that cell( which I am using as a part of the cell being formulated)?

[ExcelIsFun]

The formula usually takes the formatting from the cell reference cell. If it does not I usually use the Format Painter button.

[MrHelal123]

Mike you have given excellent examples on how to increase a value by 10%, what formulas can i use if i wanted to decrease the values by 10%?

Thanks

[ExcelIsFun]

Bad YouTube is doing it again. I have prepared a good answer, but it won't let me post it with the characters that it contains...

I'll try again...

[ExcelIsFun]

If 10% up, then (1+.1)

If 10% down, then (1-.1)

[ExcelIsFun]

I briefly mention this at the 1:20 to 1:30 minute mark.

[rameshsolonely]

Dear Mr Excel, thank you very much for help in inventory . i have a Question if is possible to show up value equal to P or Off in Roster i want to 2 different page like

12-8 sun on 3-12 mon tues off i want to see in next page sun p, mon p tues off if is possible in excel i am waiting your answer

SunJoy Kuwait

[ExcelIsFun]

I do not understand your question. Can you re-state your question?

--excelisfun (not Mr Excel)

[jaeheerang]

I have some difficulties to understand this. I think I have to go back and watch it again. But I'm sure this will be a very useful formula.

Excel is getting exciting!

Thank u so much!

[ExcelIsFun]

Dear jaeheerang,

Practice Makes perfect!

--excelisfun

[slaves2sin]

this is bloody tricky i made so many mistakes

[ExcelIsFun]

Dear slaves2sin,

EXCELlent!! I love to hear that!

When you make lots of mistakes and you keep moving forward, that is when you learn the most!!!

--excelisfun

[thirthyest]

me too :))))

[ExcelIsFun]

Me too -- that is how I learn the best tricks in Excel!