As technology evolves, finance professionals who embrace digital transformation can struggle to figure out how to get started.
You can use the Access NotInList event to add new values to the combo box control directly and create new records on the fly.
Excel pivot table commands are spread throughout several dialog boxes and context menus, making it difficult to find a feature.
Before investing in data analytics, define and structure the problem statement in detail, specifying your desired outcomes.
A look at Microsoft’s Surface Duo 3, the reMarkable 2, YubiKey 5C NFC, and the Satechi Power Bank for Apple.
Finance professionals apply cloud-based data gathering, external reporting platforms, spreadsheets, and virtual communications.
The new Surface Duo was in development for six years, and it’s the first Microsoft computer running Android.
Data integration, governance, and analytics enable business to implement data lakes, cloud computing, IoT, and NLP.
Many companies are stuck in inertia and overdue for the automation of accounting processes to save time and cut costs.
A look at the Galaxy Note 20 and Note 20 Ultra, Google Pixel 4a, Kobo Forma eBook reader, Galaxy Watch 3.
The latest Gorilla Glass from Corning has a new name, Invictus, and it’s the most unbreakable and scratch-resistant yet.
A new Excel function retrieves historical data related to science, including weather, which will help in business planning.
To keep your organization efficient and effective during COVID-19, assess your online collaboration strategy and tools.
Educators should teach aspiring accountants about Robotic Process Automation’s impact on the finance function.
A new Excel function retrieves historical data for exchange rates, stocks, bonds, ETFs, and mutual funds at various intervals.
You can use Microsoft Word to write letters or emails and personalize them with data from Access in a mail merge.
The changes forced on us by the pandemic might not be temporary, although some might even be very beneficial long-term.
To keep your organization efficient and effective during COVID-19, assess your online collaboration strategy and tools.
Dell XPS 17 business laptop, Western Digital My Book external hard drives, LapGear Home Office Pro lap desk, TwelveSouth Curve stand for Macbooks.
The tech editor reviews Microsoft’s Surface Book 3, Amazon’s Echo Show 8, Fiora Wireless Desk Charger, and Fitbit Charge 4.
Office 365 subscribers now have access to new icons, stickers, and poses of cutout people available under the Icons feature.
MIT has announced a new AI chip for mobile devices that has thousands of memristors and is the size of a piece of confetti.
To stay relevant, accountants must upskill to adapt to a finance function being transformed by robotic process automation.
Digital transformation at big financial companies is slowed due to issues with data volume, management, variety, and velocity.
Companies such as Johnson & Johnson are tapping into Industry 4.0’s potential quality-of-life and cost-of-delivery benefits.
Weigh the particular needs of your team and the company when deciding between electronic data interchange and blockchain.
Google and Apple are collaborating on a solution for tracking the COVID-19 virus using the Bluetooth on smartphones.
Digital technological advances give organizations opportunities to establish or enhance their business continuity plans.
You can use an input mask in Access to make it easier to enter information with a pattern such as general ledger codes.
Excel’s new LET function lets you reuse your earlier logic and solutions for later problems, simplifying building formulas.
A look at the Apple iPhone SE, Microsoft LifeCam, Logitech Digital Office Pro Bundle, TP-Link AC1750 Wi-fi Range Extender.
An effective approach to creating a slide presentation consists of using design elements that help convey your message effectively.
The widespread cancellations of expos, conferences, and seminars have created an uncertain future for event venues.
When implementing new technology, always keep in mind who will be impacted the most: the personnel who’ll be using it.
You can use a slicer to visually filter data and control multiple pivot tables from different data sets in Excel.
Our tech editor looked at the Apple iPad Pro 2020, MacBook Air, Onyx Boox Note 2, and iStorage diskAshur2 storage drive.
You can customize the Quick Access Toolbar to show the commands you use the most, boosting the efficiency of your workflow.
Employers must bridge the digital skills gap to keep up with the increasingly fast pace of technological change in business.
IBM’s Project Debater computer developed communication skills that are now being included in Watson’s Business Services.
There’s a more robust and flexible method for Excel users to easily create a year-over-year statistic in a pivot table.
Find Access records by using the name in the contact table or searching in another table for an address or phone number.
A look at Samsung Galaxy S20 Ultra, Lenovo Foldable ThinkPad laptop, Acer ConceptD 7 laptop, and Moleskine Smart Writing Set.
Some finance professionals resist quitting Excel, but alternatives could boost productivity and data analytics capability.
Excel lets users easily combine several worksheets into a single workbook, but the steps of the process are hard to discover.
With the pace of technological change picking up, companies need to adapt processes rapidly and train staff well to keep up.
Access developers share database development tips, including how to set up a logical system for organizing project files.
Microsoft and Samsung are experimenting with new mobile screens using bendable glass, combining dual displays in one device.
A look at the Lenovo ThinkPad X1 Carbon, foldable Samsung Galaxy Z Flip, Dell XPS 13 2-in-1, and Yamaha Desktop Audio system.
The emphasis on implementing Big Data effectively within an organization is an opportunity for finance professionals.
Algorithmia’s 2020 State of Enterprise Machine Learning report profiles trends for machine learning this year.
Excel lets Windows users create a pivot table with data from multiple worksheets if they have one field in common.
A look at the recently released Surface Pro 7, Motorola One Hyper, Dyson Cryptomic Air Purifier, and Microsoft Seeing AI app.
It’s critical for organizations to put in protocols for buying the software and applications that their employees need.
It’s important to know that Access files don’t behave the same way as other Microsoft Office files and plan accordingly.
Robotic process automation can integrate with AI, machine learning, and data science, but RPA must be governed properly.
There are two channels for reaching the Excel team; there are ways to improve your chances of making a change to the program.
A look at the recently released Surface Pro 7, Motorola One Hyper, Dyson Cryptomic Air Purifier, and Microsoft Seeing AI app.
The web’s inventor, Tim Berners-Lee, offers a global call to action to save the web from manipulation and privacy violations.
Management accountants must ensure that the IT team is protecting the organization’s data to avoid costly breaches.
Use the free downloadable CalendarMaker tool to create printable calendars in Access that help you plan and record your time.
Use core business principles to create a strategy to evaluate, navigate, and reinvent your career path.
Management accountants must ensure that their company’s IT team is on top of cybersecurity prevention and response planning.
When a need arises that can’t be handled by Access’s built-in functions, you can build user-defined functions.
As commercial chatbots get smarter and more diverse, the need for responsible design will become more critical.
An upcoming Excel feature code-named “Natural Language Query” relies on AI to answer questions about data in your workbook.
A look at the recently released Panasonic Toughbook 55, Google Pixel 4, Amazon Echo Buds, and the Mophie Juice Pack Access.
Think Security First! offers practical advice for professionals concerned with cybersecurity in an age of rising cybercrime.
The IAESB revised International Education Standards to boost aspiring and professional accountants’ competencies and skills.
Cryptocurrencies are a new form of assets that raises unusual internal control and financial reporting challenges.
When linking subreports to display other fields to enhance a main report, each subreport can be used more than once.
Digital assistants are smarter than ever due to AI and improvements in natural language processing.
A look at the recently released Microsoft Surface Pro 7, Surface Laptop 3, LG G8X ThinQ smartphone, Langogo Pocket AI Translator.
The new workbook-sharing experience for Office 365 will solve common problems when multiple Excel users collaborate.
To discover what data science can do for finance professionals, start by learning or reviewing modeling basics.
Organizations can cut costs by embracing digital transformation and automation, thus boosting their efficiency levels.
CFOs must spearhead cyber risk management to combat potential security breaches and fraud in an era of rising cybercrime.
RPA has potential benefits for the finance department, including less tedium and wasted time, as well as fewer errors.
The demise of the smartwatch has been predicted since the sales of Apple’s version of the device began to slip.
Office 365 subscribers rejoice: You’ll soon see the new functions XLOOKUP and XMATCH in Excel.
Unauthorized applications that exist on a company’s IT network, known as “Shadow IT,” can present governance problems.
The best data structure is flexible and reflects how the objects on which the data is based exist in real life.
A look at the iPhone 11 Pro, iPhone 11 Pro Max, iPhone 11, Apple Watch Series 5, Garmin Venu GPS Watch.
A Fijian retail company opted against upgrading its information system. Sometimes the status quo is best for business.
A look at the Hasselblad X1D II 50C camera, HiRise wireless charger, StayGo USB-C Hub, and Seagate expansion drive.
Excel’s CONVERT has more than 100 conversion rates built in, so you don’t have to memorize conversion facts.
Verify data before it’s updated and devise a process to undo changes so you can run update queries again if necessary.
As smartphone addiction increases, one answer might be a minimalist phone disconnected from the internet.
In our data-driven era, AI can improve data governance and establish a competitive advantage for any organization.
Help students develop familiarity with data analytics by using Excel, Power BI, and Tableau in introductory courses.
Singapore Management University added three data analytics programs to its accounting curriculum in response to a skills gap.
Apple’s legendary chief design officer, Jony Ive, has announced he will be leaving the company after 20-plus years.
A look at the OnePlus 7 Pro phone, Apple’s iPhone XR, reMarkable Digital Notepad, and the Brother HL-L2350DW laser printer.
Use the Split function in Visual Basic for Applications to break up strings of data so you can run queries.
You can use Excel’s brute-force solving feature to examine all the alternatives of a scenario with many possible permutations.
Agile project management has a number of benefits, but there also are challenges, especially if you aren’t used to using it.
The accounting profession must understand AI and its potential positive—and negative—impacts, including potential bias.
A look at ASUS ZenBook Pro Duo, Apple Mac Pro and Pro Display XDR, Dell Inspiron 27 7000, and the latest Apple iPod Touch.
When shuffling imported data into appropriate tables, the data needs to be normalized, or focused on one category.
Excel offers an Undo stack that will let you undo the previous 100 operations. How do you go back to a certain point in time?
The IoT welcomes inventors of all sorts, even those lacking backers who rely on crowdfunding from Indiegogo and Kickstarter.
Various organizations worldwide were surveyed about their biggest challenges to implementing a data management strategy.
Using chart labels from a separate range of cells, users can label clustered column charts differently.
Management accountants must stay abreast of the latest technological developments and build competencies accordingly.
This month, we look back in time to the Brunsviga Nova Calculator, Osborne 1 computer, Microsoft Multiplan, and HP 12c Platinum Calculator.
How Dan Bricklin and Bob Frankston created the first successful electronic spreadsheet program, VisiCalc.
This second in a series looks at moving imported data to a different destination table based on what the data describes.
In Excel, users can apply VLOOKUP with wildcards to match a number embedded in a longer cell. Faster VLOOKUPs are in the works.
An importing process of append and update queries can combine worksheets into a single table in Access.
This month, we look at the iPad Mini 5, iPad Air, iPad Pro, Samsung Galaxy S10, Google Pixel 3, RAVPower Filehub Plus.
Those working on analytics projects tend to prefer agile project management to traditional project management.
A review of the consequences of the Directive on Copyright in the Digital Single Market passed by the European Parliament.
Tomorrow CEO Mike Walsh advises leaders on how to thrive in the current era of disruptive technological change.
With AI, computers can now process massive databases quickly and offer deeper analyses. But it can also lead to risks.
It’s important to ensure that any new IT implementation delivers gains in both efficiency and effectiveness.
Importing data from Excel requires a proper data structure so the data will be organized for effective use in Access.
Effective organizations must have a detailed plan for responding to, not just reacting to, breaches in cybersecurity.
With the introductions of the Galaxy Fold and Mate X, the foldable smartphone begins its move toward the mainstream.
Create a pivot table that will show a rolling 12 months of sales and have it update automatically.
This month, we look at the Samsung Galaxy Fold, LG V50 ThinQ 5G, F(x)TecPro1, and Microsoft Hololens-2 AR headset.
Finance departments can improve their agility through the adoption of robotic process automation tools and techniques.
This month, we look at the Sony RX100 VI, LibreOffice 6, Omnipage Ultimate, Wemo Mini Smart Plug.
An analysis of the social, economic, and political upheaval that will accompany the four waves of AI.
The Rnd function can be used to return a single random number, but the result generated changes constantly.
With Get & Transform features introduced in Excel 2016, it’s possible to easily produce a pivot table by the day of the week.
Partition, a little-known function in Access, can group numbers into ranges, such as with aging overdue balances.
Save valuable time with this quick, easy trick for filtering data.
This month: LG Signature OLED TV R, Asus Zenbook S13, Withings Move ECG watch, AerBetic Wearable Glucose Sensor.
The OPEN Government Data Act requires federal agencies to disclose information online using machine-readable data formats.
Here’s a better look into the tech trends for 2019 through the first two international expos—CES19 and Mobile World Congress.
Blockchain is changing the way businesses conduct transactions and exchange data. The time is now to adapt and get on board.
Make your database more user friendly by adding pop-up forms to capture additional data or information.
This month: Garmin’s Fenix 5 Plus smart watch, a udoq charging system, mixcder headphones, and an Epson FastFoto scanner.
Like the Geography data type, the new Stocks data type gets current data from the internet for display in your workbook.
How Smart Machines Think by Sean Gerrish offers a detailed explanation of how many of our intelligent machines work.
Get the most out of analytics by establishing a data-driven culture with a effective, efficient approach to data governance.
Assign individual contacts to specific groups for greater flexibility in your contact management system.
Excel’s new Linked Data Types will enable users to get additional data from the internet related to cell contents.
This month we take a look at the new Apple iPad Pro, MacBook Air, Dell Ultrawide Monitor, Mac Mini.
Web 3.0 will be different in many ways, some of which—like the cloud, AI, and IoT—have already appeared online.
A forthcoming IMA study found that implementation of leading-edge analytics is a work-in-progress for most organizations.
According to the 2018 Global SMP Survey, SMPs are increasingly allocating resources to investment in technology.
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.