APUS-ITCC112.AE1
ITCC112 - Advanced Productivity Applications
- Practice in 35 Laboratorios prácticos — nothing to install
- 8 Lecciones interactivas y 33 topics mapped to the official exam objectives
Intermediate A tu propio ritmo · 1 año de acceso
35 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
01 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
8 Lecciones interactivas · 33 topics01 Excel: The 50-Cent Tour 3 topics · 2 Laboratorio en vivo +
- Getting Comfy with the Excel Window
- Creating Fresh Workbooks
- Data Entry 101
2 Laboratorio en vivo in this lesson — see the labs panel →
02 Sprucing Up a Worksheet 5 topics · 3 Laboratorio en vivo +
- Selecting Cells and Ranges
- Adjusting Columns and Rows
- Formatting Cells from the Ribbon
- Formatting Numbers, Dates, and Time Values
- Hiring Out the Format Painter
3 Laboratorio en vivo in this lesson — see the labs panel →
03 Fiddling with Your Worksheets 3 topics · 5 Laboratorio en vivo +
- Editing a Cell
- A Worksheet with a View
- Copying and Moving Stuff Around
5 Laboratorio en vivo in this lesson — see the labs panel →
04 Taming Your Worksheets 2 topics · 6 Laboratorio en vivo +
- Revamping a Worksheet
- Overhauling a Workbook
6 Laboratorio en vivo in this lesson — see the labs panel →
05 Building Basic Formulas 5 topics · 6 Laboratorio en vivo +
- Getting Started with Formulas
- Augmenting Formulas with Functions
- Copying Formulas
- Adding Array Formulas
- Naming Cells and Ranges
6 Laboratorio en vivo in this lesson — see the labs panel →
06 Analyzing Data 5 topics · 3 Laboratorio en vivo +
- Getting Quick Analyses from Excel
- Eyeballing Trends and Outliers with Conditional Formatting
- Managing Information in Tables
- What If You Used What-If Analysis?
- Summarizing Data with PivotTables
3 Laboratorio en vivo in this lesson — see the labs panel →
07 Visualizing Data with Charts 4 topics · 3 Laboratorio en vivo +
- Learning Some Crucial Chart Basics
- Forging a Fresh Chart
- Selecting Chart Elements
- Dressing Up Your Charts
3 Laboratorio en vivo in this lesson — see the labs panel →
08 Automating Excel with Copilot 6 topics · 7 Laboratorio en vivo +
- Getting Copilot on the Job
- Analyzing Data
- Creating Formulas
- Highlighting Data
- Sorting and Filtering Data
- Visualizing Data
7 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
35 Laboratorio en vivos- Creating and Saving a Workbook
- Creating Custom AutoFill Lists
- Adjusting the Columns
- Hiding the Rows
- Hiding the Columns
- Adding and Replacing Data in a Cell
- Deleting a Row
- Inserting a Cell Range
- Freezing the Top Row
- Copying and Pasting the Data
- Deleting a Column
- Adding Color to the Worksheet Tab
- Making a Copy of the Worksheet
- Adding a New Worksheet
- Hiding a Worksheet
- Deleting a Worksheet
- Creating Worksheet Formulas
- Calculating the Sum
- Using the TODAY Function
- Adding the Arguments for the IF Portion of the Nested Function
- Creating Named Ranges
- Editing Range Names
- Creating a Forecast Sheet
- Converting the Data into a Table
- Adding Fields to the PivotTable
- Creating the Combo Chart
- Changing the Chart Type
- Changing the Labels of the Line Chart
- Using the MATCH Function
- Using the INDEX Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the SORT Function
- Using the FILTER Function
- Creating Sparklines
Keep going
You might also like
Prepárate para ITCC112 - Advanced Productivity Applications
Pago único. Acceso completo durante 1 año. Comienza con una prueba gratuita si primero quieres echar un vistazo.
- 1 año de acceso completo
- 35 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito