Mikael Ahonen

Free Excel course Information technology

The Free Excel Course Online

Posted 04.11.201623.02.2019 Mikael Ahonen

Free Excel course.

Free Excel course.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/Johdatus-Exceliin-Ilmainen-Excel-kurssi-1-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Free Excel course." />

The Free Excel Course Online

The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.

Introduction to Excel for Excel beginners.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/Introduction-to-Excel-for-Excel-beginners-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Introduction to Excel for Excel beginners." />

Lecture 1 – Introduction to Excel

Workbook, worksheet, saving, opening and options in Excel.

Formatting cells in Excel.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/Solujen-muotoileminen-Excelissä-Ilmainen-Excel-kurssi-1-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Formatting cells in Excel." />

Lecture 2 – Formatting Cells in Excel

Change font color, autofit column width, merge cells, use bold text and set borders.

The basics of Excel formulas.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/Kaavojen-perusteet-Excelissä-Ilmainen-Excel-kurssi-1-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="The basics of Excel formulas." />

Lecture 3 – The Basics of Excel Formulas

A brief introduction how to compose your first Excel formula.

Copy and paste in Excel.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/Copy-and-paste-in-Excel-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Copy and paste in Excel." />

Lecture 4 – Copy and paste in Excel

Copy and paste only values, formulas or formattings in Excel.

Number formats, dates and time in Excel.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/number-formats-date-time-excel-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Number formats, dates and time in Excel." />

Lecture 5 – Number formats, dates and time in Excel

Learn different number formats as well as Excel’s date and time system.

Cell references - Absolute and Relative - Defined names.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/cell-references-absolute-relative-defined-names-excel-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Cell references - Absolute and Relative - Defined names." />

Lecture 6 – Cell references and named ranges in Excel

How to do absolute and relative references and name ranges.

Tables, sort and filter in Excel

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/table-object-sort-filter-total-style-excel-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Tables, sort and filter in Excel" />

Lecture 7 – Tables, sorting and filtering in Excel

Sort, filter and summarize easily with Excel table objects.

Text formulas and advanced functions in Excel.

<img width="550" height="400" src="https://mikaelahonencom-ec21.kxcdn.com/wp-content/uploads/2016/11/text-functions-advanced-formulas-nested-formulas-550x400.png" class="attachment-medium-thumb size-medium-thumb wp-post-image" alt="Text formulas and advanced functions in Excel." />

Lecture 8 – String functions and advanced formulas in Excel

Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().

Aiheeseen liittyy

Leave a comment Cancel reply