• MS Access
  • Section 1: Tables/Forms/Images/Drop Lists etc.
    • 1A Intro Databases: Enter Data into Tables, Datasheet View, Types of Databases, Careers in Databases, Overview Microsoft Access
    • 1B Tables: Create Tables, Add Fields in Design View, Primary Key, Data Types, School Database
    • 1C Create Forms: Autoform, Enter Records in Form, Modify Layout, Design and Layout View, Insert Images into Form, AutoFormat, Create Form Header
    • 1D Lookup Lists and Images:Drop List List in Tables and Forms, Lookup Wizard, Add Fields to Form, Insert and Modify Images
    • 1E Movie Database: AutoNumber, Primary Key, Insert Clip Art, Modify Image,
    • 1F: Putting It All Together
  • Section 2 Queries/Relationships/Subdatasheets etc.
    • 2A Navigating Tables:Find Records and Replace Records
    • 2B Creating Queries: Single and Multiple Criteria, Sorting
    • 2C Lookup Data From Another Table: Lookup Wizard, Delete Relationships
    • 2D Using a Subdatasheet: Insert Subdatasheet From Related Table
    • 2E Primary Keys - Movie Database: Autonumber, Date Function,
  • Section 3 Forms/Reports/Grouping Sorting/Parameters etc.
    • 3A Primary Key / Import and Export: Import Text File, Export Data
    • 3B Autonumber / Import and Export: Append Records in Table
    • 3C Lookups / Subdatasheets / Relationships: Subdatasheet in a Form
    • 3D Reports: Modify Report in Layout and Design View, Add a Group and Sort
    • 3E Report Wizard: Create and Modify Reports Using Wizard
    • 3F Report Parameters
  • Section 4: Functions/Action Queries//Macros etc.
    • 4A Review: Tables, Queries, Forms, Lookups, Subdatasheets, Reports
    • 4B Reports: Headers / Footers / Functions
    • 4C Action Queries: Delete Query, Append Query, Update Query
    • 4D Calculated Fields in Queries / Reports:
    • 4E Automated Database: Custom Buttons, Modules, Macros, Message Boxes
    • 4F: Appointment / Invoicing Database:
• MS Excel
  • Section 1: Formulas and Formatting etc.
    • 1A Check Register: Entering Data and Formulas, Formatting Cells
    • 1B Income Statement Example: Formulas and Formatting
    • 1C Class Textbook List: Small Database Lists and Sorts
    • 1D Financial Projections
    • 1E Computing % Changes: Balance Sheet Example
    • 1F Putting It All Together: Create an Invoice
  • Section 2: Relative References, Charts / Graphs etc.
    • 2A Retail Inventory: Markup Formula, Relative and Absolute References
    • 2B Stock Market Example: Min, Max, and Average Functions
    • 2C Charts and Graphs
    • 2D Making Linear Predictions Using Autofill Procedures, Line Charts
    • 2E Putting It All Together: Creating a Report to Shareholders
  • Section 3: If Function, Linking Worksheets, Lookups etc.
    • 3A work Schedule: If Statement, Conditional Formulas
    • 3B Work Schedule: Copying, Moving worksheets
    • 3C Payroll: columns and Rows in Linked Worksheets
    • 3D CD Store: Vlookup Formula, Looking Up Values From Another Sheet
    • 3E Templates: Interest Calculations and Cash Flow, Total Interest on Loan
  • Section 4: More Functions, Mortgages, Loan Calculations etc.
    • 4A PMT Function
    • 4B Mortgages, Monthly Payments, Principal and Interest
    • 4C PMT, Buying a Home You Can Afford, Gross Debt Ratio
    • 4D Loans and Leases, Protecting Worksheets, Locking Cells
    • 4E Goal Seek: Pensions and Investments, Personal Savings Plans
    • 4F Investment Decisions, Calculate Net Present Value and Risk
  • Section 5: Creating Macros, Programming /Automating Worksheets
    • 5A Programming Modules in Visual Basic, Macro Enabled Workbook
    • 5B Recording a Macro, Using Variables in Macros, Create Buttons
    • 5C Range and Cells Methods of Selecting Cells, Declaring Variables, =Now()
    • 5D Offsets and Loops in Macro Programming
    • 5E If Then Statements and Input Boxes in Macro Programming Modules
    • 5F Columns, Filters and Queries in Spreadsheets
• MS PowerPoint
  • Section 1: PowerPoint/Presentation Skills
    • 1A Images on Master Pages, Design, Custom Animation, Effects
    • 1B Business Presentations Charts, Graphs, Tables, Organizational Chart
    • 1C Kiosk Demo, Hyperlink to Slide
    • 1D Professional Looking Presentations
    • 1E Effective Presentation Tips, Narration, Presenter Notes
    • 1F Putting It All Together
• MS Word
  • Section 1: Letters, Merges, Tables, Reports, Resumes etc.
    • 1A Business Letters: Format, Text Wrap, Insert Text Box, Logo
    • 1B Mail Merge: Format Tables, Form Letters, Flyers
    • 1C Mailing Labels: Envelopes, Name Badges, Merge Certificates
    • 1D Reports: Headers, Footers, Title Pages, Comments, Track Changes, Leaders
    • 1E Resumes, Cover Letters
    • 1F Advanced Tables
  • Section2: Columns, Images, Layout, Word Web Pages
    • 2A Directory: Columns, Breaks, Sections, Drop Caps, Lines, Borders
    • 2B Logos: word Art, Shapes, Pictures, Shadow, Watermark, Transparancy
    • 2C Brochures, Newslettters, Linking Text Boxes, Verticle Text
    • 2D Word Web Pages: Backgrounds, Themes, Colors, Images
    • 2 E Frames, Hyperlinks, Images, Bookmarks, HTML
    • 2F Putting It All Together
• Instructor Materials
• Contact Us

CSS3 Form Buttons Css3Menu.com

Certification: Available for schools and post-secondary students as well as "General Public". Small processing fee applies to general public users, contact us for additional information.

Certificates appear "online" and can be linked to from your social networking media, electronic resumes or applications for employment. Employers and educational institutions can verify from online certificates and reference skills learned from the course.

All materials and web pages copyright protected by the original publisher of materials (see Contact Page for additional copyright info.). The material on this site and downloaded files may not be altered in any way or reproduced for use electronically or printed for distribution.

*Microsoft Office, Excel, Access, Word and PowerPoint are registered trademarks of Microsoft Corp. FreeOfficeTutorials.com is not affiliated with Microsoft Corp.

Use the blue navigation buttons above to go to specific lessons and tutorials or look further down the page for listing.

Microsoft Access Tutorials

Microsoft Excel Tutorials

• Section 1: Formulas and Formatting etc.

  • 1A Check Register: Entering Data and Formulas, Formatting Cells

  • 1B Income Statement Example: Formulas and Formatting

  • 1C Class Textbook List: Small Database Lists and Sorts

  • 1D Financial Projections

  • 1E Computing % Changes: Balance Sheet Example

  • 1F Putting It All Together: Create an Invoice

• Section 2: Relative References, Charts / Graphs etc.

  • 2A Retail Inventory: Markup Formula, Relative and Absolute References

  • 2B Stock Market Example: Min, Max, and Average Functions

  • 2C Charts and Graphs

  • 2D Making Linear Predictions Using Autofill Procedures, Line Charts

  • 2E Putting It All Together: Creating a Report to Shareholders

• Section 3: If Function, Linking Worksheets, Lookups etc.

  • 3A work Schedule: If Statement, Conditional Formulas

  • 3B Work Schedule: Copying, Moving worksheets

  • 3C Payroll: columns and Rows in Linked Worksheets

  • 3D CD Store: Vlookup Formula, Looking Up Values From Another Sheet

  • 3E Templates: Interest Calculations and Cash Flow, Total Interest on Loan

• Section 4: More Functions, Mortgages, Loan Calculations etc.

  • 4A PMT Function

  • 4B Mortgages, Monthly Payments, Principal and Interest

  • 4C PMT, Buying a Home You Can Afford, Gross Debt Ratio

  • 4D Loans and Leases, Protecting Worksheets, Locking Cells

  • 4E Goal Seek: Pensions and Investments, Personal Savings Plans

  • 4F Investment Decisions, Calculate Net Present Value and Risk

• Section 5: Creating Macros, Programming /Automating Worksheets

  • 5A Programming Modules in Visual Basic, Macro Enabled Workbook

  • 5B Recording a Macro, Using Variables in Macros, Create Buttons

  • 5C Range and Cells Methods of Selecting Cells, Declaring Variables, =Now()

  • 5D Offsets and Loops in Macro Programming

  • 5E If Then Statements and Input Boxes in Macro Programming Modules

  • 5F Columns, Filters and Queries in Spreadsheets

Microsoft PowerPoint Tutorials

• Section 1: PowerPoint/Presentation Skills

  • 1A Images on Master Pages, Design, Custom Animation, Effects

  • 1B Business Presentations Charts, Graphs, Tables, Organizational Chart

  • 1C Kiosk Demo, Hyperlink to Slide

  • 1D Professional Looking Presentations

  • 1E Effective Presentation Tips, Narration, Presenter Notes

  • 1F Putting It All Together

Microsoft Word Tutorials

• Section 1: Letters, Merges, Tables, Reports, Resumes etc.

  • 1A Business Letters: Format, Text Wrap, Insert Text Box, Logo

  • 1B Mail Merge: Format Tables, Form Letters, Flyers

  • 1C Mailing Labels: Envelopes, Name Badges, Merge Certificates

  • 1D Reports: Headers, Footers, Title Pages, Comments, Track Changes, Leaders

  • 1E Resumes, Cover Letters

  • 1F Advanced Tables

• Section2: Columns, Images, Layout, Word Web Pages

  • 2A Directory: Columns, Breaks, Sections, Drop Caps, Lines, Borders

  • 2B Logos: word Art, Shapes, Pictures, Shadow, Watermark, Transparancy

  • 2C Brochures, Newslettters, Linking Text Boxes, Verticle Text

  • 2D Word Web Pages: Backgrounds, Themes, Colors, Images

  • 2 E Frames, Hyperlinks, Images, Bookmarks, HTML

  • 2F Putting It All Together

General Public users can have their online tests evaluated and receive certification for 80% competency.

A $15 evaluation fee for each test applies.

General Public

Click on the Buy Now button to pre-pay for an evaluation then email evaluate@FreeOfficeTutorials.com after you have taken the test.

Registered School Contribution for Testing Center/Certification:

Click below:

Use of this site assumes that you have read and agree to the copyright, limitation of liability and privacy policies as outlined on the contact page.