Excel: Crea Tablas, Filtros, Fórmulas, Funciones y Gráficos

Learn essential Excel skills with our Basic Excel course for everyone! This comprehensive course will empower you to confidently navigate and utilize Microsoft Excel for work, school, and everyday tasks. You'll master fundamental techniques to organize data, perform calculations, and create insightful visualizations.

Here's what you'll discover:

• Module 01: Excel Fundamentals

  • Getting Started: How to Open Excel and understand the Excel interface.
  • Understanding the Excel Workbook: Learn about cells and ranges in Excel.
  • Efficient Data Entry: Utilize the Fill Handle in Excel for quick data population.
  • Mastering Mouse Navigation: Understand cursors and pointers in Excel.
  • Excel Cell References: Explore Relative, Absolute, and Mixed References for powerful formula creation.

• Module 02: Working with Tables in Excel

  • Excel Table Formatting: Apply predefined styles to enhance data presentation.
  • Conditional Formatting: Learn to apply new rules for highlighting important data in Excel.

• Module 03: Excel Formulas

  • Introduction to Excel Formulas: A beginner-friendly overview of creating formulas.
  • Basic Operators & Formulas: Learn fundamental operators and build simple formulas in Excel.
  • Operator Precedence: Understand how order of operations affects your Excel formulas.

• Module 04: Excel Filtering

  • Data Filtering in Excel: Quickly isolate specific data using built-in filters.
  • Sorting Data in Excel: Arrange your data in ascending or descending order.
  • Advanced Filtering Techniques: Explore various filter types to refine your data analysis in Excel.

• Module 05: Excel Functions

  • Understanding Excel Functions: Learn the structure and syntax of Excel functions.
  • AutoSum: Quickly calculate sums with the handy AutoSum feature in Excel.
  • The OR Function: Utilize the OR function in Excel for logical calculations.

• Module 06: Excel Charts & Graphs

  • Chart Elements in Excel: Understand the components of effective charts.
  • Types of Charts in Excel: Choose the right chart type for your data visualization needs.
  • Creating Charts in Excel: Step-by-step instructions for building compelling charts.

By watching all the videos in this course, you'll gain a solid foundation in basic Excel – the essential skills everyone needs to succeed in work or study. Start building your Excel proficiency today!