Author Description

This Step-By-Step Workbook will guide you through learning the advanced Excel concepts including Protection, Data Validation, Conditional Format, Import/Export, PivotTable, and PowerPivot. It can be used by a beginner to understand core concepts, and an advanced student to learn the "in''s and out''s" of Excel. Included are over 170 Practice Exercises that demonstrate how to use Excel concepts. They can also be used as a reference guide to quickly look up specific topics. What''s is in the workbook? Click on the left side of the screen: Look Inside! Enter one of the following keywords: Variables, Range, Input Boxes, VB Editor, etc. Take A Class: http://www.elearnlogic.com/download/schedule18.pdf Advanced Features - Protection, Validation, And Conditional Formatting In this group of chapters, students will learn the advanced "in''s and out''s" of Excel. The following topics will be covered: How to protect cells. How to open a file with protection. How to share a workbook on a server folder. How to track changes. How to format cells based on specific conditions. Data Validation Data Validation Dropdown Lists Macros and how they allow for the automation of routine tasks. Formula Troubleshooting Techniques. How to trace a cell. (Error Checking, Circular Reference, and Evaluating Formulas). How to watch formulas across worksheets and workbooks. What-If Analysis Scenarios Goal-Seek Solver Comma Delimited File Export and Import How to consolidate Worksheets. Advanced PivotTables PivotTables will cover Filtering, Formatting, PivotCharts, Label Adjustments, and Calculation Capability. PivotTables are very similar in all versions; however, new features that have been added to Excel 2013 and