Online Video Courses

Excel running average

How to Calculate Running Average in Excel

By Ugur Akinci | October 19, 2016

Introduction Knowing how to calculate running average in Excel can save you a lot of time and energy. Sample Data Imagine your Microsoft Excel data consists of “Days of Accidents”. For each day on this list there has been one accident: As you can see, not all days are listed. There have been no accidents…

Read More
Copyright free images

3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents

By Ugur Akinci | September 19, 2016

Introduction Copyright free images are a writer’s best friend. Images always cheer up any article, blog post, or document. But if you use images with copyright without paying for them you can get into trouble. So how do you get captivating images for free, without any copyright issues at all? Easy Sites to Find Good…

Read More

How to Delete All Hyperlinks in a MS Word Document through VBA Macro

By Ugur Akinci | September 1, 2016

You can delete a hyperlink in a MS Word document by right-clicking on the link and, from the pop-up menu, select Remove Hyperlink. You can also get rid of a hyperlink by placing your cursor anywhere on the link and then pressing CTRL + SHIFT + F9. But what if you have hundreds or thousands…

Read More

How to View a List of All Open MS Word Documents through VBA Macro

By Ugur Akinci | August 31, 2016

You can switch from one open MS Word document to another by pressing CTRL + F6, in case you didn’t know. But what if you have 16 Word documents open for some reason and you’d like to know their total number and view their file names so that you can decide whether to switch to…

Read More