Microsoft Excel - Curso nivel intermedio (2/2) - AulaGEO
Master Excel with our step-by-step course! Learn essential skills for data analysis, spreadsheets, and organization. Perfect for beginners.
Course Content
Microsoft Excel - Curso nivel intermedio (2/2) - AulaGEO is an intermediate-level Udemy course taught by AulaGEO Academy. It runs 4h 14m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 9 reviews, with 13 students enrolled. It is a paid course, last updated December 2024.
Excel Intermediate: Master Data Analysis, Tables & Charts
This intermediate-level Excel course builds upon your existing skills, offering a comprehensive approach to formal Excel training. Developed by AulaGEO, this course provides practical exercises to enhance your data handling and analysis capabilities.
#AulaGEO
Unit 1: Core Excel Concepts
This unit revisits fundamental Excel concepts to prepare you for advanced techniques like formulas, functions, and data configuration.
Chapter 1: Essential Excel Fundamentals
- Understanding Excel Basics: Learn about worksheets, workbooks, and cells.
- Customizing Your Workspace: Personalize the ribbon, define and name ranges, and master navigation using mouse clicks and dialog boxes.
- Formulas & Functions: A solid foundation for building powerful calculations.
- Data Management: Explore save options, sharing methods, and protection features for cells, sheets, and workbooks.
- View Options & Paste: Customize your view, utilize various paste options, and save files as PDF.
- Keyboard Shortcuts & Help: Boost your efficiency with keyboard shortcuts and learn to effectively use Excel's built-in help resources.
Chapter 2: Advanced Data Management & Protection
- Quick Access Toolbar & Sharing: Customize your quick access toolbar and explore different sharing options.
- Data Protection: Implement cell, sheet, and workbook protection to safeguard your data.
- View Modes: Utilize different view modes for optimal data analysis.
- Save As & Paste Options: Master saving files in various formats and understand the nuances of different paste options.
- Data Entry & Custom Styles: Learn to create data entry forms and apply pre-configured and custom cell styles.
- Custom Cell Formatting: Fine-tune cell appearance for clarity and impact.
Unit 2: Data Handling & Analysis
This unit focuses on powerful tools for data input, validation, and manipulation, ensuring data accuracy and consistency.
Chapter 3: Data Input & Customization
- Data Entry Forms: Streamline data input with user-friendly forms.
- Cell Styles: Apply pre-set and custom cell styles for consistent formatting.
- Custom Cell Formatting: Tailor cell appearance to your specific needs.
Chapter 4: Data Validation
- Data Validation Tools: Implement data validation rules to ensure data integrity.
- Data Types: Utilize number, decimal, list dropdown, date, and time validation.
- Custom Error Messages: Create informative error messages to guide users.
Chapter 5: Data Manipulation & Search
- Text Columns: Manipulate and analyze text data within columns.
- Data Linking: Link data between worksheets, workbooks, and external sources (web pages).
- Hyperlinks: Insert hyperlinks to connect related data.
- Find & Replace: Efficiently search and replace text within workbooks and worksheets, including using wildcards.
Chapter 6: Data Sorting & Filtering
- Data Sorting: Organize data effectively using sorting features.
- Filtering: Quickly isolate and analyze specific data subsets.
- Removing Duplicates: Eliminate redundant data entries.
Chapter 7: Conditional Formatting
- Highlighting Rules: Apply conditional formatting rules to highlight specific cells.
- Value-Based Rules: Format cells based on values above or below certain thresholds.
- Data Bars: Visually represent data values using data bars.
Chapter 8: The "Outline" Tools
- Grouping & Outlining: Organize and structure your data with grouping and outlining features.
- Subtotals: Calculate subtotals for grouped data.
Unit 3: Working with Tables
This unit covers creating, managing, and analyzing data within Excel tables.
Chapter 9: Excel Tables: Creation & Analysis
- Table Tools: Utilize table-specific tools for data management.
- Table Styles: Apply visually appealing table styles.
- Subtotals & Data Segmentation: Calculate subtotals and segment data for focused analysis.
Chapter 10: Pivot Tables: Powerful Data Analysis
- Creating Pivot Tables: Build interactive pivot tables for data summarization.
- Pivot Table Visualization: Explore different ways to visualize your data.
- Updating Pivot Tables: Refresh pivot tables with new data.
- Data Analysis & Slicers: Perform advanced data analysis and use slicers for interactive filtering.
- Timeline & Date Filters: Analyze data based on time periods.
Unit 4: Creating Effective Charts
Learn to create, customize,
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.