ماه: بهمن ۱۳۹۹

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…

On the left side of the screen, you’ll complete the task in your workspace. On the right side of the screen, you’ll watch an instructor walk you through the project, step-by-step. Learn how to create an effective column chart by reducing ink and ‘noise’ that distract from the main messages. Learn to sort data in Excel by a single column or by multiple columns. Join our community of 40 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics – all for free. Learn to use…