Excel - As 95 Melhores Dicas e Truques & Power BI Iniciantes

Unlock the full potential of Microsoft Excel with this comprehensive training! Learn essential tips and tricks to boost your productivity and master data management.

Excel Skills: Tips, Tricks & Advanced Formulas

This course covers a wide range of Excel techniques, from basic formatting to advanced formula applications. You'll gain practical skills to streamline your workflow and make data analysis easier.

• Formatting & Presentation:

  • Text Alignment: Master text alignment techniques for professional-looking spreadsheets.
  • Table Formatting: Learn how to create and customize tables for efficient data organization.
  • Button Customization: Personalize your Excel interface with custom buttons.
  • Text Stripping Tricks: Discover quick methods to remove unwanted text.
  • Personalized Lists: Create and manage custom lists for data validation and easy selection.

• Data Management & Import:

  • Web Data Import: Import data directly from the web to keep your spreadsheets up-to-date.
  • File Saving Strategies: Learn best practices for saving and managing your Excel files.
  • Data Validation: Ensure data accuracy with validation rules.

• Powerful Formulas & Functions:

  • INDEX & MATCH Mastery: Become proficient with the powerful INDEX and MATCH functions, including bidirectional lookup techniques.
  • SUM & INDEX/MATCH Combinations: Learn to combine SUM with INDEX and MATCH for dynamic calculations.
  • Conditional Logic: Utilize IF, AND, and OR functions to create complex conditional calculations.
  • SUMIF & Advanced SUMIF: Master SUMIF for conditional summing and explore advanced variations.
  • SUM & OFFSET: Learn to use SUM with OFFSET for flexible range calculations.
  • Combining Functions: Discover how to combine IF, SUM, OFFSET, and MIN/ABS for powerful solutions.
  • AVERAGEIF & ISNUMBER/CORRESP: Combine AVERAGEIF with ISNUMBER and CORRESP for advanced average calculations.
  • TEXT Functions: Learn to manipulate text data with functions like IF and ISTEXT.
  • SUMPRODUCT & ISTEXT: Utilize SUMPRODUCT with ISTEXT for complex calculations involving text and numbers.
  • SEERRO & PROCV/PROCV: Handle errors gracefully with SEERRO and PROCV (VLOOKUP).
  • Multiple SEERRO & PROCV: Implement nested SEERRO and PROCV for robust error handling.
  • SE + PROCV + Cell Reference: Combine IF, PROCV, and cell references for dynamic results.
  • SE + ISNA + PROCV: Use IF, ISNA, and PROCV to handle missing values.
  • Nested PROCV: Master nested PROCV for complex lookup scenarios.
  • MAX & PROCV: Find the maximum value using MAX and PROCV.
  • PROCV + SUM + %: Calculate percentages using PROCV and SUM.

• Advanced Calculations:

  • Age Calculation: Quickly calculate age from date of birth.
  • Financial Calculations: Learn to calculate loan payments with and without amortization.
  • Printing Tips & Tricks: Optimize your Excel printouts.
  • AutoCorrect: Improve efficiency with AutoCorrect settings.
  • Date & Time Functions: Work with dates and times effectively.

Course Modules:

• Aula 144:1-FUNÇÃO ÍNDICE + CORRESP - Excel 2019
• Aula 145:2-FUNÇÃO ÍNDICE + CORRESP, ESQUERDA - Excel 2019
• Aula 146:3 - FUNÇÃO INDICE + CORRESP BIDIRECIONAL Excel 2019
• Aula 147:4 - FUNÇÃO SOMA + INDICE + CORRESP Excel 2019
• Aula 148:5 - FUNÇÃO INDICE +CORRESP+MIN+ABS Excel 2019
• Aula 149:6 - FUNÇÃO SE + E - Excel 2019
• Aula 150:7 - FUNÇÃO SOMA + DESLOCAMENTO - Excel 2019
• Aula 152:9 - FUNÇÃO SE +