PowerPoint Tutorial

Here is an excellent 69-page PowerPoint Tutorial, named Using Microsoft Powerpoint 2003. Using step-by-step instructions and screen shots, it teaches you how to use Powerpoint 2003 to its fullest, using much of its functionality. It shows you how to perform the following important tasks: formatting bullets, creating master views, working with clip art and images, creating charts and graphs, working with the drawing tools, using the color palettes, and making transitions and animation effects. This PowerPoint training guide and tutorial is 1.75mb in size and is in pdf format. It is located in the University's ITS Guides page.

Contents of Using Microsoft Powerpoint 2003 Tutorial:

- Introduction
- Getting started with PowerPoint
- The New Presentation Task Pane
- AutoContent Wizard
- Navigation
- The Views
- Design Templates
- Creating a new Slide
- Adding additional Slides
- Text formatting: Bullets
- Master Views
- Clip Art
- Inserting, scaling, moving and deleting objects
- Images
- Organization Charts
- Diagrams
- Charts and Graphs
- Comments
- Working with Drawing Tools
- Layout
- Using the Color Palettes
- Multi-media elements
- Slide Shows
- Transitions, simple Text Animation Effects and Timings
- Applying Animation Effects to text and objects
- Customizing Slide Shows
- Page / Slide Format
- Printing
- Saving Presentations
- Creating a Slide Show File
- Getting Help for PowerPoint

Printer friendly

Excel 2003 Tutorials from Kansas University

Here are 4 illustrated Excel 2003 Tutorials from Kansas University that demonstrate how use use many important features of Excel. These tutorials take you step-by-step through each task being taught using screen shots and easy-to-follow instructions.

Excel Introduction Tutorial

This introductory Excel tutorial will get you going with using Excel to perform fundamental tasks, such as creating, saving, and opening new Excel workbooks and worksheets; selecting, copying, and moving data; constructing formulas; formatting worksheets; and setting up worksheets for printing. (22 pages, 424kb, pdf format)

After using this Excel tutorial, you will be able to:
- Create, open, and save Excel workbooks
- Select, copy, and move data
- Create formulas using relative and absolute references
- Format worksheets
- Use Page Setup to set up worksheets for printing

Contents of Excel Introduction Tutorial:

Introduction
Objectives
Definitions
Creating and Opening Excel Workbooks
Inside an Excel Worksheet
Creating Formulas
Editing & Deleting Formulas
Copying Formulas and Values
Changing the Workbook or Worksheet Appearance
Getting Additional Help


Excel Data Management Tutorial
This Excel 2003 tutorial describes you how to use Excel to work with lists, data forms, filtering, and subtotals features, along with managing windows and link to data and formulas. (18 pages, 267kb, pdf format)

After using this Excel tutorial, you should be able to:
- Sort a data list
- Filter a data list according to criteria
- Extract data list information
- Use the subtotal function
- Adjust the spreadsheet windows

Contents of Excel Data Management Tutorial:
Introduction
Objectives
Using Excel lists
Creating a List
Sorting
To perform a Simple Sort
To Sort by Multiple Columns
Data Forms
Adding Data Using the Data Form
Finding Records Using Criteria
Filtering Data
AutoFilter
Advanced Filters
Special Features for Filtered Lists
Totals and Subtotals
Total Row
Subtotals
Managing Windows
Multiple Windows
Splitting Windows
Freezing Panes
Linking Data
Getting Additional Help


Excel Tutorial on Functions and Data Analysis Tools
This Excel 2003 tutorial will show you how to use Excel's functions and data analysis tools. Topics explained include functions such as Average and Sum, and data analysis tools such as pivot tables and conditional summations. (19 pages, 371kb, pdf format)

After reading and applying this Excel tutorial, you will be able to:
- Define terms related to using functions
- Create and edit a function
- Identify add-in functions
- Perform data analysis using Data Analysis Tools
- Create a formula with the Conditional Sum wizard
- Learn to troubleshoot a formula

Contents of Excel Tutorial on Functions and Data Analysis Tools:
Introduction
Objectives
Definitions
Inserting Functions
Sample Functions
Add-In Commands and Functions
Loading an Add-In
Unloading an Add-In
Data Analysis Tools
Histogram
Conditional Sum
Analyzing Data with the PivotTable
Array Formulas
Getting Additional Help


Excel Charting Tutorial
Learn how to use Excel to create and edit charts, modify chart options, and format chart objects, as well as use trendlines, forecasts, and error bars to present data graphically. (17 pages, 361kb, pdf format)

You will be able to do the following after going through this Excel tutorial:
- Create and edit charts
- Modify chart options
- Format chart objects
- Apply trendlines and error bars

Contents of Excel Charting Tutorial:
Introduction
Objectives
Definitions
Creating a Chart
Using the Chart Wizard
Modifying Charts
Formatting Chart Objects
Trendlines
Pie Charts
Creating a Pie Chart
Printing Charts
Printing an Embedded Chart on a Separate Page
Getting Additional Help

Student resources for Quantitative Approaches in Business Studies

Student resources
Excel supplement
The Excel supplement is a tutorial for Microsoft Excel. It was written by Bernard V Liengme specially as a supplement to Quantitative Approaches in Business Studies by Clare Morris.

The table below explains how the units of the tutorial link to the chapters of Quantitative Approaches in Business Studies. The student is advised to read the first two units carefully. The other units may be read in any order.

The units are in Adobe Acrobat format (PDF). The Adobe Acrobat Reader is available FREE from Adobe Systems Incorporated. The workbooks named below are in Excel 97/2000 format. Right-click on any file and choose Save As to save the file to your hard disk.

Tutorial Units	Quantitative Approaches in Business Studies Chapters
1 Getting Started with Microsoft Excel	2 Spreadsheets and other computer-based resources
2 Formulas and Functions	2 Spreadsheets and other computer-based resources
3 Solving Equations	1 Tools of the Trade 19 Linear Programming
4 Creating Charts	5 Presenting the Figures
5 Regression Analysis	13 Looking for Connections 14 Spotting the Relationship 15 Multiple Regression
6 Financial Calculations	18 Allowing for Interest
7 Descriptive Statistics Workbook: STATISTICS1	6 Summarising the Figures
8 Statistical Distributions Workbooks: PROBABILITY, NORMALDISTA, NORMALDISTB & NORMALDISTC	9 Patterns of Probability
9 Hypothesis Testing Workbooks: HYPOTHESIS and CHISQUARED	10 Estimating from Samples 11 Checking a Theory

Every effort has been made to be accurate but if you believe you have found an error please let the author of the supplement, Bernard Liengme, know. As stated above, the workbooks are in Excel 97/2000 format; files in Excel 5/95 format are available from the author upon request. The author will be pleased to answer questions on Excel but please make them clear and specific.

Bernard V Liengme

Copyright © 1995-2008, Pearson Education, Inc. Legal and Privacy Terms

Getting Started with Microsoft Excel- The Workspace

The Workspace

Figure 1 shows the Microsoft Excel 2000 window. Yours may not be exactly the same

because the user can customize the window. The main parts of the window are:

• Starting at the top we have the Title bar. When Excel is started a new workbook is opened with the name Book1.
• Below the title bar is the Menu bar. You can issue commands from the menu bar including such actions as saving the data to a file, printing a worksheet, changing the appearance of some text, etc. As with all Windows applications, menu commands may be executed by clicking an item or by typing the underscored letter while holding down the A key.
• Next come the Toolbars which provide a way of accessing some of the most used commands. The toolbars contain a subset of the complete set of menu commands. There are many toolbars but generally we have only two displayed: the Standard and the Formatting toolbars. By default, Excel 2000 displays the two docked together. We explain later how to separate them. You can specify which toolbars are visible with the menu command View|Toolbars. If you let the mouse pointer linger over a tool icon, Excel will display a tooltip. This makes it easy to learn the purpose of each tool.
• The Formula bar displays the current cell’s address in the Name box and either the value or the formula in that cell.
• The Worksheet window is the main working area. The space is ruled horizontally and vertically by gridlines, dividing the space into rows and columns. The smallest unit of space, where a row and a column intersect, is called a cell. At the top of the worksheet are the 256 column headings starting with A and ending with IV. To the left are the row headings numbered 1 to 65536 (or 16384 in versions prior to Excel 97). The letters (A, B, etc) at the top of the worksheet window are the column headers and the numbers to the left are the row headers.
• At the bottom of the worksheet window are the sheet tabs. A workbook is made up of worksheets and, optionally, chart sheets. Excel 2000 opens a new workbook with three empty worksheets.
• Finally at the bottom of the window is the Status bar. To the left is the message area. Most of the time this displays the word Ready. When you begin to enter something in a cell it displays Enter to remind you to complete the entry. At other times it may display Edit. To the right are some sculptured boxes called the Keyboard indicators. Press the c key a few times and watch the text “CAPS” appear and disappear.

2 Getting Started with Excel

Figure 1

The active cell is the cell with a border around it. To move to another cell and make it active, (a) use the keyboard arrow keys; (b) use the T key or the combination of S+T; or (c) simply click the mouse on the required cell. A quick way to return to cell A1 is the combination C+h.

Sources: Bernard V Liengme specially as a supplement to Quantitative Approaches in Business Studies by Clare Morris.