Bowling Green State University

870 E Wooster St, Bowling Green, OH 43403

View map

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

Event Details

See Who Is Interested

0 people are interested in this event

User Activity

No recent activity

Bowling Green State University Powered by the Localist Community Event Platform © All rights reserved