Course Code: mswordexcelbasic
Duration: 14 hours
Prerequisites:

Knowledge of Windows.
A basic understanding of computers

Course Outline:

MS Word Outline

Introduction to the use the text editors.

  • Basic information about the program
  • Backup copies of documents
  • Quick and precise navigation through the document

Style

  • The importance of style for easy maintenance of consistency, transparency and aesthetics document
  • Style groups and their use
  • Quickly change the basic text formatting
  • Format titles and typographical resources used to distinguish them
  • General rules for obtaining clarity and aesthetic texts

Letters - bullets and lists

  • Use bullets
  • Maintaining a consistent look throughout the document lists
  • Quickly change the appearance of a letter
  • Changing the order or the level of the item in the list
  • Changing the numbering letter enumerated (eg, Roman numerals or small letters of the alphabet)
  • Change bullets

Tables

  • The construction and use of tables
  • Inserting tables
  • Aesthetics and transparency tables (such as changing font sizes, font size and edges, internal margins and background color of the cells)
  • Modifying tables (such as adding and removing columns and rows, and create headers common to several columns)

Headers and footers to pages

  • Application
  • Setting a separate header / footer for the first page of the document
  • Using automatic page numbering (including numbers such as "No next page / number of pages in the document")
  • Insert information on all pages of the document metrics (eg title, author, or date of update)
  • Change the font and size of letters for numbers (independently of the rest of the contents of the header / footer)
  • The use of separator header / footer (the line separating the content)

Mail Merge

  • Application and possible mechanism merge
  • Preparing the data source (for example, address database) and the basic document
  • Print Merge

Picture, Layout and Print (Optional Topics)

  • Inserting of Picture and Wrapping Style
  • Adjusting of margins
  • Selecting Page Orientation and Paper Sizes
  • Paragraph Spacing
  • Printing Setup

MS Excel Outline

Introduction

  • Basic information about the program
  • Construction of the main window
  • Operations on workbooks (notebooks) and sheets

Entering and modifying data in spreadsheet cells

Formatting data

  • Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
  • Determining the edge and the background of the cells
  • Formatting row and column titles
  • Using Styles

Navigation

  • Moving up in large sheets
  • Parallel work on multiple spreadsheets / workbooks

Copying and moving data

  • Select areas (cell ranges)
  • Moving data
  • Paste Special
  • Autofill cell strings (series) of data (for example, order numbers and dates of the next working day)

Formula, addresses and cell names

  • Create, modify and copy formulas
  • Circular references
  • Conditional formatting
  • The address types and their use
  • References to other worksheets and workbooks
  • Using cell names

Functions

  • General rules for using the function
  • Frequently used functions
  • Nesting functions
  • Using the conditional
  • The Function Wizard

Charts

  • The main chart types and their use
  • General principles for creating compelling charts
  • Creating Charts.
  • Components of graphs and their modification
  • Create your own chart types