WLS Virtual Classroom Course List Microsoft Office 2013 Programs
Microsoft® Office 2013: Transition from Office 2007/2010
Course Description
Time to transition to the newest Microsoft® Office applications. MS Office 2016 is here! This course builds on your current knowledge and skills with the core MS Office programs Word, Excel, PowerPoint, Outlook, and Access.
Course Objective:
Explore the new features available in MS Office 2016 applications.
Topics covered:
- Lesson 1: Getting Started with Microsoft Office 2016.
- Lesson 2: Working with Microsoft Word 2016.
- Lesson 3: Working with Microsoft Excel 2016.
- Lesson 4: Working with Microsoft PowerPoint 2016.
- Lesson 5: Working with Microsoft Access 2016.
- Lesson 6: Working with Microsoft Outlook 2016.
Target Student:
This course is designed for students who are already familiar with MS Office applications Word 2007/2010, Excel 2007/2010, PowerPoint 2007/2010, Access 2007/2010, and Outlook 2007/2010 who are interested in transitioning and learning some of the new features available in the MS Office 2016 suite.
Prerequisites:
It will be helpful if you are familiar with the 2007 and/or 2010 suite of applications. Familiarity with Windows 10 will also be helpful.
Consider these courses to prepare you for this MS Office Transition Course.
- MS Word 2010 Part 1
- MS Excel 2010 Part 1
- MS PowerPoint 2010 Part 1
- MS Office Access 2010 Part 1
- MS Outlook 2010 Part 1
Microsoft® Office Excel® 2013: Dashboards
Course Description
We need to be able to interpret and make sense of the vast amounts of data being created in our organizations on a daily basis. You already can use Excel to perform basic calculations and you are comfortable with using workbooks and worksheets to store and present your data. But that is just the tip of the iceberg. Excel can do a lot more. With Excel® your organization can gain a competitive edge when you are able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance.
Course Objective:
Create dashboards in Microsoft® Excel® 2013.
Topics covered:
- Lesson 1: Create advanced formulas.
- Lesson 2: Automate workbook functionality.
- Lesson 3: Apply conditional logic.
- Lesson 4: Visualize data by using basic charts.
- Lesson 5: Implement advanced charting techniques.
- Lesson 6: Analyze data by using PivotTables, slicers, and PivotCharts.
Target Student:
This course is designed for Excel® users who are already comfortable with basic Excel skills but want to advance to some of the higher-level functionalities. This course combines some topics from the MS Excel Part 2 and MS Excel Part 3 but focusses specifically on teaching students how to create effective dashboards.
Prerequisites:
Consider these courses to prepare you for this MS Excel® 2013 course.
Microsoft® Office Excel® 2013: Data Analysis with Power Pivot
Course Description
Big data is the order of the day. Data is being collected all the time leading to an overwhelming amount of data that needs to be analyzed quickly. Microsoft Excel's Power Pivot functionality helps users organize, manipulate and report data.
Course Objective:
Use Power Pivot along with Excel® 2013 to analyze data from a variety of sources.
Topics covered:
- Lesson 1: Get Started with Power Pivot.
- Lesson 2: Visualize Power Pivot Data.
- Lesson 3: Work with Advanced Functionality in Power Pivot.
Target Student:
This course is designed for Experienced Excel® users that want to advance their data analysis skills and capabilities by using Power Pivot.
Prerequisites:
Consider these courses to prepare you for this MS Excel® 2013 course.
- MS Excel® 2013 Part 1
- MS Excel® 2013 Part 2
- MS Excel® 2013 Data Analysis with PivotTables (recommended)
Microsoft® Office Excel® 2013: Data Analysis with PivotTables
Course Description
This course offers more with PivotTables helping learners to harness the power of advanced PivotTable features. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
Course Objective:
Use Excel® 2013 advanced PivotTable functionality to analyze your raw data.
Topics covered:
- Lesson 1: Prepare data for PivotTable reporting and create PivotTables from various data sources.
- Lesson 2: Analyze Data Using PivotTables.
- Lesson 3: Work with PivotCharts
Target Student:
This course is designed for Experienced Excel® users that want to advance their data analysis skills and capabilities by using PivotTables.
Prerequisites:
Consider these courses to prepare you for this level of MS Excel® 2013.
Microsoft® Office Excel® 2013: 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® 2013 Part 1covers key concepts of the Microsoft® Office Specialist (MOS) exam objectives to help you prepare for the Excel® 2013, and Excel® 2013 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: Get started with MS Excel® 2013
- Lesson 2: Perform calculations
- Lesson 3: Modify a worksheet
- Lesson 4: Format a worksheet
- Lesson 5: Print workbooks
- Lesson 6: Manage workbooks
Target Student:
This course is designed for beginner Excel® users and students who want to develop their skills in creating, editing, formatting, and printing basic Microsoft® Office Excel® 2013 worksheets. Also useful for learners who are transitioning from earlier versions of MS Excel®.
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
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.
