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.

Books stacked over each other
Books stacked over each other

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


YouTube Logo
LinkedIn Logo
Facebook Logo
Instagram Logo
Pinterest Logo