Excel 301 - Worksheet Functionality Part 2
Product Description
8-page bi-fold.
This quick reference guide is one of two guides dedicated to Worksheet Functionality. In Part 2, we will explore how to apply data validation techniques to capture data accurately without waiting to validate the data at a later time. In addition you will learn how to setup warning messages in data validation, how to use drop-down lists to minimize errors and how to identify incorrect data elements. Other topics include: an extensive description of conditional formatting in Excel and the numerous methods you can use such as color coding, data bars, arrows, traffic-signal symbols and how to create your own conditional formatting settings. The second half of this guide is dedicated to What-If analysis tool such as sing the Goal Seek, Scenarios, Solver and Data Tables (one-variable and two variable data tables).
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.
This quick reference guide is one of two guides dedicated to Worksheet Functionality. In Part 2, we will explore how to apply data validation techniques to capture data accurately without waiting to validate the data at a later time. In addition you will learn how to setup warning messages in data validation, how to use drop-down lists to minimize errors and how to identify incorrect data elements. Other topics include: an extensive description of conditional formatting in Excel and the numerous methods you can use such as color coding, data bars, arrows, traffic-signal symbols and how to create your own conditional formatting settings. The second half of this guide is dedicated to What-If analysis tool such as sing the Goal Seek, Scenarios, Solver and Data Tables (one-variable and two variable data tables).
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.