Creating & Designing Excel Workbooks Training

In this Microsoft Excel Workbook training course, you will learn how to create new, well-designed workbooks and gain the essential skills to summarise and analyse datasets and collect, organise, and present large amounts of data — which is pivotal in today’s highly data-driven workplace. Microsoft Excel remains the most efficient and user-friendly tool for working with data on any type of device. Learn to leverage its essential features to create and design Excel Workbooks in this 1-day hands-on course.

This product offers access to a library of Microsoft Office on-demand courses including Excel, Word, PowerPoint, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating and Designing Excel Workbooks (4610).

Creating & Designing Excel Workbooks Training Delivery Methods

• Choose from instructor-led and blended delivery methods
• After-course instructor coaching benefit

Creating & Designing Excel Workbooks Training Course Benefits

• Design workbooks to ease routine maintenance
• Improve productivity by mastering common Excel tasks
• Summarise data with simple calculations
• Explore data with tables and charts

Microsoft Excel Introduction Training Outline

Instructor-Led Training Modules

• Creating workbooks for business processes
• Summarising data with simple calculations
• Exploring data with tables and charts
• Synchronising chart/formula updates with dynamic ranges

On-Demand Training Outline

On-Demand Course List

• Access 2016 Essentials
• Excel 2016 Essentials
• Excel 2016 Essentials for Mac
• Excel 2016 Advanced
• Excel Charts and Pivot Tables
• Excel Functions
• Relational Database Design
• PowerPoint 2016
• Advanced PowerPoint 2016
• PowerPoint for Mac
• Advanced PowerPoint for Mac
• Outlook 2016
• Outlook on the Web
• Word 2016 Essentials
• Word 2016 Advanced
• Word 2016 Expert
• Word 2016 Mail Merge
• Word 2016 Essentials for Mac
• Word 2016 Advanced for Mac
• Word 2016 Expert for Mac
• Word 2016 Mail Merge for Mac
• End User Security Awareness
• Skype for Business