uCertify

IT153 Spreadsheet Applications

(PUG-IT153.ADB1)
Lessons
Lab
TestPrep
Get A Free Trial

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

Why Do Learners Love This Course?

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses