Udemyintermediatees

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.

Related:Excel Tables
4.5(9)
13students
4h 14m
Certificate
AulaGEO Academy
AulaGEO AcademySpecialists in GIS - BIM - LAND and Smart process training

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,

$ whoami — the devs behind tutorialsearch.io

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.

5.0(20)
2h 21m
intermediate
5.0(27)
2h 15m
all
5.0(21)
3h 21m
all

Curso sobre el tratamiento de bulimia

by AEPSIS Asociación Española de Psicología Sanitaria

5.0(12)
2h 18m
all

Curso sobre acoso escolar, bullying

by AEPSIS Asociación Española de Psicología Sanitaria

5.0(7)
1h 39m
all
5.0(23)
7h 26m
all