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: Setting Up (Video) (Course Id 906)

QAS / Registry
  Add to Cart 
Author : L. Keith Jordan, CPA
Course Length : Pages: 11 ||| Review Questions: 16 ||| Final Exam Questions: 15
CPE Credits : 3.0
IRS Credits : 0
Price : $44.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 906
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 QuickBooks Pro 2015 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 QuickBooks product lines, categories, versions, and features; network or standalone setup issues; and how to determine if QuickBooks is the right answer for a particular organization.
    • In Part 2 of this course, we explore how to start the process of creating a new QuickBooks Company Data file using the “Setup” or “No Company Open” window; how to use the EasyStep Interview or the Express Start process to create a new QuickBooks Company Data file; and how to enter company information into QuickBooks.
    • In Part 3 of this course, we explore the basic elements of the QuickBooks Desktop and Home Page and how to navigate both; how to determine the difference between QuickBooks User and Company Preferences; how to set or customize Preferences; and general recommendations for Preference settings.

 
Usage Rank : 10000
Release : 2015
Version : 1.0
Prerequisites : Some knowledge of QuickBooks is helpful but not required.
Experience Level : Basic
Additional Contents : Complete, no additional material needed
Additional Links :
QuickBooks Pro 2015 Tutorial Setting Up the Chart of YouTube
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 - 906
Keywords : Specialized Knowledge and Applications, QuickBooks, Pro, 2015, Setting, Up, Video, cpe, cpa, online course
Learning Objectives :

QuickBooks Pro Training Course Learning Objectives

    • Upon successful completion of Part 1 of this course, the student should be able to identify the categories and versions of QuickBooks currently available and compare the features available in the Pro, Premier, and Enterprise Editions; and evaluate for whom QuickBooks is best suited, determine if QuickBooks meets company needs, and recommend the correct setup in single and multi-user environments.
    • Upon successful completion of Part 2 of this course, the student should be able to use QuickBooks to open a new company file and initialize a chart of accounts; and explain how to add and edit company information in QuickBooks.
    • Upon successful completion of Part 3 of this course, the student should be able to identify the basic elements of the QuickBooks Desktop and Home Page; and describe Preferences and determine Preferences settings.
Course Contents :

Course Learning Objectives

Chapter 1 - QuickBooks Pro 2015: Setting Up - Part 1

Chapter 1 - Part 1 Review Questions

Chapter 1 - QuickBooks Pro 2015: Setting Up - Part 2

Chapter 1 - Part 2 Review Questions

Chapter 1 - QuickBooks Pro 2015: Setting Up - Part 3

Chapter 1 - Part 3 Review Questions

Glossary
QuickBooks Course 906 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
Sepehr S. from WA bought 1 course 6 hours ago.  |||  New User Discount - Click Here ||| Terry Lind S. from TX bought 1 subscription 6 hours ago.  |||  New User Discount - Click Here ||| MITCHELL H. from TX bought 2 courses 7 hours ago.  |||  New User Discount - Click Here ||| MICHELE H. from WI bought 1 course 7 hours ago.  |||  New User Discount - Click Here ||| Scott B. from CO bought 1 subscription 7 hours ago.  |||  New User Discount - Click Here ||| Dawn R. from VA bought 1 course 8 hours ago.  |||  New User Discount - Click Here ||| Huicong Z. from TX bought 1 course 8 hours ago.  |||  New User Discount - Click Here ||| Yuwei L. from MD bought 1 subscription 9 hours ago.  |||  New User Discount - Click Here ||| Henry P. from OH bought 1 course 10 hours ago.  |||  New User Discount - Click Here ||| Devin G. from TX bought 4 courses 10 hours 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