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

QuickBooks Pro 2015: Middle Game (Video) (Course Id 988)

QAS / Registry
  Add to Cart 
Author : L. Keith Jordan, CPA
Course Length : Pages: 13 ||| Review Questions: 13 ||| Final Exam Questions: 10
CPE Credits : 2.0
IRS Credits : 0
Price : $29.95
Passing Score : 70%
Course Type: Video - NASBA QAS - Text - NASBA Registry
Technical Designation: Technical
Primary Subject-Field Of Study:

Specialized Knowledge - Specialized Knowledge for Course Id 988
Description :

This is a brand new approach to the QuickBooks Pro series of CPE courses created by L. Keith Jordan, CPA. Previous courses have used a text format with illustrations. This course uses an audio-visual format with demonstrations (of course, a transcript is included for those who prefer). The video contains navigation controls and ADA captioning, and you can also jump to a particular part of the content by using the interactive table of contents or the search box.

    • In Part 1 of this course, we explore the importance of forms in QuickBooks, and demonstrate how forms can be designed and modified to better meet the needs of the entity.
    • In Part 2 of this course, we explore how to enter transactions using forms and classes, how to memorize and print transactions individually or in a batch, and how to utilize other QuickBooks features such as the calendar, the fixed asset list, and the loan manager.

Usage Rank : 10000
Release : 2016
Version : 1.0
Prerequisites : • Some knowledge of QuickBooks Pro.
• Completion of QuickBooks Pro 2015: Setting Up, or equivalent knowledge and skills
• Completion of QuickBooks Pro 2015: Opening Moves, or equivalent knowledge and skills
Experience Level : Overview
Additional Contents : Complete, no additional material needed
Additional Links :
QuickBooks 2015 Intuit
Advance Preparation : The student should have access to a computer and a copy of QuickBooks, preferably Pro 2015. Use of other editions of QuickBooks (such as Premier) and versions (other than 2015) with this course may be possible, but the student should understand that there
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE)
Revision Date : 01-Mar-2024
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 :

Video - NASBA QAS - Text - NASBA Registry - 988
Keywords : Specialized Knowledge and Applications, QuickBooks, Pro, 2015, Middle, Game, Video, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

    • Upon successful completion of Part 1 of this course, the student should be able to identify the basic elements of modifiable QuickBooks forms and demonstrate how to modify forms to use classes in multiple distribution transactions; and use available form options to design and modify QuickBooks forms to better meet the needs of the entity.
    • Upon successful completion of Part 2 of this course, the student should be able to define QuickBooks classes and discuss how they can be used to expand tracking and reporting capability; explain and demonstrate how to enter transactions via journal entries, payroll timesheets, and other QuickBooks forms, and how to utilize other features available in QuickBooks Pro such as the calendar, the fixed asset list and the loan manager; and demonstrate how to memorize and print or batch print transactions.
Course Contents :

Course Learning Objectives

Chapter 1 - QuickBooks Pro 2015: Middle Game - Part 1

Chapter 1 - Part 1 Review Questions

Chapter 1 - QuickBooks Pro 2015: Middle Game - Part 2

Chapter 1 - Part 2 Review Questions

Glossary
QuickBooks Course 988 Home: https://www.cpethink.com/quickbooks-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
Alpa P. from bought 1 course 7 hours ago.  |||  New User Discount - Click Here ||| Adele E. from VA bought 1 course 11 hours ago.  |||  New User Discount - Click Here ||| Sharon V. from CA bought 1 subscription 13 hours ago.  |||  New User Discount - Click Here ||| Anne A. from TX bought 1 course 15 hours ago.  |||  New User Discount - Click Here ||| Michael P. from IL bought 2 courses 15 hours ago.  |||  New User Discount - Click Here ||| Greg D. from TX bought 1 course 18 hours ago.  |||  New User Discount - Click Here ||| James E. from NC bought 1 subscription 18 hours ago.  |||  New User Discount - Click Here ||| Olivia G. from DC bought 1 course 19 hours ago.  |||  New User Discount - Click Here ||| Queencess B. from bought 3 courses 1 day ago.  |||  New User Discount - Click Here ||| Queencess B. from bought 1 course 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