MS Excel for Beginners

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
    

https://exceljet.net/