Office Computation with Excel Applications

Chapter 1 Introduction and Home Row Keys for the Ten-Key Calculator
Introduction
What are these devices and their uses in offices?
Ten-Key Calculator
The Numeric Keypad
Microsoft Excel
What are the Advantages, Disadvantages, and Limitations of Each?
Introduction to the Ten-Key Calculator
What Is the Correct Finger Position for Each?
Home Row Keys and Correct Finger Placement
Touch Method and Home Row Key Indicator
Correct Posture for Keying on the Ten-Key Calculator
Preparing for Work
Finger Placement
Home Row Key Practice Exercise DrillsÔÇöTen-Key Calculator
Fingers used for Other Keys
Finger Position/Placement for 7, 8, and 9 Keys
Finger Position for 1, 2, and 3 Keys and the 0, 00, and Decimal Keys
Finger Position for Arithmetic Keys
Ten-Key Speed Development Drills
Chapter 2 Basic Math Functions and Operations for the Ten-Key Calculator
Number Placement
Finding Place Value of Whole Numbers
Practice
Find the Place Value of the Following Numbers
Rounding Whole Numbers
Practice
Rounding Whole Numbers
Fractions
Parts of Fractions
Types of Fractions
Converting Fractions
Decimals
Rounding Numbers with Decimals
Practice
Rounding Decimal Numbers
Addition
Add-Mode
Corrections
Addition with Decimals (More Than Two Digits)
Subtraction
Subtraction with Decimals
Corrections
Credit Balances
Other Functions Used with Addition and Subtraction on the Ten-Key Calculator
Non-Add Key
Subtotal Key
Multiplication
Multiplication with Decimals
Percent Key
Constant Multiplication
Accumulative Multiplication
Division
Division with Decimals
Constant Division
Accumulative Division
Conversions of Fractions to Decimals for Use in Math Problems
Chapter 3 Home Row Key DrillsÔÇöNumeric Keypad on the Computer
Introduction to the Ten-Key Calculator
What Is the Correct Finger Position for Each?
Home Row Keys and Correct Finger Placement
Touch Method and Home Row Key Indicator
Correct Posture for Keying on the Ten-Key Calculator
Preparing for Work
Finger Placement
Home Row Key Practice Exercise DrillsÔÇöTen-Key Calculator
Fingers Used for Other Keys
Finger Position for 7, 8, 9, Division, and Multiplication Keys
Finger Position for 1, 2, 3, Decimal, Plus, and Minus Keys
Introduction to the Program Calculator
Ten-Key Speed Development Drills
Chapter 4 Basic Math Operations for the Numeric Keypad
Number Placement, Decimals, and Rounding
To Open the Computer Electronic Calculator
Addition
Corrections
Addition with Decimals
Subtraction
Subtraction with Decimals
Credit Balances
Multiplication
Multiplication with Decimals
Percent Key
Constant Multiplication
Accumulative Multiplication
Division
Division with Decimals
Constant Division
Accumulative Division
Chapter 5 Basic Math Calculations
Rounding Numbers
Converting a Fraction to a Decimal
Proofreading Numbers
Percentage Formula
Discounts
Markups
Chapter 6 Basic Excel Concepts
Ribbon
Using Formulas in Excel
Using Functions in Excel
Using the AutoSum Function in Excel Spreadsheets
Using the Average Function in Excel Spreadsheets
Using the Maximum Function in Excel Spreadsheets
Using the Minimum Function in Excel Spreadsheets
Chapter 7 Business-Specific Topics
Medical Office Administrative Assistants (MOAAs)
Office Administrative Assistants
Chapter 8 Basic Business Applications
Installment Loans
Insurance Premiums
Straight-Line Depreciation
Declining Balance Depreciation
Example for Declining Depreciation Method
First Year
Second Year
Third Year
Fourth Year
Fifth Year
Chapter 9 Using Excel 2019 for Business Documents
Invoices
Inventory Valuation
Income Statement
Check Register
Bank Statement Reconciliation
Chapter 10 Assignments Johnson Realty Simulation
Job Description
Assignments
Transaction 1
Transaction 2
Transaction 3
Transaction 4
Transaction 5
Transaction 6
Johnson Realty Quiz
Chapter 11 Assignments Smith Family Care Simulation
Job Description
About the Medical Practice
Transaction 1
Transaction 2
Transaction 3
Transaction 4
Transaction 5
Transaction 6
Transaction 7
Transaction 8
Smith Family Care Quiz