ÎçÒ¹av

COURSE DETAILS

COST: $150 + HST

DURATION: FULL DAY

COURSE TYPE: SHORT COURSE

DELIVERY METHOD: IN-PERSON

LOCATION: CHARLOTTETOWN

START DATE: WAITLIST

AVAILABILITY: Waitlist

CONTACT

To discuss your training needs, please send us an email or call: 902-566-9669.

In this intermediate Excel course, you will master complex functionalities to improve data management and analysis efficiency. You'll learn advanced worksheet management, including grouping and linking, and enhance your formula skills with relative, absolute, and mixed references. The course covers advanced functions like SUM, AVERAGE, MIN, MAX, and COUNT, and teaches data analysis and visualization through sorting, analyzing, and creating charts. An introduction to Pivot Tables will be provided, as well as data validation and security techniques and the use of Excel add-ins. Essential keyboard shortcuts to boost workflow efficiency are also included. By the end of this course, you'll be proficient in managing, analyzing, and visualizing data with intermediate Excel features.

LEARNING OUTCOMES

After successfully completing the course, students will be able to: 

• Develop spreadsheets that use basic workplace functions. 
• Use keyboard shortcuts for many different formatting commands. 
• Managing Cells and the data contained within each cell. 
• Organize Data for specific purposes.  
• Format worksheets for typical workplace requirements. 
• Change the format of cells in a spreadsheet. 
• Modifying worksheets for specific purposes. 
• Create new worksheets in a single spreadsheet file. 
• Troubleshoot formulas in spreadsheets including formulas in existing spreadsheets and self-created formulas. 
• Use references and AutoFill functions in a worksheet. 
• Manage data to answer questions. 
• Create customized charts.