Leila Gharani shows you how powerful the new Dynamic Arrays will be in Excel!
Excel is Fun gives you a great introduction to Power Pivot in Excel!
Dinesh Kumar Takyar shows how to consolidate multiple Excel worksheets using VBA.
Leila Gharani shows several methods of Sorting, as well as a tip on how to set up your data to allow “Unsorting”
Everyday Office shows you how to use Tables and Relationships to create pivot tables from multiple datasets in Excel.
Leila Gharani shows you how to create dynamic pictures that will update automatically.
Leila Gharani shows you how to use VBA to control the Header in your Excel file.
Everyday Office shows you how to protect the integrity of your worksheets when other users need to enter data.
Leila Gharani shows you how to return multiple results with an Index lookup, by using the AGGREGATE function.
Excel is Fun shows you how to import data with different geographic formats.