This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
 

Excel Advanced

  • Overview
  • Outline
  • Virtual Classroom
  • On Demand

About This Course

This advanced course aims to extend your capabilities with Excel and provide you with advanced knowledge of Excel. Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.

Audience Profile

This course is intended for advanced students who are familiar with Microsoft Excel 2016 and more experienced Excel users who want to learn the advanced topics covered in this course.

At Course Completion


• Using Pivot Tables
• Auditing Worksheets
• Data Tools
• Working with Others
• Recording and Using Macros
• Random Useful Items
• Microsoft Excel Features that Were New in 2016
• Features New in 2016

 

Module 1: Using Pivot Tables
This module explains how to how to use Pivot Tables.
Lessons

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • More Pivot Table Functionality

Lab 1: Using Pivot Tables

  • Working with Pivot Tables

After completing this module, students will be able to:

  • Use pivot tables to analyze data.
  • Edit pivot tables.
  • Format pivot tables.
  • Insert pivot charts.
  • Use Slicers.

Module 2: Auditing Worksheets
This module explains how to audit worksheets.
Lessons

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Lab 1: Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents

After completing this module, students will be able to:

  • Audit formulas.
  • Trace precedents to determine which cells impact a specific cell.
  • Trace dependents to determine which cells are impacted by a specific cell.
  • Remove precedent and dependent arrows.
  • Show formulas
  • Check for errors frequently found in formulas.

Module 3: Data Tools
This module explains how to work how to work with data tools.
Lessons

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Lab 1: Data Tools

  • Converting Text to Columns
  • Using Data Validation
  • Consolidating Data
  • Using Goal Seek

After completing this module, students will be able to:

  • Convert text to columns.
  • Use Data Validation to restrict the type of data that can be entered into a cell.
  • Consolidate data from a number of different ranges into one new range.
  • Use Goal Seek to figure out the value to input to obtain a specific result..

Module 4: Working with Others
This module explains how to do various tasks associated with working with others in Excel.
Lessons

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Lab 1: Working with Others

  • Password Protecting a Workbook
  • Password Protecting a Worksheet
  • Password Protecting Ranges in a Worksheet
  • Tracking Changes

After completing this module, students will be able to:

  • Password protect a workbook.
  • Password protect a worksheet.
  • Password protect ranges in a worksheet.
  • Use track changes.
  • Accept and reject changes.
  • List all changes on a new sheet.

Module 5: Recording and Using Macros
This module explains how to record and use macros.
Lessons

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Lab 1: Recording and Using Macros

  • Recording a Macro
  • Adding a Macro to the Quick Access Toolbar.

After completing this module, students will be able to:

  • Run macros.
  • Edit macros.
  • Add macros to the Quick Access Toolbar.

Module 6: Random Useful Items
This module explains how to do some random useful tasks in Excel.
Lessons

  • Sparklines
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files

Lab 1: Random Useful Items

  • Inserting and Customizing Sparklines
  • Importing Text Files
  • Copying Data from Excel to Word
  • Copying Charts from Excel to Word

After completing this module, students will be able to:

  • Insert sparklines into worksheets.
  • Customize Sparklines.
  • Prepare a workbook for internationalization and accessibility.
  • Import text files into Microsoft Excel.
  • Copy cells from a worksheet into Microsoft Word.
  • Copy and paste a chart into Microsoft Word.

Module 7: Microsoft Excel Features that Were New in 2013
This module explains how to use some new features that were new in 2013.
Lessons

  • Using Slicers to Filter Data
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Lab 1: Microsoft Excel Features that Were New in 2013

  • Filtering Data with Slicers
  • Creating a Timeline

After completing this module, students will be able to:

  • Use slicers to filter data..
  • Create a PivotTable timeline.
  • Create a standalone PivotChart.

Module 8: Features New in 2016
This module explains how to how to some new features new in 2016.
Lessons

  • PivotTable Updates.
  • Ink Equations
  • Multi-Select Option in Slicers
  • Quick Shape Formatting
  • Sharing with SharePoint or OneDrive

After completing this module, students will be able to:

  • Understand the enhancements to PivotTables.
  • Use the Ink Equation feature.
  • Use the Multi-Select option in slicers.
  • Use the Quick Shape formatting.
  • Share workbooks.

 

 
Read More

Training made easy...In the Cloud

  

Attending a Virtual Classroom training session has never been easier than it is today. Using the latest in web conferencing and voice over IP (VOIP) technologies we have worked hard to provide the best in class for Virtual Classroom course delivery.

What is required:

  • A high speed Internet connection.
    Note: Sometimes in office environments firewalls used for internet security prevent those connections from being made.
  • Computer, a tablet or both.
    • Option 1: One computer with two monitors.
      This allows you to view the instructor on one machine and work with your system on the other screen.
    • Option 2: Two computers.
      This is ideal for a workstation and laptop setup which will be used for viewing on one machine and working with your system on the other computer.
    • Option 3: One computer and tablet/iPad.
      This is a great option if you have a tablet or iPad. You can connect to the instructor’s presentation via the iPad/tablet device and use your computer for working your environment. You can even use the audio from the iPad/tablet for participating in the session.
    • Option 4: One computer.
      This option is for the student that is comfortable with toggling back and forth during the lecture/presentation/demo and your environment.
  • A speaker phone or hands-free headset for your telephone/device.
    Because you’ll be using the keyboard and mouse throughout the class, you will need a speakerphone or headset by your computer.
  • VOIP or Unlimited long-distance phone service.
    You can use the GotoMeeting microphone and speaker option, or using Skype is a good option. You can also call in using your Unlimited long-distance calling plan (if you have one).

Software:

The set up is easy, but you will often need your own software. 
You will need your own software and setup before attending the training session. Each course is different, so we encourage you to work with a COD representative to determine your needs before attending. Contact us if you need a virtual training lab.

Virtual Classroom Meeting Software (GotoMeeting)
You will need to test your device and install the GotoMeeting software before attending.

Test Your Connection.

 

Install GotoMeeting™ on the computer or device you're using to join the training session.


System Requirements.
Make sure the computer you are connecting to meets the minimum requirements:

For PC-based participants:

  • Internet Explorer 7.0, Mozilla Firefox 4.0, Google Chrome 5.0 (JavaScript enabled) or the latest version of each web browser
  • Windows 8, 7, Vista, XP or 2003 Server
  • Cable modem, DSL, or better Internet connection
  • Dual-core 2.4GHz CPU or faster with 2GB of RAM (recommended)

For Mac-based participants:

  • Safari 3.0, Firefox 4.0, Google Chrome 5.0 (JavaScript enabled) or the latest version of each web browser
  • Mac OS X 10.6–Snow Leopard or newer
  • Intel processor (1GB of RAM or better recommended)
  • Cable modem, DSL, or better Internet connection

Participants wishing to connect to audio using VoIP will need a fast Internet connection, a microphone and speakers. (A USB headset is recommended.)

Connect 10 minutes before the class.
A few days before the class we will send an email with instructions on how to access your meeting connection and phone bridge. Be sure to allow yourself about 20 minutes of set up time just before the start of the training session.

  

 

   
 
 

On your schedule...In the Cloud

Our On Demand learning portal allows you to learn at your own pace, on your schedule and with the support from our instructors. With our On Demand subscriptions students get access to our learning portal which provides some of the best tools and content for learning including:

Filtered Learning

Filtered Learning uses personalization to filter out content that is only relevant to your speicfic requirements. This helps to alleviate undesired or unncessary topics. We put your existing investment in learning to work again and we match the content with your current skill level.

With just a few clicks a list of recommendations are compiled for you.

 

Activity Tracking

Activity tracking and analysis helps you to adapt your learning in the most effective way. This level of reporting gives you and your team deeper insight into what you know and what you need to work on.

 
 

Training Material, Labs & Exercises

Students can continue to improve their knowledge with labs and exercises and we provide the latest and most concise training material available today. We only work with the most comprehensive content delivered either in print or PDF along with labs and exercise files so that you can work through the material at your own pace on your schedule.
 
 

Instructor Supported

Our courses are also monitored by our expert instructors available to answer questions any time. That's why we're here!

Need Onsite, Group or Tailored Training?

Let's get started



 

FAQ's

  • What is Virtual Classroom?
    • Virtual Classroom is Instructor-led training delivered to dispersed students on specific dates and times. Students attend using a computer and Internet connection. Learn More.
  • What is On Demand?
    • On Demand allows students to learn at their own pace on their own time with the support from our instructors. Learn More.
  • Do you provide training for groups?
    • Group training is an option across all of the titles we teach.
  • Can it also be done at our location?
    • Yes, we have trainers available for onsite as well.
  • What if our team is dispursed across the country or globe?
    • Satellite classrooms can be set up across our 3,000+ worldwide locations. Learn More
  • What if we don't need to be trained on all of the content in the standard outlines?
    • All of our titles can be tailored to accomodate your organizational learning objectives.
  • Can the students be tested and monitored as part of the training objectives?
    • Yes, we have a Learning Mangement System (LMS) as part of our suite of learning management solutions. Learn More.
  • Check all of our FAQ's

Office