View Cart

             Course   Search

Login

Email Address

Password

Forgot Password? Click Here
 
Courses by Number of Hours   
Courses by Field of Study
Courses by Authors
QAS Courses - Only
EA Courses - Only
RTRP Courses - Only
Pilot Courses - FREE
FREE CPE Courses
Webinars
Subscriptions
Course and Site Instruction
 
 
 
Authors
Business Services
Boards and Associations
Not For Profit Organizations
 
 
  Home > Course Details
 

Course Details - Go to Course Contents

   New ! ! !   Registry
    
Title :

Using Excel with External Data - August 7, 2012 10am to 12pm MT

Author :

L. Keith Jordan, CPA

Status :

Production

CPE Credits :

2.0

IRS Credits :

0

Price :

$59.95

Passing Score :

70%

Primary Subject-Field Of Study :

Specialized Knowledge and Applications - Specialized Knowledge & Applications

Description :

This 2-hour webcast will present students with specific situations requiring data collection via spreadsheets, and illustrates how to integrate and manipulate data from external sources for more effective analysis and reporting.

Software and version used in course presentation will be MS-Excel 2007 or higher (although users of previous versions can also benefit from the concepts being discussed)

Through a special arrangement with L. Keith Jordan, CPA Cpethink.com will be offering this webinar for only $9.95. This webinar usually sells for $50 to $75 but on Tuesday August 7, 2012 at 10am MDT it will be offered for $9.95. Don’t miss out on the special one-time offer from Cpethink.com and L. Keith Jordan, CPA, sign up today!

Usage Rank :

0

Release :

2012

Version :

999

Prerequisites :

Basic to intermediate knowledge of MS-Excel

Experience Level :

Overview

Additional Contents :

Complete, no additional material needed.

Advance Preparation :

Access to a computer with speakers or headset.
Alternatively, access to a computer and a telephone (for audio reception).

Delivery Method :

Group: Internet-based

Intended Participants :

Practitioners wanting a more powerful approach to using Excel.

Approved Audience :

 - NASBA Registry -  - 

Revision Date :

08/01/2012

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.

Comments :

CPE, online, live, webinar, live webinar, CPA, CPAs, continuing professional education, continuing education, accounting, accountants, business, commerce, Microsoft, Excel, data capture

Learning Objectives :

  • Determine whether external data should be linked to or imported into the spreadsheet, then modify and assemble the spreadsheet dataset for analysis and reporting
  • Design and create an interactive spreadsheet
   

Course Contents - Go to Details

  • Incorporating data from external sources into Excel spreadsheets and extending the spreadsheet functionality of externally-acquired data
  • Excel functions and features such as PivotTables and PivotCharts
  • Spreadsheet design considerations
 

Back To Top

Cart is empty
Subtotal: $0.00

Cpethink.com will donate 1% of ALL purchases. See our donations.

Open Live Chat
Coupons and Specials

Payments secure through

Merchant Services by
iTransact Merchant Services


Save 10-25% or more on fees

Or we will assure you that you already have an exceptional rate

 

Showcase Courses

1040 Tax Workshop - 2012
IFRS in the U.S.A.: An Implementation Guide
California’s Regulatory Review for CPAs
Payment Processing Considerations to Comply with IRS and PCI-DSS Regulations & Policies (Video)
Texas Ethics: An Overview for Texas CPAs
Healthcare Reform: Pre-Existing Conditions, Benefit Limits, Rescission & Patient Protection Rules
Spreadsheet Controls Under Sarbanes-Oxley Section 404
Fraud Audit Techniques Using Excel
The Ultimate Guide to Retirement Planning from a Tax Perspective
WordPress 101 - Install, Setup, Use It Today! (Video)
All Courses

 

 

 

Click to verify BBB accreditation and to see a BBB report. Trusted Commerce

CPE for Monday, May 20th, 2013
Copyright© 2002-2013 Cpethink.com
Home | Privacy | Refunds | Login | System Requirements | FAQs | Contact Us | Facebook

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

 
  Continuing Education Cpa - Continuing Professional Education - CPA Continuing Education - CPE for CPAs - CPA CPE - CPE CPA - CPE CoursesCPE CreditsCPE HoursEthics Continuing EducationEthics CPECPE EthicsCPE On LineOnline CPECPE OnlineCPE RequirementCPE RequirementsCPA CPE RequirementCPE TaxTax CPETax Continuing EducationAccountant CPEAccounting CPECPE Accounting