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.
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.
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.
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
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
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