Excel Course: Organize Data with Intermediate Skills

Ready to move beyond Excel basics? This course helps you organize data better with charts, advanced formulas, conditional formatting, and collaboration tools.

Learn to:

Create eye-catching charts
Use absolute & relative references
Apply conditional formatting
Collaborate with other users

Features:

Learn by doing simulations
Skill assessments
Certificate

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje

Excel Intermediate Curso Describir

Aprendizaje verificado

Habilidad	Pre-evaluación	Lección	Post-evaluación
Charts
Create Charts How to Create Charts in Excel tutorial	No empezado	No empezado	No empezado
Move and Resize Quickly resize and move charts in Excel	No empezado	No empezado	No empezado
Chart Types Choose the right chart type for clear insights	No empezado	No empezado	No empezado
Layout and Style Adjust chart layout and style in Excel	No empezado	No empezado	No empezado
Titles and Legends Customize chart titles and legend text	No empezado	No empezado	No empezado
Gridlines, Labels, and Data Tables Make charts clearer with labels and data tables	No empezado	No empezado	No empezado
Chart Elements Fine-tune chart layout, labels and data clarity	No empezado	No empezado	No empezado
Modify Chart Data Learn how to change chart data range in Excel	No empezado	No empezado	No empezado
Filter Charts Quickly refine chart data with filters	No empezado	No empezado	No empezado
Trendlines Add a trendline to highlight data trends clearly	No empezado	No empezado	No empezado
Dual-Axis Charts Add a secondary axis in Excel for clearer charts	No empezado	No empezado	No empezado
Chart Templates Save time by reusing custom chart layouts	No empezado	No empezado	No empezado
Sparklines Embed mini-charts in cells to show data trends	No empezado	No empezado	No empezado

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Print and Distribute			Cuenta requerida
Page Size and Scale Adjust size and scaling for one-page printing
Print Area and Page Breaks Select and lock the exact cells you want to print
Print Titles, Gridlines, and Headings Enable headings & gridlines for cleaner printouts
Headers and Footers Add a header and footer in Excel quickly
Margins and Orientation Adjust margins and orientation in Excel
Inspect for Issues Check for problems with Excel’s inspect tool

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Intermediate Formulas			Cuenta requerida
Reference External Worksheets Reference other sheets in formulas
Absolute and Relative References Lock cells with absolute references in Excel
Order of Operations Know calculation order so formulas behave right
Cell and Range Names Name cells and ranges for smarter formulas
Insert Functions Use the insert function tool in Excel
CONCAT Function Merge text from multiple cells into one formula
PMT and NPER Functions Compute loan payment amounts quickly
Display Formulas Learn how to show formulas in Excel
Date Formulas Calculate time fast with Excel date functions

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Manage Data			Cuenta requerida
Quick Analysis Apply fast visuals and summaries to your data
Outline and Subtotal Create data groups with built-in subtotals
Data Validation Keep entries accurate with data validation
Flash Fill Let flash fill Excel auto-complete data
Import and Export Data Import and export data in Excel easily

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Tables			Cuenta requerida
Insert a Table Create a table in Excel for cleaner data
Sort Data Sort your data alphabetically or by value
Filter Data Use Excel filter to focus on key data
Add Rows and Columns Add a Total Row to Excel tables
Table Styles Apply a table format for structured, stylish data
Remove Duplicates Clean up sheets by removing duplicate rows
Slicers Filter tables instantly with clickable buttons
Structured References Refer to table columns directly in formulas

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Intermediate Formatting			Cuenta requerida
Apply Conditional Formatting Conditional Formatting Excel rules
Apply and Remove Cell Styles Cell Styles Excel formatting tips
Create and Modify Cell Styles Create or update styles for consistent formatting
Find and Replace Formatting Find and replace formatting in Excel fast
Apply a Theme How to Change Theme Colors in Excel

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Collaboration			Cuenta requerida
Cell Comments Leave notes on cells for clearer context
Share Workbooks Invite others to collaborate on the same workbook
Co-author Workbooks Work together in real-time on the same workbook
Version History Revert to a previous file version in seconds
Protect a Worksheet Lock specific cells so data stays unchanged
Protect Workbook Structure Lock workbooks to prevent edits
Password Protection Secure files by setting a password

Descargas para estudiantes

Cheat Sheet

Concise, easy-to-use guide for quick learning and reference.

Student Guide

Step-by-step illustrated reference guide.

Practice Files

Practice files for hands-on exercises.

Descargas de instructor

Instructor Guide

Lesson plans, instructions, and tips for delivering great classes.

Obtenga un certificado de finalización

Comparte tu certificado con posibles empleadores y tu red profesional.

Certificado de Habilidades Verificadas

Su Nombre

Para habilidades verificadas en: Excel Intermediate

Emitido el agosto 4, 2026

Excel Intermediate

Pruebe este curso con una prueba gratuita