Intermediate Excel Skills, Tips, and Tricks Tutorial

Intermediate Excel Skills, Tips, and Tricks Tutorial

In this video tutorial we’re going to take a look at the intermediate Skills tips and tricks that you need to know in order to use excel Properly and efficiently if you haven’t already watched my other excel video. It’s called the Beginner’s guide to Excel and I highly recommend that you start with that […]

Read More »
How to Fix Excel Numbers That Don’t Add Up

How to Fix Excel Numbers That Don’t Add Up

If you import or copy data into excel such as a bank statement, sometimes the numbers don’t add up correctly. We’ll see how to fix that. Here is a very small sample of a bank account. We’ve got cheque numbers and the amount of each cheque. To create a total, I can go to the […]

Read More »
Filter Excel Data to Different Worksheet

Filter Excel Data to Different Worksheet

In Excel, you can use an Advanced Filter to pull data from a table and put it somewhere else in the workbook, either on the same sheet or a different sheet. In this example, we have a list of orders and we would like to pull the orders with the highest totals and put them […]

Read More »
Checking Data Entry  – 463 – Learn Excel from MrExcel Podcast

Checking Data Entry – 463 – Learn Excel from MrExcel Podcast

Hey! Welcome back to the MrExcel netcast. I’m Bill Jelen. This week it’s the beginning of March Madness. The NCAA men’s college basketball tournament in the United States. And I want to encourage you to enter our competition go to “MrExcel.comNCAA.html” to download your bracket, fill it out. Send it in you can win some […]

Read More »
MrExcel’s Learn Excel #501 – Data Entry

MrExcel’s Learn Excel #501 – Data Entry

The MrExcel netcast. I’m Bill Jelen. In the past, I’ve talked about when you have to enter data going across a worksheet, to go to tools, options and then on the Edit tab, change the move selection after enter direction, to be right and we’ve talked about how you can pre-select the data that you […]

Read More »
Excel Drop Downs From List on Different Sheet

Excel Drop Downs From List on Different Sheet

In this workbook, there’s a sheet where people will enter order information. So they’ll put in a date, and then a product, and the quantity sold. To make it easier for people, in the Product column, instead of them typing a product name, which could result in errors or invalid products, we’re going to create […]

Read More »
Fill Blank Cells in Excel With Value from Above

Fill Blank Cells in Excel With Value from Above

Sometimes in Excel, you’ll end up with data like this, possibly exported from another system where you’ve got headings but blank cells below those headings. So here we can see region and it’s only listed once and then blank to the end of the region, and the employees in each region. So you might have […]

Read More »