Školení Excel Intermediate v angličtině

Excel Intermediate Training is designed for users of Excel who want to use formulas and functions in tables, to effectively work with large spreadsheets and to format spreadsheets according to their ideas. Participants of this training will learn to enter advanced functions and to use absolute references in formulas. They will become familiar with possibilities for speeding up work with large spreadsheets and tools for work with databases.

Osnova školení Excel Intermediate

U individuálního a firemního školení je možné osnovu přizpůsobit.

  • 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

Předchozí znalosti a návazná školení

Před školením se předpokládá znalost vytváření jednoduchých tabulek v programu Excel.
Po absolvování školení můžete pokračovat:

Excel Data Analysis

Excel Charts

Verze programu

U firemního a individuálního školení si verzi programu, na které bude školení probíhat, můžete zvolit.
Otevřené kurzy probíhají na verzi Office 2016. Lektor po dohodě s účastníky upozorní na rozdíly starších verzí.