Friday, March 20, 2009
MailMerge
Personalize cover letters and emails using the Mail Merge functionality
in Microsoft Word 2007
in Microsoft Word 2007
Using Pivot Tables to View Data in Access 2007
How to use pivot tables to analyze data in Access 2007.
Thursday, March 19, 2009
Microsoft Access Convert Numbers to Dates - Advanced
If you have dates in your tables that were stored as numbers (990102) this lesson will show you how to convert them to Access Date Fields using string concatenation and an update query.
Microsoft Access - Tips and Tricks
Tips and Tricks video on integration between Microsoft Access and Outlook
Microsoft Excel #09: Using the REPT (Repeat) Function - Neat
This is a quick Microsoft Excel tutorial that demonstrates the ease-of-use of using the REPT function to display a bar-graph like column of data.
Microsoft Excel #08: Working with Dates
We will go over formatting dates and using dates in formulas. We will calculate the number of days you've been alive, an employees seniority, etc. We'll learn the "today()" and "now()" functions.
Microsoft Excel #07: Importing Data & Working with Graphs
How to walk you through important large amount of data (i.e. from the Internet) and converting it to columns. Then go over multiple graph styles and techniques.
Microsoft Excel #06: Using "IF" in Formulas
More advanced formula uses including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40." This is a very powerful ...
Microsoft Excel #04: Excel as a Database
Using Excel as something of a simple database. Using it to keep track of movies, collectibles, etc. because of the ease of organizing data, and the ability to filter data on-the-fly with AutoFilters and Sorts.
Microsoft Excel #03: Cartesian Coordinate & Venn Diagram
Using Microsoft Excel to produce a Cartesian Coordinate Plane and a Venn Diagram.
Microsoft Excel #02: Create a Seating Chart
Creating charts and diagrams may not be the first thing you think of when you use Excel, but I use it all the time. In this example I use Excel to create a seating chart for my computer lab.
Microsoft Excel #01: Introduction to Excel
This will introduce some of the basic concepts and then demonstrate a couple practical uses.
Microsoft Word : Using Pictures and Clip Art
I often get asked about formatting documents in Word -- especially when people want to insert pictures. These items are covered as well as the process for capturing shots of your computer screen.
Microsoft Word : Tips & Tricks for Making Word Awesome!
In this tutorial I discuss some tricks for speeding up your work, adding extra function to Word, and I through in some tips most people don't know about.
Subscribe to:
Posts (Atom)
