![The5MinuteLessons](/img/default-banner.jpg)
- Видео 39
- Просмотров 28 950
The5MinuteLessons
Добавлен 30 мар 2020
The5MinuteLessons Channel teaches Excel skills.
Color Usage in Graphs
This video introduces the major functions of color in graphs: differentiation/contrast, highlight, grouping, accessibility and aesthetics.
- Fang Chen & Kayla Bryson
- Fang Chen & Kayla Bryson
Просмотров: 11
Видео
Gestalt Principles
Просмотров 142 месяца назад
This video introduces some of the Gestalt Principles: principle of similarity, proximity, closure, and connection. Our next video will be about color usage by applying some of these principles. -By Fang Chen and Kayla Bryson
Types of Graphs
Просмотров 852 месяца назад
This video introduces types of graphs normally used in business, some common mistakes when using these graphs. - Fang Chen & Kayla Bryson
A Brief Introduction to Asper Business Analytics Major
Просмотров 196 месяцев назад
This is a very brief video (without voice) about Asper Business Analytics Undergraduate Major
5-Minute Excel Lesson 31 (FV)
Просмотров 1,1 тыс.10 месяцев назад
5-Minute Excel Lesson 30 (FV) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-minute Excel Lesson 29 (Text Functions)
Просмотров 64110 месяцев назад
5-Minute Excel Lesson 29 (Text Functions) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 30
Просмотров 1,2 тыс.10 месяцев назад
5-Minute Excel Lesson 30 (PMT and Rate) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
Asper Business Analytics Major
Просмотров 21811 месяцев назад
Starting Sept. 2023, Asper School of Business at University of Manitoba will have a new Business Analytics major for undergraduate students. This is a short video about this new major. Made by Fang Chen and Kayla Bryson
5-Minute Excel Lesson 28 (Date Functions, Part 2)
Просмотров 659Год назад
5-Minute Excel Lesson 28 (Date Functions, Part 2) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 27 (Date Functions)
Просмотров 711Год назад
5-Minute Excel Lesson 27 (Date Functions) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 26 (XLookup)
Просмотров 1,1 тыс.Год назад
5-Minute Excel Lesson 26 (XLookup) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 25 (Hlookup: Range Lookup)
Просмотров 30Год назад
5-Minute Excel Lesson 25 (Hlookup: Range Lookup) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 24 (Hlookup: Exact Lookup)
Просмотров 82Год назад
5-Minute Excel Lesson 24 (Hlookup: Exact Lookup) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 23 (Vlookup: Range Lookup)
Просмотров 1,1 тыс.Год назад
5-Minute Excel Lesson 22 (Vlookup: Range Lookup) Made by Fang Chen and Kayla Bryson Thank you for watching! Fang and Kayla
5-Minute Excel Lesson 22 (Vlookup: Exact Lookup)
Просмотров 1,2 тыс.Год назад
5-Minute Excel Lesson 22 (Vlookup: Exact Lookup)
5-Minute Excel Lesson 21 (AverageIF & AverageIFs)
Просмотров 894Год назад
5-Minute Excel Lesson 21 (AverageIF & AverageIFs)
5-Minute Excel Lesson 20 (SumIF & SumIFs)
Просмотров 920Год назад
5-Minute Excel Lesson 20 (SumIF & SumIFs)
5 Minute Excel Lesson16 (Mixed Cell Reference)
Просмотров 768Год назад
5 Minute Excel Lesson16 (Mixed Cell Reference)
5-Minute Excel Lesson 15 (Relative & Absolute Cell Reference; Min, Max, Average, Sum, Large, Small)
Просмотров 2 тыс.Год назад
5-Minute Excel Lesson 15 (Relative & Absolute Cell Reference; Min, Max, Average, Sum, Large, Small)
5-Minute Excel Lesson 14 (Presenting actionable recommendations / insights with charts)
Просмотров 2162 года назад
5-Minute Excel Lesson 14 (Presenting actionable recommendations / insights with charts)
5-Minute Excel Lesson 13 (Drilling down the data set for actionable recommendations / insights)
Просмотров 3972 года назад
5-Minute Excel Lesson 13 (Drilling down the data set for actionable recommendations / insights)
5-Minute Excel Lesson 12 (Pivot Charts)
Просмотров 8932 года назад
5-Minute Excel Lesson 12 (Pivot Charts)
5-Minute Excel Lesson 11 (Pivot Tables)
Просмотров 1,4 тыс.2 года назад
5-Minute Excel Lesson 11 (Pivot Tables)
5-Minute Excel Lesson 10 (Map Charts)
Просмотров 6452 года назад
5-Minute Excel Lesson 10 (Map Charts)
Hi MJFleming, thank you for pointing out that I can link the the frequency table to the live table by cell references. I tried it, it worked very well. -Fang :)
It's worth pointing out that you can actually link the histogram frequency table to the live table by way of cell references. Then you will have a histogram which updates automatically. In fact, you could probably just write the FREQUENCY() function right into the histogram frequency table itself.
how did you change the legend for the doughnut chart to look like the one at the end?
For the legend (the label for each segment of the donut), you simply highlight the word, the change the color to match the segment color. In other words, you have to do this manually. I will respond to your comment much sooner in the future!