>

DJ Dates

4Jul/122

PowerPoint 2010 Tutorial 3.1. Animations and Transitions

File can be downloaded from http://djdates.com/2010animations.pptx

In this video:
Animations Ribbon
Animation Effects
Transitions Ribbon
Timings and Rehearsal
Animation Pane
Custom Animations

This video is a remake of a previous video that demonstrated animations and transitions in PowerPoint 2007. If you have PowerPoint 2007, you would be better off watching that previous video, as some of these ribbon options have changed significantly.

26Jul/116

Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event

You can work along with this file:
database-with-forms.accdb

Code can be found at the end of the post.

In this video:

  • On Not In List event
  • Variables & Constants
  • msgbox()
  • if-else statement
  • Arrays
  • Split()
  • DoCMD.RunSQL
  • UBound()
  • Remaining Issues

When I teach my Access course, I often get students who feel that entering information into the database should be easier than it is, even with forms. Well, we can make it easier, but it usually requires some programming to do some work on behalf of the user. The more work we do, the less work the user has to do.

Filed under: Access Continue reading
4Jul/100

Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts

In this video, Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts

  • Pie Charts
    • Data Labels & Leader Lines
    • Chart Titles & Styles
  • Column Charts
    • Clustered vs. Stacked Charts
  • Line Charts
    • Select Data
    • Format Axis
    • Insert Shapes

You can work along with this file:
charts.xls

The data in this video was sourced from Netcraft.com and Wikipedia.org.

Filed under: Excel No Comments
22Jun/100

Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References

In this video, Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References

  • Relative Cell References
  • Absolute Cell References
  • Mixed Cell References

Work along with this file:

references.xls

Filed under: Excel No Comments
19Jun/100

Excel 2007 Tutorial 3.1. Using Functions

In this video, Excel 2007 Tutorial 3.1. Using Functions

  • Autosum Icon
  • Sum, Average, Count, Max, Min
  • Abs, Now Functions
  • Insert Function Icon
  • Pmt Function
  • Order of Operations
  • Using Functions inside Functions

Filed under: Excel No Comments
17Jun/100

Excel 2007 Tutorial 2.1. Formatting Spreadsheets

In this video, Excel 2007 Tutorial 2.1. Formatting Spreadsheets:

  • Text vs. Numbers
  • Currency vs. Accounting Format
  • Resizing and Merging Cells
  • Conditional Formatting
  • Clear Formatting

File used in this video: textbooks.xls

Filed under: Excel No Comments