Press "Enter" to skip to content

Computer Fundamentals – Hardware vs Software – Learn How to Use Computers & Basics for Beginners PC

This Tutorial goes over the fundamental distinctions in between hardware and also software program. This video clip is for novices that wish to find out more concerning just how to enhance as well as utilize a computer system computer abilities as well as capacities.

Right here is a complete listing of guide video clips readily available on my network:

Computer system Fundamentals:
Computer System Case Types – Dell Inspiron AMD 3656
Printer Types and also ports
The Boot Up Process
Exactly how to Get Your Computer Questions Answered
Reverse Your Mistakes on Windows 10 or Apple Mac
Modems vs. routers
What is the Cloud? Storage space as a Service
Kinds Of Internet Services on Google Android or Apple apple iphone
Searching the Web
Why Use the Cloud?
Microsoft OneDrive – Creating Uploading Downloading as well as Syncing
Discuss the Importance of File Management
Troubleshoot Common Computer Problems

Excel 2016:
Develop, Save, and also Navigate an Excel Workbook
Get in Data in a Worksheet
Just how do you Export Access to Excel as well as Apply Conditional Formatting
Usage Flash Fill, SUM, Average, Median, as well as MAX Functions and also Formulas
Rotate and also relocate information Text
Chart Data with a Pie Chart
Layout a Pie Chart
MOS Prep – Basic Certification Exam Practice Study Guide
Adjustment Fonts, Font Style, and also Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Pie chart Charts
Utilize the Sum Button to Sum a Range of Cells
Get In Formulas Using the Keyboard
Style Cells with Merge & Center, Cell Styles, and also Themes
Graph Data to Create a Column Chart & Insert Sparklines
Select Cells as well as Ranges
Usage CountIF and also IF Functions as well as Apply Conditional Formatting
Usage Date & Time Functions as well as Freeze Panes
Usage Goal Seek to Perform What-if Analysis
Include Fill Colors as well as a Background Image
Place Functions from the Formula Library
Make Use Of the PMT Function to Calculate a Loan Payment
Explain the Excel Worksheet
Go Into Formulas Using Point Mode

Workplace 2016:
Recognize the Components of the Microsoft Office Ribbon

PowerPoint 2016:
Develop a New Presentation
Modify a Presentation in Normal View
Include Pictures to a Presentation
Layout Numbered as well as Bulleted Lists
Tailor Slide Backgrounds as well as Themes
Stimulate a Slide Show
Use a Theme Used in Another Presentation
Look for and also Download an Online Theme
Microsoft Office Specialist Exam Certification
Publish and also View a Presentation
Lighten Background Images in Microsoft Office
Modify an Existing Presentation
Put Online Pictures
Produce a Title Slide as well as Slides With Lists
Select as well as Change a Document Theme and also Variant
Place and also Format Pictures
Put Shapes
Put a Video

Expectation 2016
Fundamental Tutorial

Windows 10:
Do Basic Mouse Operations
Develop Folders
Discover the Windows 10 Desktop, Taskbar, and also Start Menu
Select Multiple Files and also Folders
Download and install a File From a Website
Usage File Explorer to Access OneDrive and also Upload Student Data Files
Catch an Image of the Entire Screen
Discover the Control Panel and also the Settings App
Individualize the Desktop
Customize Screen Brightness as well as Resolution
Check Out the Control Panel as well as the Settings App
Customize the Desktop
Readjust the Sound
Strategy the Organization of Files as well as Folders
Run an App

Accessibility 2016:
Determine Good Database Design
Produce a Table and also Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet right into Access
Develop a Table in Design View
Change the Structure of a Table
Produce a Subform
MOS Prep – Basic Certification Exam Practice Study Guide
Include Existing Fields to a Form
Develop a Query, Form, and also Report
Exactly how To Use the Property Sheet
Open up and also Save an Existing Database
Develop Table Relationships
Discover Basic Database Concepts as well as Terms
Use a kind as well as produce to Add as well as Delete Records
Discover the Guidelines for Designing Databases and also Setting Field Properties
Discover, Modify, and also Delete Records in a Table
Produce a Form Using the Form Wizard

Word 2016:
Develop a New Document and also Insert Text
Put as well as Format Graphics
Modify as well as place Text Boxes
Develop a Table
Style a Table
Existing a Word Document Online
Produce a Research Paper in MLA Format
Put Footnotes in a Research Paper
Produce Citations and also a Bibliography
Conserve a Document
Appropriate Errors as You Type
Exactly how to Format a Document in APA Format
Transform Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Tabulation Tutorial
Style Paragraphs
Develop a Custom Word Template
Sneak peek as well as Print a Document
Modification Document and also Paragraph Layout
Usage AutoComplete as well as AutoCorrect
Right and also Reorganize Text
Header and also Footer Tutorial
Web Page Numbers Tutorial
Subtitles in Word
Evaluation Document Headings in the Navigation Pane
Restructure Document Text Using the Navigation Pane
Collapse and also Expand Body Text in a Document
Usage Continuous Section Breaks for Page Layout
Put Page Numbers Starting from a Specific Page
Layout Text
Reverse and also remodel Commands or Actions
Change a Style

Microsoft Publisher 2016 Full Playlist