Excel Tutorial For Beginners

Excel Tutorial For Beginners

[Music] let’s click on a blank workbook when you start Microsoft Excel. You will see this screen and when you click on it this is the screen that you see so the key first element I’m gonna introduce to you in the bottom right corner and that’s the zooming element we’re gonna make it a […]

Read More »
Excel data links (think-cell tutorials)

Excel data links (think-cell tutorials)

Welcome to the think-cell tutorials. This video shows you how to create and update think-cell charts directly from data in an Excel workbook. Let’s say you want to turn your Excel data into a think-cell chart. Just open the workbook in Excel and select the desired data range. Suppose you would like to create a […]

Read More »
Create an Employee Timesheet Using Excel

Create an Employee Timesheet Using Excel

If you’re using Microsoft Excel and you want to record your employees time, I’m going to show you a pretty easy way to do it. This sheet has been set up with something called Data Validation and I’ll show you how I did that. Highlight the column that you’re going to have the dates go […]

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 »
Top 5 Excel Interview Questions

Top 5 Excel Interview Questions

interviewing for a job that’s data focused or requires Excel skills expect to be asked more than just do you know how to use Excel I’ve interviewed many many people for positions where Excel skills were a central part of what they’d be doing it’s usually pretty clear from people’s responses to these questions who’s […]

Read More »