The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.
Workbook, worksheet, saving, opening and options in Excel.
Change font color, autofit column width, merge cells, use bold text and set borders.
A brief introduction how to compose your first Excel formula.
Copy and paste only values, formulas or formattings in Excel.
Learn different number formats as well as Excel’s date and time system.
How to do absolute and relative references and name ranges.
Sort, filter and summarize easily with Excel table objects.
Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().