.png){kind=logo}
APUS-ITCC112.AE1
ITCC112 - Advanced Productivity Applications
- Practice in 35 Hands-On Labs — nothing to install
- 8 Interactive Lessons and 33 topics mapped to the official exam objectives
Intermediate Self-paced · 1 year access
35 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
8Interactive Lessons
33Topics
35LiveLab
43Flashcards
43Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
8 Interactive Lessons · 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 →
Hands-On Labs 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
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for ITCC112 - Advanced Productivity Applications
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 35 LiveLab included
- Certificate of completion
No credit card required