Questions? Feedback? powered by Olark live chat software

Excel 2016 Combo Training Courses

About the Excel 2016 Combo

Duration: 3 days (24 hours)

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. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

Next Class Dates

Jul 17, 2017 – Jul 19, 2017
 
9:00am – 5:00pm EST
 
Guaranteed to run class (GTR)
 
Aug 21, 2017 – Aug 23, 2017
 
9:00am – 5:00pm EST
 
 
Sep 25, 2017 – Sep 27, 2017
 
9:00am – 5:00pm EST
 
 

Back to Top

This training consists of the following courses:

Excel 2016: Level 1   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Get started with Excel 2016 and understand key terminologies
  • » Navigate a spreadsheet
  • » Modify and format a worksheet
  • » Learn to open, save, manage, print, and close workbooks
  • » Learn about different formulae and perform calculations
  • » Sort and organize data and import data from other applications

Back to Top

arrow Course Outline

  • Getting Started with Microsoft Office Excel 2016
    1. Navigate the Excel User Interface
    2. Use Excel Commands
    3. Create and Save a Basic Workbook
    4. Enter Cell Data
    5. Use Excel Help
  • Performing Calculations
    1. Create Worksheet Formulas
    2. Insert Functions
    3. Reuse Formulas and Functions
  • Modifying a Worksheet
    1. Insert, Delete, and Adjust Cells, Columns, and Rows
    2. Search for and Replace Data
    3. Use Proofing and Research Tools
  • Formatting a Worksheet
    1. Apply Text Formats
    2. Apply Number Formats
    3. Align Cell Contents
    4. Apply Styles and Themes
    5. Apply Basic Conditional Formatting
    6. Create and Use Templates
  • Printing Workbooks
    1. Preview and Print a Workbook
    2. Set Up the Page Layout
    3. Configure Headers and Footers
  • Managing Workbooks
    1. Manage Worksheets
    2. Manage Workbook and Worksheet Views
    3. Manage Workbook Properties
  • Appendix A: Adding Borders and Colors to Worksheets
  • Appendix B: Basic Excel Customization
  • Appendix C: Microsoft Office Excel 2016 Exam 77-727
  • Appendix D: Microsoft Office Excel 2016 Expert Exam 77-728
  • Appendix E: Microsoft Excel 2016 Common Keyboard Shortcuts

Back to Top

Excel 2016: Level 2   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Work with Vlookup and Hlookup functions, lists, and named cells and ranges
  • » Analyze data, and use charts to visualize data
  • » Learn to use PivotTables and PivotCharts for data analysis
  • » Learn to create advanced formulas
  • » Learn to use validation in a spreadsheet
  • » Learn how to export Excel into different formats and how to protect worksheets and workbooks

Back to Top

arrow Course Outline

  • Working with Functions
    1. Work with Ranges
    2. Use Specialized Functions
    3. Work with Logical Functions
    4. Work with Date & Time Functions
    5. Work with Text Functions
  • Working With Lists
    1. Sort Data
    2. Filter Data
    3. Query Data with Database Functions
    4. Outline and Subtotal Data
  • Analyzing Data
    1. Create and Modify Tables
    2. Apply Intermediate Conditional Formatting
    3. Apply Advanced Conditional Formatting
  • Visualizing Data with Charts
    1. Create Charts
    2. Modify and Format Charts
    3. Use Advanced Chart Features
  • Analyzing Data with PivotTables and PivotCharts
    1. Create a PivotTable
    2. Analyze PivotTable Data
    3. Present Data with PivotCharts
    4. Filter Data by Using Timelines and Slicers
  • Appendix A: Microsoft Office Excel 2016 Exam 77-TBD
  • Appendix B: Microsoft Office Excel 2016 Expert Exams 77-TBD and 77-TBD
  • Appendix C: Financial Functions
  • Appendix D: Working with Graphical Objects
  • Appendix E: Using Array Formulas

Back to Top

Excel 2016: Level 3   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Learn to work with multiple workbooks and worksheets
  • » Learn about advanced text and cell formatting
  • » Learn to share and link workbooks and worksheets and how to protect them
  • » Learn how to add custom controls and update changes
  • » Understand automating workbook functionality
  • » Learn to forecast data and create map data and sparklines
  • » Learn to locate errors in a spreadsheet

Back to Top

arrow Course Outline

  • Working with Multiple Worksheets and Workbooks
    1. Use Links and External References
    2. Use 3-D References
    3. Consolidate Data
  • Using Lookup Functions and Formula Auditing
    1. Use Lookup Functions
    2. Trace Cells
    3. Watch and Evaluate Formulas
  • Sharing and Protecting Workbooks
    1. Collaborate on a Workbook
    2. Protect Worksheets and Workbooks
  • Automating Workbook Functionality
    1. Apply Data Validation
    2. Search for Invalid Data and Formulas with Errors
    3. Work with Macros
  • Creating Sparklines and Mapping Data
    1. Create Sparklines
    2. Map Data
  • Forecasting Data
    1. Determine Potential Outcomes Using Data Tables
    2. Determine Potential Outcomes Using Scenarios
    3. Use the Goal Seek Feature
    4. Forecasting Data Trends
  • Appendix A: Microsoft Office Excel 2016 Exam 77-727
  • Appendix B: Microsoft Office Excel 2016 Expert Exam 77-728
  • Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts
  • Appendix D: Cube Functions
  • Appendix E: Importing and Export Data
  • Appendix F: Internationalizing Workbooks
  • Appendix G: Working with Power Pivot
  • Appendix H: Advanced Customization Options
  • Appendix I: Working with Forms and Controls

Back to Top

This training prepares students for the following exam(s):

  • » 77-727: Microsoft Office Excel 2016 Exam
  • » 77-728: Microsoft Office Excel 2016 Expert Exam
  • » 77-727: Microsoft Office Excel 2016 Exam
  • » 77-728: Microsoft Office Excel 2016 Expert Exam
  • » 77-727: Microsoft Office Excel 2016 Exam
  • » 77-728: Microsoft Office Excel 2016 Expert Exam

Back to Top

Recent Client Testimonials & Reviews

Instructor is great! She is concise and an excellent presenter. I learned so much. I love how the instructor broke every thing down and did not rush through any topic.

- Danielle C.

Course(s) Taken

» Excel 2016 Combo

The online classroom worked very well and thoroughly enjoyed what the instructor taught.

Laura C.

Course(s) Taken

» Excel 2013 Combo

The insructor is knowledgeable, helpful & patient.

- Yarelis Q.

Course(s) Taken

» Excel 2016 Combo

  More testimonials »  

Back to Top

Ways to contact us

Back to Top