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.

Explanation

The CONCATENATE function in Excel allows us to merge text from multiple cells into one cell. This can be useful for creating a single, combined string of text from several sources.
Syntax, The syntax of the function, is simple: =CONCATENATE(text1, text2, text3…) text1, text2, text3, etc. – the text strings we’d like to combine into one cell. These can be individual cell references or direct text entries in quotation marks. Note that the “=CONCATENATE()” function can only combine text and cannot be used to perform calculations.

It is worth noting that there are newer functions that may be better alternatives for combining text, such as the =TEXTJOIN and =CONCAT functions, or use the Flash Fill.

Example

For example, if we have text in cells A1, B1, and C1, we can combine these into one cell by entering “=CONCATENATE(A1,B1,C1)” into another cell. This will result in a single cell that contains the combined text from all three cells.

Concatenate – Exercise

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 Concatenate first appeared on Excel Practice Online.

Explanation

The FORMULATEXT function in Excel allows us to display the formula of a cell as text. This can be useful for showing the underlying calculations of a cell or for referencing the formula in another part of the workbook. FORMULATEXT is a very useful function for Excel Teachers and financial modeling and anyone who wants to present the formulas behind a calculation. 

Syntax

The syntax of the function is straightforward: =FORMULATEXT(reference) where A1 is an example of reference – the cell reference for which we’d like to display the formula as text.
Note that the “=FORMULATEXT()” function can only display the formula of a cell and cannot be used to modify or change the formula.

Example

For example, if we have a formula in cell A1, =SUM(B2:B6), we can display the formula as text by entering “=FORMULATEXT(A1)” into another cell. This will display the text “=SUM(B2:B6)” in the cell.

Exercise

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 FORMULATEXT Function first appeared on Excel Practice Online.

Over the past years – Excel-Practice-Online received Emails from users facing a problem that their formulas are configured in non-English languages. While results may be correct, it can cause issues with checking if your formula is correct or not.

Example

Let’s assume that you are from Norway and you get formulas in Norwegian. in this case, instead of SUM you’d probably get the formula SUMMER, which is the same formula in Norwegian.

How can you change Excel Online’s language to English?

1. Change your OneDrive settings – Go to your onedrive account settings, and change the default language to English.
2. Use incognito mode (private browsing).
3. Alternatively, you can use Microsoft’s Formula Translator to understand which English Formula you should use.

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 How to Change Excel Online Language first appeared on Excel Practice Online.

Name *

First

Last

Email *

Phone

Checkboxes *

• Please send me information about new products and services from Excel-Practice-Online.com

Submit

The post Early Sign Up Form – Extra Practice first appeared on Excel Practice Online.

                                                                                                                  

The post Recommended Materials first appeared on Excel Practice Online.

The post Financial Functions Tutorials first appeared on Excel Practice Online.

You will be using functions and topics such as:

• COUNTIF
• FILTER
• Excel Dynamic Arrays
• SEARCH
• SUBSTITUTE
• ISNUMBER
• LEN
• Boolean algebra

And more…

You can view the answers in the Solution tab!

Exam level – Advanced

If you prefer to work on this exam using regular Excel – click here to download the Data Analyst Practice exam no. 2

Expand your Analytics Skills! Check Out Coursera’s Google Data Analytics Professional Certificate 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 Data Analyst Practice Test number 2 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.

In this post, we cover Excel Online’s main features.  Looking for excel shortcuts? See our Excel Shortcuts Page!  

 What’s Excel Online? 

Excel online or “Excel for the web”, is the web version of Microsoft Excel. With Excel-Online you can create and edit Workbooks by using your browser and share your workbook with other users. 

 How can I get Excel Online? 

 Go to http://OneDrive.live.com.

1. Sign Up With Your Email
2. Super cool Shortcut! after you have onedrive username – type excel.new into your browser! or…
3. Open One Drive and press the following buttons:
   1. New >>
   2. Excel workbook 

The shortcut way (or.. type excel.new into your browser:

Congrats! You can go ahead and use Excel online. 

Does Excel Online cost money? 

Excel Online is free. Want extra storage or more features?  See OneDrive Plans: As low as $5 user/month 

How can I share my workbook with others? 

Go to the excel file and press the “share” button in the upper right range of the window. 

Now, the following  view would open up: 

You can add your teammates’ email addresses or share the workbooks link with them by pressing copy.

You can enable editing preferences by checking and unchecking the edit button. Add expiration date and password if needed.

I have an Excel Online Workbook – Can I Open Excel online on your desktop? 

By pressing the Editing/Viewing button – you will see that the lowest option is “Open in Desktop App”; it can take a few minutes – but then you will be able to edit your Excel-Online version on your desktop. 

Don’t forget to :

1. Enable editing
2. Save before you close the workbook!

Excel Online Workbooks, Sheets and Cells:

Excel-Practice-Online.com is the best way to learn and test your knowledge in Excel. If you are completely new to Excel – we recommend starting with our Excel Basics Tutorial.

Work With Cells, Formulas and Functions

You can enter text, or alternatively, add a formula by starting with the equals sign (=) 

Work with Excel’s Most Popular Functions and Tools!

We’ve created the table below to share with you an overview of each of the most popular functions and tools! press on the Function’s name to learn and practice them online!

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 Online Cheat Sheet first appeared on Excel Practice Online.