8. What you see is what you get in the Excel Function Dictionary which is a downloadable workbook that acts as a reference dictionary. Simply find a function and learn exactly how to use it with examples embedded into the workbook. Sadly, it has not been updated since 2009.
9. While About.com is a widely known content farm and it is essentially a Wikipedia with advertisements and lots of them. We were first hesitant to include it but it hass own spreadsheets subdomain devoted to Excel with over 1800 separate pages with how-to text and pictures all dedicated to Excel and consistently posts fresh content. Realistically, the number of tutorials is probably less than one thousand because many of the posts simply link to previous posts or are split into multiple pages to maximize exposure but if you can put up with the ad content there is a lot of information.
10. Many EDU sites have their own excel tutorials. There is a lot of either specialty content (for physics or business) and outdated content. We found some excel wiki’s from 1995! However, Duke’s Fuqua School of Business Excel wiki is a head and shoulders above the rest. It has a ton of tutorial content and practice workbooks. There is some content for Excel 2010, but most of it is for Excel 2003 and 2007.
11. The Barnard Library site is another EDU site with good tutorial content for Mac for Excel 2011 and Excel 2010 for PC’s. Again, the site is a work in progress with whole sections on the using the Excel Ribbon that are under construction.
12. ExcelTutorial.com is no frills basic tutorial that does not even list the name of the author. After some detective work we were able to trace some of the videos to Juan David Suarez Gil’s Youtube Channel where he hosts makeshift Excel Massive Open Online Course (MOOC).
13. The Excel Tip of the Month is from Isaac Gottlieb, professor and author. It provides many practical applications of Excel in action. The best part is that the tips are provided in a downloadable Excel file that allows you learn and apply almost immediately. As of September 2012 this has moved to the Temple Fox School of Business website.
14. Allan Wyatts Excel Tips is a subsite of Tips.net and provides a myriad of tips of the Ribbon versions of Excel (Excel 2007 and later). The site has over 1200 different Excel tips with explicit instructions and desciptive pictures. There is also a separate subsite for the non-ribbon (older versions) of excel.
8. What you see is what you get in the Excel Function Dictionary which is a downloadable workbook that acts as a reference dictionary. Simply find a function and learn exactly how to use it with examples embedded into the workbook. Sadly, it has not been updated since 2009.
9. While About.com is a widely known content farm and it is essentially a Wikipedia with advertisements and lots of them. We were first hesitant to include it but it hass own spreadsheets subdomain devoted to Excel with over 1800 separate pages with how-to text and pictures all dedicated to Excel and consistently posts fresh content. Realistically, the number of tutorials is probably less than one thousand because many of the posts simply link to previous posts or are split into multiple pages to maximize exposure but if you can put up with the ad content there is a lot of information.
10. Many EDU sites have their own excel tutorials. There is a lot of either specialty content (for physics or business) and outdated content. We found some excel wiki’s from 1995! However, Duke’s Fuqua School of Business Excel wiki is a head and shoulders above the rest. It has a ton of tutorial content and practice workbooks. There is some content for Excel 2010, but most of it is for Excel 2003 and 2007.
11. The Barnard Library site is another EDU site with good tutorial content for Mac for Excel 2011 and Excel 2010 for PC’s. Again, the site is a work in progress with whole sections on the using the Excel Ribbon that are under construction.
12. ExcelTutorial.com is no frills basic tutorial that does not even list the name of the author. After some detective work we were able to trace some of the videos to Juan David Suarez Gil’s Youtube Channel where he hosts makeshift Excel Massive Open Online Course (MOOC).
13. The Excel Tip of the Month is from Isaac Gottlieb, professor and author. It provides many practical applications of Excel in action. The best part is that the tips are provided in a downloadable Excel file that allows you learn and apply almost immediately. As of September 2012 this has moved to the Temple Fox School of Business website.
14. Allan Wyatts Excel Tips is a subsite of Tips.net and provides a myriad of tips of the Ribbon versions of Excel (Excel 2007 and later). The site has over 1200 different Excel tips with explicit instructions and desciptive pictures. There is also a separate subsite for the non-ribbon (older versions) of excel.
การแปล กรุณารอสักครู่..