This Microsoft Excel Formulas and Presenting Data Half Day course is suitable for users of Microsoft Excel 2016 or 365 subscription editions. If you're attending at a QA location, the course will be delivered on Microsoft Excel 2016.
You will use more advanced formulas and work with various tools to present data such as Charts and Conditional Formatting.
Hedefler:
Calculate with advanced formulas
Create and modify Charts
Apply Conditional Formatting
Topics:
Calculating with Advanced Formulas
Overview of Relative and Absolute References
IF Functions
CountIF
SumIF
VLOOKUP
Charts
Creating and modifying charts
Working with Sparklines
Conditional Formatting
Applying standard rules
Creating and editing rules