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.
High Impact Excel: Pivot Table Edition
Following up on the success of his popular High Impact Excel session, this time around David H. Ringstrom, CPA turns his attention to pivot tables. In one hour you'll learn how to whip unwieldy data into shape, and then quickly build meaningful reports by dragging and dropping with your mouse. David will also discuss techniques for improving pivot table data integrity. Detailed handouts with numbered steps will be provided for a variety of Excel versions.