Course Code: 784
Duration: 14 hours
Prerequisites:

Knowledge of Windows and the basics of MS Excel

Overview:

Participants of the course will be able to organize and process data in the spreadsheet and information from external data sources. They will be able to create pivot charts and use pivot tables. They will acquire the ability to create and perform advanced operations on formulas.

Course Outline:

Excel basics

  • Excel data types - How Excel treats date and time
  • Searching for values in a spreadsheet - Find and mark
  • Sheet protection
  • Data accuracy
  • Create a data series
  • Autocorrect
  • Instant Fill
  • Go To Special
  • Paste Special
  • Text as columns
  • Quick access bar
  • Good sheet creation practices
  • Keyboard shortcuts
  • Cell formatting
  • Conditional formatting

Creating formulas

  • Inserting functions
  • Editing formulas
  • Logical functions
  • Mathematical functions
  • Search Functions
  • Text functions
  • Date and time functions
  • Summing the contents of cells with a button AutoSum
  • Adding functions using a dialog box
  • Formula evaluation
  • Specifying the location of values
  • Naming the range
  • Modify named ranges
  • Use named ranges in formulas

Create a PivotTable

  • Basic information about pivot tables
  • Overview of pivot table report fields


Creating charts and pivot charts

  • Create pivot charts
  • Change the chart type
Sites Published:

United Arab Emirates - Microsoft Office Excel - intermediate level

Qatar - Microsoft Office Excel - intermediate level

Egypt - Microsoft Office Excel - intermediate level

Saudi Arabia - Microsoft Office Excel - intermediate level

South Africa - Microsoft Office Excel - intermediate level

Brasil - Microsoft Office Excel - intermediate level

Canada - Microsoft Office Excel - intermediate level

中国 - Microsoft Office Excel - intermediate level

香港 - Microsoft Office Excel - intermediate level

澳門 - Microsoft Office Excel - intermediate level

台灣 - Microsoft Office Excel - intermediate level

Österreich - Microsoft Office Excel - intermediate level

Schweiz - Microsoft Office Excel - intermediate level

Deutschland - Microsoft Office Excel - intermediate level

Czech Republic - Microsoft Office Excel - intermediate level

Denmark - Microsoft Office Excel - intermediate level

Estonia - Microsoft Office Excel - intermediate level

Finland - Microsoft Office Excel - intermediate level

Greece - Microsoft Office Excel - intermediate level

Magyarország - Microsoft Office Excel - intermediate level

Ireland - Microsoft Office Excel - intermediate level

Luxembourg - Microsoft Office Excel - intermediate level

Latvia - Microsoft Office Excel - intermediate level

España - Microsoft Office Excel - intermediate level

Italia - Microsoft Office Excel - intermediate level

Lithuania - Microsoft Office Excel - intermediate level

Nederland - Microsoft Office Excel - intermediate level

Norway - Microsoft Office Excel - intermediate level

Portugal - Microsoft Office Excel - intermediate level

România - Microsoft Office Excel - intermediate level

Sverige - Microsoft Office Excel - intermediate level

Türkiye - Microsoft Office Excel - intermediate level

Malta - Microsoft Office Excel - intermediate level

Belgique - Microsoft Office Excel - intermediate level

France - Microsoft Office Excel - intermediate level

日本 - Microsoft Office Excel - intermediate level

Australia - Microsoft Office Excel - intermediate level

Malaysia - Microsoft Office Excel - intermediate level

New Zealand - Microsoft Office Excel - intermediate level

Philippines - Microsoft Office Excel - intermediate level

Singapore - Microsoft Office Excel - intermediate level

Thailand - Microsoft Office Excel - intermediate level

Vietnam - Microsoft Office Excel - intermediate level

India - Microsoft Office Excel - intermediate level

Argentina - Microsoft Office Excel - intermediate level

Chile - Microsoft Office Excel - intermediate level

Costa Rica - Microsoft Office Excel - intermediate level

Ecuador - Microsoft Office Excel - intermediate level

Guatemala - Microsoft Office Excel - intermediate level

Colombia - Microsoft Office Excel - intermediate level

México - Microsoft Office Excel - intermediate level

Panama - Microsoft Office Excel - intermediate level

Peru - Microsoft Office Excel - intermediate level

Uruguay - Microsoft Office Excel - intermediate level

Venezuela - Microsoft Office Excel - intermediate level

Polska - Microsoft Office Excel - poziom średnio zaawansowany

United Kingdom - Microsoft Office Excel - intermediate level

South Korea - Microsoft Office Excel - intermediate level

Pakistan - Microsoft Office Excel - intermediate level

Sri Lanka - Microsoft Office Excel - intermediate level

Bulgaria - Microsoft Office Excel - intermediate level

Bolivia - Microsoft Office Excel - intermediate level

Indonesia - Microsoft Office Excel - intermediate level

Kazakhstan - Microsoft Office Excel - intermediate level

Moldova - Microsoft Office Excel - intermediate level

Morocco - Microsoft Office Excel - intermediate level

Tunisia - Microsoft Office Excel - intermediate level

Kuwait - Microsoft Office Excel - intermediate level

Oman - Microsoft Office Excel - intermediate level

Slovakia - Microsoft Office Excel - intermediate level

Kenya - Microsoft Office Excel - intermediate level

Nigeria - Microsoft Office Excel - intermediate level

Botswana - Microsoft Office Excel - intermediate level

Slovenia - Microsoft Office Excel - intermediate level

Croatia - Microsoft Office Excel - intermediate level

Serbia - Microsoft Office Excel - intermediate level

Bhutan - Microsoft Office Excel - intermediate level

Nepal - Microsoft Office Excel - intermediate level

Uzbekistan - Microsoft Office Excel - intermediate level