<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Techtites</title>
	<atom:link href="https://techtites.com/feed/" rel="self" type="application/rss+xml" />
	<link>https://techtites.com</link>
	<description>Byte-sized bites of technology</description>
	<lastBuildDate>Sun, 04 May 2025 22:51:55 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	<generator>https://wordpress.org/?v=6.8.1</generator>

<image>
	<url>https://techtites.com/wp-content/uploads/2023/07/cropped-Techtites-Logo-100x100.png</url>
	<title>Techtites</title>
	<link>https://techtites.com</link>
	<width>32</width>
	<height>32</height>
</image> 
	<item>
		<title>Optimise Images for Free: 5 WebP/AVIF Converters to make your Website faster</title>
		<link>https://techtites.com/webp-avif-converters/</link>
					<comments>https://techtites.com/webp-avif-converters/#respond</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Sun, 04 May 2025 22:51:55 +0000</pubDate>
				<category><![CDATA[Design and Development]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Compression]]></category>
		<category><![CDATA[File Conversion]]></category>
		<category><![CDATA[images]]></category>
		<category><![CDATA[Software]]></category>
		<category><![CDATA[Tool]]></category>
		<guid isPermaLink="false">https://techtites.com/?p=12495</guid>

					<description><![CDATA[Optimising images is a no-brainer if you care about website speed, SEO, or user experience. WebP, developed by Google, delivers [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/webp-avif-converters/">Optimise Images for Free: 5 WebP/AVIF Converters to make your Website faster</a> was first posted on May 4, 2025 at 10:51 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>Optimising images is a no-brainer if you care about website speed, SEO, or user experience. WebP, developed by Google, delivers superior compression without noticeably sacrificing quality — a win-win for performance and aesthetics.</p>



<p>The best part? <a href="https://caniuse.com/webp" target="_blank" rel="noreferrer noopener">All modern browsers now fully support WebP</a>. You can also take it a step further with AVIF, the next-gen format offering even better compression — and yes, most of the tools below support that too.</p>



<p>Here are five excellent <strong>free online WebP converters</strong> that make switching to modern formats quick and painless.</p>



<h2 class="wp-block-heading"><strong>1. TinyPNG</strong></h2>



<figure class="wp-block-image size-large"><img fetchpriority="high" decoding="async" width="1024" height="588" src="https://techtites.com/wp-content/uploads/2025/05/TinyPNG-1024x588.webp" alt="" class="wp-image-12620" srcset="https://techtites.com/wp-content/uploads/2025/05/TinyPNG-1024x588.webp 1024w, https://techtites.com/wp-content/uploads/2025/05/TinyPNG-768x441.webp 768w, https://techtites.com/wp-content/uploads/2025/05/TinyPNG-1536x882.webp 1536w, https://techtites.com/wp-content/uploads/2025/05/TinyPNG-2048x1176.webp 2048w" sizes="(max-width: 1024px) 100vw, 1024px" /></figure>



<p>TinyPNG has been my trusty companion for image compression for a long time. Initially renowned for its PNG and JPEG optimisation, it&#8217;s now embraced WebP and AVIF formats. The interface is delightfully simple — drag and drop, select &#8220;Convert my images automatically&#8221;, and let it work its magic. For WordPress users, their plugin offers seamless integration, allowing the optimisation of up to 100 images monthly for free.</p>



<div class="wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex">
<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://tinypng.com/">TinyPNG</a></div>



<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://wordpress.org/plugins/tiny-compress-images/">TinyPNG WordPress plugin</a></div>
</div>



<h2 class="wp-block-heading"><strong>2. Squoosh</strong></h2>



<figure class="wp-block-image size-large"><img decoding="async" width="1024" height="588" src="https://techtites.com/wp-content/uploads/2025/05/Squoosh-1024x588.webp" alt="" class="wp-image-12621" srcset="https://techtites.com/wp-content/uploads/2025/05/Squoosh-1024x588.webp 1024w, https://techtites.com/wp-content/uploads/2025/05/Squoosh-768x441.webp 768w, https://techtites.com/wp-content/uploads/2025/05/Squoosh-1536x882.webp 1536w, https://techtites.com/wp-content/uploads/2025/05/Squoosh-2048x1176.webp 2048w" sizes="(max-width: 1024px) 100vw, 1024px" /></figure>



<p>Developed by Google, <a href="https://squoosh.app/">Squoosh</a> stands out for its versatile features in image optimisation, including WebP conversion. Its real-time preview functionality lets users fine-tune compression settings, striking the perfect balance between image quality and file size. Squoosh&#8217;s simplicity and effectiveness cater to a wide range of users, offering an excellent platform for image optimisation.</p>



<h3 class="wp-block-heading"><strong>3. BIRME</strong></h3>



<figure class="wp-block-image size-large"><img decoding="async" width="1024" height="588" src="https://techtites.com/wp-content/uploads/2025/05/Bulk-Image-Resizing-Made-Easy-1024x588.webp" alt="" class="wp-image-12622" srcset="https://techtites.com/wp-content/uploads/2025/05/Bulk-Image-Resizing-Made-Easy-1024x588.webp 1024w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Image-Resizing-Made-Easy-768x441.webp 768w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Image-Resizing-Made-Easy-1536x882.webp 1536w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Image-Resizing-Made-Easy-2048x1176.webp 2048w" sizes="(max-width: 1024px) 100vw, 1024px" /></figure>



<p><a href="https://www.birme.net/">BIRME</a>, an acronym for Batch Image Resizing Made Easy, excels in bulk image resizing and offers WebP conversion as part of its toolkit. This online tool streamlines the process for those dealing with extensive image libraries. BIRME&#8217;s user-friendly interface and batch-processing capabilities make it a practical choice for projects requiring efficient image conversion.</p>



<div class="wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex">
<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://www.birme.net/">BIRME</a></div>
</div>



<h3 class="wp-block-heading"><strong>4. Bulk Resize Photos</strong></h3>



<figure class="wp-block-image size-large"><img decoding="async" width="1024" height="588" src="https://techtites.com/wp-content/uploads/2025/05/Bulk-Resize-Photos-1024x588.webp" alt="" class="wp-image-12623" srcset="https://techtites.com/wp-content/uploads/2025/05/Bulk-Resize-Photos-1024x588.webp 1024w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Resize-Photos-768x441.webp 768w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Resize-Photos-1536x882.webp 1536w, https://techtites.com/wp-content/uploads/2025/05/Bulk-Resize-Photos-2048x1176.webp 2048w" sizes="(max-width: 1024px) 100vw, 1024px" /></figure>



<p>BulkResizePhotos is all about speed and privacy. Operating entirely in your browser, it ensures your images never leave your device. The tool excels in rapid batch conversions, offering options to resize, compress, and convert to WebP or AVIF. It&#8217;s my go-to when I need quick results without compromising on privacy.</p>



<div class="wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex">
<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://bulkresizephotos.com/">Bulk Resize Photos</a></div>
</div>



<h2 class="wp-block-heading"><strong>5. ShortPixel</strong></h2>



<figure class="wp-block-image size-large"><img decoding="async" width="1024" height="588" src="https://techtites.com/wp-content/uploads/2025/05/ShortPixel-1024x588.webp" alt="" class="wp-image-12624" srcset="https://techtites.com/wp-content/uploads/2025/05/ShortPixel-1024x588.webp 1024w, https://techtites.com/wp-content/uploads/2025/05/ShortPixel-768x441.webp 768w, https://techtites.com/wp-content/uploads/2025/05/ShortPixel-1536x882.webp 1536w, https://techtites.com/wp-content/uploads/2025/05/ShortPixel-2048x1176.webp 2048w" sizes="(max-width: 1024px) 100vw, 1024px" /></figure>



<p>ShortPixel&#8217;s online tool is a powerhouse for image optimisation. Beyond converting to WebP or AVIF, it offers intelligent compression that maintains image quality. The online tools allow you to drag and drop (or select) up to 50 files, and I have found this to have better compression than Tinypng generally. This has become my go-to image compression tool, replacing Tinypng.</p>



<p>Their plugin integrates seamlessly for WordPress users, automating the optimisation process and even serving images via their CDN for enhanced performance. It&#8217;s a comprehensive solution for those serious about site speed.</p>



<div class="wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex">
<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://shortpixel.com/online-image-compression">ShortPixel Online Tool</a></div>



<div class="wp-block-button"><a class="wp-block-button__link wp-element-button" href="https://wordpress.org/plugins/shortpixel-image-optimiser/">ShortPixel WordPress plugin</a></div>
</div>



<h2 class="wp-block-heading">Final Thoughts</h2>



<p>Each of these free online WebP converters has its strengths — whether you want granular control, lightning-fast bulk conversion, or just a smooth drag-and-drop experience. Adding them to your image workflow can drastically reduce page load times and improve Core Web Vitals.</p>



<p><img src="https://s.w.org/images/core/emoji/15.1.0/72x72/1f449.png" alt="👉" class="wp-smiley" style="height: 1em; max-height: 1em;" /> Want WordPress integration? <strong>TinyPNG</strong> and <strong>ShortPixel</strong> have free plugins.<br><img src="https://s.w.org/images/core/emoji/15.1.0/72x72/1f449.png" alt="👉" class="wp-smiley" style="height: 1em; max-height: 1em;" /> Need speed and privacy? <strong>BulkResizePhotos</strong> runs 100% in-browser.<br><img src="https://s.w.org/images/core/emoji/15.1.0/72x72/1f449.png" alt="👉" class="wp-smiley" style="height: 1em; max-height: 1em;" /> Like fiddling with settings? <strong>Squoosh</strong> gives you all the knobs and sliders.</p>



<p>No matter your needs, there’s a tool here that’ll save you time and bandwidth. Your users (and your PageSpeed score) will thank you.</p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/webp-avif-converters/">Optimise Images for Free: 5 WebP/AVIF Converters to make your Website faster</a> was first posted on May 4, 2025 at 10:51 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/webp-avif-converters/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>7 free applications to prevent your Mac from sleeping</title>
		<link>https://techtites.com/7-free-applications-to-prevent-your-mac-from-sleeping/</link>
					<comments>https://techtites.com/7-free-applications-to-prevent-your-mac-from-sleeping/#comments</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Wed, 27 Jan 2021 15:21:23 +0000</pubDate>
				<category><![CDATA[Apple]]></category>
		<category><![CDATA[Lists]]></category>
		<category><![CDATA[Mac]]></category>
		<category><![CDATA[Software]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Utilities]]></category>
		<category><![CDATA[apps]]></category>
		<category><![CDATA[sleep]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=4880</guid>

					<description><![CDATA[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.<hr style="border-top: black solid 1px" /><a href="https://techtites.com/7-free-applications-to-prevent-your-mac-from-sleeping/">7 free applications to prevent your Mac from sleeping</a> was first posted on January 27, 2021 at 3:21 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>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&#8217;ve been hunting for a good application that keeps my Mac from falling asleep.</p>



<p>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 overheat in the long run. Remember, your Mac needs regular rest just like you and me!</p>



<h2 class="wp-block-heading"><a href="https://www.intelliscapesolutions.com/apps/caffeine" target="_blank" rel="noreferrer noopener">Caffeine</a></h2>



<figure class="wp-block-image"><img decoding="async" src="https://techtites.com/wp-content/uploads/2012/05/Caffeine.png" alt="Caffeine" title="Caffeine"/></figure>



<p>Caffeine is a tiny program that puts an icon in the right side of your menu bar. Click it to prevent your Mac from automatically going to sleep, dimming the screen or starting screen savers. Click it again to go back. Right-click (or ⌘-click) the icon to show the menu.</p>



<p>This is one of the most popular programs that I have found that does this job. While it is very easy to use, it is limited in features.</p>



<h2 class="wp-block-heading"><a href="http://www.sticksoftware.com/software/Jiggler.html" target="_blank" rel="noreferrer noopener">Jiggler</a></h2>



<figure class="wp-block-image"><img decoding="async" src="https://techtites.com/wp-content/uploads/2012/05/Jiggler.gif" alt="Jiggler" title="Jiggler"/></figure>



<p><strong>Jiggler</strong> is a little freeware app with one purpose: to keep your Mac awake. Jiggler just wiggles your mouse every once in a while, keeping your machine awake and happy. When you want to stay awake, run it. When you don&#8217;t want to, quit it. You can even run it while you&#8217;re working, because you can set it not to wiggle your mouse unless your computer has been sitting idle for a while.</p>



<h2 class="wp-block-heading"><a href="https://github.com/integralpro/nosleep" target="_blank" rel="noreferrer noopener">NoSleep</a></h2>



<figure class="wp-block-image"><img decoding="async" src="https://techtites.com/wp-content/uploads/2012/05/NoSleep.png" alt="NoSleep" title="NoSleep"/></figure>



<p><strong>NoSleep</strong> makes closing of your MacBook lid possible without going to a sleep mode. Now you shouldn&#8217;t have to plug your mouse and monitor to stay computer awake &#8211; just activate it by clicking a menu bar icon or check a tick in the System Preferences and continue downloading huge files and watching favorite movies over the network with lid closed.</p>



<h2 class="wp-block-heading"><a rel="noreferrer noopener" href="https://apps.apple.com/us/app/owly-prevent-display-sleep/id882812218?mt=12" target="_blank">Owly</a></h2>



<figure class="wp-block-image size-thumbnail"><img decoding="async" width="150" height="150" src="https://techtites.com/wp-content/uploads/2021/01/Owly-150x150.png" alt="" class="wp-image-12269" title="Dont Sleep" srcset="https://techtites.com/wp-content/uploads/2021/01/Owly-150x150.png 150w, https://techtites.com/wp-content/uploads/2021/01/Owly.png 460w" sizes="(max-width: 150px) 100vw, 150px" /></figure>



<p>Say hello to Owly, a cute little fellow who lives in your Mac’s menu bar and does its best to prevent your Mac from automatically sleeping. What this means is that Owly ensures your Mac’s screen never goes dim, no screen savers appear and that your Mac doesn’t enter sleep mode.</p>



<p>By right clicking the Owly icon on the menubar, the app can toggle on/off. When the icon is red, Owly is active and will keep your Mac wide awake. When the icon is black, the app is no longer actively ensuring your Mac doesn’t enter sleep.</p>



<h2 class="wp-block-heading"><a rel="noreferrer noopener" href="https://apps.apple.com/us/app/amphetamine/id937984704" target="_blank">Amphetamine</a></h2>



<figure class="wp-block-image size-large"><img decoding="async" width="230" height="230" src="https://techtites.com/wp-content/uploads/2012/05/Amphetamine.png" alt="" class="wp-image-11605" srcset="https://techtites.com/wp-content/uploads/2012/05/Amphetamine.png 230w, https://techtites.com/wp-content/uploads/2012/05/Amphetamine-150x150.png 150w" sizes="(max-width: 230px) 100vw, 230px" /></figure>



<p>Amphetamine can keep your Mac, and optionally its display(s), awake through a super simple on/off switch, or automatically through easy-to-configure Triggers. Amphetamine is extremely powerful and includes advanced features for those who need them, yet remains intuitive and easy-to-use for those who don&#8217;t need all of the bells and whistles.</p>



<h2 class="wp-block-heading"><a href="https://en.wikipedia.org/wiki/Pmset" target="_blank" rel="noreferrer noopener">pmset</a></h2>



<p>pmset manages power management settings such as idle sleep timing, wake on administrative access, automatic restart on power loss, etc. This comes inbuilt within your Mac and you can activate it by opening a new Terminal window and running:</p>



<pre class="wp-block-code"><code>pmset noidle</code></pre>



<p>To exit pmset, simply hit Control+C and your Mac will go to sleep as per your settings.</p>



<p>Are you already running any of these utilities on your Mac? If so, which is your favourite application?</p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/7-free-applications-to-prevent-your-mac-from-sleeping/">7 free applications to prevent your Mac from sleeping</a> was first posted on January 27, 2021 at 3:21 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/7-free-applications-to-prevent-your-mac-from-sleeping/feed/</wfw:commentRss>
			<slash:comments>2</slash:comments>
		
		
			</item>
		<item>
		<title>Two Variable Data Tables in Microsoft Excel Tutorial</title>
		<link>https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/</link>
					<comments>https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/#comments</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Fri, 22 Jan 2021 18:00:00 +0000</pubDate>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Microsoft]]></category>
		<category><![CDATA[Office]]></category>
		<category><![CDATA[Software]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[data tables]]></category>
		<category><![CDATA[microsoft excel]]></category>
		<category><![CDATA[tutorials]]></category>
		<category><![CDATA[What-If Analysis]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=571</guid>

					<description><![CDATA[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.<hr style="border-top: black solid 1px" /><a href="https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/">Two Variable Data Tables in Microsoft Excel Tutorial</a> was first posted on January 22, 2021 at 6:00 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>In my last post, I taught you how to create a <a href="https://techtites.com/data-tables-in-excel-tutorial-thursday/" data-type="post" data-id="522">Single Variable Data Tables in Excel</a>. 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.</p>



<p>This tutorial assumes that you are comfortable with creating a single variable data table.</p>



<p>We&#8217;ll once again be looking at our <a href="http://en.wikipedia.org/wiki/Compound_interest">Compound Interest</a> 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 to download the example.</p>



<figure class="wp-block-image"><img decoding="async" src="https://techtites.com/wp-content/uploads/2014/02/2varDT_01.png" alt=""/></figure>



<p>Create a new excel file and lay it out as shown in the screenshot above. Alternatively, you can start with the excel file from our previous example. In cell A5, enter the formula <code>=B1*(1+B2)^B3</code>.</p>



<p>As you can see, the $5,000 invested at 7.5% for 5 years will give $7,178.15.</p>



<p>A reminder of the formula for calculating compound interest:</p>



<p>A = P * (1 + r/n) ^ nt</p>



<p>Where:</p>



<ul class="wp-block-list"><li>P = principal amount (initial investment)</li><li>r = annual interest rate (as a decimal)</li><li>n = number of times the interest is compounded per year</li><li>t = number of years</li><li>A = amount after time t</li></ul>



<p>We will be varying the annual interest rate and the number of years to find the varying results.</p>



<p>After you have created the file according to the screenshot above, select the data range <strong>A5:F10</strong>.</p>



<p>In Excel, go to <strong>Data &gt; What-If Analysis &gt; Data Table</strong> or you can use the shortcut key <em>Alt + D + T</em> in this order in Windows.</p>



<figure class="wp-block-image"><a href="http://techtites.com/wp-content/uploads/screenshots/1varDT_03.png"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_03.png" alt="Select Data &gt; What-If Analysis &gt; Data Table" title="Select Data &gt; What-If Analysis &gt; Data Table"/></a></figure>



<p>This will popup a window where you will be asked to enter Row Input Cell and the Column Input Cell. Select the Column Input Cell as <strong>$B$2</strong> and the Row Input Cell as <strong>$B$3</strong> and hit OK.</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/2varDT_02.png" alt="Enter parameters for the Data Table" title="Enter parameters for the Data Table"/></figure>



<p>The cells will be populated as shown in the screenshot below. As usual, you can choose to format the same currency.</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/2varDT_03.png" alt=""/></figure>



<h2 class="wp-block-heading">How does it work?</h2>



<p>Cells B6:F10 hold the formula <code>{=TABLE(B3,B2)}</code>.</p>



<p>Here, the values B4 to F4 are substituted for B3 in the formula in cell A5 and values A6 to A10 are substituted for B2 in the formula in cell A5 and the results are then populated accordingly.</p>



<p>Hence, for 1 year at 8%, the amount is $5,400, for 3 years at 10%, the amount is $6,655.00 and so on.</p>



<p>You can download the sample XLSX file for your reference.</p>



<a  data-e-Disable-Page-Transition="true" class="download-link download-button aligncenter" title="" href="https://techtites.com/download/two-variable-data-tables-example/?tmstv=1752259457" rel="nofollow" id="download-link-10627" data-redirect="false" >
	Download &ldquo;Two Variable Data Tables example&rdquo;	<small>TwoVariableDataTable.zip		&ndash; Downloaded 3925 times		&ndash; 4.14 KB</small>
</a>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/">Two Variable Data Tables in Microsoft Excel Tutorial</a> was first posted on January 22, 2021 at 6:00 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/feed/</wfw:commentRss>
			<slash:comments>8</slash:comments>
		
		
			</item>
		<item>
		<title>Data Tables in Excel tutorial</title>
		<link>https://techtites.com/data-tables-in-excel-tutorial-thursday/</link>
					<comments>https://techtites.com/data-tables-in-excel-tutorial-thursday/#comments</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Wed, 20 Jan 2021 01:00:00 +0000</pubDate>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Microsoft]]></category>
		<category><![CDATA[Office]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[data tables]]></category>
		<category><![CDATA[excel tutorial]]></category>
		<category><![CDATA[function]]></category>
		<category><![CDATA[microsoft excel]]></category>
		<category><![CDATA[tutorials]]></category>
		<category><![CDATA[What-If Analysis]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=522</guid>

					<description><![CDATA[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.<hr style="border-top: black solid 1px" /><a href="https://techtites.com/data-tables-in-excel-tutorial-thursday/">Data Tables in Excel tutorial</a> was first posted on January 20, 2021 at 1:00 am.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>Data Tables is also an advanced topic in Microsoft Excel that falls under the category of <a href="http://en.wikipedia.org/wiki/What-if_analysis" target="_blank" rel="noreferrer noopener">What-If Analysis</a>. 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&#8217;ll explain to you how a single variable data table can be created via an example. I&#8217;ll be using Microsoft Excel 365 but this tutorial will also apply to older versions of Excel.</p>



<p>Excel Help describes a data table as:</p>



<blockquote class="wp-block-quote is-layout-flow wp-block-quote-is-layout-flow"><p>A data table is a range of cells that shows how changing one or two variables in your formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) will affect the results of those formulas. Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your worksheet.</p></blockquote>



<h2 class="wp-block-heading">Defining the problem</h2>



<p>Consider a case of <a rel="noreferrer noopener" href="http://en.wikipedia.org/wiki/Compound_interest" target="_blank">compound interest</a>, where you invest a certain amount of money in a bank deposit and the amount is compounded every year.</p>



<p>Formula for calculating compound interest:</p>



<p>A = P * (1 + r/n) ^ nt</p>



<p>Where:</p>



<ul class="wp-block-list"><li>P = principal amount (initial investment)</li><li>r = annual interest rate (as a decimal)</li><li>n = number of times the interest is compounded per year</li><li>t = number of years</li><li>A = amount after time t</li></ul>



<p>Now, if suppose we want to see what the final amount will be at different interests rates, we can use a data table.</p>



<h2 class="wp-block-heading">The solution</h2>



<p>Open a new excel file and enter the following as given in the screenshot below:</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_01.png" alt=""/></figure>



<p>The cell B5 has the formula <code>=B1*(1+B2)^B3</code></p>



<p>As you can see, the $5,000 invested at 7.5% for 5 years will give $7,178.15.</p>



<p>Now, we will create a data table to see what amount we will receive by changing the interest rate.</p>



<p>Fill cells A6 to A10 with different interest rates. I&#8217;ve filled it with values from 6% to 10%. Now, select the cells A5:B10.</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_02.png" alt="Select A5:B10" title="Select A5:B10"/></figure>



<p>In Excel, navigate to <strong>Data &gt; What-If Analysis &gt; Data Table</strong>. You can use the shortcut key <em>Alt + D + T</em> in this order in Windows.</p>



<figure class="wp-block-image"><a href="http://techtites.com/wp-content/uploads/screenshots/1varDT_03.png"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_03.png" alt="Select Data &gt; What-If Analysis &gt; Data Table" title="Select Data &gt; What-If Analysis &gt; Data Table"/></a></figure>



<p>This will popup a window where you will be asked to enter Row Input Cell and the Column Input Cell. Select the Column Input Cell as <strong>$B$2</strong> and leave the Row Input Cell blank and hit OK.</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_04.png" alt="Data Table prompt" title="Data Table prompt"/></figure>



<p>The values will be filled in as shown below. You can choose to format them as currency, but that I have left it up to you.</p>



<figure class="wp-block-image"><img decoding="async" src="http://techtites.com/wp-content/uploads/screenshots/1varDT_05.png" alt=""/></figure>



<h2 class="wp-block-heading">How it works?</h2>



<p>Well, we did get the results, but the question remains on what just happened.</p>



<p>To understand this simply, the Column Input Cell is the variable whose value we are going to vary. If supposing the data was presented horizontally instead of vertically which is our case, then you would need to select it as a Row Input Cell.</p>



<p>The values in cells A6 to A10 are then passed to the formula in cell B5 and the corresponding results are populated in cells B6 to B10.</p>



<p>If you look at cells B6 to B10, they contain the formula <code>{=TABLE(,B2)}</code></p>



<p>Can you try creating a Data Table using a Row Input Cell? Why don&#8217;t you post your solution below or on your blog and post a link below in the comments area.</p>



<p>We created a One Variable Data Table. The next step is learning how to create a <a href="https://techtites.com/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/" data-type="post" data-id="571">Two Variable Data Table</a>.</p>



<a  data-e-Disable-Page-Transition="true" class="download-link download-button aligncenter" title="" href="https://techtites.com/download/one-variable-data-table/?tmstv=1752259458" rel="nofollow" id="download-link-10593" data-redirect="false" >
	Download &ldquo;One Variable Data Table&rdquo;	<small>OneVariableDataTable.zip		&ndash; Downloaded 4109 times		&ndash; 8.68 KB</small>
</a>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/data-tables-in-excel-tutorial-thursday/">Data Tables in Excel tutorial</a> was first posted on January 20, 2021 at 1:00 am.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/data-tables-in-excel-tutorial-thursday/feed/</wfw:commentRss>
			<slash:comments>3</slash:comments>
		
		
			</item>
		<item>
		<title>How to use Signal on your Desktop</title>
		<link>https://techtites.com/how-to-use-signal-on-your-desktop/</link>
					<comments>https://techtites.com/how-to-use-signal-on-your-desktop/#respond</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Tue, 19 Jan 2021 19:30:00 +0000</pubDate>
				<category><![CDATA[Messengers]]></category>
		<category><![CDATA[Software]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[how to]]></category>
		<category><![CDATA[messenger]]></category>
		<category><![CDATA[tutorials]]></category>
		<guid isPermaLink="false">https://techtites.com/?p=11573</guid>

					<description><![CDATA[If you&#8217;ve been following the press over the last week, you&#8217;d have noticed a large exodus of users from WhatsApp [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/how-to-use-signal-on-your-desktop/">How to use Signal on your Desktop</a> was first posted on January 19, 2021 at 7:30 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>If you&#8217;ve been following the press over the last week, you&#8217;d have noticed a large exodus of users from WhatsApp to <a href="https://signal.org/" target="_blank" rel="noreferrer noopener">Signal</a> and <a href="https://telegram.org/" target="_blank" rel="noreferrer noopener">Telegram</a>. I am one of them and I&#8217;ve written about <a rel="noreferrer noopener" href="https://ajaydsouza.com/im-switching-to-signal/" target="_blank">why I chose Signal as my primary messenger</a>.</p>



<p>Like me, if you&#8217;re familiar with WhatsApp web and have used it extensively, then you&#8217;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.</p>



<h2 class="wp-block-heading">Step 1: Install Signal on your mobile</h2>



<p>Simply visit <a href="https://signal.org/install">https://signal.org/install</a> on your phone and it will direct you to the correct location to install Signal i.e. the App Store for iPhone users and the Google Play Store for Android users.</p>



<p>Once installed, open the app and follow the setup instructions which requires you to provide it with your phone number and verify this with an incoming one-time-password.</p>



<h2 class="wp-block-heading">Step 2: Download Signal for Desktop</h2>



<p>Once you have installed Signal on your mobile, you can then go ahead and install Signal on your desktop. The first step is to visit the <a rel="noreferrer noopener" href="https://signal.org/download/" target="_blank">Get Signal page</a> and on the right you&#8217;ll notice links to download Signal for Desktop. You have clients for Mac, Windows and Linux.</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img decoding="async" width="684" height="590" src="https://techtites.com/wp-content/uploads/2021/01/Download-Signal-for-Desktop.png" alt="Download Signal for Desktop" class="wp-image-11576"/><figcaption>Download Signal for Desktop</figcaption></figure></div>



<p>You can hit the nice blue button and download the software for your computer (in my case it is for Mac). Once downloaded, open the installation file. For Mac, you just need to drag Signal into your Applications folder. On Windows, you&#8217;ll run through the typical installer.</p>



<h2 class="wp-block-heading">Step 3: Link Signal for Desktop</h2>



<p>Once installed, you can open Signal on your desktop and you&#8217;ll be presented with a screen similar to the screenshot below. The square in the centre holds a QR Code which you&#8217;ll need to scan using your phone &#8211; I&#8217;ve blanked it out in the screenshot.</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img decoding="async" width="795" height="607" src="https://techtites.com/wp-content/uploads/2021/01/Link-Signal-for-Desktop.png" alt="" class="wp-image-11579" srcset="https://techtites.com/wp-content/uploads/2021/01/Link-Signal-for-Desktop.png 795w, https://techtites.com/wp-content/uploads/2021/01/Link-Signal-for-Desktop-768x586.png 768w" sizes="(max-width: 795px) 100vw, 795px" /></figure></div>



<p> Open your signal app and then open settings. A quick way to do that is to hit your profile photo/avatar in the top left. Once there navigate to Linked Devices and hit the + button on Android or &#8220;Link New Device&#8221; on iOS.</p>



<p>If you haven&#8217;t used your camera before in Signal, it might ask you for permission which you&#8217;ll need to give. You can always disable it later in your phone settings.</p>



<p>Once you scan the QR Code, you will be asked to name the device. When you hit <strong>Finish linking phone</strong>, Signal for Desktop will sync your phone contacts and groups to the desktop which took several seconds for me.</p>



<div class="wp-block-image"><figure class="aligncenter size-large"><img decoding="async" width="793" height="607" src="https://techtites.com/wp-content/uploads/2021/01/Name-your-Linked-device.png" alt="" class="wp-image-11581" srcset="https://techtites.com/wp-content/uploads/2021/01/Name-your-Linked-device.png 793w, https://techtites.com/wp-content/uploads/2021/01/Name-your-Linked-device-768x588.png 768w" sizes="(max-width: 793px) 100vw, 793px" /></figure></div>



<p>As a security measure, you will not be able to see your chat history on this newly linked device, but once you start using it the messages appear on both your mobile and this device.</p>



<p>That&#8217;s all folks! Say hello to better battery life on your phone.</p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/how-to-use-signal-on-your-desktop/">How to use Signal on your Desktop</a> was first posted on January 19, 2021 at 7:30 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/how-to-use-signal-on-your-desktop/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Launching Popular Authors WordPress plugin</title>
		<link>https://techtites.com/launching-popular-authors-wordpress-plugin/</link>
					<comments>https://techtites.com/launching-popular-authors-wordpress-plugin/#respond</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Sat, 30 May 2020 08:03:06 +0000</pubDate>
				<category><![CDATA[WordPress]]></category>
		<category><![CDATA[WordPress Plugins]]></category>
		<category><![CDATA[plugins]]></category>
		<guid isPermaLink="false">https://techtites.com/?p=11562</guid>

					<description><![CDATA[I&#8217;m happy to announce the launch of a new WordPress plugin. Popular Authors is an add-on for Top 10 and [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/launching-popular-authors-wordpress-plugin/">Launching Popular Authors WordPress plugin</a> was first posted on May 30, 2020 at 8:03 am.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>I&#8217;m happy to announce the launch of a new WordPress plugin. <a href="https://webberzone.com/downloads/popular-authors/" class="broken_link">Popular Authors</a> is an add-on for <a href="https://webberzone.com/plugins/top-10/" class="broken_link">Top 10</a> 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.</p>



<p>This plugin came as a request from an existing user of Top 10 and I noticed that there isn&#8217;t a similar free plugin in the WordPress repository &#8211; at least not one that has been recently updated!</p>



<p>Popular Authors can be used in three ways:</p>



<ol class="wp-block-list"><li>Widget: simply drag and drop “Popular Authors” widget into your theme’s sidebar and configure it</li><li>Shortcode <code>[wzpa_popular_authors]</code>, so you can embed it inside a post or a page</li><li>Template tag: Use <code>wzpa_list_popular_authors()</code> to display the popular authors anywhere on your theme</li></ol>



<h2 class="wp-block-heading">The Widget</h2>



<div class="wp-block-image"><figure class="aligncenter size-large"><img decoding="async" width="342" height="559" src="https://techtites.com/wp-content/uploads/2020/05/Popular-Authors-Widget.png" alt="" class="wp-image-11563"/><figcaption>Popular Authors v1.0.0 widget</figcaption></figure></div>



<p>The widget is the easiest way to display the top authors &#8211; simply drag and drop it into the theme and you&#8217;re good to go. Plus you have a few options to play with. I&#8217;ll update the widget to add a few more parameters than can be customised.</p>



<h2 class="wp-block-heading">Shortcode and Template tag</h2>



<p>These are perfect if you want to insert the top list into your website at custom places that don&#8217;t support the widget. Both the shortcode and the template tag take several optional parameters.</p>



<p>Refer to this article on the <a href="https://webberzone.com/support/knowledgebase/popular-authors-shortcode/">shortcode attributes</a> for more details on what attributes you can use with the shortcode. For the template tag, you will pass these as an arguments array.</p>



<h2 class="wp-block-heading">Future plans</h2>



<p>I pushed this out as a simple release with the basic functionality of the shortcode and the widget &#8211; both of which use the function to output the data. I&#8217;ve got several plans to develop this plugin and you can always track the <a rel="noreferrer noopener" href="https://github.com/WebberZone/popular-authors/issues" target="_blank">latest features in Github</a>.</p>



<p>A few immediate features include, adding a support for <a rel="noreferrer noopener" href="https://wordpress.org/plugins/co-authors-plus/" target="_blank">Co-Author Plus</a> so as to give multiple authors credit for the number of views tracked, adding an option to display the author thumbnail and adding a new tab in the Top 10 settings page to set a few global options.</p>



<p>As always, I&#8217;m always happy to get feature requests. You can post them in the <a rel="noreferrer noopener" href="https://wordpress.org/support/plugin/popular-authors/" target="_blank">support forum</a> or create a Github issue. Please note that Github issues not related to support requests are deleted or closed.</p>



<p class="has-text-color has-background has-very-dark-gray-color has-luminous-vivid-amber-background-color has-medium-font-size"><a href="https://wordpress.org/plugins/popular-authors/"><strong>Download Popular Authors</strong></a></p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/launching-popular-authors-wordpress-plugin/">Launching Popular Authors WordPress plugin</a> was first posted on May 30, 2020 at 8:03 am.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/launching-popular-authors-wordpress-plugin/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>How to calculate NPV in Excel using Functions</title>
		<link>https://techtites.com/calculate-npv-in-excel-functions/</link>
					<comments>https://techtites.com/calculate-npv-in-excel-functions/#respond</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Sun, 16 Jun 2019 21:11:06 +0000</pubDate>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[excel tutorial]]></category>
		<category><![CDATA[how to]]></category>
		<category><![CDATA[microsoft excel]]></category>
		<category><![CDATA[tutorials]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=9880</guid>

					<description><![CDATA[In the last two posts, you learnt the basics of Net Present Value (NPV) and how to calculate NPV using [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/calculate-npv-in-excel-functions/">How to calculate NPV in Excel using Functions</a> was first posted on June 16, 2019 at 9:11 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>In the last two posts, you learnt the <a href="https://techtites.com/what-is-npv/">basics of Net Present Value (NPV)</a> and how to <a href="https://techtites.com/calculate-npv-in-excel/">calculate NPV using formulae</a>. However, Microsoft Excel makes it easy for you with two inbuilt functions. The first is <strong>NPV</strong> (surprise!) and the second is <strong>XNPV</strong> (my favourite).</p>



<h2 class="wp-block-heading">NPV</h2>



<p>From the <a rel="noopener noreferrer" href="https://support.office.com/en-us/article/NPV-function-8672cb67-2576-4d07-b67b-ac28acf2a568" target="_blank">official help article</a>, NPV takes the following syntax:</p>



<pre class="wp-block-code"><code>NPV(rate,value1,[value2],...)</code></pre>



<p>The function uses the following arguments:</p>



<ul class="wp-block-list"><li><strong>Rate</strong> Required. The rate of discount over the length of one period</li><li><strong>Value1, value2</strong>, &#8230; Value1 is required, subsequent values are optional. 1 to 254 arguments representing the payments and income</li><li>Value1, value2, &#8230; must be equally spaced in time and occur at the end of each period</li><li>NPV uses the order of value1, value2, &#8230; to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence</li><li>Arguments that are empty cells, logical values, or text representations of numbers, error values, or text that cannot be translated into numbers are ignored</li><li>If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored</li></ul>



<p>Simply put, you feed your cash flows to NPV and it will chomp them up and give you the net present value of those cash flows at the specified rate. One important point to remember is that these cash flows are assumed to be at equal periods and hence this can be used if your cash flows are arranged in this manner.</p>



<p>However, if you have date dependent cash flows, or if you&#8217;d like to make your model more dynamic, then XNPV is a better function to use. That&#8217;s also why it is my favourite NPV calculator and one that I&#8217;ve used extensively.</p>



<h2 class="wp-block-heading">XNPV</h2>



<p>From the <a rel="noopener noreferrer" href="https://support.office.com/en-gb/article/XNPV-function-1b42bbf6-370f-4532-a0eb-d67c16b664b7" target="_blank">official help article</a>, XNPV takes the following syntax:</p>



<pre class="wp-block-code"><code>XNPV(rate, values, dates)</code></pre>



<p>The XNPV function takes the following arguments:</p>



<ul class="wp-block-list"><li><b>Rate Required.</b> The discount rate to apply to the cash flows</li><li><b>Values Required</b>. A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive value and one negative value</li><li><b>Dates Required</b>. A schedule of payment dates that corresponds to the cash flow payments. The first payment date indicates the beginning of the schedule of payments. All other dates must be later than this date, but they may occur in any order</li></ul>



<figure class="wp-block-image"><img decoding="async" width="682" height="213" src="https://techtites.com/wp-content/uploads/2016/02/Calculate-NPV-using-Functions.png" alt="Calculate NPV using Functions" class="wp-image-11405"/></figure>



<p>You can download the Excel file at the end of this article that will show how to use both NPV and XNPV. You’ll note the slight difference in the final results which is mainly because of the more accurate dates being used by the XNPV function.</p>



<a  data-e-Disable-Page-Transition="true" class="download-link download-button aligncenter" title="" href="https://techtites.com/download/calculate-npv-in-excel/?tmstv=1752259458" rel="nofollow" id="download-link-11408" data-redirect="false" >
	Download &ldquo;Calculate NPV in Excel&rdquo;	<small>Techtites-Tutorial-Calculate-NPV-in-Excel.zip		&ndash; Downloaded 590 times		&ndash; 11.39 KB</small>
</a>

<hr style="border-top: black solid 1px" /><a href="https://techtites.com/calculate-npv-in-excel-functions/">How to calculate NPV in Excel using Functions</a> was first posted on June 16, 2019 at 9:11 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/calculate-npv-in-excel-functions/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>How to calculate NPV in Excel using Formulae</title>
		<link>https://techtites.com/calculate-npv-in-excel/</link>
					<comments>https://techtites.com/calculate-npv-in-excel/#respond</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Fri, 14 Jun 2019 18:09:28 +0000</pubDate>
				<category><![CDATA[Excel]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[excel tutorial]]></category>
		<category><![CDATA[how to]]></category>
		<category><![CDATA[microsoft excel]]></category>
		<category><![CDATA[tutorials]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=9797</guid>

					<description><![CDATA[I&#8217;ve covered the basics of Net Present Value (NPV) previously. If you don&#8217;t know what NPV is, then please read [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/calculate-npv-in-excel/">How to calculate NPV in Excel using Formulae</a> was first posted on June 14, 2019 at 6:09 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[
<p>I&#8217;ve covered the <a href="https://techtites.com/what-is-npv/">basics of Net Present Value (NPV)</a> previously. If you don&#8217;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.</p>



<p>Although this is a more detailed approach to calculate NPV, it gives you more flexibility vs. using the in-built Excel NPV functions.</p>



<p>Using this method, you will:</p>



<ol class="wp-block-list"><li>Calculate the discount factor that is to be&nbsp;applied in each year based on a specific discount rate</li><li>Apply this discount factor to the cash flow of each year to get the present value of the cash flow of that year</li><li>Sum up these cash flows to arrive at the NPV</li></ol>



<p>This does sound like a lot of work. Don&#8217;t worry, we&#8217;re going to take the calculations one step at a time!</p>



<h2 class="wp-block-heading">1. Calculate the discount factor</h2>



<p>From the <a href="https://techtites.com/what-is-npv/">previous post</a>, you would have learnt that you can calculate the present value of next (read <em>first</em>) year’s cash flows using $100/(1+5%) where $100 is the cash flow and 5% is the discount rate.</p>



<p>For the second year’s cash flows you will use $100/(1+5%)^2 and so on.</p>



<p>This portion: 1/(1+5%) and 1/(1+5%)^2 are the discount factors for the first and second year.</p>



<p>Putting this in Excel is very easy and this is what the formulae would look like in Excel to calculate the discount rates for the next 3 years. You can extend these to as many years as needed.</p>



<h2 class="wp-block-heading">2. Apply this discount rate</h2>



<p>Next, multiply the discount rate you calculated in the previous step to the cash flow in the same year</p>



<h2 class="wp-block-heading">3. Sum the PVs of all the cash flows</h2>



<p>Now, add the various cash flows that you calculated in the previous step to get the net present value of the stream of cash flows.</p>



<p>You can see the three steps in the screenshot below.</p>



<figure class="wp-block-image"><a href="https://techtites.com/wp-content/uploads/2019/06/Calculate-NPV-with-Formulae.png"><img decoding="async" width="690" height="233" src="https://techtites.com/wp-content/uploads/2019/06/Calculate-NPV-with-Formulae.png" alt="Three steps to calculate NPV in Microsoft Excel using formulae" class="wp-image-11399"/></a></figure>



<p>The above method assumes that the <em>cash flows are at the end of the year</em>. If you’re assuming <em>mid-year cash flows</em> then the recommended method is to discount the first year by 0.5 (instead of 1), the second by 1.5, etc. The rest of the calculations remain the same.</p>



<p>In the next post, I will show you how to use in-built Excel functions to calculate the NPV.</p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/calculate-npv-in-excel/">How to calculate NPV in Excel using Formulae</a> was first posted on June 14, 2019 at 6:09 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/calculate-npv-in-excel/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Scanned PDF to Word Conversion Proves That Brain Is Better Than Brawn</title>
		<link>https://techtites.com/scanned-pdf-to-word-conversion/</link>
					<comments>https://techtites.com/scanned-pdf-to-word-conversion/#respond</comments>
		
		<dc:creator><![CDATA[Guest Blogger]]></dc:creator>
		<pubDate>Thu, 19 May 2016 12:33:40 +0000</pubDate>
				<category><![CDATA[Software]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[Utilities]]></category>
		<category><![CDATA[online tool]]></category>
		<category><![CDATA[PDF]]></category>
		<category><![CDATA[pdf to word]]></category>
		<category><![CDATA[Word]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=9897</guid>

					<description><![CDATA[&#8220;There’s a way to do it better – find it. Thomas A. Edison&#8221;. These are the wise words of Thomas [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/scanned-pdf-to-word-conversion/">Scanned PDF to Word Conversion Proves That Brain Is Better Than Brawn</a> was first posted on May 19, 2016 at 1:33 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[<p>&#8220;There’s a way to do it better – find it. Thomas A. Edison&#8221;. 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.</p>
<p>Since everything is changing rapidly, people need to learn how to be effective in simple daily tasks.</p>
<p>One thing that has become a usual work routine is managing different electronic documents that you receive. No matter which profession you&#8217;re a part of, handling several files is a typical daily task. Most commonly those files are in PDF, the most used format in the business world. The problem occurs when you want to edit a particular document and since PDF is not editable by default, you cannot change it that easily. Let’s face it, your time is important and dealing with these issues is not something that you want to spend most of your day on.</p>
<p><img decoding="async" class="alignnone size-full wp-image-9899" src="https://techtites.com/wp-content/uploads/2016/05/Investintech.png" alt="Investintech" width="1003" height="1179" srcset="https://techtites.com/wp-content/uploads/2016/05/Investintech.png 1003w, https://techtites.com/wp-content/uploads/2016/05/Investintech-768x903.png 768w, https://techtites.com/wp-content/uploads/2016/05/Investintech-871x1024.png 871w" sizes="(max-width: 1003px) 100vw, 1003px" /></p>
<p>Luckily for you, there are some tools that can make PDF editing a walk in the park. Investintech’s online <a href="http://www.investintech.com/pdf-ocr.htm">PDF OCR service</a> lets you convert scanned and native PDFs to Word with the click of a button.</p>
<p>What makes this tool different is that it’s simple to use, completely free, with no limitations to the file size or the number of conversions. It is completely web-based which means no boring downloads and endless installations. Great thing is that it can convert PDF to Word in a quick three-step process:</p>
<p>Step 1)  Select a PDF file from your computer that you would like to convert. Since it has an advanced OCR technology, it converts both native and scanned PDF.</p>
<p><img decoding="async" class="alignnone size-full wp-image-9900" src="https://techtites.com/wp-content/uploads/2016/05/Select_file.png" alt="Step 1: Select the file" width="349" height="395" /></p>
<p>Step 2)  Type your email address to receive your converted file.</p>
<p><img decoding="async" class="alignnone size-full wp-image-9901" src="https://techtites.com/wp-content/uploads/2016/05/type_e-mail_address.png" alt="Type your email address" width="351" height="398" /></p>
<p>Step 3) Simply press the Start button and you are done. Soon enough, you will receive an email with a link to your converted file.</p>
<p><img decoding="async" class="alignnone size-full wp-image-9902" src="https://techtites.com/wp-content/uploads/2016/05/Start_converting.png" alt="Step 3: Start converting" width="349" height="397" /></p>
<p>An important thing to notice is that this PDF tool provides some of the most advanced features for an online tool which keeps your converted file as close as possible to the original document. Also, for security reasons, files are deleted from Investintech’s servers after 24 hours.</p>
<p>Give it a try and let us know the results.</p>
<p><em>This is a guest post by the team at Investintech</em></p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/scanned-pdf-to-word-conversion/">Scanned PDF to Word Conversion Proves That Brain Is Better Than Brawn</a> was first posted on May 19, 2016 at 1:33 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/scanned-pdf-to-word-conversion/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>What is NPV?</title>
		<link>https://techtites.com/what-is-npv/</link>
					<comments>https://techtites.com/what-is-npv/#comments</comments>
		
		<dc:creator><![CDATA[Ajay]]></dc:creator>
		<pubDate>Wed, 28 Oct 2015 23:17:51 +0000</pubDate>
				<category><![CDATA[Office]]></category>
		<category><![CDATA[Techtites Featured]]></category>
		<category><![CDATA[Tips and Tutorials]]></category>
		<category><![CDATA[Excel]]></category>
		<category><![CDATA[how to]]></category>
		<category><![CDATA[Microsoft]]></category>
		<category><![CDATA[microsoft excel]]></category>
		<guid isPermaLink="false">http://techtites.com/?p=9814</guid>

					<description><![CDATA[If you&#8217;re here and reading this post, then you&#8217;ve probably been asked to calculate the Net Present Value of a [&#8230;]<hr style="border-top: black solid 1px" /><a href="https://techtites.com/what-is-npv/">What is NPV?</a> was first posted on October 28, 2015 at 11:17 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></description>
										<content:encoded><![CDATA[<p>If you&#8217;re here and reading this post, then you&#8217;ve probably been asked to calculate the <a href="https://en.wikipedia.org/wiki/Net_present_value" target="_blank" rel="noopener noreferrer">Net Present Value</a> of a set of cash flows in Excel. Over the next few posts, I&#8217;ll walk you through Net Present Value (or NPV) as a concept and then go into the details of how to calculate this in Excel.</p>
<h2>Introducing NPV, PV and FV</h2>
<p>Net Present Value, as the name suggests, is the sum of the <em>present values</em> of future cash flows. Both incoming (i.e. receipts) and outgoing (i.e. payments) are considered for calculating the NPV. So, what&#8217;s <em>present value</em> (PV)?</p>
<p>Let&#8217;s try to understand this via a simple example.</p>
<p>Imagine that you deposit $100 in the bank today for one year only at an annual interest rate of 5%. After one year, the bank would return the principal ($100) along with some interest ($5), which is a total of $105.</p>
<p>You&#8217;ve probably heard the saying &#8220;a dollar today is worth more than a dollar tomorrow&#8221;. In our example, our dollar today is worth 1.05 dollars in a year. The <em>Future Value (FV)</em> of $1 is $1.05.</p>
<p>Mathematically: <strong>At the end of Year 1, the Future value of $100 = $100 * ( 1+ 5% ) = $105</strong></p>
<p>Reversing this, $105 next year is worth $100 today (assuming that the discount rate is 5%). <strong><em>Hence the present value of $105 is $100.</em></strong></p>
<p>Still with me? Good. Now let&#8217;s complicate this example further by adding in yet another year.</p>
<p>If, instead of paying you back the principal at the end of the year, the bank just paid you the interest ($5) and rolled over the principal for another year.</p>
<p>And, then after another year has passed, the bank paid back the principal and interest i.e. a total of $105, what would the present value of <em>this $105</em> be today?</p>
<p>If you&#8217;re thinking $95.24, then you&#8217;ve hit the nail on the head and you can skip the explanation below. If that&#8217;s you in the image below, then read on.</p>
<p><img decoding="async" class="alignnone wp-image-9810 size-full" src="https://techtites.com/wp-content/uploads/2015/07/man-scratching-head.png" alt="Man scratching head: Source Pixabay" width="640" height="488"></p>
<p>To find out what the present value of the $105 in Year 2 is today, we need to take two steps back in time.</p>
<p>Step 1: In Year 1, the present value of the $105 is $100 (just like we calculated in our previous example)</p>
<p>Step 2: In Year 0, i.e. today, the present value of this $100 is: $100/(1+5%) = $95.24</p>
<p>Note that in the example above, we&#8217;ve ignored the $5 that the bank paid us at the end of Year 1. Keeping with the calculation in Step 2 above, the present value of $5 would be $5/(1+5%) = $4.76.</p>
<p>And, $4.76 + $95.24 = $100!</p>
<p>Looking at this example:</p>
<p>$4.76 is the present value of $5 received in Year 1</p>
<p>$95.24 is the present value of $105 received in Year 2</p>
<p>$100 is the sum of the present values of the receipts of Year 1 and Year 2. In other words, $100 is the net present value of two cash flows of $5 and $105 received in the following two years.</p>
<h2>Summary</h2>
<p>By now, I hope I have cleared any doubts or questions you&#8217;ve had on Net Present Value and you should conceptually be able to calculate the NPV of a set of cash flows and decide if a project is feasible based on the cash flows.</p>
<p>In the next post, I&#8217;ll explain how you can calculate NPV in Microsoft Excel. Stay tuned.</p>
<hr style="border-top: black solid 1px" /><a href="https://techtites.com/what-is-npv/">What is NPV?</a> was first posted on October 28, 2015 at 11:17 pm.<br />©2005-2025 Techtites. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader or email client, then the site is guilty of copyright infringement. Please contact me at https://techtites.com/contact/<br />]]></content:encoded>
					
					<wfw:commentRss>https://techtites.com/what-is-npv/feed/</wfw:commentRss>
			<slash:comments>2</slash:comments>
		
		
			</item>
	</channel>
</rss>
