MS Excel (Beginner and Intermediate Level)

The course is structured as an introduction to Excel for the beginner user covering some intermediary topics as well such as: working with tables, creating charts, use of functions and formulae.

• Familiarization with the Excel workspace. Workbooks and worksheets - copy paste and move data/sheets (from the internet, within the same book and in different ones)
• Text editing , column and row fitting. Data, text and dates
  • freeze, hide and split columns/rows (the Window menu)
  • auto complete, auto fill and auto correct
  • printing view, centering, format painter
• Formatting:
  • cell merging, alignment, wrap, orientation

Arranging our data

• Naming cells and adding comments
  
• Sorting the data
• Filtering options

• Data tables
• Chart formatting (style, title, value axis, appearance, etc.)

• Data management. 
• Basic formulas
• Relative and absolute references
  
• Basic math functions

• Functions and formulae:
  • calculate percentage, percentage change
  • calculating average, sum,  minimum, maximum
  • conditional formatting
• Advanced functions and formulae:
  • The PMT financial function
    

Using functions for further calculations

• VLOOKUP
• TRUE, FALSE
• Goal Seek

• Pivot-tables
• Creating charts from Pivot-tables
• Recording macros
• Buttons with macros
• Working with multiple sheets
  

https://exceljet.net/

https://youtu.be/lxq_46nY43g