Curso Inicial de Excel

Master the Fundamentals of Excel: A Beginner's Guide

This comprehensive course provides all the essential basics to confidently start using Microsoft Excel. Featuring 5 video lessons with Spanish and English subtitles, you'll gain a solid foundation in this powerful spreadsheet program.

Here's what you'll learn:

• File Management:
  • Saving: Learn how to save your work in various locations and formats, including preserving or changing the file type (e.g., PDF, macro-enabled files).
  • Opening: Easily open existing Excel workbooks.
  • New Workbook: Quickly create a fresh, blank spreadsheet.
• Formatting & Presentation:
  • Text Adjustment: Automatically adjust row width to fit your text.
  • Merging & Centering: Combine multiple cells and center the text within the combined cell.
  • Cell Formatting: Control cell height, width, and data type.
  • Colors, Fonts & Backgrounds: Enhance your spreadsheets with customizable colors, fonts, and background styles.
  • Lines & Borders: Add lines and borders to clearly delineate data.
• Data Manipulation:
  • Inserting, Deleting & Modifying Cells: Master cell manipulation techniques.
  • Autosum: Instantly calculate the sum of selected cells.
  • Sorting: Organize your data using various sorting methods.
  • Print Area: Define and manage print areas for professional output.
  • Organizing Data: Learn to arrange overlapping data or images, bringing elements to the front or sending them to the back for optimal visibility.
• Data Analysis & Formulas:
  • Conditional Formatting: Dynamically highlight cells based on specific criteria.
  • Basic Formulas: Understand and use essential formulas like SUM, AVERAGE, MAX, and MIN.
  • Conditional Formulas: Explore and utilize conditional formulas for advanced data analysis.
• Data Protection & Enhanced Functionality:
  • Protecting Cells: Secure your work with password protection for entire sheets or individual cells.
  • Freeze Panes: Keep important titles (like row or column headers) visible while scrolling through large datasets.
  • Dollar Sign ($): Understand absolute and relative cell references and when to use the dollar sign for precise control.

Course Objective:

The primary goal of this course is to equip you with a strong understanding of Excel fundamentals. You'll be able to confidently work with the program and build a solid foundation for exploring more advanced features. Think of this course as obtaining your driver's license – you'll have the skills to confidently navigate the world of Excel and explore further on your own!