Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().
In Excel's table object you can sort, filter and summarize data effortlessly as well as select the formatting that fits your needs.
Excel cell references are important part of formulas. Learn the difference between the absolute and relative reference.
Number formats allow you to preserve the original cell value while displaying it as percentage, currency, date or time format.
It's possible to paste only specific components of you data such as formulas, values or formattings. Make you workbook great again.
In the Excel formula basics lecture we'll first mix numbers and text to create generic sentences and then we use SUM and IF.
Learn how formatting cells in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells.
Introduction to Microsoft Excel. What is workbook and worksheet? How to add and delete worksheets? Where to save and open Excel files?