APUS-ITCC112.AE1
ITCC112 - Advanced Productivity Applications
- Practice in 35 Praktische Übungen — nothing to install
- 8 Interaktive Lektionen Und 33 topics mapped to the official exam objectives
Intermediate Selbstgesteuert · 1 Jahr Zugang
35 Praktische LiveLabs
Practice real IT tasks in guided environments.
- Reale Umgebungen
- Automatisch bewertet
- Keine Installation
8Interaktive Lektionen
33Topics
35LiveLab
43Karteikarten
43Glossar der Begriffe
01 / Lektionen & Labore
See exactly what you will learn and practice
Unterrichtsplan
8 Interaktive Lektionen · 33 topics01 Excel: The 50-Cent Tour 3 topics · 2 LiveLab +
- Getting Comfy with the Excel Window
- Creating Fresh Workbooks
- Data Entry 101
2 LiveLab in this lesson — see the labs panel →
02 Sprucing Up a Worksheet 5 topics · 3 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
03 Fiddling with Your Worksheets 3 topics · 5 LiveLab +
- Editing a Cell
- A Worksheet with a View
- Copying and Moving Stuff Around
5 LiveLab in this lesson — see the labs panel →
04 Taming Your Worksheets 2 topics · 6 LiveLab +
- Revamping a Worksheet
- Overhauling a Workbook
6 LiveLab in this lesson — see the labs panel →
05 Building Basic Formulas 5 topics · 6 LiveLab +
- Getting Started with Formulas
- Augmenting Formulas with Functions
- Copying Formulas
- Adding Array Formulas
- Naming Cells and Ranges
6 LiveLab in this lesson — see the labs panel →
06 Analyzing Data 5 topics · 3 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
07 Visualizing Data with Charts 4 topics · 3 LiveLab +
- Learning Some Crucial Chart Basics
- Forging a Fresh Chart
- Selecting Chart Elements
- Dressing Up Your Charts
3 LiveLab in this lesson — see the labs panel →
08 Automating Excel with Copilot 6 topics · 7 LiveLab +
- Getting Copilot on the Job
- Analyzing Data
- Creating Formulas
- Highlighting Data
- Sorting and Filtering Data
- Visualizing Data
7 LiveLab in this lesson — see the labs panel →
Praktische Übungen Our edge
35 LiveLabs- 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
Labore laufen direkt im Browser — nichts zu installieren.
Keep going
You might also like
Bereiten Sie sich vor auf ITCC112 - Advanced Productivity Applications
Einmalige Zahlung. Voller Zugang für 1 Jahr. Starten Sie mit einer kostenlosen Testversion, wenn Sie sich zunächst umsehen möchten.
- 1 Jahr voller Zugang
- 35 LiveLab enthalten
- Abschlusszertifikat
Keine Kreditkarte benötigt