uCertify

IT153 Spreadsheet Applications

This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
Get A Free Trial

About This Course

Skills You’ll Get

Download Course Outline

1

Getting Started with Excel 2021

  • Topic A: Navigate the Excel User Interface
  • Topic B: Use Excel Commands
  • Topic C: Create and Save a Basic Workbook 
  • Topic D: Enter Cell Data 
  • Topic E: Use Excel Help 
2

Performing Calculations

  • Topic A: Create Worksheet Formulas 
  • Topic B: Insert Functions 
  • Topic C: Reuse Formulas and Functions
3

Basic charting

  • Answers to this lesson’s questions
  • Problems
4

Managing Workbooks

  • Topic A: Manage Worksheets 
  • Topic B: Manage Workbook and Worksheet Views 
  • Topic C: Manage Workbook Properties
5

Recording macros

  • Answers to this lesson’s questions
  • Problems
6

Using the Scenario Manager for sensitivity analysis

  • Answer to this lesson’s question
  • Remarks
  • Problems

1

Getting Started with Excel 2021

  • Exporting Ribbon Customizations as a File
  • Adding and Replacing Data in a Cell
  • Creating and Saving a Workbook
  • Copying and Pasting the Data
2

Performing Calculations

  • Creating Worksheet Formulas
  • Determining the Minimum Value
  • Determining the Maximum Value
  • Reusing Formulas
  • Calculating the Sum
  • Calculating the Average
3

Basic charting

  • Creating a Scatter Chart
4

Managing Workbooks

  • Deleting a Worksheet
  • Hiding a Worksheet
  • Adding a New Worksheet
  • Adding Color to the Worksheet Tab
  • Making a Copy of the Worksheet
  • Freezing the Top Row

Related Courses

All Course
scroll to top