Curso Completo de Excel para MAC OS

Master Excel: From Beginner to Expert – Unlock Powerful Data Analysis

This comprehensive course will transform you from an Excel novice to a confident user, equipping you with the skills to handle data like a pro. We'll start with the fundamentals and progress to advanced techniques, all within a few hours.

Getting Started & Data Management

• Excel Basics: A complete introduction to the Excel interface and core functionalities.
• Data Entry & Saving: Learn efficient methods for inputting and saving your data.
• Creating Data Series: Generate data sequences for analysis and visualization.
• Column Management: Insert, delete, and fill data efficiently.
• Formulas: Your First Steps: Master basic formulas to perform calculations.
• Automated Formulas & Error Handling: Create dynamic formulas and troubleshoot common errors.
• Working with Sheets: Add, delete, and format worksheets for organized data management.
• Data Transfer Between Sheets: Easily move data between different worksheets.
• Cell Manipulation: Add, delete, and format cells, rows, and columns.
• Undo & Redo: Utilize the "undo" and "redo" commands for error correction.
• Resizing & Panel Management: Adjust row and column sizes and manage Excel panels for optimal viewing.
• Cell Alignment: Control the alignment of text and numbers within cells.
• Text Conversion: Convert text within cells into columns for easier analysis.

Formulas & Functions: The Powerhouse of Excel

• Basic Math Formulas: Perform simple mathematical operations using Excel formulas.
• Formulas vs. Functions: Understand the difference and when to use each.
• The "Concatenate" Function: Combine text strings for comprehensive data labeling.
• Excel Menu Structure: Navigate and utilize the Excel menus for efficient workflow.
• Printing Worksheets: Configure print settings and define print areas.
• Merging & Centering Cells: Create visually appealing reports with merged and centered cells.
• Data Sorting & Filtering: Organize and analyze data using sorting and filtering tools.
• Converting Data to Ranges: Transform data into usable ranges for formulas and charts.
• Tables vs. Ranges: Understand the differences and when to use each for data management.
• Creating Charts: Generate professional-looking charts from your data.
• Essential Functions: AVERAGE & IF: Utilize core functions for data analysis.
• Conditional Formatting: Apply formatting based on data criteria (create, modify, delete).
• Chart Copying & Duplication: Easily replicate and customize charts.
• Data Range Filtering: Filter data based on specific criteria.
• VLOOKUP Function: Retrieve data from a table based on a lookup value.
• Relative & Absolute References: Understand and utilize cell references for formula flexibility.
• MAX & MIN Functions: Find the maximum and minimum values in a range.
• K.ESIMO.MAYOR & K.ESIMO.MENOR Functions: Identify the k-th largest or smallest value.
• Time Manipulation: Perform calculations with dates and times.

Advanced Excel Techniques for Professionals

• Automated Invoice Creation: Design and create invoices with automatic calculations.
• PDF Printing Margins: Define print margins for PDF documents.
• Dynamic Calendars: Create color-coded calendars based on activity types.
• Print Preview & Margin Adjustment: Quickly adjust print margins in print preview mode.
• Conditional Formatting Refinement: Modify and remove conditional formatting across multiple sheets.
• Pivot Tables: Summarize and analyze large datasets with pivot tables.
• Percentage Calculations: Calculate percentages relative to totals.
• Transposing Data: Switch between rows and columns.
• Table Concatenation: Combine data from multiple tables.
• Custom Views: Create personalized views of your workbook.
• Dropdown Lists: Implement dropdown lists for data entry consistency.
• Nested Functions: Combine multiple functions for complex calculations (VLOOKUP + MATCH).
• Linking to External Files: Connect Excel to external data sources.
• Password Protection: Secure your Excel files with passwords.
• Locking Cells & Hiding Formulas: Protect sensitive data and formulas.
• Professional Data Presentation: Apply professional formatting to data ranges.
• Report Design: Create visually appealing and informative reports.
• Dynamic Data Segmentation: Segment data using multiple pivot tables.
• **Slicers &