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...
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...
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...
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...
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...
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...
My Top 10 personal favourite Excel keyboard shortcuts
Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...
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...