Grade Reports and Unofficial Transcripts are available by accessing the Students Tab. For all other features, please visit the new student portal at https://portal.cmcc.mainecc.edu/ and login using your mainecc.edu account.
MS 2016 Excel - Advanced (WPD 019)
Term: 2021-2022 Fall Semester
Tue, 8:30 AM - 11:30 AM (11/2/2021 - 11/2/2021) Location: CMCC LPC 217
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 functionsSession 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