Course Outline

Word

Introduction to the use of text editors

  • Possibilities of computer text processing.
  • Creating and saving 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 applications
  • Quickly change the basic text formatting
  • Format titles and typographical resources used to distinguish them
  • General rules for obtaining clarity and aesthetic texts

Letters - bullet points and lists

  • Use bullet points and calculations
  • Maintaining a consistent look throughout the document lists
  • Quickly change the appearance of a letter
  • Rearranging or level for the list item

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

  • The use of
  • Setting a separate header / footer for the first page of the document
  • Using automatic page numbering (including numbers such as "Number 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 from the rest of the contents of the header / footer)

Excel

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
  14 Hours

Testimonials (9)

Related Courses

Microsoft Office Excel - intermediate level

  14 Hours

Related Categories