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
|