This lesson will teach you how to use conditional formatting. You will learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. This lesson will introduce you to custom controls-graphical objects that help facilitate data input and are sure to impress users. You will practice using whole number, decimal, date, time, list, and other forms of validation.

In this lesson, you will tackle data validation techniques-your first line of defense against incorrect or missing data and the logical next step after data forms. You will be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel. This lesson explores Excel's table management features, using data forms with Excel databases, and alternative database techniques. You will use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar. To kick things off, your first lesson explores different ways you can modify Excel to streamline processes and make your work easier.

Microsoft excel 2019 tutorial