Best Tools to Succeed Online
This is a video tutorial on how to use drop down in MS Excel. How to do drop down selection list in MS Excel is one of the most commonly used MS Excel functions. It adds an additional choice into the existing choices. Drop down can be applied to any list based data with the … Read more
Everything is possible with Excel. And how can you make your Excel table look cool? Just follow this step by step The step by step guide on how to create an Excel table. 1. Click the tab above named “Type”. 2. Select Standard > Table 3. Below, select “My Table Has Headers” 4. Click OK. … Read more
Are you looking for a way to create a fillable pdf? This article tells you how to easily create fillable pdf forms. Fillable pdf’s are becoming more and more popular, so if you learn how to create fillable pdf’s it will be very beneficial. The fillable pdf’s are free, there is no charge to use … Read more
If you want to learn how to create Excel formulas this is a good place to start. I have created a short guide that will explain how to create some basic formulas in Excel. The guide provides you with the basics on how to use the formulas as well as some examples of where they … Read more
I was working in Excel this morning, when I came across a spreadsheet that had a table of data. Instead of just listing the data in a table, they allowed their data to flow in a way that visually represented the message in the data. The graph below is an example of how an Excel … Read more
Every day, you read your favorite news on your smartphone, but lot of the time you want to read them at home or on some other device. You can transfer them to your PC or Mac by emailing them to yourself. But here is the problem. When you open the email on your computer, you’re … Read more
A pdf can be a very useful and beneficial file for any organization. With the rise of the internet, many people have started doing away with using paper as much as possible. Companies that were once mailing out copies of pamphlets and other forms of literature are now posting such information on their websites. While … Read more
Create an Excel Macro to Speed Up Your Repetitive Tasks! Macros—you’ve probably heard the word before, and you may have even heard people talk about how great they are. But what’s the hype all about? When it comes to working with spreadsheets in Excel 2013, some processes can be repetitive (and dare I say, boring). One … Read more
The following article will cover a number of tools that I have used extensively throughout my programming career. All of these tools have drastically reduced the time needed to complete tasks, and allowed me to become more efficient when writing code. In fact, some of these tools have made me so efficient, I’m not sure … Read more
I have always struggled with creating pivot tables in Excel. My university professors told me that I could create them, but I just could not get them to do it correctly. One of the biggest challenges was entering the data into the cells, which Excel does automatically. After years of being frustrated by creating pivot … Read more
You can specify a single cell location in a range, a single cell value, a range name, array formulas, or if it is defined as an Excel table. You can also filter your Pivot Table based on one or more criteria you have selected from the Filter drop-down list. In this article, I will explain … Read more
Nowadays, it is very important to be able to manage digital files in an organized manner, because the number of files that we have to manage is increasing constantly. In order to do that, we have several solutions that allows us to store these files in a way that is easier. One of these methods … Read more