Module 1 – Working with Charts & Data Formatting
- Conditional formatting
- More on charts (bar, histogram, pie charts)
- Sort & Filter (removing duplicate data)
- Module Quiz
-
Module One: Working with Charts & Data Formatting
Instructor
0.00 average based on 0 ratings
5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
₦7,500
Thank you Morgan, this is impressively informative.
On Part A, regarding duplicate/replicate data; Let us assume I have an extensive data sheet with data entered in a manner that I have a couple of reoccurring names at different rows down a name column but at the value column, these reoccurring names bear different value entries. Being an extensive data sheet, I can sort by name to have all the names grouped together, fine, but how can I automatically condense/compress (I dont know the jargon lol!) the set of a particular name into one entry/row whilst having all the different values summed/condensed/compressed up into the value cell? I don’t know if my question is explicit enough sir?
Hello Thanks for the question, we will pass on to the instructor and he will reply you, but if you dont mind, you cant take note of this and raise it during your one on one session with the instructor next week.
we are happy you are enjoying the lessons.
Thanks
Thank you Morgan, this is impressively informative.
Regarding duplicate/replicate data; Let us assume I have an extensive data sheet with data entered in a manner that I have a couple of reoccurring names at different rows down a name column but at the value column, these reoccurring names bear different value entries. Being an extensive data sheet, I can sort by name to have all the names grouped together, fine, but how can I automatically condense/compress (I dont know the jargon lol!) the set of a particular name into one entry/row whilst having all the different values summed/condensed/compressed up into the value cell? I don’t know if my question is explicit enough sir?
great
Great blog, check us out at smaartcollections.com
Please how do I access this content. I need it.
One of our people will call you soon ma
Thanks