Видео 39
Просмотров 28 950

5:27

Types of Graphs

5:19

A Brief Introduction to Asper Business Analytics Major

1:00

5-Minute Excel Lesson 31 (FV)

5:18

5-minute Excel Lesson 29 (Text Functions)

6:18

5-Minute Excel Lesson 30

6:42

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

Видео

5:27

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

5:19

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

1:00

A Brief Introduction to Asper Business Analytics Major

Просмотров 196 месяцев назад

This is a very brief video (without voice) about Asper Business Analytics Undergraduate Major

5:18

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)

6:18

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

6:42

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

7:55

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)

6:38

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)

7:58

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

10:35

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)

4:29

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)

3:15

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)

5:30

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)

5:40

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)

3:50

5-Minute Excel Lesson 21 (AverageIF & AverageIFs)

Просмотров 894Год назад

5-Minute Excel Lesson 21 (AverageIF & AverageIFs)

5-Minute Excel Lesson 20 (SumIF & SumIFs)

3:39

5-Minute Excel Lesson 20 (SumIF & SumIFs)

Просмотров 920Год назад

5-Minute Excel Lesson 20 (SumIF & SumIFs)

4:27

5-Minute Excel Lesson 19 (Frequency)

Просмотров 663Год назад

5-Minute Excel Lesson 19 (Frequency)

3:36

5-Minute Excel Lesson 18 (Count)

Просмотров 931Год назад

5-Minute Excel Lesson 18 (Count)

5:06

5-Minute Excel Lesson 17 (IF)

Просмотров 950Год назад

5-Minute Excel Lesson 17 (IF)

5 Minute Excel Lesson16 (Mixed Cell Reference)

5:30

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)

5:55

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)

16:42

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)

14:20

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)

10:50

5-Minute Excel Lesson 12 (Pivot Charts)

Просмотров 8932 года назад

5-Minute Excel Lesson 12 (Pivot Charts)

17:05

5-Minute Excel Lesson 11 (Pivot Tables)

Просмотров 1,4 тыс.2 года назад

5-Minute Excel Lesson 11 (Pivot Tables)

16:57

5-Minute Excel Lesson 10 (Map Charts)

Просмотров 6452 года назад

5-Minute Excel Lesson 10 (Map Charts)

10:58

5-Minute Excel Lesson 9 (Box Plot)

Просмотров 532 года назад

5-Minute Excel Lesson 9 (Box Plot)

16:12

5-Minute Excel Lesson 8 (Histogram)

Просмотров 5842 года назад

5-Minute Excel Lesson 8 (Histogram)

@The5MinuteLessons 8 месяцев назад
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 :)
@MJFleming-pp9dc 8 месяцев назад
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.
@joaquinnarvaez3053 Год назад
how did you change the legend for the doughnut chart to look like the one at the end?
@The5MinuteLessons Год назад
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!

The5MinuteLessons

Комментарии