The new Microsoft Excel LET Function
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula....
Read MoreHow to use the AVERAGEIF and AVERAGEIFS Functions
AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.Syntax AVERAGEIF(range, criteria,...
Read MoreHow to change text cases in Microsoft Excel
Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER,...
Read More
Fetching Live Data from Kobo using Power Query
Power Query for Excel allows you to fetch/pull your Live Data from Kobo Data Collection database (submissions). Use the power of Power Query to Extract, Transform and Load your data to Excel
Read More
Dynamics 365 Business Central Adoption Guide
The most successful companies are already reaping the rewards of digital transformation. Digital transformation enables organizations to attract the best talent, empower employees, and deliver innovative products and services all with streamlined operations—centered around exceptional customer experiences.
Read MoreBusiness Owners Guide to Replacing Accounting Software
Replacing your accounting software is easier and more affordable than you may think. Use this guide to learn about the...
Read More
Excel Add-In for Dynamics NAV
Excel Add-In for Dynamics NAV Read, Write, and Update Dynamics NAV from Excel Your Dynamics NAV Data, Your Way! The...
Read More
How to Connect QuickBooks Data to Excel
As an accounting application designed for small businesses, QuickBooks and QuickBooks Online have relatively robust reporting options. In addition to...
Read More
Download Inventory Control Template
Use this Stock Control Template to monitor your stock in, stock out and sales. Use the summary sheet to get the YTD, Week to Date, and Month to date this year and last year reports
Read MoreKenya Revenue Authority PAYE 2021 Excel Formula
Here is a beautiful formula to help you calculate the new Income Tax amount based on 2021 Rates
Read More
