Sorting a list makes it more accessible makes it easier to find data. But you still have to search through all the data to find the specific records that you’re looking for example I’m looking at Buyers 2015 and I just sorted it by month but you know what I …
Read More »13.4 Using Custom Sorts in an Excel List
Here’s one more topic about sorting within Excel lists. Now I’ve still got the exercise file . I’m on the Buyers 2015 worksheet. I mean to give a quick little tip here in order to find really make it more accessible for the little arrows on the left hand side …
Read More »13.3 Sorting a List Using Multi-Level Sorts
The second technique that I want to talk about here in sorting the list deals with a multilevel sort, I want to sort this list by multiple columns. Now this one is is very quick as well but a few extra steps. I want to get into this list. Same …
Read More »13.2 Sorting a List Using Single Level Sort
Here’s the first tool that I want to get into within working with a list inside of Excel. And this is perhaps one of the most common tools that are used inside of a list. Now think about this what’s the purpose of a list. I’ve got a list of …
Read More »13.1 Understanding Excel List Structure
Here’s the first concept there’s actually two that I want to bring in here and make you aware of as you work with in Excel with the LISTS. Now inside the exercise pile that I have open, I’m looking at the employee records tab and on I have a simple …
Read More »10.4. Creating a Custom Template
Now let us take-a-look at taking our monthly budget and turning it into a template. First step. Remember the basis of a template is to build the basic structure the basic layout, do the basic formatting and so on have the consistent elements always there. Opening your document that you …
Read More »10.3. Opening an Existing Template
Welcome to the next section of this Excel for Beginners, during this section we are going to take-a-look at using and creating Microsoft Office templates and specifically within Excel. So, I have still got the monthly budget open, We are going to talk about utilizing one of the built in …
Read More »10.1. Intro to Excel Templates
Welcome in the next section of this Microsoft for Beginners. Now before we jump in and start to talk about templates, I want to do a quick preview on what the idea is what the concept is of an Excel template. Now I am going to use our monthly budget …
Read More »9.4 Printing a Specific Range of Cells
Let us take-a-look at one more option in-regards-to printing. Now in many cases when you go to a printed document you are going to print the entire thing. The spreadsheet all its data the charts the entire set of data contained within that worksheet. But there will come a time …
Read More »9.3 Adding Header and Footer Content
I want to take-a-look at the header and footer of your printed document. Think about the header footer for a moment. You receive a document whether it is word whatever it is. A lot of times in the very top portion of your page roughly half an inch or so …
Read More »