Excel or Google Sheets Resources
Are you looking to learn more about Excel or Google Sheets?
If yes, then you have come to the right place!
We have compiled a comprehensive repository of knowledge articles on Excel and Google Sheets.
The articles cover A to Z of what you need to know about Excel or Google Sheets.
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.
Select the article of your choice from the list below and dive straight into it!
Essential Formulas
Learn key formulas used for analysis such as SUM, AVERAGE, SUMRODUCT, RANK, MAX, MIN, UNIQUE, and FREQUENCY
Cell Referencing
How to use Relative, Fixed and Advanced referencing methods to write formulas and boost your productivity
Defining Names
Define Names using multiple methods to increase productivity, make it easy to refer to cells and help in easy creation of lists
LOOKUP Formulas
Learn how to find related data to a known value using VLOOKUP, or VLOOKUP with Approximate Match and HLOOKUP
INDEX & MATCH
Use the Index and Match formulas to perform a 2 way lookup and find out value based on more than one parameter
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
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
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
