wonderful, well understood
Good one
Clear and precise
Wow so nice and interested
understood, pefectly
very clear
Well taught. Thank you.
This lesson are wonderful. Am glad I registered with you 😊
Thank you so much
understood
Very very grateful for this lesson
Nice
Hi, everyone, I experimented with something and saw that if you insert a sheet between the sheets you have consolidated using 3dsum, it’s updates the totals on the consolidated sheet
Nice Findings. I love that.
This is interesting
very interested
well understood!
very interesting
well understood and knowledgable
Wonderful. Please, with the consolidation, the three examples you used have the same range. Can it work if one of the sheets differ from the others in terms of range
If one of the range is different then the goal of consolidation is defeated already.
Consolidation performs operations(Sum, average etc) for different sets of data with same range and labels.
Thank you Boss
Hello sir. I have a problem with the static allsame consolidation. I used 3 sheets just like you used in the video, but my result was showing the first month twice. I mean it added up just the first month (January) on the both sheet, then it left the month on the third sheet alone. Please how do i go about it?
You definitely made a mistake and the best I can do is to encourage you to do it again but this time paying attention to the steps.
It’s like GIGO.
We learn some times from mistakes too
So don’t be discouraged.
Thank you very much, my great instructor. My question on “Static All Same Cons”:
In a situation where the number of Sales Agent is more than the Month i.e. rows is more the the columns, what formula can we make use? Thank you once again, I’m really enjoying the lectures.
Thanks friend
The Sales Agent and Month mustn’t be the same.
It works either ways
Wow, I’m enjoying the class, great value 🌟♥️
Thank you for the lecture. assuming we have sales agent 6 in con 2 and none in con 1 and 3. will the consolidation still work
You’re welcome.
Yes it will work.
Just ensure the row with Sales Agent 6 is highlighted
Thanks boss
thanks alot
SIR please how do i get the document
Reach me via mail
awesome8emmanuel@gmail.com
please sir, how do i get the document
The lesson materials is attached to the first lesson. Click on it to download.
You can also send a request mail
awesome8emmanuel@gmail.com
Good morning, I want to know if Static consolidation will work in a sheet when the sales agents numbers are scattered
for instance, let’s say sheet one has (agent 1, agent 2, agent 3)
but in sheet 2, sales agent 2 is the first line i.e (agent 2, agent 1, agent 3)
then, sheet 3 (agent 3, agent 1, agent 2)
will static/linked work on this???
Thanks
Thanks for your question.
Both Static and Link Same consolidation will work BUT the result (answer) will be WRONG due to the disarrangement of the Agents.
It’s not sensitive enough to match the Agents correctly when they are mixed up.
Noted, thanks sir
Well explained, Mr. Awesome. You’re good
Understood.
Enjoyed the class
very informative session i must confess. however, i am using Microsoft office 365 and i am not seeing consolidate button under data tab. can you kindly advice? thanks
perfectly understandable
6 Comments
I enjoy the program very well I will try to invite most of my friends to enroll for it.
My pleasure, Thanks for trusting AQskill
I truly enjoyed the step by step training and am now better in excel, thank you so much sir.
This is indeed great and amazing,I must admit that I have a good value for my money, Honestly the course is well delivered.
Secondly,I truly appreciate how the instructor Mr Awesome is ever ready to respond as quickly as possible to any area that needs more classification during the course of my learning this program on Excel.
Thanks for your effort Mr Awesome,I will recommend this valuable course to my friends …
This is indeed great and amazing,I must admit that I have a good value for my money, Honestly the course is well delivered.
Secondly,I truly appreciate how the instructor Mr Awesome is ever ready to respond as quickly as possible to any area that needs more classification during the course of my learning this program on Excel.
Thanks for your effort Mr Awesome,I will recommend this valuable course to my friends …
Thanks to AQ Skill
The pleasure is mine. Thanks for trusting AQskill.