MS Excel Workshop - Intermediate

The Digital Business Student Association (DBSA) was established in 2015 by a group of students in the Bachelor of Commerce –Digital Business ManagementBComm degree program. It is a student run organization that collaborates with alumni and professionals to provide various workshops and events on the growing trends in the technology industry. DBSA strives to empower and connect students to the world of digital business.

Digital Business Student Association

Digital Business Association presents TechWeek Conference 2018!
The day includes hands-on and full day Microsoft Excel Workshop - Office 2016.
There will be a 30 minute lunch break provided (bring your own lunch).
Location: L Building, Room L3012
Led By: Microsoft Certified, <A HREF="https://www.linkedin.com/in/isabellaannouza/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Isabella Annouza</A>
Workshop Content: Microsoft® Office Excel® 2016 (Intermediate)
Lesson 1: Customizing the Excel Environment 
<UL>
<LI>Topic A: Configure Excel Options</LI>
<LI>Topic B: Customize the Ribbon and the Quick Access Toolbar</LI>
<LI>Topic C: Enable Excel Add-Ins</LI>
</UL>
Lesson 2: Creating Advanced Formulas 
<UL>
<LI>Topic A: Use Range Names in Formulas</LI>
<LI>Topic B: Use Specialized Functions</LI>
<LI>Topic C: Use Array Formulas</LI>
</UL>
Lesson 3: Analyzing Data with Functions and Conditional Formatting 
<UL>
<LI>Topic A: Analyze Data by Using Text and Logical Functions</LI>
<LI>Topic B: Apply Advanced Conditional Formatting</LI>
</UL>
Lesson 4: Organizing and Analyzing Datasets and Tables 
<UL>
<LI>Topic A: Create and Modify Tables</LI>
<LI>Topic B: Sort Data</LI>
<LI>Topic C: Filter Data</LI>
<LI>Topic D: Use SUBTOTAL and Database Functions</LI>
</UL>
Lesson 5: Visualizing Data with Basic Charts 
<UL>
<LI>Topic A: Create Charts</LI>
<LI>Topic B: Modify and Format Charts</LI>
</UL>
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts 
<UL>
<LI>Topic A: Create a PivotTable</LI>
<LI>Topic B: Analyze PivotTable Data</LI>
<LI>Topic C: Present Data with PivotCharts</LI>
<LI>Topic D: Filter Data by Using Slicers</LI>
</UL>

Humber College Lakeshore Campus

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

MS Excel Workshop - Intermediate

More events from Digital Business Student Association

Discover more events from Digital Business Student Association, from Business to other experiences you might love.

MS Excel Workshop - Intermediate

More events from Digital Business Student Association

Discover more events from Digital Business Student Association, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.