Welcome to the How To Excel At Excel Download Area. 
The downloads are split into sections.
F001[ddownload id=”7090″]How To Calculate The Most Improved Sales Area With An Array Formula.
F002 [ddownload id="7095"]Which Of My Scores Is In 3rd Position Using Excel Large Formula.
F003 [ddownload id="7101"] Index and Randbetween To Pick A Random Winner
F004[ddownload id="7106"]Use the LEN Function To Identify Issues With An Access Data Import
F005 [ddownload id="7477"]Use SUMIFS Funtion To Calculate Product Volumes Sold At Promotion Price
F006 [ddownload id="7841"]Use VLOOKUP To Return Multiple Values Horizontally
Excel Charts Downloads and Templates
C001 [ddownload id="7564"]Sales Funnel Chart Template. Quickly create a sales funnel chart in Excel 2013
The New Ribbon Interface Simplified- Get ripping With The Ribbon!] Want to know more and get ripping with the Excel Ribbon, here is a FREE EBook Guide that includes a guide to all of the different tabs what each of them does and a few extra bonus tips to get you on your way.[wpdm_package id=11]
[callout title=Want Templates?] Look No Further. A Huge Collection of Fabulous Templates For Every Occasion! Browse around you won’t be disappointed. Hundreds to choose from and download right now. Just Click HERE[/callout]
[callout title=Working With Advanced Filtering In Excel]Most of the time in Excel an AutoFilter would enable you filter lists in the ways you need to, But, in some cases you may need or want to exert more control of over the way filtering operates. If this is the case then using Excel advanced filters is the way to go……{filelink=6}[/callout]
[callout title=Create A Very Simple Dynamic Chart Quickly In Excel]There are many ways to create dynamic charts in Excel, but today I want to share with you one of the most simple. In fact I think it is THE simplest way I think I know to create fun simple but impressive dynamic charts. Let’s for an example say we want to show……..{filelink=2}[/callout]
[callout title=The How To Excel At Excel Tracker For 2012] A free goal tracker . Want to track set goals, track progress then this is for you………..All done with a little Excel stardust….this was a free download for my How To Excel At Excel newlestter subscribers in preparation for 2012. Want to sign up for three free top Excel tips every 15 days?- then just sign up there on the right>>>…… {filelink=5}[/callout]
[callout title=MS Excel Tutorial Pivot Table Foundations] To fully understand and get the best out of this fantastic Excel function you need to know the core terminology, concepts, functions and building blocks to getting your data set just right so you can have perfect pivots!.Let’s start with the basics………{filelink=7}[/callout]
[callout title=MS Excel Tutorial- What Is A Pivot Table? And How To Create Your First One] One of THE most useful features in Excel is the pivot table which is used to summarize, analyze, explore, tabulate and present your data. Not just small amounts of data, but we can cope with huge amounts. Whether it is 500 or 50,000 lines of data no problem with your friend the pivot table………{filelink=7}[/callout]