Microsoft Office Level 1 & Level 2 Training Course Notes

Legal & Organizational Administration

The training curriculum and associated documentation are copyrighted property of CIS College. Any unauthorized reproduction, copying, or utilization of this content is strictly prohibited and subject to legal action.

Level 1 Microsoft Office Training: Foundation & Core Objectives

Program Overview

Level 1 is an introductory training course designed to establish a solid foundation across Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. It targets beginners and individuals seeking to solidify fundamental skill sets. The curriculum emphasizes basic document creation, text formatting, basic data analysis, spreadsheet construction, and multimedia presentation design. Instructional delivery incorporates live demonstrations, interactive icebreakers, practical exercises, and collaborative group tasks.

Core Objectives by Application

Microsoft Word (Level 1)

  • Text Styling & Editing: Create, format, and edit professional documents utilizing customized font styles, sizes, and color schemes.

  • Content Organization: Organize document content systematically using paragraph formatting options, bulleted lists, and numbered lists.

  • Page Structuring: Design structured documents incorporating custom headers, footers, and page breaks.

  • Table Management: Master the creation, structuring, and ongoing management of tables for data presentation.

  • Graphics Integration: Insert and manipulate graphical elements and visual objects to augment document content.

Microsoft Excel (Level 1)

  • Interface Navigation: Navigate Excel's layout, ribbon, grid structure, and workspace environment effectively.

  • Data Entry & Formatting: Input and format data with precision using cell styles and conditional formatting rules to improve visual readability.

  • Data Visualization: Build and customize diverse chart types to highlight patterns and trends in data.

  • Data Summarization: Summarize and evaluate complex datasets using PivotTables for immediate business insights.

  • Mathematical Calculation: Implement basic mathematical formulas and standard built-in functions to perform automated calculations.

Microsoft PowerPoint (Level 1)

  • Presentation Design: Craft clean presentations utilizing customized slide layouts and design themes.

  • Visual Dynamics: Apply slide transitions and element animations to maintain presentation flow.

  • Multimedia Integration: Embed external multimedia components, including images, audio tracks, and video clips, for storytelling.

  • Slide Management: Organize, reorder, and control slide progression across presentation decks.

  • Idea Communication: Develop visually appealing presentation materials that convey ideas clearly to audiences.

Level 2 Microsoft Office Training: Advanced Capabilities & Objectives

Program Overview

Level 2 is an intensive 20-hour program designed to expand upon basic operational knowledge of the Microsoft Office Suite. While advancing capabilities in PowerPoint and Word, the level focuses heavily on intermediate-to-advanced Excel functionality. Learning is facilitated through Trivia Quizzes, hands-on workshops, real-world analytical challenges, formula optimization, professional presentation design, dynamic charts, and collaborative document review workflows.

Core Objectives by Application

Suite Fundamentals Review

  • Conduct systematically timed evaluations to reinforce foundational concepts in Excel, PowerPoint, and Word.

Advanced Microsoft Excel

  • Formula Building & Functions: Master complex formula construction, error handling, and logical function execution.

  • Advanced Analytics: Execute advanced data manipulation using PivotTables, interactive Data Slicers, and multi-criteria filtering.

  • Data Storytelling & Visualization: Construct dynamic charts, graphs, sparklines, and visual indicators to present analytical findings.

Advanced Microsoft PowerPoint

  • Design Principles & Delivery: Enhance presentation creation by applying professional layout rules, multimedia sync, and presenter tools.

  • Interactive Content: Implement custom animations, slide master configurations, and multimedia integration for impact.

Advanced Microsoft Word

  • Collaborative Workflows: Execute multi-user document creation utilizing real-time collaboration tools, comment threads, and track changes.

  • Document Engineering: Format long-form documents using advanced typography, document sectioning, automatic tables of contents, styles, and footnotes.

Instructional Methodologies & Delivery Framework

Course delivery relies on twelve distinct pedagogical methods to ensure material retention and real-world applicability:

  1. Live Demonstrations: Real-time software walkthroughs conducted by the trainer highlighting specific tools and operations.

  2. Hands-On Practice: Direct student execution of functional tasks in Word, Excel, and PowerPoint immediately following demonstrations.

  3. Group Activities: Team-based problem-solving exercises designed to promote peer collaboration and communication.

  4. Interactive Quizzes: Formative assessments integrated throughout the course to measure recall and comprehension.

  5. Real-World Examples: Practical scenarios modeling business environments and workplace data challenges.

  6. Multimedia Content: Integration of video guides, motion graphics, and animated content to break down technical steps.

  7. Icebreakers and Energizers: Purposeful introductory activities designed to encourage active group participation.

  8. Practical Projects: Project-based milestones simulating end-to-end professional workplace deliverables.

  9. Visual Aids: Supplemental diagrams, process flows, and charts to clarify software infrastructure.

  10. Progress Tracking: Continuous monitor-and-feedback loops evaluating individual skill development.

  11. Practical Applications: Explicit focus on using Office software tools to solve operational tasks.

  12. Gamification Elements: Motivational frameworks utilizing points, performance badges, and rewards to drive engagement.

Level 1 Detailed Curriculum Breakdown

Lesson 1: Introduction to Microsoft Office

  • Core Syllabus Topics:

    • Comprehensive overview of the Microsoft Office Suite.

    • Identification of common user interface elements across applications.

    • Navigation protocols within Word, Excel, and PowerPoint environments.

  • Applied Pedagogical Activities:

    • Engaging Icebreaker: Presentation of historical milestones and productivity impacts of Microsoft Office.

    • Visual Walkthrough: Live demonstration of shared ribbon UI structures, file management, and quick-access toolbars.

    • Group Discussion: Facilitated exchange regarding prior software experiences, goals, and applications.

Lesson 2: Microsoft Word Basics

  • Core Syllabus Topics:

    • Getting Started: Document creation, save functions, template selection, and theme application.

    • Text Formatting: Font attributes (styles, sizes, colors), paragraph alignment, line spacing, bullets, and numbering.

    • Page Layout & Design: Margins, page orientation, paper sizing, header/footer configuration, and manual page breaks.

    • Table Operations: Table insertion, cell styling, data alignment, and structural modifications.

    • Graphics & Objects: Inserting pictures, geometric shapes, SmartArt graphics, and object layer management.

  • Applied Pedagogical Activities:

    • Step-by-Step Guide: Walkthrough covering document instantiation and template customization.

    • Practical Exercise: Timed typing task focusing on save protocols and template adaptation.

    • Before & After Examples: Visual contrast between unformatted raw text and professionally styled copy.

    • Collaborative Activity: Group exercise formatting text blocks using contrasting colors, font sizes, and paragraph alignments.

    • Storytelling with Headers and Footers: Exercise configuring headers/footers to format continuous narrative documents.

    • "Page Break Adventure": Activity strategically placing page breaks to control document pagination and content flow.

    • Real-World Data Entry: Designing operational tables for tracking expenses, schedules, and event itineraries.

    • Table Styling Challenge: Transforming unformatted data tables into visually clear grid structures.

    • Visual Storytelling: Constructing SmartArt infographics summarizing historical sequences or technical processes.

    • "Picture Puzzles": Arranging and layering sequence images to master graphic positioning.

Lesson 3: Microsoft Excel Fundamentals

  • Core Syllabus Topics:

    • Excel Introduction: Grid geometry, worksheet layout, cell address notation, and interface navigation.

    • Data & Formulas: Efficient entry techniques, manual formula building, and basic mathematical operations.

    • Formatting: Cell styling, format types (General, Currency, Date), and conditional formatting rules.

    • Worksheet Management: Managing sheet tabs (inserting, renaming, reordering, deleting) and cross-sheet data linking.

    • Charts & Graphs: Plotting chart types (Column, Bar, Line) and modifying chart components (titles, legends, axes).

    • PivotTable Analysis: Instantiating PivotTables, configuring fields, and calculating summary metrics.

  • Applied Pedagogical Activities:

    • Excel Spreadsheet Race: Data entry speed competition emphasizing accuracy in pre-built worksheets.

    • Excel Scavenger Hunt: Task list forcing exploration and discovery of specific ribbon functions and settings.

    • Interactive Formulas: Live calculation challenges where students predict formula results prior to evaluation.

    • Real-Life Formulas: Practical calculation models based on household budgeting and business expense tracking.

    • "Conditional Formatting Detectives": Team assignment applying rules to highlight data anomalies and trends.

    • Data Cleanup Challenge: Re-architecting and formatting messy, unorganized raw datasets.

    • Worksheet Olympics: Timed event measuring speed in sheet tab organization, color coding, and structure management.

    • Linked Data Treasure Hunt: Exercises requiring dynamic data referencing across separate sheets.

    • Storytelling with Charts: Mapping raw data to appropriate visual chart types to convey business trends.

    • Data Visualization Quiz: Analytical exercise critiquing visual charts for design flaws or misleading axes.

    • PivotTable Adventure: Summarizing multi-column datasets rapidly via PivotTable fields.

    • "PivotTable" Role-Play: Collaborative activity assigning distinct analytical roles (Sum, Average, Count aggregate functions) to build combined reporting models.

Lesson 4: Microsoft PowerPoint Essentials

  • Core Syllabus Topics:

    • Getting Started: Initializing slide decks, theme selection, and slide layout configurations.

    • Slide Management: Slide creation, sequencing, slide transition effects, and object animations.

    • Multimedia Integration: Embedding image files, audio playback, video files, and timing animated assets.

  • Applied Pedagogical Activities:

    • Presentation Inspiration: Analysis of high-impact slide presentations to study theme layout and typography.

    • "Design Your Dream Presentation": Exercise designing cover slides utilizing tailored themes and graphics.

    • Interactive Slide Transitions: Experimentation lab testing timing, context, and suitability of transitions.

    • "Animate Your Ideas": Constructing custom animation sequences to highlight key points step-by-step.

    • Media Showcase: Demonstrations detailing video integration, audio playback options, and compression settings.

    • Multimedia Extravaganza: Independent build of a multi-slide presentation incorporating sync'd video, audio, and visual assets.

Level 2 Detailed Curriculum Breakdown

Lesson 1: Suite Concepts Recap

  • Core Syllabus Topics:

    • Comprehensive review of core features across Excel, PowerPoint, and Word.

    • Application interface cross-comparison and navigation mastery.

    • Review of baseline data entry, editing rules, cell formatting, slide layout, and document parameters.

    • File management protocols: saving formats, file recovery, and access management.

  • Applied Pedagogical Activities:

    • Gamified Trivia Quiz: Interactive competitive quiz using multiple-choice questions and timed countdown rounds to measure foundation retention.

Lesson 2: Excel Essential Functions and Formulas

  • Core Syllabus Topics:

    • Syntax mechanics of formulas and built-in functions.

    • Operational hierarchy of arithmetic (+,−,∗,/+, -, *, /) and comparison (=,>,<,>=,<=,<>=, >, <, >=, <=, <>) operators.

    • Standard aggregation formulas: SUM, AVERAGE, COUNT, COUNTA.

    • Addressing mechanics: Relative cell referencing versus Absolute cell referencing ($A$1\$A\$1).

    • Logical, Lookup, and Text functions: IF, VLOOKUP, CONCATENATE.

    • Formula debugging, syntax correction, and error evaluation (#N/A, #REF!, #VALUE!).

  • Applied Pedagogical Activities:

    • Guided Problem Solving: Step-by-step construction of functional business calculations applied to real-world operational problems.

Lesson 3: PowerPoint Presentation Mastery

  • Core Syllabus Topics:

    • Advanced slide design techniques and structural layout optimization.

    • Formatting rules for custom shape groups, vectors, and complex text blocks.

    • Configuring Master Slides and Slide Layout templates for enterprise branding.

    • Precision controls for slide transitions and sequential animations.

    • Advanced multimedia integration: editing media timing, bookmarks, and poster frames.

    • Customizing Slide Shows, presenter view setup, and multi-monitor tools.

  • Applied Pedagogical Activities:

    • Presentation Construction Project: Individual assignment building a complete presentation project incorporating design standards, visual hierarchy, animations, and peer feedback sessions.

Lesson 4: Word Document Formatting and Collaboration

  • Core Syllabus Topics:

    • Typography control, line spacing, paragraph control, and style library creation.

    • Section management, break types (Page, Section, Continuous), paper orientation shifts, and running headers/footers.

    • Advanced graphic layouts: inserting embedded charts, dynamic tables, and SmartArt diagrams.

    • Collaboration tools: Track Changes, inline comments, revision accept/reject workflows, document lock settings.

    • Data automation: Executing Mail Merge operations for personalized mass communications.

  • Applied Pedagogical Activities:

    • Collaborative Peer Review: Group execution of real-time collaborative editing on shared documents utilizing Track Changes and comment threads.

Lesson 5: Advanced Excel Data Analysis

  • Core Syllabus Topics:

    • Advanced PivotTable architectures, calculated fields, and PivotChart generation.

    • Interactive filter elements: Slicers and visual Timeline controls.

    • High-level data filtering: multi-condition filters and criteria ranges.

    • Analytical What-If tools: Goal Seek and Solver add-ins.

    • Managing variable datasets via Scenario Manager.

    • Statistical analysis execution using the Analysis ToolPak and Descriptive Statistics features.

  • Applied Pedagogical Activities:

    • Dataset Deep-Dive: Practical exercise analyzing a real-world enterprise dataset via Slicers and PivotTables, concluding with formal team findings presentations.

Lesson 6: Excel Data Visualization and Charts

  • Core Syllabus Topics:

    • Plotting options: Bar, Line, Pie, Scatter, Area, and Combo charts.

    • Micro-visualization: Sparkline trends and inline Data Bars.

    • Fine-tuning visual elements: titles, axis scales, data labels, callouts, and custom legends.

    • Formatting layer options: series fill, chart styles, overlaying data series.

    • Constructing dynamic chart engines powered by dynamic OFFSET or INDEX/MATCH Named Ranges.

  • Applied Pedagogical Activities:

    • Data Storytelling Workshop: Hands-on activity designing data dashboards tailored to convey underlying narrative insights clearly to stakeholders.

Lesson 7: PowerPoint Design and Delivery

  • Core Syllabus Topics:

    • Visual design theory: slide spatial balance, contrast, focus points, visual emphasis.

    • Information graphics: converting text blocks to SmartArt and structured graphic layouts.

    • Audience engagement techniques: real-time slide annotations, digital ink, and presenter notes.

    • Presentation rehearsal: timing routines, speech cadence, and rehearsal tools.

  • Applied Pedagogical Activities:

    • Presentation Delivery Challenge: Design task requiring creation and delivery of a custom slide deck on an assigned topic, followed by interactive peer review.

Lesson 8: Word Advanced Features

  • Core Syllabus Topics:

    • Long-document compilation: automated Table of Contents generation, index creation, cross-referencing, and Footnotes/Endnotes.

    • Complex section breaking: isolated page numbering and page orientation switches within single files.

    • Advanced formatting systems: nested styles, base style inheritance, and template storage.

    • Workflow automation: macro recording, basic VBA editing, and custom keyboard shortcuts.

    • Application customization: Quick Access Toolbar configuration, ribbon customization, and system options.

  • Applied Pedagogical Activities:

    • Advanced Word Workshop: Hands-on technical lab focused on structuring long-form documents, generating references, and configuring automated macros with custom instructor feedback.