Excel 2007/2010 - Level II - School of Continuing Education, University Of Wisconsin

	Excel 2007/2010 - Level II

	Microsoft Excel allows users to create and manage spreadsheets to manipulate data used in personal finance, budget preparation, financial and investment analysis, business modeling, sales forecasting and other calculating and analytical applications. For specific topics covered in Excel Level II, click on the arrow next to Course Outline/Topics below:
Course Outline/Topics ▼ Course Content Microsoft Excel Level II Lesson 1: Calculating Data with Advanced Formulas Apply Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions Lesson 2: Organizing Worksheet and Table Data Create and Modify Tables Format Tables Sort or Filter Data Use Functions to Calculate Data Lesson 3: Presenting Data Using Charts Create a Chart Modify Charts Format Charts Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts Create a PivotTable Report Filter Data Using Slicers Analyze Data Using PivotCharts Lesson 5: Inserting Graphic Objects Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects Lesson 6: Customizing and Enhancing the Excel Environment Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates Close ▲
	Prerequisites Excel 2007/2010 - Level I (or equivalent experience)
	Notes Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.
	"The material was extremely useful, and exactly what I was looking for. Greg is flexible. He modified the material to answer specific student questions. I will recommend this class to co-workers." -- student, Excel-II, 2012



	Thu., June 27 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Greg Patterson, Great Lakes Training & Consulting Fee: $224 Program No. 5070-0004 Add To Registration Form Check Registration Form

	Thu., Nov. 7 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Greg Patterson, Great Lakes Training & Consulting Fee: $224 CEUs: 0.7 Program No. 5070-6219 Add To Registration Form Check Registration Form

	Tue., Feb. 11, 2014 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Greg Patterson, Great Lakes Training & Consulting Fee: $224 CEUs: 0.7 Program No. 5070-6273 Add To Registration Form Check Registration Form

	Thu., June 26, 2014 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Greg Patterson, Great Lakes Training & Consulting Fee: $224 CEUs: 0.7 Program No. 5070-6276 Add To Registration Form Check Registration Form


	Excel 2010 - Level III Online

	For more information, contact:
		Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208

IT Certificate Programs Brochure

Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>