What is in this lesson?
- What is it and Syntax
- Vlookup examples
- Vlookup hacks
- Vlookup Errors & Fixing them
- INDEX Formula
- MATCH formula
Online Classroom – Chandoo.org
Excel | Power BI | SQL | Coding | VBA and More
Text formulas are what you use to process, manipulate or find information about a give piece of text in some cell(s). In this lesson, you can learn about the most important text formulas in Excel. The following formulas are discussed,
LEFT, TRIM, FIND, LEN, RIGHT, LOWER, SEARCH, TEXT, MID, UPPER, VALUE, PROPER, SUBSTITUTE, REPLACE, CONCATENATE and REPT
Continue reading “Relative & Absolute Cell References in Formulas”
As a bonus to Excel Beginners, I have created 10 videos to teach various basics of Excel.Please use below links to download the videos you want. You can also watch these videos online. Continue reading “Excel Beginner Videos”
This should be a perfect way to start Excel school.