| 11/23 | Access 2010 Beginner 1 If you are new to Microsoft Access 2010, this video tutorial will teach you all of the basics of how to build a Microsoft Access database. You will learn:
- Database Terminology & Benefits
- Planning Your Database
- The Access Interface & Ribbon
- Building a Customer Table
- Entering and Editing Data
- Sorting & Filtering Records
- Constructing Customer Queries
- Designing a Customer Form Interface
- Developing Reports & Mailing Labels
Click here for more [more...] |
| 10/21 | Access SQL Seminar Part 3 This two-hour long seminar on Microsoft Access SQL picks up where PART 2 left off. You will learn how to manipulate the structure of your databases using simple SQL commands. You'll be able to build and modify tables, queries, indexes, relationships, and much more. These techniques are especially powerful for developers who have to support remote, back-end database [more...] |
| 10/01 | Excel 2010 Expert 10 Excel Expert 10 covers several different features. Topics covered include:
- Working with Custom Views
- Using the SUBTOTAL Function
- Creating Data Sheet Outlines
- Expand & Collapse Data Groups
- Control Input with Validation
- Select Values in Dropdown Lists
- Multiple Cascading Drowndown Lists
- Lookups with the DGETS Function
- Lots More! |
| 08/09 | Excel 2010 Expert 9 Excel Expert 9 covers several different features. Topics covered include:
- Advanced Sorting Techniques
- Creating Custom Lists
- Customizing the Excel Interface
- Modifying the Quick Access Toolbar
- Creating Custom Ribbon Tabs
- Advanced Data Filtering
- Special Text, Numeric, Date Filters
- Create a Custom Filtering Section
- Lots More!
|
| 07/20 | Excel 2010 Expert 8 Excel Expert 8 covers several different features. Topics covered include:
- Protecting Worksheet Contents
- Encrypting Workbooks with Password
- Advanced Copy & Paste Methods
- Paste Special Options
- Using the Office Clipboard
- Fill & Series Fill
- Customizing the Quick Access Toolbar
- Data Entry Forms
- Lots More! |
| 06/14 | Excel 2010 Expert 7 The focus of this course is working with PivotTables and PivotCharts in Excel. Topics covered include:
- What is a PivotTable? Why use them?
- Creating a PivotTable
- Set Values, Row & Column Labels
- Editing a PivotTable
- Sort, Filter, Expand, Collapse, Pivot Data
- PivotTable Layout, Slicers, Multiple Values
- Subtotals, Styles, Data Subsets
- Creating & Editing PivotCharts
- Grouping Data by Month, Value Ranges
- Lots More! |
| 06/08 | Excel 2010 Expert 6 The focus of this course is working with financial functions in Excel. Topics covered include:
- Financial Terms & Functions
- PV, FV, PMT, RATE, NPER
- Loan Calculator with Multiple Scenarios
- Investment Calculator with Multiple Years
- Interest Rate Calculator with ROI
- Millionaire Calculator
- Home Value Calculator (how much house?)
- Loan Amortization Schedule
- Credit Card Payoff Calculator
- Lots More!
|
| 06/06 | Excel 2010 Expert 5 The focus of this course is working with math and basic statistical functions in Excel. Topics covered include:
- More with the SUM function
- Calculating a Running Balance / Total
- The SUMIF and SUMIFS functions
- Counting Numeric, Blank, Non-Blank Cells
- Rounding Up, Down, and more
- Lots of Math (Median, Sqrt, Modulus, Random)
- Automatic Recalculation
- Basic Trigonometry in Excel
- Calculate the Height of a Building
- Lots More! |
| 06/04 | Excel Expert 4 Handbook Released The handbook for Excel 2010 Expert Level 4 was just released and is now available on the site.
If you've previously purchased the video tutorial for this course, you can get the handbook on the Handbook Order Page.
If you haven't picked up this course yet, then what are you waiting for? ORDER NOW. |
| 06/02 | Access Payables Handbook Released I just posted the handbook for the Access Payables Seminar online. If you have purchased the course previously, you can now order it from the Handbooks page. |