Budget Vs Actual – Analyzing Profit and Loss Statements in Excel using Pivot tables
This tutorial is effectively a continuation of last tutorial on profit and loss statements using pivot tables in which we learnt how to make a report in Excel using pivot tables feature to make...
Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...
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...
How to convert numbers into words in Excel – VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words....
Create Waterfall Charts in Excel – Visualize Income Statements!
A waterfall chart in Excel is a great way to visualize running totals making it super easy to understand how addition and subtraction of values affected starting value and how we reached the final...
40+ Excel navigational shortcuts to make accounting job super efficient
With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K...
Payroll calculation in Excel – Piecework with Guaranteed wage – How To
This Excel tutorial is part of:
Payroll calculator with Piece Work wage payments in Excel - How to
To access complete list of payroll calculation tutorials for piece work wage system visit this page.
Payroll calculations under...
Conditional Charts in Excel – Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone...