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 »
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 …
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 »
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 hide a cell content with value and still reference that cell in a formula – You will notice that even though the cell content is hidden, …
HOW TO HIDE CELL VALUES USING CUSTOM NUMBER FORMATTING Read More »
The DATEDIF Excel function calculates the number of days, months, or years between two dates. The DATEDIF function is one of the undocumented functions in Excel. This means that when you input the Excel function it will not pop up any suggestion as Excel will do for all other functions that are documented. The good …
Inserting page numbers as a footer in an Excel file with more than one page makes it easy for the reader to know the order of the pages and the sequence for better understanding when reading through the document. Having a single-page document with a footer that reads “2 of 5” implies that the document …
HOW TO INSERT PAGE NUMBER FOOTER IN AN EXCEL FILE Read More »
Having a good knowledge of how the printing options in Excel work will help you print document better. To print multiple copies of a multiple-page document in Excel, you have two options to explore: First is the collated option that allows you to print the entire pages of the document in multiple copies. …
In a two-way lookup, you will have to get the value at the point of intersection of a column and a row. In such a scenario, you will have two criteria to test. We shall use the knowledge from advanced lookup functions to generate this dynamic report from an extensive database using a two-way lookup. …
