Cursos
Excel Mac Intermediate

5 hour course

Excel Mac Intermediate

4.9 sobre 5 en G2

Try this course with a Free Trial

Looking to enhance your Excel skills on Mac? This course covers intermediate features like advanced formulas, data management, and chart creation.

Learn to:

Create Advanced Charts
Apply Conditional Formatting
Utilize Intermediate Formulas
Collaborate on Workbooks

Features:

Learn by doing simulations
Skill assessments
Certificate

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

Excel Mac Intermediate Describir

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Charts			Aprendizaje verificado
Create Charts How to Create Charts in Excel	No empezado	No empezado	No empezado
Move and Resize How to Move and Resize a Chart in Excel	No empezado	No empezado	No empezado
Chart Types How to Change Chart Types in Excel	No empezado	No empezado	No empezado
Layout and Styles How to Apply Chart Layouts and Styles in Excel	No empezado	No empezado	No empezado
Titles and Legends How to Customize Chart Titles and Legends in Excel	No empezado	No empezado	No empezado
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel	No empezado	No empezado	No empezado
Chart Elements How to Format Chart Data in Excel	No empezado	No empezado	No empezado
Modify Chart Data How to Modify Chart Data in Excel	No empezado	No empezado	No empezado
Filter Charts How to Filter Charts in Excel	No empezado	No empezado	No empezado
Trendlines How to Add Trendlines in Excel	No empezado	No empezado	No empezado
Dual-Axis Charts How to Create Dual-Axis Charts in Excel	No empezado	No empezado	No empezado
Chart Templates How to Create Chart Templates in Excel	No empezado	No empezado	No empezado
Sparklines How to Add Sparklines in Excel	No empezado	No empezado	No empezado

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Print and Distribute			Aprendizaje verificado
Page Size and Scale How to Adjust Page Size and Scale in Excel	Cuenta requerida
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Intermediate Formulas			Aprendizaje verificado
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCATENATE Function How to use the Concatenate Text Function in Excel
PMT Function How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Manage Data			Aprendizaje verificado
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Flash Fill How to Use Flash Fill in Excel
Data Validation How to Use Data Validation Rules in Excel
Import and Export Data How to Import and Export Excel Data

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Tables			Aprendizaje verificado
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Intermediate Formatting			Aprendizaje verificado
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cells Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Apply a Theme How to Apply a Theme in Excel

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Collaborate with Excel			Aprendizaje verificado
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Track Changes
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Password Protection How to Add Password Protection in Excel