Use Cell Referencing in Excel
Learn how to use cell referencing in excel.
Use Cell Referencing in Excel Read More »
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 »
Send BULK EMAILS using VBA in Excel and sending it via Outlook
Learn how to create macros to send bulk emails through Outlook automatically from Excel.
Send BULK EMAILS using VBA in Excel and sending it via Outlook Read More »
Create a Duplicate Removal Tool in Excel using VBA
Learn how to create a duplicate removal tool in Excel using VBA.
Create a Duplicate Removal Tool in Excel using VBA Read More »