Share via

Free excel spreadsheets to practice excel

Anonymous
2020-05-01T17:29:12+00:00

I want to improve my excel skills, and I need free excel spreadsheets to do so. 

Please tell me where can I get them

Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2020-05-01T17:35:19+00:00

    Hi LuisRiosZW,

    I'm an Independent Advisor and consumer of Microsoft products just like you. Let me help you with your concern.

    You can go to the official Excel for Windows training page below. It offers tutorial videos and downloadable templates.

    https://support.office.com/en-us/article/excel-...

    60+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2020-05-01T18:46:59+00:00

    Google is your friend. There are lots of web sites with free download files to go along with their lessons / tips.

    **Vertex42.com******https://www.vertex42.com/

    This emodel has hundreds of ready made Excel templates that you can download for free and use straight away!

    .

    Zapier’s Guide to Mastering Excel Online****https://zapier.com/blog/excel-online-guide/****Microsoft has a free version of Excel that anyone can use through a browser. Excel Online (or Office Online, as the official name goes) only requires a free Microsoft account and an active internet connection. While it’s not as robust as Excel 2016, it’s still pretty good.

    Our friends at Zapier, the premier if-this-then-that automation service, have an excellent guide to Excel online to get you started. Through this, you will learn every part of what you can and can’t do with Excel on the web.

    .

    Step-by-Step Learning Videos From GCF LearnFree****https://www.makeuseof.com/tag/best-excel-tutorials-courses-beginners/

    The Goodwill Community Foundation’s LearnFree online academy is an outstanding accompaniment to Microsoft’s official course. It is broken down into similar sections and videos, all of which are free on YouTube.

    Again, it’s the careful break-up of learning Excel that is key here. GCF LearnFree turns it into a step-by-step process, with a total of 29 sections. Each section has a video, a long article, as well as recommended exercises.

    .

    Spreadsheeto’s Daily 10-Minute Email Course****https://spreadsheeto.com/

    Anyone who tells you that you need several days of dedicated time to learn Excel is flat out lying, according to the creators of Spreadsheeto. Instead, all you need are 10 minutes daily to watch a video, and another five minutes to practice what you learned.

    Spreadsheeto works on the principle of micro-learning, sending small lessons to your inbox daily. Watch the video, and then use the accompanying Excel file to practice it. The file actually includes a sheet to replicate what you just saw, so you know whether you’re doing it right or not.

    .

    **Online Excel Lessons****** 2013 11 07 Jeff Lenning ****http://www.excel-university.com/online-excel-lessons/ ****I’m pleased to announce the immediate availability of the Excel University Chapter Evaluation Courses, which are online Excel lessons that cover a single chapter and topic and can be used to evaluate our online Excel training. These mini-classes typically take about 30 minutes to complete, and contain a lecture video, homework activities, the practice Excel workbook, an exam, a certificate of completion, and additional resources.

    .

    **The Start-to-Finish Giant Tutorial by Excel Easy******http://www.excel-easy.com/

    it’s flabbergasting that such a great tutorial is available for free.

    You start with the introduction, move on to the basics, learn how functions work, start analyzing data with Excel, and finally learn Excel VBA at the advanced stage. Each of those has the simplest explanation possible in the form of a single page, with screenshots and easy language.

    As if that wasn’t enough, Excel Easy then gives you 300 examples of common tasks you can automate in Excel. Get ready to become an Excel macros ninja!

    .

    Office Online Training Courses Free & Paid, Excel Word & Outlook

    http://www.myonlinetraininghub.com/microsoft-office-online-training-courses

    Excel 2016 Tutorial: A Complete Guide on Excel for Anyone Sali Kaceli (video 2:04hr).

    Excel 365 for Windows traininghttps://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb

    Quick start

    Intro to Excel

    Rows & columns

    Cells

    Formatting

    Formulas & functions

    Tables

    Charts

    PivotTables

    Share & co-author

    Take a tour   Download template >

    Formula tutorial       Download template >

    Make your first PivotTable Download template >

    Get more out of PivotTables        Download template >

    MyExcelOnline -

    https://www.myexcelonline.com/free-excel-online-training-courses#webinars

    Functions & Formulas    Learn The MUST KNOW Excel Formulas to ADVANCE your Excel skills!

        IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...!

    Macros & VBA

         Learn How To Record MACROS & Write VBA Code within 1 HOUR!

        AUTOMATE repetitive & boring tasks with a single press of a button that will SAVE YOU Time & Money!

    Pivot Tables

        Analyze Tons of Data With a Couple of MOUSE CLICKS!

        Create interactive EXCEL DASHBOARDS without having to memorize Formulas or write code!

    .

    **MyOnlineTrainingHub.com**(paid courses)http://www.myonlinetraininghub.com/

    Mynda Treacy runs this beautiful website which has many examples, covering all Excel tools.  Her technical explanation and easy to understand blog posts have now become my favourite source of inspiration.

    At bottom of page, FREE Access to Over 19 Hours of Video Tutorials for Excel, Word & Outlook 2007, 2010 and 2013

    .

    Introducing Spreadcheats – Become Supergood with Excel in 30 days                    2008 10 31

    https://chandoo.org/wp/tag/spreadcheats/

    Starting next week, PHD is going to feature a 30 post series on spreadcheats. The purpose of these posts is to make day to day spreadsheeting a breeze. Each post will be less than 200 words in size and aspires to make your day at office a little bit more productive. I have already identified

    .

    Note: many of the blogs on the Chandoo site include free downloads

    .

    Learn Any Area of Excel using these 80 Linkshttp://chandoo.org/wp/2011/12/12/learn-excel-by-topic/We share some of the best tutorials & examples with you so that you can learn. In this post, we have presented more than 75 links, to help you learn your area of focus..

    MS Office Training Center

    https://support.office.com/en-us/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb?ui=en-US&rs=en-US&ad=US#ID0EAABAAA=Excel

    Links to all MS apps

    .

    MS Excel 2013 training

    https://support.office.com/en-us/article/excel-2013-training-aaae974d-3f47-41d9-895e-97a71c2e8a4a?wt.mc_id=otc_excel

    Beginner

        Start using Excel     Create a chart

        Add numbers in Excel 2013         Basic math in Excel 2013

        Top tips for working in Excel Online        Understand and use cell references

        Use AutoFill and Flash Fill

    Intermediate

        Add or subtract time                    Average a group of numbers

        Insert headers and footers           Make the switch to Excel 2013

        Sort and filter data                       Take conditional formatting to the next level

        Use conditional formatting            VLOOKUP: When and how to use it

    Advanced

        Advanced IF functions                                               Array formulas

        Create and manage drop-down lists                           Create a PivotTable and analyze your data

        Password protect workbooks and worksheets             Print worksheets and workbooks

        Work with macros

    .

    MS Excel Training sub page (free)-https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb****Workbooks, Cells, and formulas

    Tables Charts and analysis

    PivotTables, Collaboration and Mac

    links to Excel 2013, 2010 specific training

    .

    MS Office Training Center – Excel

    https://support.office.com/en-us/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb?ui=en-US&rs=en-US&ad=US#ID0EAABAAA=Excel

    .

    Microsoft Excel 2016 Quick Start Guide - Computer-PDF.comhttps://www.computer-pdf.com/office/excel/401-tutorial-microsoft-excel-2016-quick-start-guide.html

    New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics. A PDF file by Microsoft

    Introduction to Excel 2016****https://www.computer-pdf.com/office/excel/464-tutorial-introduction-to-excel-2016.html

    This booklet is the companion document to the Excel 2016: Intro to Excel workshop. It includes an introduction to the Microsoft Office 2016 interface and covers the various aspects of creating, formatting, editing, saving, and printing a document in Excel

    Advanced Excel ToolsExcel 2016 ****https://www.computer-pdf.com/office/excel/466-tutorial-excel-2016-advanced-excel-tools.html

    This booklet is the companion document to the Excel 2016: Advanced Excel Tools workshop. PDF file by Kennesaw State University.

    Excel 2013: Advanced Excel Tools****https://www.computer-pdf.com/office/excel/369-tutorial-excel-2013-advanced-excel-tools.html

    Download free Microsoft Office Excel 2013 Advanced Excel tools, course tutorial training, a PDF file by Kennesaw State University.

    .

    Linkedin Learn Excel (30 day free trial)https://learning.linkedin.com/in/microsoft-excel?trk=par_acq_MSFThelp-excel-tc-help-seealso-c017-v00114_learning&src=mi-inprod&veh=excel-help&utm_source=microsoft&utm_medium=help-integration&utm_campaign=par_acq_MSFThelp-excel-tc-help-seealso-c017-v00114_learning

    Advance your knowledge of Microsoft® products with LinkedIn Learning. 30 day free trial, followed by paid subscription

    You can learn

       • Basics and fundamentals           • Worksheet management

       • Financial functions           • Data management and analysis

       • Macros in depth              • Advanced formulas and functions

       • Database creation           • Master pivot tables, formulas

       • and more

    .

    https://wellsr.com/vba/excel/ - Collection of macros you can download.

    20+ people found this answer helpful.
    0 comments No comments