Excel is one of the prominent spreadsheet programs or suite offered by Microsoft that has received a warm welcome by all fields and sectors. Spreadsheets are application programs that enable…
Analysis of huge amounts of data is very crucial. Humans have for long been in the process of devising newer ways that are more efficient to manipulate data. It all…
Excel is a spreadsheet program that helps us manipulate data in cells. A cell is an intersection between a row and a column. A row in excel is a horizontal…
Many businesses handle lots of documents and a lot of repetitive tasks each day and this may slow down the processing processes. You can decide to automate your accounting task…
Formatting cells to be different from other cells makes them to stand out and get noticed. Conditional formatting enables you to create rules that automatically change the cells formatting based…
SUMIF excel function is used to sum values between a different date range. The cells values are added based on specific criteria or a set of conditions. SUMIF function is…
You can compare data in a column and match the content to a different column. Different Excel formula can be used to compare two columns, find the matches in the…
A macro is an excel feature used to automate tasks. As an accountant, you always carry out repetitive task each day and you can automate some of those tasks to…
This tutorial is suitable for individuals who generate reports for complex data processes using Ms. Excel charts, Gantt charts, Pivot tables among other tools. What is excel dashboard? A dashboard…
