Computer Skills with Word, Excel, and PowerPoint Course

Lesson 1 • Using Help, Templates, and Search

Leverage built-in Help, Tell Me search, and pre-built templates to solve problems independently. These tools reduce reliance on external support.

Lesson 2 • Sharing, Permissions, and Co-Authoring

Share files with colleagues, set view or edit permissions, and co-author in real time. Collaboration features are consistent across all three applications.

Lesson 3 • Understanding the Office Interface Layout

Identify the Ribbon, Quick Access Toolbar, and status bar common to all three apps. This shared knowledge accelerates learning in every subsequent chapter.

Lesson 1 • Formatting Text and Paragraphs

Apply font styles, sizes, colors, alignment, indentation, and line spacing to text. Consistent formatting signals professionalism in any document.

Lesson 2 • Page Layout and Document Structure

Set margins, orientation, page size, headers, footers, and page numbers. Proper layout ensures documents meet professional and organizational standards.

Lesson 3 • Proofing and Finalizing Documents

Use spelling and grammar check, readability statistics, and accessibility checker before sharing. Final proofing prevents errors that undermine credibility.

Lesson 4 • Using Styles and Themes for Consistency

Apply built-in heading styles, modify style definitions, and switch document themes. Styles enable one-click reformatting across entire documents.

Lesson 1 • Using SmartArt and Charts in Word

Add SmartArt diagrams and embedded charts to illustrate processes and data. These visuals transform dense text into clear, memorable graphics.

Lesson 2 • Working with Lists and Outlines

Create bulleted, numbered, and multilevel lists to structure hierarchical content. Well-formatted lists improve document scannability and logical flow.

Lesson 3 • Building and Formatting Tables

Insert tables, add and delete rows and columns, merge cells, and apply table styles. Tables organize complex information for quick reader comprehension.

Lesson 1 • Writing Basic Formulas and Functions

Build SUM, AVERAGE, MIN, MAX, and COUNT formulas using relative and absolute references. These core functions underpin virtually every Excel task.

Lesson 2 • Understanding the Excel Workspace

Navigate worksheets, workbooks, rows, columns, and the formula bar with confidence. Workspace fluency is prerequisite to all data entry and formula work.

Lesson 3 • Entering and Organizing Data

Enter text, numbers, and dates; use AutoFill and Flash Fill to speed input. Clean, consistent data entry is the foundation of reliable analysis.

Lesson 4 • Formatting Cells and Worksheets

Apply number formats, fonts, borders, fill colors, and conditional formatting rules. Formatting makes data readable and highlights critical information instantly.

Lesson 1 • Data Validation and Protection

Set input rules with data validation, protect sheets, and lock specific cells. These controls maintain data integrity in shared workbooks.

Lesson 2 • Sorting, Filtering, and Tables

Sort data by multiple columns, apply AutoFilter, and convert ranges to structured tables. Structured tables automate formatting and make formulas more readable.

Lesson 3 • PivotTables and PivotCharts

Build PivotTables to summarize large datasets and add PivotCharts for visual reporting. PivotTables are the fastest tool for cross-tabulation and trend analysis.

Lesson 4 • Creating and Customizing Charts

Build column, bar, line, and pie charts; format axes, legends, and data labels. Charts translate numbers into visual stories that drive faster decisions.

Lesson 1 • Slide Transitions and Basic Animations

Apply slide transitions and entrance animations to guide audience attention purposefully. Restrained animation enhances flow without distracting from content.

Lesson 2 • Designing Slides with Themes and Layouts

Apply themes, variant colors, and slide layouts to establish visual consistency. A coherent design system makes presentations look polished and credible.

Lesson 3 • Inserting Visuals, Tables, and Charts

Add images, icons, tables, and charts to slides to support data-driven storytelling. Visuals reduce cognitive load and increase audience retention.

Lesson 4 • Adding and Formatting Text on Slides

Insert text boxes, format fonts, adjust alignment, and use bullet hierarchy effectively. Concise, well-formatted text keeps audiences focused on key messages.

Lesson 1 • Structuring a Compelling Presentation

Apply narrative frameworks to organize slides into a clear opening, body, and close. Strong structure ensures the audience follows and remembers the message.

Lesson 2 • Slide Master and Custom Layouts

Edit the Slide Master to enforce brand fonts, colors, and logo placement globally. Master-level edits propagate instantly to every slide in the deck.

Lesson 3 • Delivering and Exporting Presentations

Use Presenter View, rehearse timings, and export to PDF, video, or handout formats. Delivery preparation and export options maximize presentation impact.

Lesson 4 • Embedding Audio, Video, and Screen Recordings

Insert audio clips, embed video, and record screen captures directly in PowerPoint. Rich media increases engagement and supports self-paced learning decks.

Lesson 1 • Building Integrated Reports and Dashboards

Combine Word narrative, Excel data tables, and PowerPoint visuals into a unified deliverable. Integrated outputs demonstrate mastery of all three applications working together.

Lesson 2 • Embedding Excel Charts in PowerPoint

Insert Excel charts into slides as linked objects so data updates flow through instantly. This workflow eliminates manual chart recreation for recurring presentations.

Lesson 3 • Embedding and Linking Excel Data in Word

Paste Excel tables and charts into Word as linked or embedded objects. Linked objects refresh automatically when source data changes, saving rework time.