Microsoft® Office Excel® 2010: Level 3

Microsoft® Office Excel® 2010: Level 3

register here

Course Description

Microsoft® Excel® Part 3 is for those experts whose work like revolves around spreadsheets and their functionality. Part 3 uses the foundation set in Parts 1 and 2 of Microsoft® Office Excel® 2010 to sharpen your Excel capabilities and experience. You will learn advanced collaboration functionalities, how to automate complex and repetitive tasks, and  how to develop elaborate formulas and functions by applying conditional logic. 

MS Excel® 2010 Part 2 covers key concepts of the Microsoft® Office Specialist (MOS) exam objectives to help you prepare for the Excel 2010, and Excel 2010 Expert Exams.

Course Objective:

Perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Topics covered:

  • Lesson 1: Work with multiple worksheets and workbooks simultaneously.
  • Lesson 2: Share and protect workbooks.
  • Lesson 3: Automate workbook functionality.
  • Lesson 4: Apply conditional logic.
  • Lesson 5: Audit worksheets.
  • Lesson 6: Use automated analysis tools.
  • Lesson 7: Present your data visually.

Target Student:

This course is designed for experienced Excel® users that need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel® functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Prerequisites:

It will be helpful if you have completed Microsoft® Excel® 2010 part 1 or have the equivalent knowledge prior to taking this course.

Consider these courses to prepare you for this level of MS Excel® 2010. 

register here