Practice Exercises

Irene, the link below must help..
http://www.graphixfree.net/graphixshare/excel-practice-exercises-2013

You can any training course in your copy of Excel to recreate the examples they describe.

Google is your friend, try doing some web searches. There is Lots of material out there!

KEY TIP

Changes to Office applications (and Windows) is slow, "evolutionary" rather than "revolutionary". So when you find resources that look good, do not ignore them simply because they are not for your specific version of Office.  Older tips, going back to menu versions are often still very applicable to 2016.  The command locations may vary, but the underlying logic still applies, with only a little translation.

https://support.office.com/en-us/article/Excel-2007-training-courses-and-tutorials-1efc6672-7c37-4805-a04a-915284298875

https://support.office.com/en-us/excel  (2016)

https://support.office.com/en-us/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb (2016)

https://powerbi.microsoft.com/en-us/guided-learning/?ui=en-US&rs=en-US&ad=US

http://chandoo.org/wp/training-programs/

http://chandoo.org/wp/excel-school/faqs/ - this specific page is about (paid) training course. But look through the rest of the site. He has LOTS of short tips. Many of them come with example files you can download to look at exactly what was done to get the end result.  Subscribe to his blog, it is well worth it!

http://chandoo.org/wp/2011/12/12/learn-excel-by-topic/

http://www.brighthub.com/computing/windows-platform/topics/microsoft-excel.aspx - a good tips site

http://www.free-training-tutorial.com/ - free online training for Excel and other applications

http://www.microsofttraining.net/microsoft-training-manuals.php - download free Office training manuals 2003-2013

http://www.myonlinetraininghub.com/free-registration - 19 hours of FREE video tutorials, plus a free download "100 Excel Tips".

http://www.innatespreadsheet.com/excel-techniques-news-and-more/excel-resources-blogs-forums-links-and-more/

by John Franco on November 23, 2009

Didn’t find the info you were looking for? Find it here where you have a selection of the Best Sites of the entire Internet in the areas of Excel Help, Tips, VBA, Spreadsheet Modeling and more…

·      Vertex42.com - Templates and spreadsheets for small business, personal finance, time management, education, statistics, and engineering and more.

·      ExcelTips.com - The site offers over 1,900 articles and tips.

·      MrExcel.com - It has tons of tips and articles. Visit the forum to find thousands of questions and answers from a very active community of users and experts.

·      Ozgrid.com - I love the forum, it is a vibrant community full of expertise. The site also offers you a Free Excel Stuff section with tons of downloads, examples and more.

·      ExcelExperts.com - Download for free practical Spreadsheets (personal finance, property and more). Participate in the forums; learn new advanced tips, get deep info in the blog and more…

·      ExcelHero.com – Advance your Excel creativity with extreme Excel

·      Spreadsheetpage.com - It contains tips, downloads, books, oddities and more. It also offers the Spreadsheet Blog.

·      MVP page – Official list of the current Most valuable professionals (MVP) and their websites

This Excel resource list is a work in progress; do you know a great resource worth sharing? Please post your findings in the comments section below…

http://www.mrexcel.com/msft.html - Free Book download, Learn Excell 97-2007 from MrExcel, 926 pg PDF

http://www.contextures.com/excelfiles.html#FN0022 - Sample Excel Files - Excel Templates - Data Validation, Filters, Conditional Formatting, UserForms, VBA, Add-Ins, External Data, Charts and Graphics, PivotTables, Functions, Scenarios, Comments

http://www.pierrefondes.com/  - 100+ example sheets and charts

http://www.ozgrid.com/ - Free excel examples and free training

http://chandoo.org/wp/2015/12/03/cp050-fifty-excel-tips/

Although this is slightly off topic, it is a concept that I've been using for 25 years as a professional programmer. It is certainly worth applying to Excel development.

http://chandoo.org/wp/2014/05/07/modular-spreadsheet-development-a-thought-revolution/