Jenzabar University

MS 2016 Excel - Advanced (WPD 019)

Term: 2021-2022 Fall Semester

Faculty

Schedule

Tue, 8:30 AM - 11:30 AM (11/2/2021 - 11/2/2021) Location: CMCC LPC 217

Description

Session One:
• Create a worksheet group
• Format and edit multiple worksheets at once
• Create cell references to other worksheets
• Consolidate information from multiple worksheets using 3-D references
• Create a link to data in another workbook
• Create a workbook reference
• Use the IF function
• Use the AND function
• Use the OR function
• Use structured references in formulas
• Nest the IF function
• Use the VLOOKUP function
• Use the HLOOKUP function
• Use the IFERROR function
• Summarize data using the COUNTIF, SUMIF, and AVERAGEIF functions

Session Two:
• Create an application
• Create, edit, and delete defined names for cells and ranges
• Paste a list of defined names as documentation
• Use defined names in formulas
• Add defined names to existing formulas
• Create validation rules for data entry
• Protect the contents of worksheets and workbooks
• Add, edit, and delete comments
• Learn about macro viruses and Excel security features
• Add the DEVE