IT Training Modules are offered for download on Amazon Kindle.

If you are a CPA looking for Continuing Education credits, find our training modules and others at CPEThink.com.

 

 

Visit

DawgHouse

IT Modules

 

 

 

IT Training Modules

OfficeFest 2007

OfficeFest 2007 is a collection of documents written with the Microsoft® Office 2007 user in mind. These documents are written with the intent of showing the reader aspects of Office 2007 that they might not otherwise use. The “voice” in the collection is informal to make a more relaxed atmosphere for the reader.

Using Microsoft Excel for Financial Analysis

Using Microsoft Excel for Financial Analysis offers an overview of formulas and functions, relative and absolute references, as well as in depth look at financial functions, such as PMT, CUMIPMT, FV and more.

Microsoft Excel 2007 Pivot Tables and Pivot Charts

This document introduces you to using Pivot Tables and Pivot Charts within Excel 2007. You will learn how to use pivots to manipulate data available in an Excel spreadsheet. You will work with columns and rows, and learn how to summarize data, such as the Sum and Average functions. You will learn how to open and use PivotChart Tools, including chart types, chart designs, and add chart titles. This document also instructs how to import data from an external source.

Visual Basic for Applications in Microsoft Excel 2007

This document is designed as an introductory course to Visual Basic for Applications (VBA) for Excel 2007. You will learn what VBA is, and how it is used in Excel to create programs that might make your daily grind easier. You will learn how to write the code to create a calculator, how to add new worksheets to a workbook that duplicates an existing worksheet, and you will learn how to create a time logging application (DayLogger) that allows you to log start and end time as you work on a client’s job. DayLogger then calculates the time spent, and enters the information in a spreadsheet.

Using SQL View in Microsoft Access 2007

This document is for moderate to intermediate users of Access. An assumption is made that the user knows Access database terminology and processes, such as how to create tables with fields and records.

Outlook 2007: Everything You Always Wanted to Know, and More. Lots More. Even More Than More.

In this document you will learn about Outlook 2007, and its components. You will learn the steps to setup Outlook for a POP3 mail server. This document will teach you about the components of Outlook, including Mail, Calendar, Contacts, Tasks, Notes and Journal.

It is assumed you already have Outlook 2007 installed, and an e-mail account (address) and password provided to you by your Internet Service Provider (ISP). Outlook does not create this for you.