In Excel Intermediate, we will explore advanced workbook formatting including: using and customizing themes, cell styles, borders, adding images to worksheets as well as using and editing document properties. We will also cover date functions, conditional formatting, and using advanced functions for text and analysis. Learn how to trouble-shoot formulas and the value of using 3-D cell references in formulas. Introducing lookup function (VLookup and Hlookup), using Outline features and creating subtotals. Prerequisite: Excel Basic or equivalent experience.