On This Page...
On this page you will find a link to every lesson Mr. Miller has presented in class. The lessons include screenshots of the exact buttons you need to use in the Office programs so you can get an idea visually of what you need to do. The lessons may also include videos from the classroom lectures and the examples completed in class.
Excel Unit
- Excel Lesson 1
- Spreadsheet Terms
- Spreadsheet Titles
- The Ribbon
- AutoFit Cells
- Currency Style
- AutoSum
- Merge & Center
- Formatting Cells with Color
- Bar Charts
- Formatting and Resizing Charts
- Excel Lesson 2
- Math Formulas
- Cell References
- Inserting/Deleting Rows and Columns
- Viewing All Formulas
- Formatting a Spreadsheet for Printing
- Excel Lesson 3
- Assumption Tables
- Locking Cell References
- The Fill Handle
- Percent Style
- Counting with the Fill Handle
- Excel Lesson 4
- Functions (Average, Max, and Min)
- Selecting Disjoint Cells
- Pie Charts
- Excel Lesson 5
- The Choose Function
- Formula AutoComplete
- Line Charts
- Excel Lesson 6
- The VLookup Function
- Sorting Data
Word Unit
- Word Lesson 1
- Columns
- Headers
- Paragraph Styles (Left, Right, Center, Justify)
- Word Lesson 2
- WordArt
- Images
- Shapes
- Word Lesson 3
- Text Boxes
- Lines
- Word Lesson 4
- Cropping Images
- Rotating and Flipping Images
- Recoloring Images
- Creating Transparency in Images
- Word Lesson 5
- Microsoft Paint
- Word Lesson 6
- Layout of an Announcement
- Bullets
- Word Lesson 7
- Mail Merge
- Word Lesson 8
- Formatting a Title Page
PowerPoint Unit
- PowerPoint Lesson 1
- Fonts
- Graphics
- Presentation
- PowerPoint Lesson 2
- Adding New Slides
- PowerPoint Lesson 3
- Moving Slides
- Deleting Slides