NOTE THAT THIS SITE IS NO LONGER BEING MAINTAINED. PLEASE USE OUR NEW SITE AT:
http://workshops.marshall.usc.edu ​

 ----------------------------------------------
This page contains the guides that accompany the Microsoft workshops taught at Marshall and guides on common tasks users of Microsoft applications encounter.  Note that Microsoft Outlook guides are found on the Email page.

 

Table of Conten​ts

 
​
 

Access 2002

Marshall AIS no longer officially supports Access for faculty and staff and therefore we have not kept our Access documentation current.  However, much of the information in the older guides provided below are still relevant.
​Guide Description​​​ ​Support / Exercise Files
Access Tables (2002) An introduction to Access, this handout covers an overview of the program as well has creating tables. Topics include: creating tables, setting field properties & the primary key, creating table relations, and inputting data.
 None
​Queries - Level 1 (2002) T​opics include single and multitable searches, using wildcards, searching using date and number ranges, calculations in queries, summarizing data, and action queries.​ ​Example
Database​
​Queries - Level 2 (2002) ​Topics include performing mathematical operations on grouped data, changing join properties to find data which is in one table but missing in another, finding unmatched data between tables, parameter queries, IIF statements in queries, and update, make table, delete, append, and cross tab queries ​​​Examp​le
Database​  
​Forms​ (2003)​ ​The use of forms to enter data. Topics include custom forms, drop down lists, check boxes, calculations in forms, and entering data into two tables from one form. ​Example
Database​  
​Reports (2002) ​Topics include mailing labels, form letters, summary and group reports, multitable reports, and calculations in reports. ​Example
Database​  
​Macros & Switchboards (2002) ​A switchboard is a screen containing buttons and drop down boxes that can be used as a main menu to control common access functions. Topics covered include placing command buttons on switchboards to open forms, tables, and execute queries; drop down boxes to go to records, and macros to filter data. The DSUM and DLOOKUP function will also be covered as well as macro basics. ​Example
Database​  
 
 

 
 

 
 

 
 


DreamSpark - Free Software for Students  (MSDNAA)

DreamSpark Guide. 
​
Through their DreamSpark Program Microsoft makes much of its development and design related software availabel to USC students for free.  Instructions in the guide above cover searching, downloading, and decompressing Microsoft software.   Downloadable software includes:​
  • Access
  • Expressions Studio
  • Lync
  • MapPoint
  • Mathematics
  • OneNote
  • Project
  • SharePoint  Designer
  • Visio
  • Visual Studio
  • Windows
  • XNA Game Studio
 


 

Excel

​Guides ​Description ​Exercise / Support Files
Excel Keyboard Shortcuts (2007) Lists the keyboard shortcuts available in Excel 2007.  (Note that most of these also work in Excel 2003). 
 No​ne
​Excel 2003 to 2007 Cheat Sheet ​This guide is designed to help uers of Excel 2003 or earlier migrate to then new interface introduced in Excel 2007 and also used in Excel 2010. ​None
Beginning - Excel (2007)
 An introduction to Excel. Topics include navigation, highlighting, selection, entering & editing cells, basic formulas, simple functions, coping, using absolute addresses, and printing. ​
 Absolute Address Exercises

Exercise Solutions​​
Intermediate - Excel (2007)
 ​Covers the following topics:  Working with multiple sheets, linking files, range names, Goal Seek, Solver, Scenario Manager, and If() Statements. ​​
Interm-
e​diate
​Charts - Excel (2007) Covers creating bar, line, area, column, pie, linked pie, XY Scatter, and bubble charts using the wizard and an example of setting ranges manually. 
 ​

Ch​arts
​Sparklines and Conditional Formatting -  Excel (2010)  ​Covers creating Sparklines and Conditional Formatting.  Conditional formatting examples include using the built-in criteria as well as creating your own criteria through formulas.  ​

Spar​klines & Conditional Formatting
Data Tables and Dates Workshop Abridged ​This contains the most commonly used features from the "Date / Time Functions" guide and the "Data Tables" guide combined into a single workshop.
Dates and DataTables Combined​
​Date / Time Functions - Excel

 ​Covers how to add and subtract dates and times as well as the following functions:  Match(), Index(), Time(), Date(), Hour(), Minute(), DateDif(), WeekNum(), Weekday(), Year(), Month(), Eomonth(), Edate(), Weekday(), If(), Choose(), and NetWorkingDays().

 

​
Dates

​Data Tables ​Covers how to create a one variable and two variable data table. DataTable Exercises​
Databases -  Excel (2007)
 Includes proper database construction, sorting, filtering, advanced filter, database functions (Dsum), tables, data validation, transpose, finding duplicates, vlookup, and working with external data. 
 Databases​
​Breakeven Analysis (Excel 2007-2013) ​Covers how to find the breakeven price (or units) uisng Goal Seek, Breakeven equations, and how to produce mutlple breakeven prices using a one variable data table.  Also includes how to adjust cost per unit using Vlookup(). ​None
​Financial Functions - Excel (2007) Covers using the following financial functions in Excel:  PV, FV, PMT, NPV, IRR, RATE, MIRR, NPER, YIELD, EFFECT, NOMINAL, PRICE, and ACCRINT. 
 ​Financial Functions
​Macros Recorder an Intro to VBA ​Covers using the Macro Recorder and an introduction to Visual Basic for Applications and Custom Functions. Macros​
Custom Functions
 This workshop covers how to create your own functions in Excel.  It introduces the VBA editor and covers the following custom function topics:  variables, constants, debugging code, commenting code, If Then Else, Select Case, For Each Next Loop, MessageBox, and using your custom functions in other Excel workbooks. ​Custom Functions
​Pivot Tables -  Excel (​2007) A PivotTable allows you to easily analyze data stored in database or tabular format by creating a matrixs with column and row headings.  This handout covers PivotTables, PivotCharts, summary operators, grouping, calculated items, caculated fields, and formatting. 
 Databases​
​Statistics Workshop - Excel (2013)​​ Topics include:
Weighted Average, Summations, Factorials, Frequency Distributions, Rank, Percentile, Normal Distributin, Standard Normal Distribution, Probability Distributions,  Z-Scores, T-Tests, Z-Tests, Simple Linear Regression with Slope, Y-Intercept, Forecast(), and Trend(), Chi-Square. 
 ​Statistical Func​tions​

​Advanced Excel - Dashboards & Reports

(Utilizing VBA Macros & Functions)

​Topics include creating a dynamic dashboard with charts and tables that update when a user selects a specific company or financial.  Skills include using:

  • The Macro Recorder.
  • Introductory VBA Coding. *
  • Radio Buttons and Drop Down Lists.
  • Charts.
  • PivotTables & PivotCharts.
  • Range Names.
  • The Camera Tool. 
  • Choose().
  • Vlookup().
  • Index() & Match() in an Array.
  • Linking Between Sheets

* Note that VBA a complex programming language that we will touch on but cannot hope to learn in a three hour workshop.  Consider this an exposure to it that you can use to decide if this is something you wish to persue further.

 

Dashboards​

​Excel ​for Professor Ryan's Class ​ ​
​Excel for Special Saturday Workshops ​ ​
 
 

 

 

 

Expressions Web​

​Guides ​Description ​Exercise / Support Files
Expressions Web Workshop 1 - Introduction
 Introduction to HTML using Microsoft Expressions Web 4.  Topics include creating a site using Expressiosn web as well as publishing to the USC student web server as well as working with text, images, hyperlinks, and lines.   EW1​
Expressions Web Workshop 2 - Page Layout ​Introduction to CSS and page layout using Microsoft Expressions Web 4.  Gives an overviewe of  CSS html selector styles, descendent selectors, inline styles, class styles and ID styles.  Exercises include altering the properties of an HTML tag via CSS, floating images and <div> containers, relative positioning, absolute positioning, and nesting absolutely positioned containers inside of relatively positioned containers. EW2​
​​

 

 
 

Lync

Lync guides are located on the Remote Computing page
 

 
​

PowerPoint

Note that PowerPoint 2007 for Windows is very similary to PowerPoint 2010 for Window and somewhat similar to PowerPoint 2011 for the Mac.
​Guides ​Description ​Exercise / Support Files
Introduction - PowerPoint (2007)  Covers selecting a theme, creating title and bulleted slides, showing your presentation, and printing. None
SmartArt - Powerpoint (2007) ​SmartArt consists of a gallery of premade graphics and text boxes that allow you to quickly expression your ideas in a graphic manner. None​
​Charts - PowerPoint (2007) ​Covers creating the following types of charts:  pie, column, bar, line, area, scatter, stock, and bubble. ​None
​Themes - PowerPoint (2007) ​Covers modifying existing themes and and creating new themes and layouts. ​None
​Images and Drawing Tools - PPT (2007) ​Covers using the drawing tools and working with text and images. ​None
​Animation - PowerPoint (2007) ​Covers animating text, images, and drawn objects. ​None
​Multimedia - PowerPoint (2007)​ ​Covers how to play movies and sound during a PowerPoint presentation.  Also includes playing a YouTube video and packaging a CD. ​​None
​
​
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
​​ ​​​​​​​​​​​​​​​​​​​​
​​​​​​​