Microsoft Excel: Formulas & Functions with Charts & Graphs

What you’ll learn

• Overview of Excel Formulas and Functions
• Working with LogicalFunctions
• Nesting Functions for Complex Calculations
• Date and Time Functions
• Using VLOOKUP Functions
• Using HLOOKUP Functions
• Understanding Absolute and Relative Cell References
• Building Formulas for Dynamic Data Analysis
• Overview of Excel Chart Types
• Inserting and Customizing Charts
• Formatting Chart Elements
• Linking Excel Formulas with Chart Data
• Analyzing Sales Data with Formulas and Charts
• Data Visualization Techniques for Presentations and Reports