Home
0
Home
Cart Empty | Login/Register  Login/Register
Search Courses List  >  Course Details
Use Landscape to see Search/Filter
Item Types:
Field of Study:
Authors:
CPE Hours:
Keyword:
Hide left panel Collapse Menu
Show left panel
Recent Searches
No recent searches found.
A~B
Similar Courses

This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity. The course covers some basics, along with some advanced tips and tricks. It starts with how to select and navigate through data and worksheets as well as copying and moving data efficiently. It then details a wide spectrum of functions that can be used in everyday practice. Functions including SUBTOTAL, SUMIF(), and INDEX MATCH are discussed. New functions, such as AGGREGATE(), IFNA(),TEXTJOIN() , CONCAT() and IFS() are covered. Learn how to comparing lists using arrays. Pivot tables are discussed in detail. Other topics include:  Charts, Conditional formatting, and tools for importing data into Excel. XLOOKUP() and dynamic arrays are briefly touched upon. You will definitely impress your coworkers with all your new knowledge!  There are no associated Excel files however topics are gone over in  a detailed step by step fashion that is easy to follow.

Version:  Excel 2019 and Microsoft 365 users. Users of Excel 2010 through 2016 should not have a lot of difficulty; however, some features may not be available or may be in a slightly different location.

Must Know Excel Tips Tricks and Tools for CPAs - v11 (5 Hrs)

The risk of needing long term care—a name given to a broad range of services designed to meet an individual’s mental, emotional, or physical health and personal needs and which are often provided over an extended period of time—is present at all ages. However, as individuals become older the risk of requiring long term care increases significantly.

The U.S. population is expected to increase in size by about 27% by the year 2050. In contrast, the part of the U.S. population most at risk for needing long term care—the segment comprised of individuals 85 years old or older—is expected to grow about 280% during this same period. Not only is the part of the population most at risk for needing long term care growing disproportionately, but the cost to provide that care is also increasing. Long term care costs are substantial and, over the last several years, have been increasing at a rate that exceeds the inflation rate.

The growing risk of needing long term care fueled by a rapidly aging population coupled with the high and continually increasing cost of such care can present burdensome financial concerns to many clients and their heirs. This long term care informational course examines tax treatment, the nature of long term care, the forms in which it may be delivered, the risk of needing such care, the costs of long term care, the sources available to pay the costs, and the features of long term care insurance.

Long Term Care Fundamentals (5 Hrs)

A dashboard provides pertinent summary information to assist in management decision making. It is geared to emphasize areas of performance that managers are interested in. It essentially provides the analysis which allows the users to draw a quick conclusion based on the trends and comparisons shown. In this course we are focusing on using Excel to create an effective dashboard using Tables, Charts, Camera Tool, Conditional formatting, Data Validation, In-cell Charts and functions such as SUMIF and INDEX. This course assumes a good underlying knowledge base of Excel and a basic knowledge of chart creation as much of the course focuses on charting features as well as basic functions. 

Drive Your Dashboard with Excel (11 Hrs)

This course covers both financing and investing in real estate. The first section deals with two major aspects of real estate financing:  (1) financial instruments and (2) the means of financing.  It examines the financial side of the lending process.  The second section deals with investing in real estate. Topics include: the advantages and pitfalls of real estate investing, how to value an income-producing property, how to use leverage and increase return, and buying a home. 

Real Estate Financing and Investment - v12 (4 Hrs)

Real Estate: Basic Accounting and Mathematics is a refresher course covering the basic concepts and tools of accounting, finance, and math necessary for new real estate professionals.  It is also applicable for accountants as well as real estate investors. Topics covered are balance sheet, income statement, basic accounting concepts, real estate algebra, finance math, and more.

Real Estate: Basic Accounting and Mathematics (3 Hrs)
A/B
Suggested Courses

This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity. The course covers some basics, along with some advanced tips and tricks. It starts with how to select and navigate through data and worksheets as well as copying and moving data efficiently. It then details a wide spectrum of functions that can be used in everyday practice. Functions including SUBTOTAL, SUMIF(), and INDEX MATCH are discussed. New functions, such as AGGREGATE(), IFNA(),TEXTJOIN() , CONCAT() and IFS() are covered. Learn how to comparing lists using arrays. Pivot tables are discussed in detail. Other topics include:  Charts, Conditional formatting, and tools for importing data into Excel. XLOOKUP() and dynamic arrays are briefly touched upon. You will definitely impress your coworkers with all your new knowledge!  There are no associated Excel files however topics are gone over in  a detailed step by step fashion that is easy to follow.

Version:  Excel 2019 and Microsoft 365 users. Users of Excel 2010 through 2016 should not have a lot of difficulty; however, some features may not be available or may be in a slightly different location.

Must Know Excel Tips Tricks and Tools for CPAs - v11 (5 Hrs)

The risk of needing long term care—a name given to a broad range of services designed to meet an individual’s mental, emotional, or physical health and personal needs and which are often provided over an extended period of time—is present at all ages. However, as individuals become older the risk of requiring long term care increases significantly.

The U.S. population is expected to increase in size by about 27% by the year 2050. In contrast, the part of the U.S. population most at risk for needing long term care—the segment comprised of individuals 85 years old or older—is expected to grow about 280% during this same period. Not only is the part of the population most at risk for needing long term care growing disproportionately, but the cost to provide that care is also increasing. Long term care costs are substantial and, over the last several years, have been increasing at a rate that exceeds the inflation rate.

The growing risk of needing long term care fueled by a rapidly aging population coupled with the high and continually increasing cost of such care can present burdensome financial concerns to many clients and their heirs. This long term care informational course examines tax treatment, the nature of long term care, the forms in which it may be delivered, the risk of needing such care, the costs of long term care, the sources available to pay the costs, and the features of long term care insurance.

Long Term Care Fundamentals (5 Hrs)

A dashboard provides pertinent summary information to assist in management decision making. It is geared to emphasize areas of performance that managers are interested in. It essentially provides the analysis which allows the users to draw a quick conclusion based on the trends and comparisons shown. In this course we are focusing on using Excel to create an effective dashboard using Tables, Charts, Camera Tool, Conditional formatting, Data Validation, In-cell Charts and functions such as SUMIF and INDEX. This course assumes a good underlying knowledge base of Excel and a basic knowledge of chart creation as much of the course focuses on charting features as well as basic functions. 

Drive Your Dashboard with Excel (11 Hrs)

This course covers both financing and investing in real estate. The first section deals with two major aspects of real estate financing:  (1) financial instruments and (2) the means of financing.  It examines the financial side of the lending process.  The second section deals with investing in real estate. Topics include: the advantages and pitfalls of real estate investing, how to value an income-producing property, how to use leverage and increase return, and buying a home. 

Real Estate Financing and Investment - v12 (4 Hrs)

Real Estate: Basic Accounting and Mathematics is a refresher course covering the basic concepts and tools of accounting, finance, and math necessary for new real estate professionals.  It is also applicable for accountants as well as real estate investors. Topics covered are balance sheet, income statement, basic accounting concepts, real estate algebra, finance math, and more.

Real Estate: Basic Accounting and Mathematics (3 Hrs)
Recent Searches
No recent searches found.
Similar Courses

This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity. The course covers some basics, along with some advanced tips and tricks. It starts with how to select and navigate through data and worksheets as well as copying and moving data efficiently. It then details a wide spectrum of functions that can be used in everyday practice. Functions including SUBTOTAL, SUMIF(), and INDEX MATCH are discussed. New functions, such as AGGREGATE(), IFNA(),TEXTJOIN() , CONCAT() and IFS() are covered. Learn how to comparing lists using arrays. Pivot tables are discussed in detail. Other topics include:  Charts, Conditional formatting, and tools for importing data into Excel. XLOOKUP() and dynamic arrays are briefly touched upon. You will definitely impress your coworkers with all your new knowledge!  There are no associated Excel files however topics are gone over in  a detailed step by step fashion that is easy to follow.

Version:  Excel 2019 and Microsoft 365 users. Users of Excel 2010 through 2016 should not have a lot of difficulty; however, some features may not be available or may be in a slightly different location.

Must Know Excel Tips Tricks and Tools for CPAs - v11 (5 Hrs)

The risk of needing long term care—a name given to a broad range of services designed to meet an individual’s mental, emotional, or physical health and personal needs and which are often provided over an extended period of time—is present at all ages. However, as individuals become older the risk of requiring long term care increases significantly.

The U.S. population is expected to increase in size by about 27% by the year 2050. In contrast, the part of the U.S. population most at risk for needing long term care—the segment comprised of individuals 85 years old or older—is expected to grow about 280% during this same period. Not only is the part of the population most at risk for needing long term care growing disproportionately, but the cost to provide that care is also increasing. Long term care costs are substantial and, over the last several years, have been increasing at a rate that exceeds the inflation rate.

The growing risk of needing long term care fueled by a rapidly aging population coupled with the high and continually increasing cost of such care can present burdensome financial concerns to many clients and their heirs. This long term care informational course examines tax treatment, the nature of long term care, the forms in which it may be delivered, the risk of needing such care, the costs of long term care, the sources available to pay the costs, and the features of long term care insurance.

Long Term Care Fundamentals (5 Hrs)

A dashboard provides pertinent summary information to assist in management decision making. It is geared to emphasize areas of performance that managers are interested in. It essentially provides the analysis which allows the users to draw a quick conclusion based on the trends and comparisons shown. In this course we are focusing on using Excel to create an effective dashboard using Tables, Charts, Camera Tool, Conditional formatting, Data Validation, In-cell Charts and functions such as SUMIF and INDEX. This course assumes a good underlying knowledge base of Excel and a basic knowledge of chart creation as much of the course focuses on charting features as well as basic functions. 

Drive Your Dashboard with Excel (11 Hrs)

This course covers both financing and investing in real estate. The first section deals with two major aspects of real estate financing:  (1) financial instruments and (2) the means of financing.  It examines the financial side of the lending process.  The second section deals with investing in real estate. Topics include: the advantages and pitfalls of real estate investing, how to value an income-producing property, how to use leverage and increase return, and buying a home. 

Real Estate Financing and Investment - v12 (4 Hrs)

Real Estate: Basic Accounting and Mathematics is a refresher course covering the basic concepts and tools of accounting, finance, and math necessary for new real estate professionals.  It is also applicable for accountants as well as real estate investors. Topics covered are balance sheet, income statement, basic accounting concepts, real estate algebra, finance math, and more.

Real Estate: Basic Accounting and Mathematics (3 Hrs)
Suggested Courses

This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity. The course covers some basics, along with some advanced tips and tricks. It starts with how to select and navigate through data and worksheets as well as copying and moving data efficiently. It then details a wide spectrum of functions that can be used in everyday practice. Functions including SUBTOTAL, SUMIF(), and INDEX MATCH are discussed. New functions, such as AGGREGATE(), IFNA(),TEXTJOIN() , CONCAT() and IFS() are covered. Learn how to comparing lists using arrays. Pivot tables are discussed in detail. Other topics include:  Charts, Conditional formatting, and tools for importing data into Excel. XLOOKUP() and dynamic arrays are briefly touched upon. You will definitely impress your coworkers with all your new knowledge!  There are no associated Excel files however topics are gone over in  a detailed step by step fashion that is easy to follow.

Version:  Excel 2019 and Microsoft 365 users. Users of Excel 2010 through 2016 should not have a lot of difficulty; however, some features may not be available or may be in a slightly different location.

Must Know Excel Tips Tricks and Tools for CPAs - v11 (5 Hrs)

The risk of needing long term care—a name given to a broad range of services designed to meet an individual’s mental, emotional, or physical health and personal needs and which are often provided over an extended period of time—is present at all ages. However, as individuals become older the risk of requiring long term care increases significantly.

The U.S. population is expected to increase in size by about 27% by the year 2050. In contrast, the part of the U.S. population most at risk for needing long term care—the segment comprised of individuals 85 years old or older—is expected to grow about 280% during this same period. Not only is the part of the population most at risk for needing long term care growing disproportionately, but the cost to provide that care is also increasing. Long term care costs are substantial and, over the last several years, have been increasing at a rate that exceeds the inflation rate.

The growing risk of needing long term care fueled by a rapidly aging population coupled with the high and continually increasing cost of such care can present burdensome financial concerns to many clients and their heirs. This long term care informational course examines tax treatment, the nature of long term care, the forms in which it may be delivered, the risk of needing such care, the costs of long term care, the sources available to pay the costs, and the features of long term care insurance.

Long Term Care Fundamentals (5 Hrs)

A dashboard provides pertinent summary information to assist in management decision making. It is geared to emphasize areas of performance that managers are interested in. It essentially provides the analysis which allows the users to draw a quick conclusion based on the trends and comparisons shown. In this course we are focusing on using Excel to create an effective dashboard using Tables, Charts, Camera Tool, Conditional formatting, Data Validation, In-cell Charts and functions such as SUMIF and INDEX. This course assumes a good underlying knowledge base of Excel and a basic knowledge of chart creation as much of the course focuses on charting features as well as basic functions. 

Drive Your Dashboard with Excel (11 Hrs)

This course covers both financing and investing in real estate. The first section deals with two major aspects of real estate financing:  (1) financial instruments and (2) the means of financing.  It examines the financial side of the lending process.  The second section deals with investing in real estate. Topics include: the advantages and pitfalls of real estate investing, how to value an income-producing property, how to use leverage and increase return, and buying a home. 

Real Estate Financing and Investment - v12 (4 Hrs)

Real Estate: Basic Accounting and Mathematics is a refresher course covering the basic concepts and tools of accounting, finance, and math necessary for new real estate professionals.  It is also applicable for accountants as well as real estate investors. Topics covered are balance sheet, income statement, basic accounting concepts, real estate algebra, finance math, and more.

Real Estate: Basic Accounting and Mathematics (3 Hrs)
Course Details

Real Estate Financing and Investment - v12 (Course Id 1759)

QAS / Registry
  Add to Cart 
Author : Jae K. Shim, Ph.D., CPA
Course Length : Pages: 37 ||| Review Questions: 29 ||| Final Exam Questions: 20
CPE Credits : 4.0
IRS Credits : 0
Price : $35.95
Passing Score : 70%
Course Type: NASBA QAS - Text - NASBA Registry
Technical Designation: Technical
Primary Subject-Field Of Study:

Specialized Knowledge - Specialized Knowledge for Course Id 1759
Description :

This course covers both financing and investing in real estate. The first section deals with two major aspects of real estate financing:  (1) financial instruments and (2) the means of financing.  It examines the financial side of the lending process.  The second section deals with investing in real estate. Topics include: the advantages and pitfalls of real estate investing, how to value an income-producing property, how to use leverage and increase return, and buying a home. 
Usage Rank : 24583
Release : 2022
Version : 1.0
Prerequisites : Basic Math.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Investment Real Estate
Advance Preparation : None.
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 16-Jan-2023
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - Text - NASBA Registry - 1759
Keywords : Specialized Knowledge and Applications, Real, Estate, Financing, Investment, v12, cpe, cpa, online course
Learning Objectives :

Chapter 1
Real Estate Financing

After completing this section, you should be able to:
    1. Recognize elements of the loan process.
    2. Identify transactions covered and disclosures required by lending laws.
    3. Identify agencies involved in the mortgage market.
    4. Recognize the classification and uses of different mortgage types.

Chapter 2
Housing: The Cost of Shelter

After completing this section, you should be able to:
    1. Identify the benefits and disadvantages of buying vs. renting.
    2. Identify factors of the real estate purchase price and different loan types.

Chapter 3
Investing In Real Estate

After completing this section, you should be able to:
    1. Identify the advantages and disadvantages of real estate investing.
    2. Recognize the characteristics of REITs.
    3. Identify ways to calculate returns for real estate investments.
Course Contents :

Chapter 1:    Real Estate Financing

Learning Objective

The Loan Process

Lending Laws

Chapter 1 Review Questions - Section 1

Sources of Funds

Chapter 1 Review Questions - Section 2

Classification of Mortgages

Chapter 1 Review Questions - Section 3

Chapter 2:    Housing: The Cost of Shelter

Learning Objective

Homeownership

Chapter 2 Review Questions

Chapter 3:    Investing In Real Estate

Learning Objective

Real Estate Investing

Chapter 3 Review Questions

Glossary
CPE Specialized Knowledge Course: https://www.cpethink.com/cpe-for-cpas
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
  
Exam completed on .

Do you want to add the course again?
  
     
Our IRS Approved Continuing Education Provider number is 1SXC8 NASBA QAS Self-Study sponsor Id is 108299 Customer Reviews Shopper Award Click to verify BBB accreditation and to see a BBB report. Trustwave View TrustedSite Certification
MITCHELL H. from TX bought 1 course 5 hours ago.  |||  New User Discount - Click Here ||| Kimberly H. from MA bought 1 subscription 5 hours ago.  |||  New User Discount - Click Here ||| Michelle W. from TX bought 1 course 6 hours ago.  |||  New User Discount - Click Here ||| Sandra B. from MA bought 1 course 6 hours ago.  |||  New User Discount - Click Here ||| Eric B. from CA bought 1 subscription 16 hours ago.  |||  New User Discount - Click Here ||| Paul H. from IL bought 2 courses 1 day ago.  |||  New User Discount - Click Here ||| Chikako K. from CA bought 1 subscription 1 day ago.  |||  New User Discount - Click Here ||| Sepehr S. from WA bought 1 course 1 day ago.  |||  New User Discount - Click Here ||| Terry Lind S. from TX bought 1 subscription 1 day ago.  |||  New User Discount - Click Here ||| MITCHELL H. from TX bought 2 courses 1 day ago.  |||  New User Discount - Click Here ||| 
Remove Marquee
Copyright © 2024 Cpethink.com

Privacy | Refunds | Terms | Blog | Site Map | Contact Us | FAQs | Login | NASBA Id 108299 | IRS Id 1SXC8 | Cage Code 874S4