Be an Analyst is weekly series which aimed to enhance skills beyond beginner level.These topics are composed of the most popular articles, as well as articles demonstrating new or updated features.
1. Using Auto filter with a Pivot Table
Have you ever tried of applying AutoFilter in Microsoft Excel and finally end up with disappointing ?. then this is the article for you which will explain how to apply AutoFilter
2. Copy an Exact Formula to the Below cell
This YouTube video from Bill Jelen will explain how to copy the exact formula from the above cell with same references.
3. Why Use Access, Why not use Excel
In this video from Stephen Brower , Explained why to use access rather than Excel. If you are working with data, which is similar to what Mr.Browner explained. then it’s better to work with access which will eradicate errors using referential integrity.