Excel Video Tips
|   Home    |    Excel    |    Access   |   Word   |   VBA   |   Downloads   |   Contact   |   Index   |
eBooks

eBooks by Martin Green

Do you want to learn more about Access, Excel and VBA? Are you a teacher looking for top quality courseware for your students? My eBooks are the ideal solution to your needs. They are packed with code snippets, illustrations and step-by-step exercises. Written in the same style as my popular on-line tutorials, my eBooks will help you develop your skills and build useful, professional looking applications. Find out more at my eBooks Page.

 

Excel Video Tips

Here you will find a wide range of video tips for Microsoft Excel. I plan to add videos suitable for range of skill levels from absolute beginner to advanced user so check back occasionally for updates. The videos were recorded using Excel 2007 or 2010. To save space I have kept the video frames you see on this page quite small but the videos were all recorded at 1024x768 resolution and are best viewed at 720p (HD) quality. You can also view the videos full-screen. See the screenshots below for how to do this.

All the videos are hosted on YouTube so you can view them there if you prefer. Just click the YouTube link on the video player or visit my YouTube Video Tips Channel at www.youtube.com/martingreenvba.

How to change the video settings

Currently Available Videos for Excel

  • Excel's Business Tools - What-if Analysis
    This video uses the simple example of a cash loan to demonstrate some of these tools. It makes use of Excel's PMT Function to calculate repayments on a loan, then shows how you can use the Goal Seek tool to manipulate variables such as the amount borrowed, repayment period and interest rate to arrive at a desired result. You will see how to use Data Tables to display a large number of calculations employing one or two variables and finally use Conditional Formatting to present the results in an easily understandable way
  • Analysing Business Data with Excel - The Subtotal Tool
    A useful way to summarize data is to sort it then add subtotals to each group. Done manually, this can be very time consuming. The data used in this example requires subtotals to be calculated for 13 offices each of which has 8 departments, a total of 112 separate subtotals (one for each department in each office and another for each office as a whole). The Subtotal tool can achieve this with just a couple of mouse clicks and allows you to display the data with its subtotals or just the subtotals themselves. And it is just as easy to remove the subtotals when you are finished. This video shows you how to do it.
  • Analyzing Business Data with Excel - The SUMIF Function
    This video explains how to useExcel functions (SUMIF, AVERAGEIF, COUNTIF) to analyze business data and includes some useful, timesaving tricks to help you make sense of your data. It demonstrates how to use these functions creatively with the aid of some of Excel's other features such as the Autofill tool (to quickly enter multiple calculations) and the Remove Duplicates and Data Validation tools to add a useful dropdown list.
  • Excel Pivot Tables #1
    The first of a three-part tutorial introducing Pivot Tables in Excel 2007/2010. It demonstrates how to select data and summarize it by using a Pivot Table, how to rearrange and filter the table and how to "drill down" to display the source data underlying any value in the table.
  • Excel Pivot Tables #2
    Part two of three tutorials introducing Pivot Tables in Excel 2007/2010. It demonstrates how to format numbers and text in a pivot table, add or remove grand totals and use the Design tools to select a color scheme.
  • Excel Pivot Tables #3
    Part three of three tutorials introducing Pivot Tables in Excel 2007/2010. Demonstrates how to group and ungroup fields in the table and add subtotals to the groups, how to rearrange rows, and how to specify how data is summarized.
  • Excel Spreadsheet Techniques #1
    This is the first part of a two-part tutorial illustrating a range of techniques useful for creating all kinds of spreadsheets in Excel. Starting with basic data entry and formatting this part goes on to build a simple interactive financial model. It includes formulas that use percentages. It uses the Autofill tool to simplify the entry of text and calculations, and illustrates the significance of absolute references in formulas. Finally, a drop-down list is added to create a simple interactive tool.
  • Excel Spreadsheet Techniques #2
    The second part of the tutorial enhances the model created in part one with the addition of a chart. It shows how to select the data for the chart and illustrates the importance of choosing the right type of chart. You learn how Excel's tools make it easy to create professional looking charts and customize them to get them looking just the way you want.

More Excel Videos in the VBA Videos Section

  • Build a Pop-up Calendar for Excel - Part 1
    The first of three videos that accompany my popular tutorial A Pop-up Calendar for Excel and is an excellent introduction to working with UserForms in VBA. The entry of dates is always a headache for people who use spreadsheets or databases. How should the date be written and in what format and what was the date of the third Thursday in October last year anyway? The answer is my pop-up calendar. Use a keyboard shortcut or right-click on a cell to ask for the calendar and all you have to do is pick a date. This short introductory video shows you what the calendar will look like and what it can do. [03:36]
  • Build a Pop-up Calendar for Excel - Part 2
    In this second video I show you how to create a UserForm in Excel's Visual Basic Editor. I add a command button and the calendar itself and write the VBA code to make it work, as well as a macro to open the calendar in Excel. [26:55]
  • Build a Pop-up Calendar for Excel - Part 3
    In the final video I enhance the calendar by writing some code to have it synchronise with an existing date, then add code to the workbook that defines a keyboard shortcut and creates a new item on the cell's right-click menu. Finally I convert the project file into an Excel Add-In for safe and easy distribution. [30:40]
^ top