Word and Excel Basics

Course participants will learn how to create a aesthetic professional-looking documents in a word processor Microsoft Word. The course participants will be able to efficiently perform a variety of calculations in a transparent way to organize and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets in Excel.

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