CEC - Curso Excel Corporativo (Básico ao Avançado)

Unlock Your Excel Potential: Master Data Analysis & Automation

Ready to elevate your Excel skills and impress at work? This comprehensive course is designed for those with basic Excel knowledge who want to achieve proficiency, automate tasks, and even boost their career prospects!

Here's what you'll learn:

• Excel Fundamentals & Essential Features:

  • Effortlessly merge and center cells.
  • Utilize automatic text wrapping for better formatting.
  • Apply formatting styles with the Paint Format tool.
  • Leverage conditional formatting to highlight important data.
  • Add border information for clear data presentation.
  • Create and manage tables for organized data.
  • Implement data validation to ensure data accuracy.
  • Use the Name Box for easy cell referencing.
  • Secure your spreadsheets by partially or fully locking worksheets.
  • Remove duplicate entries for cleaner data.
  • Quickly find data with fast search functionality.

• Logical Formulas:

  • Master logical formulas in Excel.
  • Understand and apply the "IF" formula for conditional calculations.
  • Utilize the "AND" formula for combined conditions.
  • Employ the "OR" formula for alternative conditions.
  • See practical examples of these formulas in action.

• Sum & Average Conditional Calculations:

  • Learn to perform sums and averages with criteria using Excel formulas.
  • Utilize the "SUMIF" formula for conditional summing.
  • Employ the "SUMIFS" formula for multiple criteria.
  • Use the "AVERAGEIF" formula for conditional averages.
  • Discover practical applications of these formulas.

• Count Conditional Calculations:

  • Master counting numbers and text with criteria in Excel.
  • Utilize the "COUNTIF" formula for conditional counting.
  • Employ the "COUNTIFS" formula for multiple criteria.
  • Use the "COUNTNUM" formula to count numbers.
  • Use the "COUNTVALORES" formula to count non-blank cells.
  • Explore practical examples of these formulas.

• Data Lookup Functions:

  • Introduction to data lookup functions for retrieving specific information from spreadsheets.
  • Understand the "OFFSET" formula for dynamic ranges.
  • Master the "MATCH" formula for finding data positions.
  • Combine "OFFSET" and "MATCH" for advanced data retrieval.
  • Utilize the "VLOOKUP" formula for vertical lookups.
  • Employ the "HLOOKUP" formula for horizontal lookups.
  • Understand the power of "INDEX" and "MATCH" for flexible data retrieval.
  • See practical examples of these functions in action.

• Pivot Tables:

  • Introduction to pivot tables and their importance for business analysis.
  • Learn basic shortcuts for data manipulation.
  • Create pivot tables efficiently.
  • Understand the logic behind pivot table calculations.
  • Master filtering data by fields, columns, rows, and values.
  • Build practical reports with pivot tables.
  • Format pivot tables for professional presentation.
  • Manage the "Value Field Settings".
  • Insert slicers and timelines for interactive data exploration.

Don't miss out on this incredible opportunity! Enroll now and take your Excel skills to the next level. You won't regret it!