Microsoft Office Excel 2016: Part 2 (Intermediate)
Microsoft Office Excel 2016: Part 2 (Intermediate)


  • access_time 02:30 hours

Microsoft Office Excel 2016: Part 2 (Intermediate) builds on your knowledge of the basic functionality of Excel by teaching you to perform more advanced calculations and specialized actions. To begin, you’ll develop a deeper understanding of the complex formulas and functions that allow you to extract important information from your data. You’ll discover how to sort, filter, and query data to increase the readability of your worksheets. You’ll see how to create and manipulate sophisticated tables and charts. You’ll also discover how to create PivotTables and PivotCharts to analyze and present your data with a high level of flexibility, and you'll discover helpful ways of filtering data using Timelines and Slicers. The second part of our Microsoft Office Excel 2016 series, this course is 2 hours and 30 minutes in length and will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and a final quiz to test your comprehension.

Suggested Use:

PC & Mac System Requirements
• Turn off/disable popup blockers, 3rd Party cookies must be accepted, JavaScript must be enabled, Adobe Reader version 7+, Microsoft Office version 2003 or newer.
Browser Requirements
• Internet Explorer 9+, Google Chrome, Safari 3+, Firefox 3+. OpenSesame recommends using the newest browser versions whenever possible for improved security, performance and support.
• If your organization uses Internet Explorer, you must also add listed websites (where applicable) to trusted sites, make sure "Enable Protected Mode" is unchecked for trusted sites only and disable compatibility view for
Hardware Requirements
• 256 Mb RAM minimum, a computer with speakers or headphones, internet bandwidth: 512 kb/s+ recommended, computer processor: 450 MHz minimum, graphics card and high-resolution monitor supporting SVGA and screen resolution of 1024x768 or larger.
Mobile-Ready Testing Recommendations
• If you are planning for learners to access courses on a mobile device such as a tablet or smartphone, be sure to consider factors such as device screen size, device versions, operating system, mobile browser, LMS, etc., which will impact the learner's experience. It is highly recommended that you thoroughly test all courses using these devices to ensure compatibility and optimize the learner experience.
• Turn off/disable popup blockers
Firewall: Allow content from these websites
• https://*••

Show More