In Dietary Guide to Excel Applications Volumes 1 and 2, learn how to Master Excel and the art of worksheet applications development. Without any previous knowledge, you will learn how to build elegant interfaces by creating seven different worksheet applications: Chapter 1, "Excel Survival Kit: Understanding Worksheets," learn how to deal with data inside cells, how Excel uses formatting to change the way we see it data and how to deal with it interface and security. You will also learn about Excel IF( ) function, Conditional Formatting and Custom Formats to create a professional look interface. This chapter also teaches how to set and break Excel security ; Chapter 2, "Formula References: the key to Excel productivity " deals with formula references - the way you use Excel power to create just one formula cell that can be easily propagated to many other cells. You will also learn about Conditional Formatting to build a beautiful nutritional chart to take control of any person's BMI - Body Mass Index; Chapter 3, "Your first Excel Application: The BMI Companion Chart " you will use Excel to produce a simple worksheet application that can control any person's weight along time. In this chapter you will also learn a lot about user interface, Excel charts, printing features and how to take the most from Excel Templates; Chapter 4, "Using names, data validation lists and lookup functions" you will learn one of the most basic and powerful Excel features: range names Using range names you will discover how to use Excel Data Validation to create personalized data entry forms. You will also be introduced to Excel lookup functions and cascading data validation lists; Chapter 5, "Personal DRI - Dietary Recommended Intakes" is where you will build another dietary worksheet application to search a large table and return personalized and formatted nutrient data. You will also learn how to use a multi-sheet worksheet application to create a single, elegant and very powerful nutritional solution; Chapter 6, "Personal EER - Estimated Energy Requirements and Dependent Worksheets" expand the concept of the Chapter 5 to create another nutritional application adopting the concept of "dependent worksheets" Excel Templates that needs a basic framework to work properly.
Chapter 7, "The Label Maker" is a beautiful and useful worksheet application capable to generate a complete Nutrition Facts food label using many concepts and techniques learned on previous chapters. You will also learn a lot about barcodes and barcode fonts, how to validate a UPC-A barcode digit and produce any barcode symbology inside Excel; Chapter 8, "The Food Composer" you will learn how to join the functionality of the Nutrition Facts food label developed on Chapter 7 to build another worksheet application to collect nutrient data from food labels and use it to create composed foods and automatically generates it nutrient facts food label. You will also have your first contact with Excel macros Chapter 9, "Using USDA Food Tables" you will learn how to obtain USDA-ARS nutritional tabels, and how to use a simple Microsoft Access application to generate the most precise Excel worksheets of nutrient data for free. You will also learn about Excel filtering, subtotals and classifications tools to deal with large amounts of data; Chapter 10, "The USDA Food Composer" is a worksheet application that uses the concepts and interface you had built on Chapter 8 to create a precise interface where you can mix up to 18 different USDA Food items in different amounts, to generate the most precise nutritional profile using up to 178 nutrients for any recipe you want to eat, cook or sell Chapter 11, "The Dietary Planner" you will build a huge and simple worksheet application that is capable to define any person's dietary and energy needs, compose an entire weekly menu using up to 4 meals a day, and analyze any weekday menu with the precision used by USDA Food Composer worksheet applicatio.