Advanced Classes

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.

MS Excel 1: Introduction and Data Entry

Class ID: 
27
excelv3.jpg

Microsoft Excel I - Introduction and Data Entry: Learn to start Excel, save and open spreadsheets, copy and paste cells, select and insert rows and columns, and type text and numbers.

MS Word: Templates, Headers and References

Class ID: 
25
wordv.jpg

The skills taught in this series of classes can be used in any document, but they are essential to create long documents efficiently:

  • Compile tables of contents based on Heading Styles.
  • Create a list of sources for footnoting and bibliographies, and place citations as footnotes or endnotes in the document.
  • Mark text for indexing and compile and update an index.

MS Word: Themes and Styles

Class ID: 
24
wordv.jpg

The skills taught in this class can be used in any document, but they are essential to create long documents efficiently:

  • Use columns and breaks to control text placement.
  • Use themes and styles to format headings, body text and other document components. Modify styles to make changes consistently throughout the document.

MS Word: Graphics 2

Class ID: 
22
wordv.jpg

Microsoft Word: Graphics 2: Add graphics to your Microsoft Word documents and control how they interact with document text. The two Graphics classes will cover photographs, Clip Art, Charts, Shapes, WordArt, and the new Smart Art graphics in Microsoft Office 2007.

MS Word: Mail Merge

Class ID: 
23
wordv.jpg
Microsoft Word 2007 - Mail Merge: Use Word to keep address lists; print form letters and address labels.
Syndicate content