Advanced Classes

MS Access 1: Getting Started with Database Design

Class ID: 
37
accessv.jpg

Microsoft Access 1: Getting Started with Database Design: Learn basic principles of database design, how to plan your database, determine needed tables and fields, create database in Access, and set up tables.

Students should be comfortable using a PC; familiarity with word processing and spreadsheets very helpful.

MS PowerPoint 2: Design

Class ID: 
36
powerpointv.jpg

Microsoft PowerPoint II - A Closer Look: Delve more deeply into tools for enhancing your PowerPoint presentations. We will cover toolbars, text boxes, slide objects and more.

MS PowerPoint 1: Introduction

Class ID: 
35
powerpointv.jpg

Microsoft PowerPoint I - Introduction: Create a quick slide-show presentation using PowerPoint. Familiarity with word processing required.

MS Publisher 2: Advanced

Class ID: 
34
publisherv.jpg

Microsoft Publisher II - Advanced: Using a newsletter as an example, learn to flow and organize text, customize colors, and use other advanced techniques in Microsoft Publisher.

MS Publisher 1: Introduction

Class ID: 
33
publisherv.jpg

Microsoft Publisher I - Introduction: Use this desktop-publishing tool to create business cards, invitations, newsletters and other documents. Must have basic word processing skills.

Advanced MS Excel 2: Taking Formulas Further

Class ID: 
32
excelv2.jpg

Advanced Microsoft Excel II: Use range names and 3-D references in formulas; learn to use financial, logical and date functions; troubleshoot formulas and functions with auditing tools, use Goal Seek and Scenarios.

Students should have taken all previous Excel classes or be familiar with the skills covered.

Advanced MS Excel 1: Workbooks

Class ID: 
31
excelv2.jpg

Advanced Microsoft Excel I: Customize Excel 2007's Quick Access Toolbar, customize and manage your worksheets and workbooks, use custom number formats and conditional formatting.

Students must have taken the Basic Excel series or be familiar with formulas, functions and formatting in Excel.

Download handouts and practice problem files below. If files fail to download properly, try a different browser (Internet Explorer, Firefox).

MS Excel 4: Charts and Graphs

Class ID: 
30
excelv2.jpg

Microsoft Excel IV - Charts/Graphs: Explore Excel’s chart-making abilities. Create several types of charts, format charts, enhance and control axes, scales, labels.

MS Excel 3: Formatting and Printing

Class ID: 
29
excelv3.jpg

Microsoft Excel III - Formatting and Printing: Format Excel spreadsheets, control how numbers display, add colors and borders, use conditional formatting; learn printing, control page divisions, print row and column headers, and more.

MS Excel 2: Formulas and Functions

Class ID: 
28
excelv3.jpg

Microsoft Excel II - Formulas and Functions: Learn to do basic mathematical calculations with Excel.

Syndicate content