Back to Courses
Premium Course
Computer Appreciation and Data Processing for Professionals
Computer Appreciation and Data Processing for Professionals and Trainers
Course Syllabus
Lesson 1: What is a Computer and Basic Function of a Computer?
Lesson 2: The Two Pillars – Hardware vs. Software, and Type of Computers
Lesson 3: The I.P.O.S. Cycle (Input, Process, Output, Storage) and Importance of a Computer
Lesson 4: Typing Skills and Keyboarding
Quiz for Module 1: Introduction to Computer
LESSON 1: THE DESKTOP, TASKBAR, START MY MENU, AND FILE EXPLORER
LESSON 2: INTEGRATED SYSTEM APPLICATIONS—NOTEPAD AND CALCULATOR
LESSON 3: PRODUCTIVITY UTILITIES—SNIPPING TOOL AND PAINT
Quiz for Module 2: Introduction to Windows & System Applications
LESSON 1: RIBBONS, TITLE, PAGE, WORDS COUNT, PAGE LAYOUT AND ZOOM.
LESSON 2: THE HOME TAB—CLIPBOARD & FONT TYPOGRAPHY MASTERY
LESSON 3: ADVANCED PARAGRAPH FORMATTING, BULLETS, AND LAYOUT BORDERS
LESSON 4: TIME-SAVING STYLES AND FAST FIND & REPLACE TECHNIQUES
LESSON 5: PAGES AND TABLE STRUCTURING FUNDAMENTALS
LESSON 6: DESIGNING ADVANCED TABLES AND LAYOUT PROPERTIES
LESSON 7: ILLUSTRATION, ADVANCED TABLES AND LAYOUT PROPERTIES
LESSON 8: ADVANCED DATA VISUALS—SMARTART, INFOGRAPHIC CHARTS, AND SCREENSHOTS
LESSON 9: MULTI-PAGE CONFIGURATIONS—HEADERS, FOOTERS, AND AUTOMATED PAGE NUMBERING
LESSON 10: SPECIAL LAYOUT ELEMENTS—TEXT BOXES, WORDART, AND DROP CAPS, SCIENTIFIC DATA ENTRY—BUILDING EQUATIONS AND CHARACTER SYMBOLS
LESSON 11: PROFESSIONAL DOCUMENT DESIGN—THEMES AND CUSTOM WATERMARKS
LESSON 12: PAGE SETUP MASTERY—MARGINS, ORIENTATION, AND MULTI-COLUMNS
LESSON 13: ADVANCED PARAGRAPH SPACING AND OBJECT LAYOUT PROPERTIES
LESSON 14: ACADEMIC FORMATS—AUTOMATING TABLE OF CONTENTS AND CITING SOURCES
LESSON 15: AUTOMATION SECRETS—MAIL MERGE, ENVELOPES, AND LABEL PRINTING
LESSON 16: VERIFICATION & FINAL VIEW OPTIONS—SPELL CHECKS, REVIEW PANELS, AND MACROS
Quiz for Module 3: Mastery Microsoft Office Word
LESSON 1: INTRODUCTION TO EXCEL, RIBBONS, CELLS, AND ALIGNMENT
LESSON 2: FORMAT CELLS MENU – NUMBERS AND SETTINGS
LESSON 3: CELL STYLES, TABLES, AND DATA SEQUENCES
LESSON 4: STATISTICAL FUNCTIONS AND THE EDITING PALETTE
LESSON 5: THE INSERT TAB – PIVOTTABLES, ILLUSTRATIONS, AND SMARTART
LESSON 6: VISUAL ANALYTICS – INSERTING CHARTS
LESSON 7: TEXT BOXES, EQUATIONS, AND PAGE LAYOUT VIEWS
LESSON 8: PAGE LAYOUT SETTINGS AND PRINT PROPERTIES
LESSON 9: ADVANCED FORMULAS – IF, SUMIF, AVERAGEIF, AND COUNTIF
LESSON 10: DATA RIBBON TOOLS AND ADVANCED TEXT STRINGS
LESSON 11: PROFESSIONAL ANALYTICS – VLOOKUP, HLOOKUP, AND RANK
Quiz for Module 4: Mastery Microsoft Office Excel
LESSON 1: INTRODUCTION TO POWERPOINT
LESSON 2: SLIDE CONTROLS, TYPOGRAPHY, AND TEXT CONVERSION
LESSON 3: SLIDE TYPES, STRUCTURAL TABLES, AND DESIGN LAYOUTS
LESSON 4: GRAPHIC MANIPULATION, SCREENSHOTS, PHOTO ALBUMS, AND VECTOR SHAPE ENGINEERING
LESSON 5: TYPOGRAPHY ASSETS, EQUATIONS, AND LIVE AUDIO/VIDEO STREAMS
LESSON 6: LAYOUT DESIGN ELEMENTS, VARIANTS, AND CANVAS BACKGROUNDS
LESSON 7: SLIDE TRANSITIONS, PACING, AND AUDIO SYNCING
LESSON 8: OBJECT ANIMATIONS, ADVANCED PANES, AND EFFECT TRIGGERS
LESSON 9: SLIDE SHOW DELIVERY, REVIEW PANELS, AND PRESENTATION STUDIO FORMATS
Quiz for Module 5: Introduction to Microsoft Office PowerPoint
LESSON 1: INTRODUCTION TO MS PUBLISHER AND THE RIBBONS
Lesson 2: Textboxes, Clipboards, Font, and Paragraph Formatting
LESSON 3: STYLES, OBJECTS, ARRANGE, AND EDITING
LESSON 4: PAGE CONSTRUCTION, CATALOG PAGES, AND TABLES
LESSON 5: ILLUSTRATIONS, DRAWING TOOLS, AND PICTURE PLACEHOLDERS
LESSON 6: BUILDING BLOCKS, CALENDARS, AND BUSINESS INFORMATION
LESSON 7: PAGE DESIGN, GEOMETRY, AND MASTER PAGES
LESSON 8: MAILINGS AND MASS CUSTOMIZATION (MAIL MERGE)
Quiz for Module 6: Introduction to Microsoft Office Publisher
Course Includes
-
Modules11
-
Lessons51
-
Quizzes6
-
CertificateNo
-
AccessLifetime