If you want to upgrade your excel skills you probably considered taking an excel course. We gathered for you the top excel courses that you actually can get for free. While some websites allow free viewing and only paid certification, others would allow the first weeks for free.

1. Coursera – Free, paid certificates

Coursera is one of the most popular online learning platforms in the world. It offers a wide range of courses from top universities and institutions. Coursera also offers a wide range of Excel Courses and subjects, from beginner to intermediate levels, including data analysis, pivot tables, and complex formulae. Additionally, they provide certificate programs and specialties that let you gain a deeper understanding of particular Excel abilities.

2. EdX – Free, paid certificates

EdX is another well-known online learning platform. EdX offers Data Science, Software Programming and online Master’s Degrees, in addition to Excel courses from top universities. EdX provides a selection of beginner to expert-level courses on Excel subjects including data visualization, financial modeling, and Excel macros. Furthermore, you can find there a variety of certified credentials that can assist with upgrading your career.

3. SkillShare – Free for 30 days

Skillshare provides creative and practical skills for individuals. Skillshare provides a selection of Excel courses taught by professionals on subjects including data analysis, Excel shortcuts, and financial modeling. Additionally, Skillshare provides access to a large selection of creative courses through a subscription-based strategy.

4. AmazonKindle – get KindleUnlimited Free for 30 day

Did you know that some of Kindle’s online books include full video training courses?

Kindle Unlimited is a subscription-based service offered by Amazon that gives members access to a wide range of e-books, including books on Excel. These books and courses cover a variety of Excel subjects, including data analysis, pivot tables, and Excel macros, and may be found in basic to intermediate levels. Kindle Unlimited provides a variety of possibilities and is a wonderful choice if you enjoy reading and studying at your own speed even if it is less interactive than other platforms.

5. Excel-Practice-Online.com – Absolutely Free!

No need to add much more on our unique website :). Excel Practice Online is the best website for Excel learning and practice. With our hands-on approach and hundreds of exercises with explanations, you’ll become a Master of everything related to Excel formulas and tools.

The post Free Excel Courses and Resources first appeared on Excel Practice Online.

Excel-Practice-Online.com Resources

1. Practice Data Worksheet  – this page includes an excel-online workbook with a practice data set.
2. Excel Exercises – Find here dozens of excel sheets for practice functions and formulas.

External links

1. Northwind Traders Excel Version– Excel Version of the famous Northwind Example Database
2. Kaggle –  Kaggle is operated by a community of machine learning and data scientists.  The website has thousands of data sets for practice and learning. 
3. Data.gov  – US government official website where you can find data, tools, and resources to practice your Excel skills.

Want to share with us other datasets and practice materials? please let us know in the form below!

Having an issue with the formulas' language? check out this post

Help us with improving our content! Please rate this post

• Poor
• Average
• Excellent!

Should we add a video with explanations to this page?

• Yes, that would be helpful!
• No Need.
• I don't know

My level in Excel: (Optional)

• Beginner
• Intermediate
• Advanced

Your Country (optional)

Please share your feedback with us!

Submit

The post Excel Data For Practice first appeared on Excel Practice Online.

Whether you’re an analyst, accountant, student and or job seeker – you must know these tools. The list contains the top 10 formulas and tools, which we identified in a survey conducted in one of the Facebook groups we manage with over 40K users! Over 200 participants voted for the most useful formulas. The results and instructions for how to use them are detailed in this article!

1. VLOOKUP

VLOOKUP  is a super helpful function that lets you search for a value in a table and return a corresponding value in another column! Whether you want to complete a table automatically, compare two datasets, or find a value from another sheet – VLOOKUP is what you’re looking for.

V is for vertical, as the lookup feature allows us to search for a value in a vertical table.

Most of the users will use VLOOKUP exact match, which is explained in our VLOOKUP tutorial

2. Pivot tables

Ask any excel expert and they will tell you that this tool is a must! With only three clicks, pivot tables will allow you to create super powerful reports and use many tools such as filter, sorting and charts! 

Learn more about Pivots or click here to download the Pivot table example

3. SUM

If you ever used a calculator – you probably know how tedious it is to add many items into the sum line.

Sum function will allow you to add up cells together. In 5 seconds, you’ll be able, to add up, thousands of rows.

Learn and practice SUM here

4. SUMIF 

Now let’s assume that you would like to add cells together by criteria. You can easily do it by using SUMIF formula.

This formula (and its sisters SUMIFS, COUNIFS and average if) will quickly help you with aggregating many cells tougher

Learn and practice SUMIF here

5. SUMIFS

If you liked SUMIF – you would love SUMIFS. SUMIFS is very similar to SUMIF, however – it allows summing cells by multiple criteria

For example, we would like to sum only cells that match more than one condition  – SUMIFS is precisely for that!

if you would like to apply other operations than SUM – you can use COUNTIFS for counting and AVERAGEIFS for averaging!

Learn and practice SUMIFS here

6. Charts and Graphs

Charts and Graphs are great for presentations and quantitative storytelling. We are all familiar with charts from newspapers, TV, School and sports. With Excel, you can easily create charts from many different kinds! More on charts here

7. IF

IF function checks whether a statement is TRUE or FALSE and lets you choose the value for each of the case. Use the simple IF formula to quickly check if one cell is greater/equal/less than another one.

Learn and practice IF here!

8. Conditional Formatting

Yes, Excel is boring! So why don’t we add some color to it? Reports and analysis papers could be much easier to read if we highlight the points that we want to focus on with conditional formatting.

Simply make your spreadsheet return red for negative or green for positive, in fact, you can control any formatting attribute you’d like! Such as bolding, underline, or even sizing a font! More on Conditional formatting here

9. Filter

Quickly want to hide all irrelevant values?  Filter is a great tool that would visually help you analyze and structure your report better!

10. Index & Match

This combination of formulas is Like VLOOKUP – only better! Even though Vlookup is super popular, it is not so flexible. With index&match you can use any column as the lookup column.

Learn and practice index & match here!

Having an issue with the formulas' language? check out this post

Help us with improving our content! Please rate this post

• Poor
• Average
• Excellent!

Should we add a video with explanations to this page?

• Yes, that would be helpful!
• No Need.
• I don't know

My level in Excel: (Optional)

• Beginner
• Intermediate
• Advanced

Your Country (optional)

Please share your feedback with us!

Submit

The post Top 10 Microsoft Excel Functions You Must Know! first appeared on Excel Practice Online.