The AICPA Code of Professional Conduct: What You Need to Know
The American Institute of Certified Public Accountants is the rule-making and standard-setting body of the CPA profession. AICPA membership is not a requirement of the CPA profession, but it does help accounting professionals stand out by proving they’re being held to...The California Accountancy Act: What You Need to Know
The California Accountancy Act (CAA) is the enabling act of the California Board of Accountancy, and is the comprehensive framework for Certified Public Accountants in California. It gives the California Board of Accountancy authority to license, regulate, and...Why Professional Ethics Are a Cornerstone of the Accounting Industry
Why Professional Ethics Are a Cornerstone of the Accounting Industry The core of the accounting profession is simple math; debits equal credits, assets equal liabilities plus equity. And, as we know, math and numbers are the same across all languages, and they...
Top Excel Tips
I should not even be telling this story but here goes. My husband took an Excel course yesterday and came home all excited to share the tips he learned. Yes, I too wondered why he was taking an Excel course when he could ask me a question or better yet – read my blog...
Plotting Empty Cells
I received a call from my daughter yesterday. She was totally frustrated as she was trying to plot data for a class project that contained a lot of empty cells. I told her how to fix it and then learned that these suggestions would not work on a MAC. As I helped her...Fill & Sign Forms-Adobe Acrobat DC
Fill and Sign PDF Forms Open the PDF that you want to fill in and sign using Adobe Acrobat DC. Click the Fill & Sign tool located in the right hand pane. Click in a field and start typing.Adobe may suggest responses based upon previously entered data or stored...
Find & Select Constants
I just discovered this little timesaver and thought I would share it with you. Okay, to be honest, my husband told me about it. Suppose you have an Excel spreadsheet and you have a number of product codes all in one row and need to break them out. You can do text to...
Let’s Get Rid of =GetPivotData
=GetPivotData If you use pivot tables a lot, then you have run into the GetPivotData formula. The other day, I was trying to create a formula referencing some pivot table cells and the GetPivotData formula popped up when I did not want it to. Today, I read Debra...