What you’ll learn Make games with Python. Create basic line and scatter plots with Matplotlib 1.5. Customise our graphs with visuals, a title, labels, text and a legend. Recognize types of visualization: histograms, pie charts, and box and whisker plots. “Basic & Advanced Excel Tools Overview of Excel Cell Referencing Excel Formatting and Shortcuts Paste Special Data Sort Data Filter Advanced Data Filters Conditional Formatting Go To Special Printing and Protection “Basic & Advanced Formula Basic Formulas Logical Formulas “ IF Logical Formulas “ IF AND OR Logical Formulas “ Nested IF Statistical Formulas Date & Text Formulas Financial Formulas Lookup Formulas Dynamic Lookups Advanced Conditional Formatting “Visualization Charts & Pivot Tables Charts Advanced Charts Pivot Tables “Business Simulations & Management Dashboards What If Analysis – Goal Seek & Data Tables Scenario Manager Solver (Excel Add-in) Management Dashboards “Automation “ Macros & VBA Macros “ Basics & Recording VBA Coding – Basics VBA Coding – Advanced VBA User Defined Function VBA: Creating a User Interface “ADVANCED EXCEL TEST