uCertify

ITCC112 - Advanced Productivity Applications

(APUS-ITCC112.AE1)
Lessons
Lab
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Excel: The 50-Cent Tour

  • Getting Comfy with the Excel Window
  • Creating Fresh Workbooks
  • Data Entry 101
2

Sprucing Up a Worksheet

  • 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

Fiddling with Your Worksheets

  • Editing a Cell
  • A Worksheet with a View
  • Copying and Moving Stuff Around
4

Taming Your Worksheets

  • Revamping a Worksheet
  • Overhauling a Workbook
5

Building Basic Formulas

  • Getting Started with Formulas
  • Augmenting Formulas with Functions
  • Copying Formulas
  • Adding Array Formulas
  • Naming Cells and Ranges
6

Analyzing Data

  • 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
7

Visualizing Data with Charts

  • Learning Some Crucial Chart Basics
  • Forging a Fresh Chart
  • Selecting Chart Elements
  • Dressing Up Your Charts
8

Automating Excel with Copilot

  • Getting Copilot on the Job
  • Analyzing Data
  • Creating Formulas
  • Highlighting Data
  • Sorting and Filtering Data
  • Visualizing Data

1

Excel: The 50-Cent Tour

  • Creating and Saving a Workbook
  • Creating Custom AutoFill Lists
2

Sprucing Up a Worksheet

  • Adjusting the Columns
  • Hiding the Rows
  • Hiding the Columns
3

Fiddling with Your Worksheets

  • Adding and Replacing Data in a Cell
  • Deleting a Row
  • Inserting a Cell Range
  • Freezing the Top Row
  • Copying and Pasting the Data
4

Taming Your Worksheets

  • 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
5

Building Basic Formulas

  • 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
6

Analyzing Data

  • Creating a Forecast Sheet
  • Converting the Data into a Table
  • Adding Fields to the PivotTable
7

Visualizing Data with Charts

  • Creating the Combo Chart
  • Changing the Chart Type
  • Changing the Labels of the Line Chart
8

Automating Excel with Copilot

  • 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

ITCC112 - Advanced Productivity Applications

$239.99

Buy Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More