Videos
Excel Dynamic Arrays – Game Changer!
Leila Gharani shows you how powerful the new Dynamic Arrays will be in Excel!
Excel Power Pivot Introduction!
Excel is Fun gives you a great introduction to Power Pivot in Excel!
Consolidate Excel Worksheets Using VBA
Dinesh Kumar Takyar shows how to consolidate multiple Excel worksheets using VBA.
Sorting and Unsorting in Excel
Leila Gharani shows several methods of Sorting, as well as a tip on how to set up your data to allow “Unsorting”
Create Pivot Table from Multiple Datasets in Excel
Everyday Office shows you how to use Tables and Relationships to create pivot tables from multiple datasets in Excel.
Dynamic Images in Excel
Leila Gharani shows you how to create dynamic pictures that will update automatically.
Use VBA to Control Header in Excel
Leila Gharani shows you how to use VBA to control the Header in your Excel file.
Protect Your Worksheets
Everyday Office shows you how to protect the integrity of your worksheets when other users need to enter data.
Return Multiple Match Results using the AGGREGATE Function.
Leila Gharani shows you how to return multiple results with an Index lookup, by using the AGGREGATE function.
Variable Scope in VBA.
Dinesh Kumar Takyar shows how to create variable scopes in VBA.
Power Query to Import Data From Different Countries
Excel is Fun shows you how to import data with different geographic formats.
Alternative to Merging in Excel
Everyday Office shows you how to use the “Center Across Selection” option instead of Merging & Centering.