Training agenda
  1. Introduction to MS Excel and its environment
    • Elements of a window
    • Quick Access Bar
    • Smooth navigation in MS Excel sheet
  2. Appropriate data storage
    • The rules of appropriate data storage
    • Introduction and data edition
    • Table object
    • Copying and transferring
  3. Data preparation
    • Flash Fill tool
    • Data series
    • Comments
    • Autofilter
    • Data type recognition
    • Erase duplicates tool
  4. Formulas, functions, data analysis
    • Flash analysis tool
    • Types of cell addressing
    • The most important functions  (among others SUM, AVERAGE, MIN, MAX, IF; COUNT, COUNTBLANK, COUNTA, …)
    • Copying and transferring formulas
    • Function constructor
    • Mathematical operators
  5. Data formatting and file preparation
    • Embedded table styles
    • The basics of conditional formatting
    • Formats painter
    • Manual modification of cell and table style
    • Page settings
    • Printing options
    • Securing with a file and folder password
  6. Graphs
    • Using recommended graphs
    • Matching the type of graph to data
    • Adjusting the elements of graph