روز: بهمن ۲۹, ۱۳۹۹

How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability. Learn to create custom conditional formatting rules based on formulas. Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells. Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data). Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column. Immerse yourself in practical exercises, reinforcing your understanding of…