Introduction to Excel Tables – Data beyond just formatting

Many people think converting data into table is basically a formatting options giving it colours and other eye candies like giving data "zebra lines". But there is much more to it beside data formatting...

FREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download...

Everyone loves getting paid but to get paid one needs to send invoice and to make an invoice that is not only effective from a business perspective but also help you get invoicing done...

Excel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of...

In Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind their working through example and explained how pivot table let...

Turn off Excel Table Formulas / Structured references

Although I absolutely LOVE Excel tables and the reason is not just 1 or 5 or 10 but more than 20 to make you awesome in Excel. And one of such reason is structured references which in simple...

10+ Excel features in Home tab that every beginner MUST learn

1 Don't just Paste, Paste Special! Position in tab: Clipboard group>Paste button drop down | Shortcut: Alt+Ctrl+V This one is definitely a speciality in Excel's arsenal of features. Normal paste option only put what you copy...

Stock Ageing Analysis Reports using Excel – How To

Stock is one of the most important investment made by the entity. Optimum quantity and turnover period is essential for entity to be successful. Faster the conversion, better the prospects for entity as inventories...

Building a reference to specific Worksheet based on Cell value using Formula

Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more...

Making dynamic Chart of Accounts, Journal + Ledgers in Excel – How To

Excel is one of the favourite tools for accountants and for everyone else who has anything to do with accounting information. It is a tool of choice when it comes to data extraction and...