You can't easily tell at a glance if a cell is locked or not, but Excel expert David Ringstrom shows you how to add a visual aid. As an added bonus, the technique also makes it far easier to lock and unlock worksheet cells.
Want to know where the next major tax reform legislation is coming from? You might check on Facebook, Twitter, or LinkedIn. Senate Finance Committee Chairman Max Baucus and House Committee on Ways and Means Chairman Dave Camp said they'll ask the public for tax law proposals via social media.
According to news reports filtering out of Washington, the IRS will begin employing new technology this year that can track a taxpayer's online activities ranging from Facebook and Twitter posts to credit card and PayPal transactions.
By its very nature as a spreadsheet, it's easy to create a series of numbers in Excel. But most users don't realize that you can configure Excel to create a series of letters in a similar fashion. Excel expert David Ringstrom explains how.
Big data is not without big obstacles for some CIOs. In a survey from Robert Half Technology, 76 percent of chief information officers (CIOs) said their companies don't presently gather customer data, such as demographics or buying habits.
Cary Walkin, a CA and video game enthusiast in Canada, found a novel way of using Excel for something other than number crunching. Walkin, who is also an MBA candidate at the Schulich School of Business, created a video game using nothing but Excel.
Spreadsheet users frequently insert rows and columns into spreadsheets, but for most users, it's a multiple-step process. Excel expert David Ringstrom explains how you can create your own custom shortcut to insert rows or columns with a single keyboard shortcut or mouse click.
How many times have you heard someone say, "I'd rather chew nails than go to the dentist?" Believe it or not – with my tongue firmly planted in my cheek – there are still some accounting professionals who would rather chew nails than move some or all of their practice to the Cloud.
It's every spreadsheet user's worst nightmare – you've worked on a workbook for a period of time, and then accidentally close it without saving. Or the power goes out, or Excel crashes . . . the list of spreadsheet hazards goes on and on.
A survey conducted by Bill.com of corporate financial executives shows a shift toward mobile money management. Two-thirds of respondents reported they now process at least some of their financial transactions on mobile devices.
So you have a client that wants to make the jump from QuickBooks Pro, Premier, Mac, or Enterprise? This is indeed exciting news, and I shall happily guide you through this process. Come with me, and let's go down this path together. I promise you're in good hands; I've been doing this for a very long time.
Excel 2013 has arrived, and for the most part, it's much like Excel 2007 and 2010, but with some spiffy new features, such as Recommended Charts and Pivot Tables, Flash Fill, Quick Analysis, Power View, and more.
The AICPA framework for evaluating technology-related controls and other safeguards used by Cloud service providers has been endorsed by CSA, a not-for-profit organization that promotes best practices on security assurance within Cloud computing.