Excel or Google Sheets Resources
Excellent knowledge of fundamentals of Excel or Google Sheets is essential for most working professionals.
We have compiled an explanation of the most common topics to provide you with a better understanding in these areas.
Excel or Google Sheets Resources
Excellent knowledge of fundamentals of Excel or Google Sheets is essential for most working professionals.
We have compiled an explanation of the most common topics to provide you with a better understanding in these areas.
Are you looking to learn more about Excel or Google Sheets?
If yes, then you have come to the right place!
You can find explanations of new features, formulas, ways to create dashboard elements, common stumbling blocks and simple answers to most burning questions on Excel or Google Sheets.
FORMULAS
FORMULAS
Essential Formulas
Learn key formulas used for analysis such as SUM, AVERAGE, SUMRODUCT, RANK, MAX, MIN, UNIQUE, and FREQUENCY
LOOKUP Formulas
Learn how to find related data to a known value using XLOOKUP, VLOOKUP, HLOOKUP including the Approximate Match option
INDEX & MATCH
Use the Index and Match formulas to perform a 2 way lookup and find out value based on more than one parameter
Essential Formulas
Learn key formulas used for analysis such as SUM, AVERAGE, SUMRODUCT, RANK, MAX, MIN, UNIQUE, and FREQUENCY
LOOKUP Formulas
Learn how to find related data to a known value using XLOOKUP, VLOOKUP, HLOOKUP including the Approximate Match option
INDEX & MATCH
Use the Index and Match formulas to perform a 2 way lookup and find out value based on more than one parameter
PRODUCTIVITY
PRODUCTIVITY
Cell Referencing
How to use Relative, Fixed and Advanced referencing methods to write formulas and boost your productivity
Define Names
Define Names using multiple methods to increase productivity, make it easy to refer to cells and help in easy creation of lists
Creating Lists
Create lists using multiple methods and maintain consistency during data entry. This reduces errors and allows you to work faster
Filter Data
Filter unique values, Using Text Filters, Customizing Criteria to Filter Data, Applying Filter by Color, and Clear Filters
Advanced Filters
How to use Advanced Filters, Using OR & AND conditions with Advanced Filters, Applying Formulas in Advanced Filters
Sort Data
Sort Data, Sort basis Single or Multiple Columns, Sort only a Single Column, Custom Sort, Sort Lists, Sort by Color & Formatting
Format Range as Tables
Format your data as a table and write formulas that are easy to read and copy. Apply formulas and formatting automatically to new rows added
Cell Referencing
How to use Relative, Fixed and Advanced referencing methods to write formulas and boost your productivity
Define Names
Define Names using multiple methods to increase productivity, make it easy to refer to cells and help in easy creation of lists
Creating Lists
Create lists using multiple methods and maintain consistency during data entry. This reduces errors and allows you to work faster
Filter Data
Filter unique values, Using Text Filters, Customizing Criteria to Filter Data, Applying Filter by Color, and Clear Filters
Advanced Filters
How to use Advanced Filters, Using OR & AND conditions with Advanced Filters, Applying Formulas in Advanced Filters
Sort Data
Sort Data, Sort basis Single or Multiple Columns, Sort only a Single Column, Custom Sort, Sort Lists, Sort by Color & Formatting
Format Range as Tables
Format your data as a table and write formulas that are easy to read and copy. Apply formulas and formatting automatically to new rows added
FORMATTING
FORMATTING
Formatting Worksheets
Text Alignment, Fonts, Cell Styles, Borders, Format Painter, Hide/Unhide Columns, Merge Cells, Wrap Text and Writing on Multiple Lines
Format Cells
Format cells based on the type of data it contains. Detailed explanation on formatting cells as Number, Currency, Data and Fractions
Formatting Worksheets
Text Alignment, Fonts, Cell Styles, Borders, Format Painter, Hide/Unhide Columns, Merge Cells, Wrap Text and Writing on Multiple Lines
Format Cells
Format cells based on the type of data it contains. Detailed explanation on formatting cells as Number, Currency, Data and Fractions
