Course Code: 3024
Duration: 14 hours
Prerequisites:

Knowledge of Windows

Overview:

The course participants will be able to efficiently perform a variety of calculations in a transparent way to arrange and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, as well as protect the calculations and their results against unauthorized persons

Course Outline:

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
Sites Published:

United Arab Emirates - Working with spreadsheet in Microsoft Excel

Qatar - Working with spreadsheet in Microsoft Excel

Egypt - Working with spreadsheet in Microsoft Excel

Saudi Arabia - Working with spreadsheet in Microsoft Excel

South Africa - Working with spreadsheet in Microsoft Excel

中国 - Working with spreadsheet in Microsoft Excel

香港 - Working with spreadsheet in Microsoft Excel

澳門 - Working with spreadsheet in Microsoft Excel

台灣 - Working with spreadsheet in Microsoft Excel

USA - Working with spreadsheet in Microsoft Excel

Österreich - Working with spreadsheet in Microsoft Excel

Schweiz - Working with spreadsheet in Microsoft Excel

Deutschland - Working with spreadsheet in Microsoft Excel

Czech Republic - Working with spreadsheet in Microsoft Excel

Denmark - Working with spreadsheet in Microsoft Excel

Estonia - Working with spreadsheet in Microsoft Excel

Finland - Working with spreadsheet in Microsoft Excel

Greece - Working with spreadsheet in Microsoft Excel

Magyarország - Working with spreadsheet in Microsoft Excel

Ireland - Working with spreadsheet in Microsoft Excel

Luxembourg - Working with spreadsheet in Microsoft Excel

Latvia - Working with spreadsheet in Microsoft Excel

España - Working with spreadsheet in Microsoft Excel

Italia - Working with spreadsheet in Microsoft Excel

Lithuania - Working with spreadsheet in Microsoft Excel

Nederland - Working with spreadsheet in Microsoft Excel

Norway - Working with spreadsheet in Microsoft Excel

Portugal - Working with spreadsheet in Microsoft Excel

România - Working with spreadsheet in Microsoft Excel

Sverige - Working with spreadsheet in Microsoft Excel

Türkiye - Working with spreadsheet in Microsoft Excel

Malta - Working with spreadsheet in Microsoft Excel

Belgique - Working with spreadsheet in Microsoft Excel

France - Working with spreadsheet in Microsoft Excel

日本 - Working with spreadsheet in Microsoft Excel

Australia - Working with spreadsheet in Microsoft Excel

Malaysia - Working with spreadsheet in Microsoft Excel

New Zealand - Working with spreadsheet in Microsoft Excel

Philippines - Working with spreadsheet in Microsoft Excel

Singapore - Working with spreadsheet in Microsoft Excel

Thailand - Working with spreadsheet in Microsoft Excel

Vietnam - Working with spreadsheet in Microsoft Excel

India - Working with spreadsheet in Microsoft Excel

Venezuela - Working with spreadsheet in Microsoft Excel

Polska - Microsoft Office Excel - poziom podstawowy

United Kingdom - Working with spreadsheet in Microsoft Excel

South Korea - Working with spreadsheet in Microsoft Excel

Pakistan - Working with spreadsheet in Microsoft Excel

Sri Lanka - Working with spreadsheet in Microsoft Excel

Bulgaria - Working with spreadsheet in Microsoft Excel

Bolivia - Working with spreadsheet in Microsoft Excel

Indonesia - Working with spreadsheet in Microsoft Excel

Kazakhstan - Working with spreadsheet in Microsoft Excel

Moldova - Working with spreadsheet in Microsoft Excel

Morocco - Working with spreadsheet in Microsoft Excel

Tunisia - Working with spreadsheet in Microsoft Excel

Kuwait - Working with spreadsheet in Microsoft Excel

Oman - Working with spreadsheet in Microsoft Excel

Slovakia - Working with spreadsheet in Microsoft Excel

Kenya - Working with spreadsheet in Microsoft Excel

Nigeria - Working with spreadsheet in Microsoft Excel

Botswana - Working with spreadsheet in Microsoft Excel

Slovenia - Working with spreadsheet in Microsoft Excel

Croatia - Working with spreadsheet in Microsoft Excel

Serbia - Working with spreadsheet in Microsoft Excel

Bhutan - Working with spreadsheet in Microsoft Excel

Nepal - Working with spreadsheet in Microsoft Excel

Uzbekistan - Working with spreadsheet in Microsoft Excel