Welcome to The BRIDGE Excel Learning Series! In these presentations, you will learn what the SUM, AVERAGE and COUNT functions are and how to apply them. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Check out the full series here. 

About The BRIDGE @ U of T Scarborough  

Located at the University of Toronto Scarborough, The BRIDGE is a joint venture between UTSC’s Department of Management and the UTSC Library. It is where business, research and innovation converge, delivering extraordinary student experiences through entrepreneurship, research, advanced training programs, and work-integrated learning. Our state-of-the-art facility includes a business research library, data lab, and collaboration lounge. We are a U of T accelerator focused on student formation, and a pathway for industry and community partnerships. The BRIDGE connects the best academic theory with creative applications and aspiring minds.  

Copyright: These resources fall under Creative Commons copyright, meaning they can be reused and adapted with credit.  

01 - Basic Functions: SUM, AVERAGE, COUNT

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn what the SUM, AVERAGE and COUNT functions are and how to apply them. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

BRIDGE logo

02 - Basic Functions: ROUND, INT, MAX

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn what the ROUND, INT and MAX functions are, and their applications. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

BRIDGE logo

03 - Basic Functions: Comparison Operators

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn how to use comparison operators. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

 

BRIDGE logo

04 - Logical Operators: AND, OR, NOT

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn how to use the AND, OR, and NOT operators. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

 

BRIDGE logo

05 - Basic Functions: IF

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn how to identify the purpose and uses of the IF function. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

 

BRIDGE logo

06 - Basic Functions: SUMIF, COUNTIF

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn about SUMIF and COUNTIF, and how to Identify potential causes for error when using these functions. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

 

BRIDGE logo

07 - Different Standard Deviation Functions: Part 1

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn how to develop the ability to differentiate between the different standard deviation functions. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

BRIDGE logo

08 - Different Standard Deviation Part 2

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will see an example of how to apply standard deviation concepts.. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

 

BRIDGE logo

09 - The Use of Filters

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn about filter shortcuts and options. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

BRIDGE logo

10 - Data filtering

Welcome to The BRIDGE Excel Learning Series! In this presentation, you will learn how to format cells to prepare an unorganized dataset , and the applications of formatting data. Links to supplementary materials below.  

Follow along and practice by downloading the sample dataset: Median Daily Per Capita Expenditure vs. GDP Per Capita. 

Watch the video now!  

Check out the full series here. 

BRIDGE logo