|
|
Course Information
Intermediate I Excel 2010
Intermediate I Excel 2010 for Windows –
Prerequisites: Intro to Excel or equivalent experience-
Audience: students who are familiar with the basics of Excel, but would like to expand their knowledge-
Course topics include:
-Splitting and freezing panes in a worksheet
-Sorting & filtering data
-Formatting data as a table
-Linking data across worksheets
-Relative and absolute cell references
-Naming cells and cell ranges with the name box
-#### and other common error values
-Function library
-IF functions
-Rounding Numbers
-Text functions
-Conditional Formatting
-Creating & formatting charts (graphs)
- Questions about the course? Email: jdonelan@depaul.edu
|