Artificial Intelligence is perfect for a range of Finance tasks. Billing, analysis, data processing — in many cases, the mundane but critical duties that require staffers’ time. One major exception? Accounting. The “Big Four” accounting firms (Deloitte, Ernst Young, PricewaterhouseCoopers and KPMG) all agree that AI and machine learning will certainly augment accountant and audit […]
Excel is great for summarizing data in tables, charts and PivotTables. Here are a couple of time-saving methods for summarizing data in Excel that Finance staffers can try: Excel Special Paste The Special Paste feature can be used to copy and paste both static and linked data. To use it, first copy the data that […]
Finance technology is changing all the time. Trends come and go. But the underlying goals of finance teams don’t change much at all. The top goals of teams that manage the invoice‑to‑cash process remains the same — to improve payment timelines and reduce outstanding balances by strengthening customer relationships. A new report — The State […]
AI and machine learning technology is giving companies an edge like they’ve never enjoyed before. Businesses can pinpoint exactly which customers (and which kinds of customers) are more likely to buy their products — and a whole lot more. Such as, when customers are more likely to shop and buy. And of course, at how […]
Can a company’s cybersecurity weakness equate to “ineffective accounting controls?” The Securities & Exchange Commission (SEC) says yes … … but for now, the courts say no. The SEC charged SolarWinds and its chief information security officer (CISO) Timothy Brown with fraud and internal control failures under section 13(b)(2)(B) of the Securities Exchange Act. SolarWinds […]
Fully integrated, automated payments! A dream goal for of many CFOs and controllers. Imagine how much more mission-critical work finance staffers could dig into? Here’s a reality check: If you’re still in the process of transitioning from manual to automated processes, you’re far from alone. Just 5% of mid-sized companies (annual profits between $3 to […]
Excel financial formulas allow users to process accounting data quickly and easily. To use a financial formula in Excel, click on the “Formula” tab along the main tool bar. From the function library, click on “Financial” and select the formula you want to use from the drop down menu. After selecting the formula that you […]
Did you hear about the Snowflake hack? Snowflake is a cloud computing company that got blasted by a series of attacks earlier this spring. Snowflake clients ended up taking most of the shrapnel. Snowflake client Ticketmaster estimates 560 million customer records were stolen/copied. The threat actors (TAs) who breached Snowflake may be responsible for another […]
An Excel database is perfect for organizing — and clearly seeing — financial data. A database includes a series of series of records in rows with fields of data entered in columns. Here are three steps to use Excel as a database: 1. Get Started by Organizing Data To use Excel as a database, your […]
