When it comes to power management, the Mac far excels any of the PCs. I have my Mac configured such that it goes to sleep within 30 minutes of it being idle. unfortunately this tends to disrupt my downloads and also prevents me from remote logging in whenever I want to.
Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT. Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
I’m happy to announce the launch of a new WordPress plugin. Popular Authors is an add-on for Top 10 and allows you to display the… Read More »Launching Popular Authors WordPress plugin
In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using formulae. However, Microsoft Excel makes… Read More »How to calculate NPV in Excel using Functions
I’ve covered the basics of Net Present Value (NPV) previously. If you don’t know what NPV is, then please read that post first before continuing.… Read More »How to calculate NPV in Excel using Formulae
As part of my day job, I’ve spent a lot of time working with Microsoft Excel and Microsoft PowerPoint. Not only with 2010, but also with… Read More »2 Tips to become more efficient at Microsoft Excel