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

	Excel 2007/2010 - Level III

	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 III, click on the arrow next to Course Outline/Topics below:
Course Outline/Topics ▼ Course Content Microsoft Excel Level 3 Lesson 1: Streamlining Workflow Update Workbook Properties Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Lesson 2: Collaborating with Other Users Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access Lesson 3: Auditing Worksheets Trace Cells Troubleshoot Invalid Data and Formula Errors Watch and Evaluate Formulas Create a Data List Outline Lesson 4: Analyzing Data Create a Trendline Create Sparklines Create Scenarios Perform a What-If Analysis Perform a Statistical Analysis with the Analysis ToolPak Lesson 5: Working with Multiple Workbooks Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links Lesson 6: Importing and Exporting Data Export Excel Data Import a Delimited Text File Lesson 7: Integrating Excel Data with the Web Publish a Worksheet to the Web Import Data from the Web Create a Web Query Close ▲
	Prerequisites Excel 2007/2010 - Level II (or equivalent experience)
	Notes Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.



	Wed., July 24 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructors: Lynne Miller Greg Patterson, Great Lakes Training & Consulting Fee: $224 Program No. 5070-0005 Add To Registration Form Check Registration Form

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


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

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>>