EQ Excel – Intermediate
Prerequisite: Excel Beginner, or equivalent knowledge
Intermediate Excel builds upon beginner skills with the introduction of management tools to import and work with rows of data to provide meaningful reports and information for business decisions. We will also look at using more complex formulas and logic to create more versatile worksheets.
The hands-on, in-class method allows the student to develop proficiency and confidence working in Excel.
Content:
• Importing data from an outside source
• Managing data using tables
• Finding and replacing
• Sorting and filtering data
• Searching for data using VLOOKUP & HLOOKUP
• Enforcing accurate data input
• Protecting workbook data
• Analyzing data with PivotTables
• Visualizing information with PivotCharts
• Cleaning data using text functions – UPPER, LOWER, PROPER, TRIM
• Calculating based on conditions
• Consolidating data
• Setting named ranges
• Creating conditional formulas – IF, AND, OR
• Using functions to check for error
Required Material: Students must bring a USB Drive to class
Course Price: $60.00
Winter 2021
Day Sessions
Jan 23 - Mar 27Sat
Saturday, Jan 23 - Saturday, Mar 27
Day | Time | Room Number |
---|---|---|
Saturday | 09:30 - 12:30 | VIR-Non-CR |
Additional Information
Teacher: | Yves Anglade |
Course Number: | 922060 |
Registration Start Date: | Thursday, Nov 12, 2020 |
Maximum Class Size: | 12 |
Total Hours: | 30 |
Status: | Activity in Progress |
