VBA stands for visual basic for application. It is the default programming language for MS Office. If you want to program MS Excel you should know how to work with VBA Macros. VBA is at the same time is fun and a source of improving productivity. Actually it provides an opportunity to do things what canot be done in usual way or to have features that are not available by … [Read more...]
Remove All Rows Containing Certain Data
Recently I had some data from a website that was poorly formatted, but I needed to get it into a spreadsheet to work with. When I copied the data into the spreadsheet, I needed to remove all of the rows that contained certain irrelevant data, such as repeated header fields. Other use cases might require you to delete any rows containing someone's name, a location, or some … [Read more...]
How to Create Combination Charts in Excel
Most Excel users know how to create either a bar chart or a line chart to visually show a set of data. One way to really step up your game and graphically show multiple relationships across two or more sets of data is to use a combination chart. This powerful function will allow you to combine a bar chart and a line graph and add a Y-axis (vertical line) to express broader … [Read more...]
Adding and Subtracting Time in Excel
Adding and subtracting time in Excel is something that people often times have a difficult time figuring out how to do correctly. Often times you are doing it right, but the results don't seem to be displaying correctly. Other times you may give up doing it the "correct" way and set up an hours column and a minutes column. Then add the minutes, divide by 60, and add it to the … [Read more...]
Count Cells Meeting Certain Criteria
Whenever you are dealing with lists it seems like you always are looking to count how many of a certain item is in the list. Maybe you want to count how many cars were sold by a certain salesperson, or how many times an employee called out sick. Luckily Excel makes it easy to count cells meeting certain criteria just like this. Count cells meeting certain criteria with Excel's … [Read more...]