Teaching of excel courses and their applications in the world of work to enhance efficiency and effectiveness

Introductory Level Courses

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 validation
Protecting worksheets and workbooks
Automatic subtotals
Creating charts
- 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
- NPV financial function
Using functions for further calculations
- Cell merging, alignment, wrap, orientation
Arranging our data
- VLOOKUP
- HLOOKUP
- XLOOKUP
- INDEX-MATCH
Pivot-tables
- Creating pivot tables
- Creating charts from Pivot-tables
- Creating dashboards
Using slicers
Recording macros
- Buttons with macros
Working with multiple sheets
Maximize efficiency with DATEDIF, YEAR, TODAY, MONTH, etc. functions
Using IF functions to manage a condition
Nested functions
Conditional SUM (SUMIF)
SUMPRODUCT function to management conditions
CONCANTENATE function
TEXT functions