This is a past event.
Wed, Nov 30, 2022 7:15pm to 8:45pm
Robert W. and Patricia A. Maurer Center, 100
Space is limited! RSVP to attend
November2 – Manage worksheets and workbooks (10-15%)
Topics include: •Import data into workbooks
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks
• Format worksheets and workbooks
• Customize headers and footers Customize options and views
• Display and modify workbook content in different views
• Freeze worksheet rows and columns
• Display formulas Configure content for collaboration
• Set a print area
November 9 – Manage data cells and ranges (20-25%)
Topics include: • Manipulate data in worksheets
• Paste data by using special paste options
• Fill cells by using Auto Fill
• Format cells and ranges
• Modify cell alignment, orientation, and indentation
• Apply cell formats from the Format Cells dialog box
• Apply cell styles
• Define and reference named ranges
• Summarize data visually
• Insert Sparklines
November 11 – Manage tables and table data (15-20%)
Topics include: • Create and format tables
• Apply table styles
• Modify tables
• Add or remove table rows and columns
• Configure table style options
• Insert and configure total rows
• Filter and sort table data
Manage Charts (20-25%)
Topics include: • Create & modify charts
• Add data series to charts
• Switch between rows and columns in source data
• Format charts
• Apply chart layouts and styles
• Add alternative text to charts for accessibility
November 30 – Perform operations by using formulas and functions (20-25%)
Topics include: • Insert references
• Insert relative, absolute, and mixed references
• Reference named ranges and named tables in formulas
• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
• Perform conditional operations by using the IF() function Format and modify text
• Format text by using RIGHT(), LEFT(), and MID() functions
• Format text by using UPPER(), LOWER(), and LEN() functions
• Format text by using the CONCAT() and TEXTJOIN() function