Are you a Human Resource or Finance personnel that manages employees’ payroll computation? You will agree with me that in preparing staff payroll there are a number of computations that are required based on statutory requirements and the organization’s policies. In this training, we will look at how to design an Excel template that computes …
How To Compute Employee Seniority Bonus in Excel Automatically Read More »
This training assumes the User has no previous knowledge of Excel. The lessons are systematically arranged to ensure an upward progression in your Excel skills. To assist you in completing the course within the next fifteen (15) days kindly Join the email list HERE to get a notification on action to take on a daily …
How To Get Started with Excel – A Practical Guide Read More »
Accounts receivable also known as debtors are customers that owe your business due to credit sales. This item is captured as current assets on the balance sheet and a vital area of any business financials. If this aspect of your business is not properly managed, it can result in a loss of assets. In this …
Financial Statement is the final output of the completion of an accounting cycle. An accurate accounting entry from the General Journal to the Trial balance will produce a seamless profit or loss and Balance sheet statement. This training is a continuation of “How to Design Charts of Accounts, General Journal, General Ledger and Trial Balance”. …
How To Prepare Financial Statement Statement In Excel Read More »
A well-designed chart of accounts can impact the accounting cycle that results in the preparation of financial statements. The accounting cycle starts with making daily entries of your business transactions into the books of accounts using the double-entry accounting principles. In this training, you will understand the concept of debit and Credit which is the …
Learn Charts of Accounts, & Double Entry Accounting In Excel Read More »
Pivot Table is a great tool that helps you summarize extensive data in order to get a better insight into the data as a whole. Analyzing data can be tasking if you lack the necessary skills. In this video training, I will show you how to use Pivot Table in Excel to analyze any set …
How To Analyze Data Using SymbolsAnalyzing data using symbols and chart helps the end user to better understand the data and make informed decisions. In this training, I will show you a step-by-step approach on how to analyze data on a table using symbols and representing such analyzed data on a chart. Watch the video …
An Excel chart presents your data in a graphical format for easy understanding by the end users. Having an interactive chart on your report will help you compare more data and see performance over time to make informed decisions. In this training, I will guide you on how you can design an interactive Excel chart …
How To Design An Interactive Excel Chart Using Check Box Read More »
When you input a negative number in Excel, by default it displays a minus sign or parenthesis based on the system setting. The custom number formatting feature in Excel changes the appearance of values in a cell without altering the original content. In this training, I will show you how to display negative numbers in: …
If you sell physical goods and tracking your inventory has been a challenge then here is an easy-to-use tool that will do the job for you. When I say tracking your inventory, I mean your ability to keep track of the movement of the goods you buy and sell. Here are the benefits of what …
How To Design An Inventory Tracker Excel Template Read More »
