Microsoft Excel 2019 & 365: Level 2 covers key intermediate Excel skills. Among others, topics in Level 2 include themes, cell styles, and number formats, as well as functions for dates, numbers, and text. Textbook included. Pre-requisites: Basic computer skills. Course Objectives By the end of this course, you will be able to: Apply and customize themes Create and use cell styles Apply cell borders and fill Create custom number formats Customize the page setup Edit document properties Identify date serial numbers Apply custom date formatting Enter times Create functions using dates Perform date and time calculations Create customized conditional formatting rules Edit rules using the Conditional Formatting Rules Manager Create financial functions Create one-variable and two-variable data tables Use the What-If Analysis tools to create scenarios Adjust input values using Goal Seek Use functions to format text Create conditional functions using IF and IFS criteria Create formulas using nested functions Find and correct errors in formulas Use 3-D cell references in formulas Create formulas using lookup functions Use the Outline feature Create subtotals Use the Quick Analysis tool Much, much more!