Video Tutorials | Books | What's New | FAQ | Testimonials | Credits | Support | Login | My Account

Search available tutorials for:(Enter Phrase or Excel Command) Getting Started Working with Brackets Sometimes it can be difficult to see how an equation works, especially if someone else wrote it. In this presentation we see how you can use some simple debugging tools to see how Excel works out the more ... Filtering Lists and the Status Bar This Tutorial shows how you can use the status bar and the auto filter option to analyse financial data without using a single function Introduction to the IF statement A beginners guide to the excel If statement and how they can be nested. Introduction to Conditional Formatting This introduction to conditional formatting shows how to easily highlight values in a financial spreadsheet based on values within the spreadsheet. Introduction to Named Ranges Once you have mastered the basics of Excel Named Ranges you will be able to make complicated equations and expressions that are simple to understand (and possibly debug at a later date!) This tutorial more ... Auditing Spreadsheets This tutorial will show you two excellent techniques in Excel to immediatly understand how someone else's spreadsheet works and will give you confidence in changing some of the values in it will full Making your Spreadsheet Easier to use. Once you have created a spreadsheet for your office the last thing you want to do is teach everyone how to use it every time they open it. This simple presentation will show you 4 techniques that will more ... Excel 2007 Menus Hidden Secret When you first make the move from Excel 2003 to Excel 2007 the new menu structure can cause you a massive drop in your productivity. In fact I have been using Excel 2007 (on and off) now for almost 5 more ... Customizing Toolbars Simply everything you need to know about customizing Excel Toolbars. .. This tutorial shows you :- 1) How to add new buttons into existing toolbars 2) How to add a new toolbar 3) How to find features more ... getting started with dates and times Dates and Times in Excel and drive you mad if you do not understand the basic principles of how Excel handles the dates and times you enter. This tutorial shows you a couple of the common problems Working on more than one sheet at once In this tutorial you will learn two techniques for carrying out the same task on two or more worksheets at the same time. The first technique is very simply and anyone who can click a mouse will be able more ... Charts Calculating and Charting the Moving Average This example shows 3 different ways of calculating and presenting moving average data in Excel. It uses Share price data as the example. Theming Data on Bar Charts There are times when drawing attention to some of the data bars on a bar chart can enhance your chart significantly. However Excel only allows you to have one style and colour for each data series and more ... Quick In-Cell Bar Charts This great video shows you the quickest way to produce a bar chart without using the Excel Graphing control. The technique uses just one Excel functino to do the whole chart - no matter how many rows more ... Save time by using Custom Chart Types Let's face it - Excel Default chart types leave a lot to be desired and often result in you having to spend 2 - 3 minutes changing the cosmetic look of a graph everytime you create one. In this tutorial more ... Quick and Easy Frequency Distribution charts This tutorial will show you how to quickly and easily create a frequency distribution chart for financial transaction data. Without this hidden function in Excel this task can take 15 - 20 minutes. Once more ... Data Validaion Control the Contents of Drop Downlist from a cell This advanced tutorial show you how to control the contents on a data validation drop down list based on the contents of a cell or another dropdown list. In the turorial the list of students available more ... Adding Drop Down Lists to your Speadsheet This tutorial shows you how to add drop down lists to cells - this is a great technique to ensure data entry is done correctly Statistics Quick and Easy Frequency Distribution charts This tutorial will show you how to quickly and easily create a frequency distribution chart for financial transaction data. Without this hidden function in Excel this task can take 15 - 20 minutes. Once more ... Descriptive Statistics - Which Average To Use? This tutorial describes the 3 common ways to display the average of a data set. It is important to understand when you are presenting an average whether you are looking at the most common value, the Calculating and Charting the Moving Average This example shows 3 different ways of calculating and presenting moving average data in Excel. It uses Share price data as the example. Text Manipulation Joining cells together with Carriage Returns Excel has some great features for joining text from two or more cells together but these features can be a bit tricky if you do not know the tricks. This tutorial shows how to easily join cells together more ... Splitting Text Without Equations This movie shows how you can manipulate data in Excel to get it in the format you need. This tutorial ONLY uses features in Excel and does require any equations. The tutorial takes a list of US presidents more ... Splitting Text Strings Using Equations This tutorial shows how text strings can be split up in Excel using Left(), Right(), Find() and Len() commands. It illustrates how these techniques can be used to order lists according to parts of a what-if analysis Goal Seeking Goal Seek is part of a suite of commands sometimes called what-if analysis tools. When you know the desired result of a single formula but not the input value the formula needs to determine the result, more ... VBA Working on more than one sheet at once In this tutorial you will learn two techniques for carrying out the same task on two or more worksheets at the same time. The first technique is very simply and anyone who can click a mouse will be able more ... Calling a VBA when a cell changes This tutorial shows you have to add VBA code to your project to check a value as it is entered into a spreadsheet. This example shows you how to ensure that the user only ever adds data to a cell using more ... Introduction to Debugging Excel VBA Finding where your applications or functions are going wrong is vital to the successful implementation of any VBA code. This tutorials shows you how you can set break points in your code and use the Creating a User Defined Function using VBA This function uses a very simple example to show you how to add to the Excel Function library. First the Tutorial shows you how to add a function to display a test box on the screen and then goes on Using Macros to Save You Time Would you like to create Excel VBA code but do not know to write VBA? With the Macro Features within Excel you can do just. If you want to learn Excel VBA then this tutorial will get you up and running more ... Functions Hiding Excel Error Messages Having Error messages such as #DIV/0! in your spreadsheet can worry users and make the spreadsheet application look unfinished. This turorial shows you two ways to remove these error messages Extending Charts and Equations for Dynamic Data In this presentation we are going to look at how we can use dynamic data within graphs and equations in Excel. It is quite an ambitious tutorial and users techniques and functions that are covered in more ... Introduction to Named Ranges Once you have mastered the basics of Excel Named Ranges you will be able to make complicated equations and expressions that are simple to understand (and possibly debug at a later date!) This tutorial more ... Dynamic References to External Spreadsheets This tutorial show how you can create a dynamic reference to another spreadsheet based on parameters in your spreadsheet. The example uses the results from an Excel based questionnaire and fills all Introduction to Excel Offsetting The Microsoft Offset command is a very powerful function that can help you if you ever need to look at moving averages, or monthly accounts. I personally use this one function with every financial spreadsheet more ... Master Excel Dates Functions Excel Dates can drive you mad if you are not careful. However there are lots of ways to use dates in Excel and this tutorial give you some neat tricks to make your own calendar. You may not see an immediate more ... Nested IF statements This tutorial illustrates how IF statements in Excel an be placed inside other IF statements to make complex statements. If uses a very simply example of an end of year financial statement for 10 products more ... Introduction to the IF statement A beginners guide to the excel If statement and how they can be nested. Cell Referencing This tutorial shows you the difference between incremental and absolute referencing in excel. Or in other terns when to use A1 and when to use $A$1, A$1, $A1 Vlookup This Tutorials explains and shows you the basics of the VLOOKUP function. The tutorial shows two typical, but different, uses for this function Producing Consolidated Reports With Excel Consolidated reports in Excel are another rarely used, but powerful feature. If you have ever tried to merge excel spreadsheet data, either from different spreadsheets or even different work sheets in more ... Using Option (radio) Button on a Spreadsheet Quest This short tutorial shows you have to add Excel Option Buttons to your spreadsheet. It highlights the differences between using option buttons, checkboxes and dropdown lists in a simple questionnaire. The more ... Accounting Calendar This short presentation show you how to create an accounting calendar spreadsheet in Excel. It takes an example from a member of the site and shows how, with some simple equations, it can fully automated. more ... First and Last Names using Subsitute and Find This tutorial shows how just two commands (subsistute and find) and be used to pull out any text string from a cell. The example shows how you can find the first and last names of people no matter Finding Data using INDEX and MATCH The Index and Match commands offer a very powerful way to extend the functionalty of the Vlookup command. In this tutorial we examine how these two commands can be used on their own and then combine Financial Accounting Calendar This short presentation show you how to create an accounting calendar spreadsheet in Excel. It takes an example from a member of the site and shows how, with some simple equations, it can fully automated. more ... Auditing Spreadsheets This tutorial will show you two excellent techniques in Excel to immediatly understand how someone else's spreadsheet works and will give you confidence in changing some of the values in it will full Extracting Data from Lists - Part III (using OR) This presentation extends part I of this series. It takes the spreadsheet and adds up to 5 conditional statements to the query. This tutorial not only shows you how to do this but will also show you more ... Extracting Data from Lists - Part I This tutorial shows you how to set up query sheet to pull out statistical results from your data based on one or more criteria. The tutorial explains how to use the DSUM, DAVERAGE and DCOUNT functions more ... Extracting Data from Lists - Part II (using AND) This tutorial Shows you how to take the Excel DSUM function and use it to construct a very powerfully query spreadsheet with multiple creteria. After explaining the basics of how this function works more ... Using Excel Check Boxes on a Quote This Tutorial shows you how you can easily add simple check boxes to any Excel Spreadsheet. This tutorial explains how to add check boxes, how to set them up and then how to use the status of the check more ... Simplify Financial Data Using Groups and Outline Grouping and Outlining is a great way to help your spreadsheet readers to quickly see the data that is important to them. To often I see financial spreadsheets that are just a sea of numbers - well this more ... Pivot Tables Introduction to Pivot Tables Excel Pivot tables are one of the most powerful features in Excel and used by only a small minority of users. Why? Well if you have never used them, you will be the best person to answer that question more ... Single Column Pivot table This Tutorial shows you how you can use Pivot Tables even if you only have one column of data. This is a very powerful technique for counting groups of data and may well save you hours. The only other more ... Conditional Formatting Hiding Excel Error Messages Having Error messages such as #DIV/0! in your spreadsheet can worry users and make the spreadsheet application look unfinished. This turorial shows you two ways to remove these error messages Introduction to Conditional Formatting This introduction to conditional formatting shows how to easily highlight values in a financial spreadsheet based on values within the spreadsheet. Working with 2, 3 or 4 Conditional Formats Excel's conditional formatting allows you to add up to 3 conditional statements. This tutorial uses a set of student marks to show you 4 important things; 1) How to use this feature 2) The order Working with Lists Removing Blank Data From Lists This tutorials shows you a quick and easy way to remove blank data from your lists. The example uses a list of names, but it could easily be email address, stock codes or anything else you may have in more ... Mastering the Excel AutoFill Features The Autofill feature in Excel allows you to quickly fill in data. Most people only use a fraction of the power of this small and simple feature - the only interface it has is inside the red circle! If more ... Filtering Lists and the Status Bar This Tutorial shows how you can use the status bar and the auto filter option to analyse financial data without using a single function Comparing two Lists In Excel One of the great things that Excel is good at is comparing two sets of data to determine what has changed in each set. This tutorial will show you how to do this manually (very time consuming and not more ... Advanced Filtering If you need to filter a list of data by more than one criteria then the simple auto filter will not be clever enough for you. Instead you need to use Excel Advanced Filter options. This Tutorial covers more ... Removing Duplicates from a list Finding Duplicate entries in a list of data is one thing but being able to remove them can be quite time consuming unless you know the tricks in Excel. This tutorial uses a list of English Premiership more ... Removing Blank Rows from Spreadsheets Deleting blank rows in Excel is a very common requirement especially when the data has been exported from another application. I recently received the following message from a member of the library. I'm more ... Extracting Data from Lists - Part III (using OR) This presentation extends part I of this series. It takes the spreadsheet and adds up to 5 conditional statements to the query. This tutorial not only shows you how to do this but will also show you more ... Introduction to the Excel Array Formula Excel Array Formulas are a very powerful feature in Excel that until recently I had not found a use for. However once you have mastered how they work then a whole new area of Excel will open up for you. Excel more ... Finding Duplicates in a list This tutorial illustrates a really neat trick in Excel that allows you to use the COUNTIF function and conditional formatting to highlight duplicates in a list. The example uses email address for a more ... Extracting Data from Lists - Part I This tutorial shows you how to set up query sheet to pull out statistical results from your data based on one or more criteria. The tutorial explains how to use the DSUM, DAVERAGE and DCOUNT functions more ... Finding The Three Highest Values in a Grid of Data finding the highest number in a grid is easy using the MAX() statement but how do you find the 2nd and 3rd highest? This tutorial will show you how to use a little known function in Excel to return the more ... Extracting Data from Lists - Part II (using AND) This tutorial Shows you how to take the Excel DSUM function and use it to construct a very powerfully query spreadsheet with multiple creteria. After explaining the basics of how this function works more ... Printing Viewing and Printing Large Tables This tutorial shows how to use the best options in Excel to view and print large grids of data without getting lost in your own data. Once you have watched this tutorial there will be no more bits Case Studies Removing Blank Rows from Spreadsheets Deleting blank rows in Excel is a very common requirement especially when the data has been exported from another application. I recently received the following message from a member of the library. I'm more ... TimeSheet Case Study Part II This tutorial continues from the The Timesheet Case Study Part I and completes the example by automatically collecting data from external sheets. At the end of this tutorial you are simply able to Timesheet case study Part I This tutorial shows how you can pull data from one table and store it in another area of a spreadsheet. It uses a real life case study to show how you could pull timesheet data from a daily record onto more ... Case Study: Using MID and LARGE together This is an interesting tutorial that shows you how to determine the number of unique individual numbers combinations that are used to create the numbers 100 to 200. Although this is a slight odd topic more ... Advance Sorting and macros - Medial Case Study This tutorial shows a real life application of intermediate Excel techniques for sorting and making macros to make your life easier and quicker. This spreadsheet was submitted by a member of the tutorial more ... Case Study: Automatic Forms with excel One of the longest and most powerful tutorials on this site. This tutorial combines the OFFSET command, with dynamic names and the MATCH command to produce a Hazard Register that updates itself depending more ... Removing Blank Rows - Part II The best thing about Excel is there are always many different ways to do something and sometimes it can take a few goes to work out which one is best. After I send out the removing blank rows tutorial more ... Case Study: Aged Debtors Report with Array Formula This tutorial is a case study requested by a member of The Tutorial Library that illustrates just how powerful Excel array formulas can be. The Tutorial Examines one of the ways that you can use Excel more ... Case Study: Excel Array formula and MAX statement This tutorial is a case study requested by a member of The Tutorial Library that illustrates just how powerful Excel array formulas can be. The tutorial uses a debt sheet for a number of accounts and more ...