Creating a database of personal and business contacts begins with storing unique names for each contact.
A new set of powerful array functions in Excel can be used to solve problems and simplify complicated formulas.
This month: Google’s smartphones Pixel 3 and Pixel 3X, the Razer Phone 2, Google Home Hub, and Kobo’s Forma eReader.
The problem with data libraries is that they depend on short-lived hardware and are vulnerable to attack.
This month we look at the iPhone XS, iPhone XS Plus, iPhone XR, Lenovo Yoga Book C930, and the new Apple Watch Series 4.
Management accountants must partner with IT and adopt essential tools to stay involved in business processes and strategy.
Since autumn is now “new smartphone season,” we review some history and the basic numbers for the revolution that continues.
Microsoft is rolling out threaded comments to Excel for Office 365 subscribers, but the old notes system will also remain.
Use conditional formatting to highlight the current record on a form so that it stands out and is easier to focus on.
The Digital Transformation Barometer reveals concerns around social engineering, manipulated content, and data poisoning.
The 2018 Finance Trends Survey Report highlights the areas of the finance function that finance executives are focusing on.
Completing 40 to 60 hours of study in data science can keep you on track to a successful future in management accounting.
This month we look at the Samsung Galaxy Note 9, Apple MacBook Pro 2018, Logitech K780 keyboard, and the Sherpa 40 Power Bank.
As technology changes management accounting, keeping up with the latest developments requires a step-by-step approach.
A new feature coming to Excel lets you build surveys that users can access by scanning a 2-D barcode with their smartphone.
The hackers at Def Con and the researchers at Cisco agree: Hacking is growing and becoming more dangerous.
Building international applications can require more generic designs and advanced settings to display values in local formats.
A survey of individuals at small businesses finds that most employees and company leaders underestimate cyber risk.
The SEC has developed a phased transition plan for organizations to submit financial information using Inline XBRL.
Snapchat can help professors engage their students by illustrating real-world examples, reinforcing key concepts, and more.
As technology takes on an increasingly larger role in operations, business-focused frameworks might not be enough.
The SecureCircle model for corporate cybersecurity embraces Zero Trust, Transparent File Encryption, and Similarity Detection.
This month we look at the Microsoft’s Surface Go, Hippocketwifi, SanDisk Extreme Portable, and Corel Photo Mirage.
Power Query not only makes it easier to get and transform data, but you can also teach Excel to automate the process.
The Windows region settings influence how date and time values are displayed. In Access, this can impact certain data types.
Increased adoption and standardization efforts are moving blockchain beyond proof of concept and into operations.
This month we look at the Asus ZenBook Pro 15, Unihertz Atom smartphone, WordPerfect Office X9, Sony Wireless Earbuds.
With the Data Model and the new DAX function CONCATENATEX, you can display text fields in pivot tables.
Don’t let the specialized language and new technology scare you away from cryptocurrencies. Even novices can get involved.
Use symbols and characters in the Format property to control how date and time values are displayed.
Understanding the typical phases of data resource management can help an organization establish its data governance protocol.
This month: reMarkable tablet, Logitech’s Keys-to-Go keyboards, Nest smart security camera, and the Dymo LabelWriter 4XL.
Have a monthly close process or other processes with a series of tasks? Create a checklist in Excel using custom icon sets.
When entering date or time values, Access is very flexible at recognizing variety of different formats.
Trades and transactions in cryptocurrencies like bitcoin can be taxable events and need to be properly reported to the IRS.
The key to effective data management lies in smart governance, technology integration, and process improvements.
Taking notes by hand leads to greater comprehension and retention compared to typing notes into a laptop.
This month we look at the Apple iPad 9.7, ZeroLemon Battery Case, iPhone Special Red edition, and Dyson Wi-Fi Air Purifier.
With the built-in Consolidate tool, you can combine data sets from multiple worksheets (or workbooks) into one.
Will achieving human-level machine intelligence be followed by superintelligent machines? What might the consequences be?
IMA’s updated Competency Framework will outline key skill areas management accountants will need to master in the digital age.
With nonfinancial information growing in importance, ensuring its integrity is vital. Internal controls and technology can help.
With a wrapper function written in VBA, you can use Excel’s built-in functions, like PMT, throughout your database.
A survey identifies best practices and areas for improvement for IT audit and internal audit leaders and professionals.
In today’s ever-changing technological world, companies are turning to the CFO to manage and oversee cyber risk management.
IBM’s Lori Victor Feller talks about digital strategies, being a first mover vs. fast follower, and disruptive technologies.
This month we look at the Samsung Galaxy S9/S9 Plus, Lenovo 300e Chromebook, Asus Zenfone 5Z, and Nokia 8110 4G.
Artificial intelligence has a very positive side and a seriously threatening one. Both require a culture of responsibility.
With a VBA script, Access users can leverage Excel’s built-in functions such as PMT, which calculates the periodic payment for an annuity.
The new TEXTJOIN formula available to Office 365 subscribers offers significant improvements over CONCATENATE.
Materials, machines, and models are vital to staying ahead of the AI curve. Even traditional companies can adapt to compete.
A new tool, named Insights, can analyze your Excel data for patterns and identify unusual or interesting facts.
A recent innovation in the Internet of Things, digital twins could have a dramatic impact on product manufacturing and more.
With VBA, you can create your own functions to use throughout a database—in forms, queries, reports, and even code.
This month we look at Bitdefender Antivirus 2018 and Bitdefender Box 2, the Spot-R Sensor, and the Apple HomePod.
These four steps will help finance leaders take advantage of the value-creation opportunities that RPA can provide.
Technology is rapidly changing the business environment. Companies need to stay ahead of the curve or risk obsolescence.
Changes in technology should be undertaken through the lens of IT governance and benefit the whole organization.
With VBA, you can modify an SQL statement to change the content of a list box based on other parameters on the form.
The focus of data processing is shifting from the centralized cloud to the edges, where much of the data is generated.
We look at HP Spectre x360 convertible laptop, Lenovo Smart Display, Optoma Home Projector, Soofa Bulletin Board.
Microsoft is rolling out a new feature that lets users deselect unwanted cells after selecting multiple cells or ranges.
Management accountants can use their experience with performance measures to help companies monitor and evaluate IT risks.
SQL and VBA provide a lot of neat functionality in Access. Take your first step in learning about SQL with this example.
We revisit the question of machine imagination and creativity with the Lovelace Test and Chef Watson from IBM.
New technologies and the internet’s culture of openness are transforming business reporting and data analytics.
We look at Sony Bravia A1E smart TV, Samsung Gear S3 smartwatch, MikMe wireless microphone recorder, SanDisk iXpand Base.
Don’t use formulas that calculate the same answer repeatedly. Improve calculation times by using a helper range.
When working with a form, add subforms to display relevant, updated data and other information drawn from multiple tables.
We look at Google Home, Kindle Oasis 2, Nixplay digital picutre frames, and the Razer smartphone for gamers.
Use a disconnected pivot table to generate a worksheet title that always shows the dates selected for a Timeline slicer.
During the Year of AI, the conversation turned to an old question about AI—can machines show imagination and act creatively?
Both individuals and companies need to be educated and work together to combat the ever-growing cybersecurity threats.
Implementing XBRL with the right cloud-based solutions greatly improve financial and business reporting processes.
Rather than replace management accountants, robots will help elevate them from bean counters to strategic business partners.
Cybercrime is a dynamic risk. To avoid a costly security setback, organizations must learn to recognize the warning signs.
The cybersecurity industry has grown immensely for both private and government entities. Each sector has its own challenges.
Using Excel’s Power Query tools, you can convert delimited data within a cell or column into new rows.
Information warfare and cyberwarfare are different from espionage and warfare in the past, and they may be more dangerous.
We look at Google’s Pixel 2 and 2XL, Microsoft’s Surface Book 2, the Google Home Max assistant, and the August Smart Lock Pro.
Embedding forms in Access is useful for streamlined data entry and better organization of relational data.
Eye tracking provides a concrete representation of the most efficient and effective data visualizations for management accountants.
Brad Monterio and Anne Leslie-Bini discuss RegTech, a way to leverage technology to help companies remain compliant.
A combo box in Access allows you to display values a user can choose from. This is especially useful for a list of customers.
Microsoft added a feature called AutoSave. While it affords Co-Authoring, it also prevents you from closing without saving.
The iPhone deserves most of the credit it has been given as a prime mover of the mobile revolution.
This month we look at the iPhone X, iPhone 8, iPhone 8 Plus, Apple Watch Series 3, and the Volterman Smart Wallet.
Organizations need to be informed about the many avenues hackers might use to execute costly data breaches and prepare accordingly.
A free downloadable tool can turn data from a query into a calendar that shows important dates and information for a month.
This month we look at the Tab S3, Keeper Security Password app, Samsung DeX Station, and a perpetual calendar.
With a subscription to Office 365, you no longer have to wait for the next version to come out before you get new features.
While artificial intelligence and technology may threaten certain sectors, a forward-thinking professional can stay ahead of the curve.
As the blockchain revolution ramps up, the trust economy prepares for its impact. Just how disruptive will the technology be?
SAP and Oxford Economics look at how accounting and finance roles are evolving in response to the digital economy.
Excel-based projects help students learn how to apply management accounting concepts in practical business scenarios.
This month we look at a Dell 2-in-1 laptop, the HTC U11 smartphone, a Louis Vuitton smartwatch, and Nikon’s KeyMission 170.
Use data visualizations in Access to show if a value has increased, decreased, or stayed the same.
Excel normally uses 15 digits of precision, but some features now appear to be using 17, which can cause unexpected problems.
Management accountants need to be aware of new technology and keep themselves updated on the latest trends.
There are important differences between printed text and the electric text created on word process running on computers.
Critics of the SEC’s proposed requirement to use Inline XBRL note that many software vendors aren’t prepared for it.
While some may have forgotten about them, there are powerful commands available in the Excel Paste Special dialog.
This month we look at the Asus ZenBook Flip S (UX370), Apple iPad Pro 10.5, Apple Home Pod, and Rocketbook Wave Notebook.
It’s possible to use Unicode characters, such as blocks or half blocks, to display a simple bar graph in an Access query.
A review of Nick Bilton’s book American Kingpin: The Epic Hunt for the Criminal Mastermind behind the Silk Road.
A look at the tools, skills required, and other information needed to increase the analytics capability of your organization.
Contrary to popular belief, a significant proportion of knowledge work can be standardized. CFOs can lead the way.
The integration of domain knowledge, technical ability, and analytical skills can lead to successful projects.
This month, we look at the Microsoft Surface Laptop, Amazon Echo Show, VeriMark Fingerprint Key, and OWC Thunderbolt 3 Dock.
A recorded macro for sorting data won’t work if the number of rows in the data changes. Use this VBA code instead.
Microsoft is increasing its efforts to regain its position in the education sector with an OS geared toward the classroom.
Using the Immediate If function in a query, you can group accounts receivable into different age categories and track totals.
Continuous Accounting modernizes the financial close process by embedding automation and more into day-to-day activities.
With Excel’s iterative calculation option, using the reciprocal method is much simpler and more efficient.
Lead a business transformation by partnering with data scientists to unlock the potential of data and technology.
Use the Expression Builder to create formulas in many different places, including fields, queries, and tables.
A recent book looks into the engineering and politics that go into the manufacturing of computer hardware.
Follow this simple but nonintuitive trick to use the Function Arguments dialog when creating a formula with nested functions.
iPad Tablet 5th generation, Samsung Galaxy S8, UE Wonderboom Bluetooth speaker, SandDisk iXpand drive.
Used for calculations, validating data, and setting default values, formulas are a critical element of Access databases.
A look at how Basware business software is incorporating Artificial Intelligence in its products and processes.
A new Excel feature for Office 365 users lets you set the default layout for any pivot table you create.
A look at the Nokia 3310, BlackBerry Key One, Sony Xperia XA1, and Lenovo Miix 320.
Because of its predictive and learning abilities, cognitive computing is expanding into many areas of business.
A new framework for accounting information systems will help accounting education keep pace with changes in technology.
With AI dominating headlines, preventing these intelligent machines from enabling fraud remains a significant concern.
A neat trick that involves sorting data while grouped by subtotal is a powerful way to manipulate your data.
CTL J5X Chromebook, daVinci Mini 3D Printer, Lenovo Yoga 910, Ventev s500 Charging Hub.
When a field contain numerical data, there are several different data type and field size options to choose from.
After a 30-year period of development, AI may finally be seeing its great realization in 2017.
Protiviti and ISACA find that IT audits and technology issues are getting more attention at the board and executive levels.
New technologies will push the role of accountants further away from bean counting toward business coach and advisor.
The launch of the quantum communications satellite Micius could provide a path forward for computer security.
Management accountants are in a key position to help companies leverage nonfinancial reporting for long-term sustainability.
Lenovo Phab 2 Pro, Lenovo Smart Assistant, Acer Predator Z301CT, Cota Ceiling Tile Wireless Charger.
Excel doesn’t have a function that returns a fiscal-year quarter number. These solutions will get you the results you need.
Selecting the correct data type for your fields can make all the difference in creating a successful database.
Organizations need to go the extra mile and not only ensure the security of their data but safeguard its privacy as well.
Satechi Smart Charging Stand, Seagate 5TB Portable Hard Drive, Logitech Create iPad Pro, FitBit Flex 2 Fitness Wristband
Even the most high-profile tech luminaries were vulnerable to being hacked in 2016. Is a quantum satellite the answer?
Management accountants need to remain ahead of the IT curve, learning about blockchain and its potential business impact.
There are a couple of solutions to consider when the MATCH formula won’t recognize matching items in two lists.
Designing an effective database begins with the how you organize and structure the data within tables.
3D printing can have a significant impact on traditional supply chain logistics as well as product development and prototyping.
Automate your manual accounting processes to free up your accounting and finance team to focus on driving performance.
Big Data isn’t just for giant corporations. There are many tools and solutions for budgets and companies of any size.
When using dates, Excel usually assumes a traditional calendar. The Data Model can help if you use something different.
Put the commands you use regularly on the QAT and avoid having to search through the various tabs and ribbons.
The smartwatch has been in development for 88 years and is still having trouble finding adopters. Why?
Microsoft Surface Studio, Microsoft Surface Book i7, MacBook Pro 2016, Kodak Ektra.
Discover the latest in must-have technology: Google Pixel, Google Home, Netgear Arlo Pro, Quad Lock Car Mount.
Despite the vast impact that computers have had on the world, there’s no Nobel Prize for computing. It’s time for a change.
After applying the Subtotals feature, use this technique to move the subtotals into a separate column from your data.
After creating a report with the Report Wizard, it’s often necessary to tweak the design so it’s easier to read.
Keep these important tips in mind when implementing a new system or software package at your company.
iPhone 7, Apple Watch Series 2, Echo Dot, SignalVault.
A new tool from Microsoft enables users to create and share a number of interactive reports.
How to build a report for product sales grouped by year, month, and day.
There are some positive benefits to being a gadget enthusiast.
The first in a series on moving from predictive to prescriptive analytics.
Our computers and robots are getting smarter, which raises the question: Will they achieve consciousness?
Galaxy Note7, Instax Share SP-2, Logitech iPad Cover CREATE, AUKEY Power Bank.
Add code that will limit the records displayed in a report based on user-entered criteria.
A user encounters a problem after a computer upgrade: All new workbooks only print in black and white.
Open source accounting software is becoming an increasingly popular choice. Management accountants need to know the benefits and downsides.
Use a tab control to organize the controls on a menu form and create a better user experience.
The discontinuation of the BlackBerry Classic is a sign of the inevitability and persistence of change.
Use conditional formatting to highlight cells or rows in different colors, depending on their values.
Management accountants need to stay abreast of the latest technology trends and developments that could help on the job.
HP Spectre 13, New Kindle, Garmin Fenix 3, iRoller Cleaner.
Pen and paper might finally face a serious challenge from the digital world with Apple’s pencil and the Surface stylus.
Dell Inspiron 2-in-1 laptop, Innova8, Apple App Store, Notability, NuBryte Touchpoint
This solution frees users from having to type the same series of values with the creation of each new workbook.
Menus provide a simple, direct solution for helping users navigate your database.
Cal Poly Pomona uses a hands-on, learn-by-doing approach to teach its students about cybersecurity and computer information systems.
Use the results of aggregate calculations to create other statistics for your Access report.
Be a collaborative business leader by understanding your organization’s IT general controls and leveraging them for continued success.
Use an array formula with conditional formatting to highlight the smallest value greater than zero.
Philips SpeechAir recorder, Punkt. MP01, Kindle Oasis, Apple HomeKit, Hesperus
Personal digital assistants have developed slowly, but they now have human voices and deep learning capabilities.
An Excel add-in makes it easier to analyze text and comments fields from survey results.
Samsung Galaxy TabPro S, iPad Pro 9.7, iPhone 6s Plus, BrydgeAir Keyboard
Within a single month, both Apple and Microsoft got embroiled with the government in legal disputes over privacy.
Turn your data into grouped reports with subtotals and summaries.
When the economy isn’t doing well, prioritizing investments in IT can be difficult. These strategies can help.
Corporate performance management software helps CFOs broaden their thinking to better contribute to the overall health and longevity of the organization.
Use custom number formats to flag cells in a large range to avoid a potential slowdown in performance.
Management accountants are in a prime position to help ensure better data governance and quality.
Loaded with chips, software, and various computer systems, our cars are now hackable in ways most of us wouldn’t consider.
Samsung Galaxy S7 Edge, LG G5, Garmin Vivoactive HR.
Use a crosstab query to help create a chart that tracks monthly sales by category.
The late-January Excel update included the new CONCAT, TEXTJOIN, IFS, SWITCH, MAXIFS, and MINIFS functions.
Another AI milestone looms with the upcoming match between Google’s AlphaGo and Lee Sedol, the human world champion of Go.
Display two different sets of data on the same chart in Access.
Management accountants need to be prepared to master the newest technology innovations in accounting.
HP Spectre x2 2-in-1, My Passport Ultra external drive, ThinkWare DashCam, Pulse Solo LED light with JBL Bluetooth speaker.
Hackers launch another attack against the IRS, this time using stolen personal data.
Corporate performance management software can provide better automation and information gathering to help financial professionals make better, more informed decisions.
Reduce calculation time and improve efficiency by using related tables and the Power Query tool.
The ThinkPad X1 Tablet, Sony USB Turntable, Oculus Rift VR, D-Link DIR-879 Wi-Fi Router.
A variety of factors influence how nonprofit organizations use technology and online tools.
Tracking monthly data? Use a query to create a running sum for your results.
The website with the 7th-highest traffic worldwide provides 5 million encyclopedia articles free in 250 languages.
A new Excel feature makes it easy to combine an entire folder of CSV files into one workbook.
Data leakage is a bigger threat to companies than hacking or data breaches.
Create charts and graphs in Access to present your data visually.
Olympus Tough TG-4, Epson Expression Home XP620, Tylt Vu wireless charger, Eton emergency light.
The World Economic Forum solicited predictions about the future of software and society.
Big Data skills should be supported with “big empathy” skills to improve the quality of data.
Custom number formatting applied to a pivot table doesn’t stay after the pivot table is changed, but there’s a way around it.
The LG Urbane 2 smartwatch, an entry-level Roku, the Alpha 2 Robot, and the Nest Security Cam.
The next version of Bluetooth will be twice as fast, reach four times as far, and will be able to connect to other networks.
A look back at the key strategies and functions covered in previous columns.
Excel doesn’t recognize dates very well. This process can help convert your data into the right format.
Management accountants can harness the Internet of Things to improve data collection, analysis, and decision making.
The DSUM function is an effective tool for creating running totals for use in queries.
New tablets from Amazon and Google, a mini desktop computer from Acer, and smartwatches from Samsung
Think Bigger explains how Big Data is created, collected, stored, cataloged, and used in more than 18 industries.
Under new CEO Satya Nadella, Microsoft has reinvented itself to fit today’s computing world.
Create business reports in XBRL GL format to enhance reporting and decision-making capabilities.
The newest version of Excel contains several improvements.
Identify, analyze, recommend, and implement the technologies that will bring your organization to the next level.
The Intelligent Personal Assistant field is getting a little crowded with Google, Microsoft, Facebook, and Amazon joining Apple’s Siri.
Three new products from Apple, including two new iPhones, a very large iPad Pro, and an improved Apple TV.
A recent IMA survey of senior finance professionals looks at their concerns regarding cybersecurity.
You can create a process similar to Excel’s Fill Handle to fill in incomplete data in a table.
The pains of creating waterfall charts are gone with the release of Excel 2016.
A simple table and update query can fix dates that are imported from Excel as number values.
Dell offers three rugged tablets that can survive the outdoors and the assembly line.
Take advantage of the latest trends in mobile computing while ensuring that company data and information remain secure.
Companies like Automated Insights now provide computer-generated stories and financial reports for outlets like the AP, Yahoo!, and the NFL.
The IRS raised its estimate of people affected by the May 2015 cybersecurity breach.
Add data visualizations to quickly show if an amount has increased or decreased from one period to the next.
IT governance is an issue that affects all finance professionals, not just those in top management.
ASUS released the ZenPad S 8.0, the latest competitor to Apple’s iPad Mini.
The breach at the Office of Personnel Management compromised personal information and more for 21 million federal employees and contractors.
Duplicate records are inevitable. Create a process that will check for and remove duplicates from your data.
Force Excel to repeat any calculation 359 times in a single formula.
Microsoft’s latest OS is an ambitious attempt to create a universal engine that can run on all platforms.
Windows 10 will be a free update that will operate across all platforms.
IMA’s Technology Solutions & Practices Committee has put together a list of top technology trends for 2015.
Access and Excel have different strengths that you can take advantage of within a single project.
The primary concerns of security, access, control, reliability, and quality should be familiar to any management accountant.
If you’re having difficulty bringing data into your database, these importing basics and tips should help.
Prescriptive analytics allow companies to better gauge customer profitability and reach potential new markets.
The Excel 2013 Data Model lets you combine your budget data and actuals into one pivot table.
Tesla introduces a revolutionary home battery for solar power systems and simple backup against blackouts.
Technology has failed to provide a paperless office, but don’t blame the machines.
The NSA program that collected millions of Americans’ data has been found unlawful by a federal court.
Consumers support replacing magnetic-strip cards with embedded-chip ones, but they haven’t done so on their own.
Management accountants need to raise their technical intelligence to keep pace with today’s rapidly changing technologies.
Excel 2013 lets you build pivot tables with data from more than one source.
As the power and effectiveness of computing continues to increase, the progress is producing even greater discounts.
The MID and INSTR functions help you manipulate text from your data.
Microsoft adds the lower-priced Surface 3 to its tablet line to directly compete with Apple’s iPad.
Users haven’t changed their behavior online despite greater awareness of privacy concerns.
Tracking, settling, and reconciling intercompany transactions can be a burdensome process. Technology offers a solution.
The Apple Watch is finally available for purchase, and we also review the Samsung Galaxy S6 and two keyboards.
Use multiple queries to link and combine different data sets together so you can create the report layout you want.
The latest survey of emerging cyber threats from Georgia Tech shows that the links exploited most often are human, not digital.
Software-as-a-Service applications provide small businesses with a number of major advantages over in-house solutions.
An approximate match VLOOKUP is a simple alternative to a long series of nested IF functions.
IMA’s Technology Solutions & Practices Committee has launched a new online community on LinkUp IMA.
Add to Selection and Go To Special are two useful tools for selecting multiple ranges.
Up to 80 million individuals have been affected.
FSCM has different meanings in different contexts, but they share the common theme of improving financial operating processes.
The story of the much-hyped device successfully captures the corporate vision that drove Steve Jobs.
Combo boxes can help users find data and limit the output of reports.
Reviews for the Lenovo Yoga Tablet 2, Eero Wi-Fi System, InkCase Plus, and Amazon Kindle Convert.