|
J. Carlton Collins
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
1. Excel Budgeting, Projections and Cash Flow Forecasting
J. Carlton Collins, CPA - This course specifically addresses the budgeting process, to help CPAs learn how to use linear and exponential regression to create budgets based on prior year actual data. The concepts, features, functions and commands have utility outside the budgeting process. The case study starts with data exported from QuickBooks and Great Plains, and ends by generating a consolidated, seasonally adjusted budget, including balance sheet and cash flow projections. Some of the specific concepts covered are as follows:
1. Introduction to the budgeting concept using basic regression. 2. Scatter Charts & Trend lines. 3. Slope and intercept functions. 4. Growth and Forecast functions. 5. Complex regression budgeting. 6. Linear, Exponential & Logarithmic regression. 7. Budgeting examples using QuickBooks and Great Plains data. 8. Seasonally adjusting your budget. 9. Rounding techniques. 10. Formatting shortcuts and tricks. 11. Testing data for regression – Pearson, Kurtosis, Skew & R Square functions. 12. Over-riding regression values. 13. Documenting budget assumptions. 14. Preparing a balance sheet forecast. 15. Preparing cash flow projections. 16. Budgeting preparation, accuracy, seasonality, accounting software reporting, analysis and investigating budget variances. 17. Consolidating budgets. 18. Forecasting profit and profit margins. 19. Embedded footnotes, including superscripted footnote references.
2. Excel - What's New in Excel 2013
J. Carlton Collins, CPA - Excel 2013 received the most impressive enhancements in Office 2013, making this the most powerful edition of Excel by far. Excel includes dozens of new features, functions, and commands; and specifically you will learn about the 21 enhancements listed below:
1. Quick Analysis - helps you analyze data more quickly by offering data layouts. 2. Flash Fill - watches you work and applies logic to help you complete your tasks. 3. PowerView - enables you to create new report types, such as the interactive map charts. 4. Timeline Slicer - helps you slice and dice Pivot data containing dates. 5. Create Relationships tool – enables you to build PivotTables from multiple data sources. 6. Drill Up and Cross Drill - Drill upward and cross drill to related tables. 7. Improved Edit Mode - edit mode, Excel no longer displays an apostrophe. 8. Excel Instances - Excel now opens each workbook in a separate instance. 9. New PivotTable Tools - decouple PivotCharts so they stand alone. 10. Fifty New Functions – Bring the total number of functions to 450. (1) 11. Recommended Pivot Tables & Charts – To help you work quicker and easier. 12. New Chart Controls - Excel pops up new chart controls. 13. Get A Link – Send Excel workbooks links instead of workbooks via email. 14. Publish Excel Data to Social Media – Embed Workbooks directly in Facebook. 15. Review Tools - new inquire Add-in reviews design, function and data dependencies. 16. Excel Compare tool - similar to Word’s Compare tool. 17. Touch-Screen Enabled – Makes excel accessible on touch-screen mobile devices. 18. Windows 8 Style Tiles – For easy launching and navigation. 19. Cloud-Enabled – Save Excel workbooks directly to your free cloud data storage SkyDrive. 20. Office 2013 Web Apps – a free version of Excel 2013 is available via the cloud. 21. Subscription Pricing – enables you to install Excel on five devices, and run Excel from the cloud.
3. Excel for CPAs - Tips, Tricks and Traps
J. Carlton Collins, CPA - Microsoft Excel is the number one tool for the CPA, and in this course your instructor will provide you with detailed explanations of his top 50 tips and tricks for using Excel, and demonstrate as many as possible. This is a fun one, don’t miss out! Selected example tips are listed below:
Creating Elbows in Excel; Transposing Data; Default settings in Excel; Issues with the 1904 date system; Referencing PivotTables to dynamic table sources; Using the Aggregate function; Sorting Excel data left to right; Mixing formats in a single Excel cell; Navigation Tips; Create Excel links by dragging data; Create formulas in PivotTables; Enable formula auditing tools in Excel; Parsing tips; Foot noting Financials in Excel; Custom Views; Tips for arranging Excel Windows on multiple monitors; Pasting tricks; Displaying a Two-Digit Year; Creating an Excel based portfolio tied to the web; Dragging tabs to creating new worksheets; E-mail a Single Worksheet; Cheating charts and how they can lie; Zoom techniques; Excel's Split screen tools; How to unlock 218 Hidden commands in Excel; Chart printing tips; Two keystroke access to recent files; Recovery tips for unsaved or lost Excel files; Customizing the ribbon and Quick Access toolbar; Get Excel to read to you; Hyperlink tips; Named range tips; Using Sparklines; Creating underlines that don't touch one another; Highlighting tip for summing data; Five tips for using the Excel fill handle; Controlling font sizes in Excel; Tips for sorting PivotTable data; Transparent settings in area charts; Exploring Excel templates online; Tip for locating external links in workbooks; Repeating column tip for PivotTables; Tips creating relative macros; Shortcuts for entering dates, selecting data, and defining names.
4. Fifty Top Tech Tips
J. Carlton Collins, CPA - In this course, you will receive more than 50 top technology tips that you can use to save money, save time, and improve system performance. This course will include tips for configuring Windows, browsing the Internet, operating Excel, using Word, configuring Outlook, purchasing hardware, implementing systems, printing, security, remote communications, software drivers, data organization, printers, computers, laptops, servers, cell phones, web sites, Internet tools, utilities, scanners, optical mice, hand held devices, productivity software, operating systems, accounting software, e-mail applications, and browsers. This course will also include an overview of some of the newest hot productivity products on the market today. Selected example tips are listed below:
Why SD cards are better than thumb drives; Using tags and QR Codes; Portable dual monitors tips for your laptop; Watermarks; Using electronic business card; Animated movies with Xtranormal; Word’s column tool; Inserting dummy paragraphs in Word; Editing the Office dictionary; Customizing folder views; Tips for using solid state drives; Presentation development tool; Portable 4G internet access; Hidden folders; Blocking friends from your wall; Video editing tools; Smartphone app recommendations; Sharing browser favorites on multiple computers; Windows SkyDrive; Hyperlinking to target frames; Clipboard tips; Tool for migrating to a new computer; Tip for displaying Word documents; How to edit in full screen reading mode; Drive-by viruses; IE shortcuts; Organizing Windows Icons; Formatting Bullet Lists; Windows Shortcuts; Windows Calculator; Caps Lock tip; Compressing picture sizes; XPS vs. PDF; Blind copies; Advanced Searching; Backing up cellular phone data; Using autocorrect; QuickBooks' Loan Manager; Internet Explorer Tricks; Windows’ GodMode; Shared Calendars in Outlook; Grouping Reports in QuickBooks; Indexed Searching; Saving Facebook pictures; Entering dates with the number pad; Five tips for using PowerPoint; Using Windows Sticky Notes; Ergonomics tips; Mastering CDs; Outlook Port tip; Outlook 2010 & 2007 Shortcuts.
5. Top 25 Security Measures for CPAs
J. Carlton Collins, CPA - “Information Security” has been listed as the number one technology in the AICPA’s annual listing of top ten technologies for the past 12 years. This course features in-depth coverage of Internet security issues and offers simple and advanced solutions for combating these problems. Some of the topics to be discussed are as follows:
Running anti-virus programs; Software and hardware updates; Firewalls; Password protected screen savers; Encrypting your wireless routers; Encrypting your data files, folders and hard drives; Encrypting your email; Online Backups; Uninterruptible power supplies; Upgrading to Windows 7 or 8; Internet filtering; Using strong passwords; Employee & customer background checks; Computer disposal techniques; Upgrading door locks; Shredding paper; Online security tests; Employee agreements; Periodic computer checks; Physical inventories and surprise cash counts; Be wary of hacking tools; Bolting down computer systems; Filtering spam; Identity theft procedures.
6. Excel Macros
J. Carlton Collins, CPA - Macros offer a powerful and flexible way to extend the features of Excel. They allow the automation of repetitive tasks such as printing, formatting, configuring, or otherwise manipulating data in Excel. In its’ simplest form, a macro is a recording of your keystrokes. While macros represent one of the stronger features found in Excel, they are rather easy to create and use. This courses covers the following major points that CPAs should know about macros.
1. Recording macros and the Stop Recording options. 2. Tips for naming macros. 3. Creating macro-enabled Excel files. 4. Macro Locations – saving macros personal macro workbooks. 5. Assigning macros to icons, text, and objects. 6. Creating macro buttons, including working with buttons. 7. Creating absolute versus relative macros. 8. Editing macros, including combing multiple macros. 9. Testing and reviewing macros. 10. Visual Basic programming comments.
7. QuickBooks 2013 Tips and Tricks - Part 1
J. Carlton Collins, CPA - In this webinar, we have ferreted out the important QuickBooks features and functions that CPAs need to know, but typically are unaware of to bring you up to speed with the product's essential functionality. Your instructor will walk you through core functionality as well as hidden QuickBooks functionality and secrets regarding Invoicing, Time and Billing, Cash Receipts, Cash Flow Projections, Fixed Asset Accounting, Inventory Management, and Financial Reporting. You will learn about the most common mistakes in QuickBooks and how to avoid them.
1. New HTML and hyperlink designed user interface. 2. Paste and save 1,000+ transactions from Excel. 3. Email journal entries that clients can import. 4. A new left pane menu provides improved navigation. 5. Reclassify hundreds of transactions in a single batch. 6. Create a new QB company from an existing QB company. 7. More contact info fields for customers and vendors have been added. 8. You can now customize up to 8 contact fields. 9. The new ribbon layout on customer forms shows more info. 10. New tabs show "transactions", "contacts", "to dos" and "notes. 11. You can now shop for additional QB apps right from QuickBooks. 12. MAC Edition only – Now supports attached documents and batched invoicing. 13. Enterprise only – Bin location tracking, Barcode scanning, a new purchase order button, default item classes, and more accounts, classes, to do's.
8. QuickBooks 2013 Tips and Tricks - Part 2
J. Carlton Collins, CPA - Hang onto your seats. In this course, your instructor will walk you through some of the advanced functionality that lay with QuickBooks regarding consolidating financial statements from multiple companies, managing multiple warehouses, managing unit of measure conversions, linking QuickBooks data to Excel, importing and exporting transactions, linking QuickBooks to web stores, editing row descriptions on financial reports, editing invoice templates, online backups, maintaining fixed assets, pricing inventory, and financial reporting. We will show you how to extract the information you need for use in other applications such as tax software, work paper tools, and Microsoft Office products. You will learn about the latest product developments including Intuit Enterprise Suite.
9. Excel Data Analysis & Data Commands
J. Carlton Collins, CPA - Excel provides an abundance of specialized tools for analyzing data and generating financial reports, yet most CPAs are unaware of these tools or don’t know how to use them. In this course, your instructor will use financial data to demonstrate the following data analysis and reporting tools: Subtotaling, Grand Totaling, Filtering, Consolidations, Grouping & Outlining, Drilling, OLAP Data Cubes, PivotTables, Sparklines, Data bar Reporting, Conditional Formatting, Charting, Foot Notes and End Notes, Formula Auditing Tools, Error Checking, Functions, and Data Analysis Tools. The concepts discussed are intended to directly aide the CPA in summarizing, slicing, dicing and analyzing data, and generating related financial reports.
10.Excel Pivot Tables
J. Carlton Collins, CPA - The PivotTable is widely considered to be one of the most powerful tools in Excel, and perhaps the most useful Excel tool for the CPA. This course covers PivotTables in depth using common CPA data such as general ledger, inventory, and sales order data to name a few. Some of the topics to be covered include the following.
1. Creating, pivoting, filtering and drilling PivotTables and PivotCharts 2. Positioning, copying, relocating, publishing and sharing PivotTables 3. Totaling, sorting, refreshing, and formatting PivotTables 4. Displaying data as values, percentages, differences and running totals 5. Adding calculated columns and fields to PivotTables 6. Working with field lists and drag boxes 7. PivotTable settings, such as autofit, preserve, layout, 8. Slicing PivotTables with data and date slicers and timeline tools 9. Referencing PivotTable data and using the GetPivotData function 10. Grouping, expanding and collapsing PivotTable columns and rows 11. Pivoting multiple tables and disparate data sources 12. Archiving PivotTables, static images, and converting PivotTables to hard data 13. PowerPivot, PowerView, Pivot Maps and Charts 14. Linking PivotTables to dynamic data sources 15. Editing data directly in PivotTables 16. PivotTable layouts, styles, banding, and controlling blank rows
11QuickBooks Consulting
J. Carlton Collins, CPA - The economy may be a bust, but QuickBooks consulting is red-hot and it’s a good time to become a QuickBooks Consultant. In tough times people don’t stop spending, they search for bargains…and when it comes to accounting systems, there is no better bargain than QuickBooks. With 4.5 million companies using QuickBooks, there seems to be an unlimited demand for QuickBooks consultants. Couple this opportunity with the fact that it is rather easy for a CPA to become a QuickBooks consultant, and you have a relatively obvious and easy path to growing your business.
Intuit reports there are 70,000 certified QuickBooks Pro Advisor consultants – about one third of which are CPAs. Intuit further reports that these consultants typically generate approximately $2,800 per year in QuickBooks consulting services (not including tax, compilation, write up, or business advice – it’s purely revenue related to keeping the client’s QuickBooks up and running). Once established, a QuickBooks consultancy grows fast and a good QuickBooks consultant can comfortably serve 30 to 50 QuickBooks clients – building a business that is recession proof and someday sellable when it comes time to retire.
The objectives of this course are to help CPAs become QuickBooks consultants by educating them about the QuickBooks product, the QuickBooks Advisor Program, and QuickBooks consulting activities and services they should render. The end goal is for attendees to be better positioned to find and develop new QuickBooks clients to expand their practice or create a new practice. Specific discussion points to be covered are presented below.
1. Installation, set-up and implementation of QuickBooks. 2. Configuring QuickBooks, assembling, editing and entering starting data. 3. Training clients to properly use QuickBooks. 4. Sample Contracts and agreements. 5. Editing Financial Statements and reports to produce the desired information. 6. Setting up memorized transactions. 7. 25 Step Checklist of the monthly services to be provided by the QuickBooks consultant. 8. Marketing your QuickBooks practice & billing your QuickBooks clients.
Whether you work for a CPA firm or as an individual, this course is designed to help you get started with your own QuickBooks consultancy. If you are a stay at home mom or dad, or a corporate CPA who wants to earn extra income or build another skill or business just-in-case, this course will help you understand what’s involved.
12.QuickBooks Job Costing in Depth
J. Carlton Collins, CPA - Designed for CPAs who use QuickBooks, or consult on QuickBooks job costing situations, this course covers the fundamentals, then dives deep into the intermediate, and advanced features and functions regarding QuickBooks job estimating and job costing.
The course starts by walking attendees through job estimating and job costing transactions – from setup to estimating, to billing and collections. Next the process is repeated in more detail, focusing on intermediate and advanced aspects of these processes such as using job phases and tasks, completed contract versus percentage of completion methods, creating estimates and converting them to jobs, creating purchase orders from job estimates, receiving payments, adjusting pricing levels, customer specific pricing, and more. We will focus on common problems regarding revenue recognition and explore how QuickBooks handles this sensitive area.
In this course you will also learn about several top third-party inventory and job costing add-on modules designed to deliver more job costing power than QuickBooks alone. The objective is to help attendees tackle these complicated business processes using QuickBooks.
13.The Tech-Savvy CPA
Participants will start by answering a simple questionnaire to help determine how Tech Savvy they really are. The questionnaire highlights fifty technologies that CPAs could be using to save time and be more productive. During the course, your instructor will demonstrate these technologies and explain why CPAs should employ them in their everyday work.
Excel Functions
J. Carlton Collins, CPA - Excel 2013 has 450 functions, 88 of which are especially suited for use by CPAs. (The remaining functions, such as CRITBINOMIAL, SOSINE, and TANGENT are better suited for engineers, statisticians, and mathematicians.) In this course, participants will receive a complete listing and explanation of all 450 functions, and your instructor will demonstrate as many of the top 85 functions as time permits. The top 88 functions, according to your instructor are as follows:
15. QuickBooks- What's New in QuickBooks 2014
QuickBooks releases new editions in late August each year, and at that time your instructor will summarize these new features and functions and demonstrate them to you live. At the time of this writing, the new 2014 features were unknown. Please see the webinar description for the QuickBooks 2013 course for an example of what to expect.
16. QuickBooks Inventory in Depth
J. Carlton Collins, CPA - Designed for CPAs who use QuickBooks, or consult on QuickBooks for inventory management, sales order processing and job costing situations, this course covers the fundamentals, then dives deep into the intermediate, and advanced features and functions regarding QuickBooks job estimating, job costing, sales order entry, and inventory management.
The course starts by walking the attendees carefully through a complete set of inventory, sales order, job estimating and job costing transactions – from setup to estimating, to billing and collections. Next the process is repeated in more detail, focusing on intermediate and advanced aspects of these processes such as using job phases and tasks, completed contract versus percentage of completion methods, creating estimates and converting them to jobs, creating purchase orders from job estimates, receiving inventory against jobs, billing jobs, adding inventory to bills, receiving payments, pricing levels, customer specific pricing, price adjustments, margin pricing, average costing, First-in, First-out cost (FIFO), serial number tracking, and more. We will focus on common problems regarding revenue recognition and explore how QuickBooks handles this sensitive area.
In this course you will also learn about several top third-party inventory and job costing add-on modules designed to deliver more inventory and job costing power than QuickBooks alone. By day’s end, attendees will be ready to tackle these complicated business processes using QuickBooks.
17. QuickBooks Financial Reporting
J. Carlton Collins, CPA - Compared to many popular accounting and ERP solutions, QuickBooks reporting is surprisingly powerful, and in this course you will learn about these powerful financial reporting capabilities. Attendees will learn
1. Modifying date ranges, filtering reports & adding columns 2. Stratifying and drilling reports, expanding and collapsing details 3. Emailing reports, including Outlook, Gmail and Hotmail options 4. Exporting reports to Excel, including option, header and gridline settings, 5. Memorizing, grouping and processing multiple reports at the same time 6. Suppressing and displaying account numbers on reports, forcing print breaks 7. Financial Statement Designer (Discontinued in 2008) and the Statement Writer 8. Creating charts, graphs and snapshots 9. The Report Finder & Report Center 10. Using the financial statements options Box 11. Consolidating financial statements for multiple QuickBooks companies 12. Adding custom data to financial statements 13. Actual versus cash basis reporting issues 14. Producing actual versus budget comparison reports 15. Creating budgets 16. Printing QuickBooks financial statements to PDF, XPS and ASCII file formats 17. Querying QuickBooks data from Excel using ODBC drivers 18. password protecting financial statements
18. QuickBooks 2014 Tips and Tricks - Part 1
J. Carlton Collins, CPA - In these two courses, we have ferreted out the important QuickBooks features and functions that CPAs need to know, but typically are unaware of to bring you up to speed with the product's essential functionality. Your instructor will walk you through core functionality as well as hidden QuickBooks functionality. Specifically, you will learn about the following.
1. Accountants Edition – Why this is the only QuickBooks edition you should ever use. 2. Importing Credit Card Transactions – So you don’t have to retype them into QuickBooks. 3. Memorized Frequent Transactions – So they are entered automatically each month. 4. Loan Manager – Set QuickBooks to generate accurate loan payments automatically. 5. Excel Editing – How CPAs can eliminate hours of corrections by editing QB data in Excel. 6. The Intuit Import Kit – A free downloadable tool for importing transactions into QuickBooks. 7. Custom Data Fields – Perhaps the strongest feature QuickBooks has to offer. 8. Calculator Tape – A simple tip every CPA should know about. 9. Prevent Prior Period Changes – How to lock down your adjustments and reviews. 10. Default Date Settings – A simple setting that can prevent a great deal of headaches. 11. CRTL+1 – The merits of the QuickBooks’ Product Information screen. 12. Templates – How to and why you should edit QuickBooks templates. 13. Assessing the Skills of a Potential QuickBooks Bookkeeper – Important insight. 14. Running an Efficient Accounting System – Common sense workflow advice. 15. Reminders – QuickBooks built-in tool to help you stay on top of your workload. 16. Department Accounting – Using the Class feature to set up departmental reporting. 17. Consolidating financial statements for multiple companies – Enterprise only 18. Multiple warehouses – Enterprise only 19. Unit of Measure Conversions - Enterprise only
19. QuickBooks 2014 Tips and Tricks - Part 2
J. Carlton Collins, CPA - Hang onto your seats. In this course, your instructor will walk you through some of the advanced functionality that lay with QuickBooks regarding consolidating financial statements from multiple companies, managing multiple warehouses, managing unit of measure conversions, linking QuickBooks data to Excel, importing and exporting transactions, linking QuickBooks to web stores, editing row descriptions on financial reports, editing invoice templates, online backups, maintaining fixed assets, pricing inventory, and financial reporting. We will show you how to extract the information you need for use in other applications such as tax software, work paper tools, and Microsoft Office products. You will learn about the latest product developments including Intuit Enterprise Suite.
1. Drilling Data – QuickBooks’ drill-down and drill-around capabilities. 2. Company Snapshot – QuickBooks’ graphical charts and tables in dashboard form. 3. Fixed Assets – QuickBooks’ built-in fixed asset solution. 4. Keyboard Shortcuts – A long list of shortcuts to help you navigate QuickBooks faster. 5. Voiding Checks – What CPAs need to know about the void check command. 6. Editing the ICON Bar – Customizing the menu to provide quick access. 7. Checklist for QuickBooks Systems that Running Too Slow – Ten measures you can take. 8. Backup Options – Backing up QuickBooks data online. 9. Networking Limitations – Understanding how QuickBooks File locking works. 10. Deposits – Case study scenario, from Estimates and Orders to Payments and Deposits. 11. QuickBooks Online – A brief discussion of QB online and QBE hosted options. 12. Accountants Copy – An option for sharing QB data between CPA and client. 13. Remote Access – A better option for sharing QB data between CPA and client. 14. QuickBooks Audit Trail – What CPAs need to know. 15. Journal Entry Tips – Memorizing JEs, AJEs, RJEs, and working with allocations. 16. QuickBooks Marketplace – The top QuickBooks industry solutions. 17. Job Costing – The 8 default settings necessary for optimum job costing results. 18. Inventory Tips – Work with items, item pricing, discounts, reports, etc. 19. Financial Reporting – The whole point of an accounting system, studied in depth.
|