Ms office

M S Office 2024 Course Outline

Word 2024/365 Basic Course Outline Excel 2024/365 Basic Course Outline PowerPoint 2024/365 Basic Course Outline Outlook 2024/365 Basic Course Outline Access 2024/365 Basic Course Outline
Unit 1: Getting started
Unit 1: Getting started Unit 1: Getting started Unit 1: Getting started Unit 1: Getting started Topic A: Database Concepts
Topic A: The Word window Topic A: Spreadsheet terminology Topic A: The PowerPoint interface Topic A: The program window Topic B: Exploring the Access environment
Topic B: New documents Topic B: The Excel environment Topic B: Outlook Today
Topic C: Document navigation Topic C: Navigating a worksheet Unit 2: Creating presentations Unit 2: Databases and tables
Topic D: Using a template Topic A: Creating a basic presentation Unit 2: Email basics Topic A: Planning and designing databases
Unit 2: Editing text Topic B: Working with slides Topic A: Reading messages Topic B: Exploring tab les
Topic A: Working with text Unit 2: Entering and editing data Topic B: Creating and sending messages Topic C: Creating tables
Topic A: Entering and editing text and values Unit 3: Editing slide content Topic C: Working with messages
Topic B: The Undo and Redo commands Topic B: Entering and editing formulas Topic A: Formatting text and lists Topic D: Handling attachments Unit 3: Fields and records
Topic C: Cut, copy, and paste Topic C: Saving and updating workbooks Topic B: Editing efficiently Topic E : Printing messages and attachments Topic A: Changing the design of a table
Topic D: Find and replace Topic B: Finding and editing records
Unit 3: Modifying a worksheet Unit 4: Working with shapes Unit 3: Email management Topic C: Organizing records
Unit 3: Text formatting Topic A: Moving and copying data Topic A: Creating shapes Topic A: Setting message options
Topic A: Character formatting Topic B: Moving, copying, and viewing formulas Topic B: Formatting shapes Topic B: Organizing the Inbox folder Unit 4: Data Entry rules
Topic B: Tab settings Topic C: Absolute and relative references Topic C: Applying content to shapes Topic C : Managing junk email Topic A: Setting field properties
Topic C: Paragraph formatting Topic D: Inserting and deleting ranges, rows, and columns Topic B: Working with input masks
Topic D: Paragraph spacing and indents Unit 5: Graphics Unit 4: Contacts Topic C: Setting validation rules
Unit 4: Functions Topic A: WordArt Topic A: Working with contacts
Unit 4: Tables Topic A: Entering functions Topic B: Pictures Topic B: Address books Unit 5: Basic queries
Topic A: Creating tables Topic B: AutoSum Topic C: Using contact groups Topic A: Creating and using queries
Topic B: Working with table content Topic C: Other common functions Unit 6: Tables and charts Topic B: Modifying query results and queries
Topic C: Changing the table structure Topic A: Tables Unit 5: Tasks Topic C: Performing operations in queries
Unit 5: Formatting Topic B: Charts Topic A: Working with tasks
Unit 5: Page layout Topic A: Text formatting Topic C: SmartArt Topic B: Managing tasks Unit 6: Using forms
Topic A: Headers and footers Topic B: Row and column formatting Topic A: Creating forms
Topic B: Page setup Topic C: Number formatting Unit 7: Preparing and printing presentations Unit 6: Appointments and events Topic B: Using Design view
Topic D: Conditional formatting Topic A: Proofing presentations Topic A: Creating and sending appointments Topic C: Sorting and filtering records
Unit 6: Graphics Topic E: Additional formatting options Topic B: Preparing a presentation Topic B: Modifying appointments
Topic A: Adding graphics and clip art Topic C: Printing presentations Topic C: Working with events Unit 7: Working with reports
Topic B: Working with graphics Unit 6: Charts Topic D: Using Calendar Views Topic A: Creating reports
Topic A: Chart basics PowerPoint 2024/365 Advanced Course Outline Topic B: Modifying and printing reports
Unit 7: Proofing, printing, and exporting Topic B: Formatting charts Unit 7: Meeting requests and responses
Topic A: Spelling and grammar Unit 1: Slide masters and transitions Topic A: Scheduling meetings
Topic B: AutoCorrect Unit 7: Graphics Topic A: Slide masters Topic B: Managing meetings
Topic C: Printing and exporting documents Topic A: Working with pictures Topic B: Transitions and timings

Word 2024/365 Intermediate Course Outline
Topic B: Conditional formatting with graphics Topic C: Custom slide shows
Topic C: SmartArt graphics
Outlook 2024/365 Advanced Course
Outline Unit 1: Customizing
Outlook

Unit 2: Graphics and media Topic A: The Outlook environment
Unit 1: Styles and outlines Unit 8: Printing Topic A: Modifying graphics Topic B:General options and account settings
Topic A: Examining formatting Topic A: Preparing to print Topic B: Media clips Topic C: Quick Steps
Topic B: Working with styles Topic B: Page Setup options Topic C: Animations Topic D: The Folder pane and Navigation bar
Topic C: Working with outlines Topic C: Printing worksheets Topic D: Photo albums
Unit 2: Customizing messages
Unit 2: Table formatting Excel 2024/365 Intermediate Course Outline Unit 3: Customizing slide elements Topic A: Message appearance
Topic A: Table design options Topic A: Working with SmartArt graphics Topic B: Signatures
Topic B: Table data Unit 1: Managing workbooks and worksheets Topic B: Customizing tables Topic C: Voting buttons
Topic A: Viewing large worksheets Topic C: Working with charts Topic D: Out-of-office messages
Unit 3: Illustrations Topic B: Printing large worksheets
Topic A: Creating diagrams Topic C: Working with multiple worksheets Unit 4: Action buttons and equations Unit 3: Mailbox organization and management
Topic B: Working with shapes Topic D: Linking worksheets with 3-D formulas Topic A: Action buttons Topic A: Setting rules
Topic C: Formatting text graphically Topic E: Using multiple workbooks Topic B: Equations Topic B: Managing your mailbox
Topic F: Linking workbooks
Unit 4: Advanced document formatting Unit 5: Integrating Microsoft Office files Unit 4: Organizing items

Topic A: Creating and formatting sections Topic B: Working with columns Topic C: Document design Unit 5: Document sharing Topic A: Document properties Topic B: Tracking changes Topic C: Finalizing documents Unit 6: Mail Merge Topic A: Form letters Topic B: Data sources for the recipient list Topic C: Mailing labels and envelopes Word 2024/365 Advanced Course Outline Unit 1: Document interactivity Topic A: Creating forms Topic B: Inserting objects and charts Topic C: Web pages Unit 2: Document references Topic A: Tables of contents and captions Topic B: Indexes, bibliographies, and footnotes Unit 3: Working efficiently Topic A: Customizing the ribbon Topic B: Building Blocks Topic C: Master documents Unit 4: Macros and VBA fundamentals Topic A: Simple macros Topic B: Visual Basic for Applications Topic C: Modifying and creating macros Topic D: Word objects Unit 5: VBA programming Topic A: Control structures Topic B: VBA forms Topic C: Debugging and error handling Topic A: Using special number formats Topic B: Working with themes Topic C: Other advanced formatting Unit 3: Outlining and subtotals Topic A: Outlining and consolidating data Topic B: Creating subtotals Unit 4: Cell and range names Topic A: Creating and using names Topic B: Managing names Unit 5: Data structure and tables Topic A: Sorting and filtering data Topic B: Working with tables Unit 6: Web and sharing features Topic A: Saving workbooks as Web pages Topic B: Using hyperlinks Unit 7: Documenting and auditing Topic A: Auditing features Topic B: Comments in cells and workbooks Topic C: Protection Topic D: Workgroup collaboration Unit 8: Application settings and templates Topic A: Application settings Topic B: Working with templates Topic A: Applying content from a Word outline Topic B: Embedding and linking content Unit 6: Finalizing and distributing presentations Topic A: Reviewing and finishing Topic B: Distributing presentations Unit 7: Customizing PowerPoint Topic A: Application settings Topic A: Folders Topic B: Searching Topic C: Advanced filtering Topic D: Categories Unit 5: Notes and Journals Topic A: Recording information with notes Topic B: Tracking activities with the Journal Unit 6: Collaboration Topic A: Sharing your calendar and contacts Topic B: Staying informed with RSS Appendix A: Connecting with SharePoint Topic A: Connecting with colleagues via Outlook Social Connectors