WLS Virtual Classroom Course List Microsoft Office 2010 Programs
Microsoft® Office Excel® 2010: Level 1
Course Description
Every organization processes data. Companies depend on data accuracy to make major operations decisions. Typically the amount of data that is available requires programs that can quickly and efficiently do the work. Microsoft Excel is designed for robust data processing. This program helps you manage your data for more efficient planning and decision making.
MS Excel® 2010 Part 1covers 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:
You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Topics Covered:
- Lesson 1: Getting Started with Excel
- Lesson 2: Performing Calculations in an Excel Worksheet
- Lesson 3: Modifying a Worksheet
- Lesson 4: Modifying the Appearance of a Worksheet
- Lesson 5: Managing an Excel Workbook
- Lesson 6: Printing Excel Workbooks
Target Student:
This course is designed for students who would like to gain the necessary skills to create, edit, format, and print basic Microsoft® Office Excel® 2010 worksheets.
Prerequisites:
It will be helpful if:
- You have previously used a personal computer and know how to navigate with the mouse and keyboard.
- You are comfortable in the Windows environment and are able to use Windows to manage information on the computer.
If you are unfamiliar with using Windows or a personal computer, we recommend you take an introductory Windows course such as either of the following, or have equivalent skills or knowledge:
- Introduction to Windows 7
- Introduction to Windows 8
- Introduction to Windows 10
Microsoft® Office Excel® 2010: Level 2
Course Description
More advanced than basic Excel®, this course prepares you for some of the more high-level capabilities of Excel®. No matter where you work in your organization, whether its sales, operations, marketing, HR, IT, or any other department if information processing matters to you, you will find this course useful.
This course builds on the foundation of Microsoft® Office Excel® 2010: Part 1.
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:
Use basic excel functions to create and develop Excel worksheets and workbooks to help you work with and analyze the data.
Topics covered:
- Lesson 1: Customize the Excel environment
- Lesson 2: Create advanced formulas
- Lesson 3: Analyze data by using functions and conditional formatting
- Lesson 4: Organize and analyze datasets and tables
- Lesson 5: Visualize data by using basic charts
- Lesson 6: Analyze data by using PivotTables, slicers, and PivotCharts
Target Student:
This course is designed for Excel® users that are already comfortable with the basics but want to take advantage of some of the higher-level functionalities offered by Excel®.
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.
- MS Excel® 2010 Part 1
- Introduction to Windows 7
- Introduction to Windows 8
- Introduction to Windows 10
Microsoft® Office PowerPoint® 2010 - Level 1
Course Description
PowerPoint 2010 is a great program to help you create beautiful presentations to share your data. Learn how to use the features and functionality offered in PowerPoint 2010, so you can organize your ideas and enhance your presentations with high-impact visuals, that will clearly convey your message. In this course, you will use PowerPoint 2010 to begin creating engaging, dynamic presentations.
You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft PowerPoint 2010.
Course Objective:
You will explore the PowerPoint environment and create a presentation.
Topics Covered:
- Lesson 1: Getting Started with PowerPoint
- Lesson 2: Creating a Basic Presentation
- Lesson 3: Formatting Text on Slides
- Lesson 4: Adding Graphical Objects to a Presentation
- Lesson 5: Modifying Graphical Objects in a Presentation
- Lesson 6: Working with Tables
- Lesson 7: Working with Charts
- Lesson 8: Preparing to Deliver a Presentation
Target Student:
This course is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft Office PowerPoint 2010.
Prerequisites:
It will be helpful if:
- You have previously used a personal computer and know how to navigate with the mouse and keyboard.
- You are comfortable in the Windows environment and are able to use Windows to manage information on the computer.
If you are unfamiliar with using Windows or a personal computer, we recommend you take an introductory Windows course such as either of the following, or have equivalent skills or knowledge:
- Introduction to Windows 7
- Introduction to Windows 8
- Introduction to Windows 10
Microsoft® Office Excel® 2010: Level 3
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.
Microsoft® Office PowerPoint® 2010 - Level 2
Course Description
PowerPoint 2010 is a great program to help you create beautiful presentations to share your data. Learn how to use the features and functionality offered in PowerPoint 2010, so you can organize your ideas and enhance your presentations with high-impact visuals, that will clearly convey your message. In this course, you will use PowerPoint 2010 to begin creating engaging, dynamic presentations.
You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft PowerPoint 2010.
Course Objective:
To enhance your presentation skills using the advanced features of Microsoft® PowerPoint.
Topics Covered:
- Lesson 1: Customizing the PowerPoint Environment
- Lesson 2: Customizing a Design Template
- Lesson 3: Adding SmartArt Graphics to a Presentation
- Lesson 4: Adding Special Effects to a Presentation
- Lesson 5: Customizing a Slide Show
- Lesson 6: Collaborating on a Presentation
- Lesson 7: Securing and Distributing a Presentation
Target Student:
This course is for professionals that need to use Microsoft office PowerPoint 2010 to prepare presentations and be more productive in their work.
Prerequisites:
If you are new to PowerPoint it will be helpful if you complete Level 1 of this course or have the equivalent experience.
If you are unfamiliar with using Windows or a personal computer, we recommend you take an introductory Windows course such as either of the following, or have equivalent skills or knowledge:
- Introduction to Windows 7
- Introduction to Windows 8
- Introduction to Windows 10
Join Our Mailing List!
Our mailing list is permission-based. By submitting your contact information, you are consenting to receive periodic communications from Workplace Learning Solutions LLC.
