You are here

Excel 2016 Intermediate

Excel 2016 Intermediate


Corporate Training Group
120 S Wood Ave
4th Fl, Ste 405
Iselin, NJ 08830
Register for Course
Tuesday, April 23, 2019 - 5:00am


This course builds upon the foundational knowledge presented in the Excel Fundamentals course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. Upon successful completion of this course, you will be able to: Leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. Course Description: Module 1: Organizing Workbooks Overview Of Workbooks And Worksheets Working With Sheets In Groups Module 2: Linking & Consolidating Data Working With Hyperlinks Working With Formulas That Link Worksheets And Files Consolidating Data From Various Worksheets Module 3: Enhancing Workbook Navigation Adjusting Window Layout Organizing Data In An Outline Module 4: Working With Lists of Data Overview Of Excel Lists Rules For Designing A List Flash Fill Remove Duplicate Values Module 5: Sorting and Subtotaling Sorting a Worksheet List Sorting By Columns Creating Custom Sort Orders Producing Subtotals On A Sorted List Module 6: Creating Tables, Using Filters and Criteria Automating Your List For Day-To-Day Activity Setting A Custom Autofilter Working With Criteria Ranges Module 7: Working With Charts Creating A Chart Excels Assumptions About Your Data Modifying The Chart Enhancing The Chart Changing Series Orientation From Rows To Columns Working With Data Tables Updating A Charts Data Series Changing The Data Series Order Working With Series-Related Options User-Defined Custom Types Printing Charts Creating Sparklines Deleting Sparklines

Register for Course

Additional Sessions