Use Cell Referencing in Excel
Learn how to use cell referencing in excel.
Use Cell Referencing in Excel Read More »
Excel Basics
Spreadsheet tools created with excel foundational basics.
Use AND, OR, IF and IFERROR formulas in Excel
Learn how to use AND, OR, IF and IFERROR formulas in Excel and understand how it works.
Use AND, OR, IF and IFERROR formulas in Excel Read More »
Create a NESTED IF with AND easily
Learn how to create a “NESTED IF with AND” formula easily.
Create a NESTED IF with AND easily Read More »
Create an IFS with AND formula (easier alternative to NESTED IF)
Learn how to create an IFS with AND formula.
Create an IFS with AND formula (easier alternative to NESTED IF) Read More »
Create Multiple Dependent Dropdown Lists using INDIRECT formula
Learn how to create Multiple dependent dropdown lists using the INDIRECT formula in Excel and Google Sheets.
Create Multiple Dependent Dropdown Lists using INDIRECT formula Read More »
Create Multiple Dependent Dropdown Lists using MATCH, OFFSET & COUNTA formula
Learn how to create Multiple dependent dropdown lists using MATCH, OFFSET and COUNTA formula in Excel.
Create Multiple Dependent Dropdown Lists using MATCH, OFFSET & COUNTA formula Read More »
Create a Profit & Loss Statement with PivotTable
Learn how to create your own Profit and Loss Statement using Pivottables.
Create a Profit & Loss Statement with PivotTable Read More »
