Creating and Working with Dynamic Charts in Excel

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

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...

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...

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...

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...

Highlight every Nth row in Excel Tables – How To

By default, every second row in Excel tables is highlighted and the other option is to turn highlighting off completely. Though it does help most often but often times we may find a need...

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...

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...