General
- Introduction
Introduction
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.
- Beginners. Day 1: The basics
Beginners. Day 1: The basics
- 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
- Beginners. Day 2: Charts
Beginners. Day 2: Charts
Arranging our data
- Naming cells and adding comments
- Sorting the data
- Filtering options
- Data tables
- Chart formatting (style, title, value axis, appearance, etc.)
- Beginners. Day 3: Formulas
Beginners. Day 3: Formulas
- Data management.
- Basic formulas
- Relative and absolute references
- Basic math functions
- Intermediate. Day 1: Functions
Intermediate. Day 1: Functions
- Functions and formulae:
- calculate percentage, percentage change
- calculating average, sum, minimum, maximum
- conditional formatting
- Advanced functions and formulae:
- The PMT financial function
- The PMT financial function
- Intermediate. Day 2: Functions
Intermediate. Day 2: Functions
Using functions for further calculations
- VLOOKUP
- TRUE, FALSE
- Goal Seek
- Intermediate. Day 3: Working with Data
Intermediate. Day 3: Working with Data
- Pivot-tables
- Creating charts from Pivot-tables
- Recording macros
- Buttons with macros
- Working with multiple sheets
- Useful resources
Useful resources
https://exceljet.net/
https://youtu.be/lxq_46nY43g
- Introduction