Description
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