What is in this lesson?
- How to debug formulas using F9 key
Formula Editing Tips And Tricks
What is in this lesson?
- Using F2 key
- Using F4 Key
- Copying Formulas
- Moving Formulas
- Auto-filling formulas
- Using Mouse to Edit Formula Ranges
- More
- More
ROWS, COLUMNS Formulas
What is in this lesson?
- What is it and Syntax
- Using Rows /columns to generate running numbers
SMALL, LARGE Formulas
What is in this lesson?
- What is it and Syntax
- Examples of SMALL and LARGE
- Using Small / large to fetch nth item of an un-sorted list
SUMIFS Formula, COUNTIFS Formula
What is in this lesson?
- What is it and Syntax
- SUMIFS examples
- COUNTIFS examples
SUMPRODUCT Formula
What is in this lesson?
- What is it and Syntax
- Sumproduct – Simple examples
- Conditional Sum using Sumproduct
- Sumproduct hacks
- Alternatives to Sumproduct
OFFSET Formula
What is in this lesson?
- What is it and Syntax
- Offset examples
- Uses of Offset formula
How to Get Unique Values from a List using Formulas
What is in this lesson?
- How to get unique values from a list using formulas alone
Continue reading “How to Get Unique Values from a List using Formulas”
Advanced VLOOKUP Tricks
What is in this lesson?
- Advanced Vlookups
- Looking up on left
VLOOKUP formula, INDEX, MATCH Formulas
What is in this lesson?
- What is it and Syntax
- Vlookup examples
- Vlookup hacks
- Vlookup Errors & Fixing them
- INDEX Formula
- MATCH formula
Excel Text Formulas
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
COUNTIF, SUMIF Formulas
What is in this lesson?
- What is it and Syntax
- Countif with wild-cards
- Countif with conditions
- Uses of Countif
- SUMIF formula
- SUMIFS examples
- COUNTIFS examples
Using IF Formula, Nesting IF Formulas
What is in this lesson?
- IF Formula
- Nesting IF Formulas
- CHOOSE Formula
- Examples of Nested IFs and Discussion
Relative & Absolute Cell References in Formulas
What is in this lesson?
- Difference between relative and absolute references
- using $ symbol while writing formulas
- Switching between relative & absolute refs. With F4 key
Continue reading “Relative & Absolute Cell References in Formulas”
Lesson 0 – An Overview of Excel
Hi there,I was an year late to create this lesson. But now I have learned my lesson ;). So here we have a brand new lesson on overview of Excel. This should be a perfect way to start Excel school.
What is in this lesson?
- A brief overview of Excel
- Understanding and working with Ribbon
- How to create links to different sheets and cells?
- Inserting org. charts and other stuff
- Using Auto-fill, copying and pasting values
- Printing Worksheets
- Little tips & tricks that may surprise you