Click blue button above to begin.

Microsoft Excel Tutorial

These lessons and step-by-step tutorials in “courseware format” are for students to learn how to use Microsoft Excel in thousands of registered school institutions with advanced sections for post-secondary users. These Microsoft Office tutorials and lessons apply to Microsoft Excel 2007 and 2010, a powerful windows spreadsheet software. The courseware is now available on-line for free for the general public to learn through a Computer Literacy Program. Providing free educational material is a mandate of the program. Everyone, at all ages and abilities can learn how to master MS Excel spreadsheets, as well as MS Access, MS Word and PowerPoint through these carefully crafted and engaging tutorials. Note: Access, Word, and PowerPoint are found on the home page.

• 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