Subscribe
[…]
Search results for ""
| Results 1 - 10 of 581 | Page 1 of 59 |
| Sorted by: Relevance | Sort by: Date | Results per-page: 10 | 20 | 50 | All |
Popular Articles on Techtites
Popular this week All time […]
7 free applications to prevent your Mac from sleeping
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. I’ve been hunting for a good application that keeps my Mac from falling asleep. Before you proceed with installing a new utility, keep in mind that preventing you Mac from sleeping has to be done with care, especially when the lid is closed. This can cause your Mac to […]
Two Variable Data Tables in Microsoft Excel Tutorial
In my last post, I taught you how to create a Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variables data table. This allows you to flex two different variables simultaneously to see the output. This tutorial assumes that you are comfortable with creating a single variable data table. We’ll once again be looking at our Compound Interest example where you will be calculate what the amount you will receive at a certain interest rate after a specific period of time. You can also skip to the bottom of this post […]
Data Tables in Excel tutorial
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. Data Tables are an extremely powerful tool when used carefully. They give you insight on outputs for a varying level of inputs. In this post, I’ll explain to you how a single variable data table can be created via an example. I’ll be using Microsoft Excel 365 but this tutorial will also apply to older versions of Excel. Excel Help describes a […]
How to use Signal on your Desktop
If you’ve been following the press over the last week, you’d have noticed a large exodus of users from WhatsApp to Signal and Telegram. I am one of them and I’ve written about why I chose Signal as my primary messenger. Like me, if you’re familiar with WhatsApp web and have used it extensively, then you’ll be pleased to know that Signal has you covered via their desktop apps as well as one for your iPad. The latter in particular is fantastic if you use your iPad a lot and find it easier to respond there with a full keyboard. […]
Launching Popular Authors WordPress plugin
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 top authors on your blog based on the number of views that your posts receive. The plugin uses the number of views that are tracked by Top 10. This plugin came as a request from an existing user of Top 10 and I noticed that there isn’t a similar free plugin in the WordPress repository – at least not one that has been recently updated! Popular Authors can be used in three ways: Widget: simply […]
How to calculate NPV in Excel using Functions
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 it easy for you with two inbuilt functions. The first is NPV (surprise!) and the second is XNPV (my favourite). NPV From the official help article, NPV takes the following syntax: The function uses the following arguments: Rate Required. The rate of discount over the length of one period Value1, value2, … Value1 is required, subsequent values are optional. 1 to 254 arguments representing the payments and income Value1, value2, … must be equally spaced […]
How to calculate NPV in Excel using Formulae
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. After reading this post, you will be able to learn how to use Excel to calculate NPV of cash flows. This tutorial will teach you how calculate the NPV using formulae. Although this is a more detailed approach to calculate NPV, it gives you more flexibility vs. using the in-built Excel NPV functions. Using this method, you will: Calculate the discount factor that is to be applied in each year based on a specific discount rate […]
Scanned PDF to Word Conversion Proves That Brain Is Better Than Brawn
“There’s a way to do it better – find it. Thomas A. Edison”. These are the wise words of Thomas Edison and, by all means, he was right. In today’s digital world, working in informational technology means constantly seeking to improve and develop in each field. It is crucial to always discover new and interesting ways to do better, to increase productivity and to get things done in the most efficient way. Since everything is changing rapidly, people need to learn how to be effective in simple daily tasks. One thing that has become a usual work routine is managing […]