Excel Intermediate

Základní info

Popis kurzu

This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, visualize your data with charts.


This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, visualize your data with charts.

Obsah kurzu

Adding and summary of basic terms



  • Keyboard shortcuts for facilitation the work in Microsoft Excel

  • Options Paste Special, Find and Replace


Tables formatting



  • Inserting and deleting cells, rows and columns

  • Hiding and unhiding rows and columns

  • Copying of format


Conditional Formatting



  • Based on a cell value

  • Based on a formula

  • Quick styles in conditional formatting


Formulas



  • Basic mathematical operations

  • Formulas modifications

  • Quick check of formulas

  • Copying and moving formulas

  • Relative and absolute references of cells ($A$1)

  • Entering more advanced formulas

  • Naming cells and ranges

  • Impact of copy and move of absolute references


Functions



  • Using basic functions and its view in calculation line

  • Insert function in a cell

  • Adjustments of formulas with functions

  • IF function

  • Selected functions from category Text, Date and Time


Links



  • Linking Excel sheets and workbooks

  • Linking with Microsoft Word and Microsoft PowerPoint applications


Charts



  • Automatic format of a chart – recommended charts

  • Basic chart types

  • Creating and adjusting charts


Databases in Microsoft Excel



  • Basic terms

  • Principles of work with data

  • Freeze of panes

  • Sorting data according its value or format

  • Automatic filter

  • Grouping data


Print in Microsoft Excel



  • Print area

  • Repeating header on every page

  • Advanced page appearance settings for print

Studijní materiály

V angličtině

Excel Intermediate

Vybraný termín:

9.6.2021  Praha

Cena
3900 Kč + 21 % DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je sedm a šest ? Součet zapište číslicemi.