Working with spreadsheet in Microsoft Excel Training Course

Introduction

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

Entering and modifying data in worksheet cells

Formatting data

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

Navigation

• Moving up in extensive sheets
• Concurrent work on multiple worksheets / workbooks

Copying and moving data

• Select areas (cell ranges)
• Moving data
• special insert
• Autofill sections (series) of data (for example, ordinals 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
• Nested functions
• Using the conditional
• The Function creator

Graphics in spreadsheets

• AutoShapes and WordArt
• static and dynamic data images

Charts

• The main chart types and their applications
• General principles for creating compelling charts
• Creating charts
• Components of graphs and their modification
• Create owns chart types

Hiding and Data Protection

• Hiding sheets, columns, and rows
• Hide formulas and cell entries
• Protect worksheet and workbook from changes
• Protecting workbooks before opening

Print

• Printing sheets and areas of discontinuous
• Printing charts