Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.
Parsing first name, last name and company from email in Excel Do you have a list of emails that you want to split by first […]
Katso ensimmäinen oppitunti esimerkiksi. Muut oppitunnit löytyvät alta.
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().
Next I will introduxe briefly how Power tools in Microsoft Excel Power BI family are related to each other. That way you quickly realize whether […]