During the period 23/12 to 6/1, we will have slightly longer response times than usual. Merry Christmas and a Happy New Year! 🎄✨

Articles - All you need to know about Excel
Tips, guides & news

Cleaning data part 3 of 3 – Find and Replace as well as the Text to Column function

To determine numeric values, marking cells for sums in the status bar is a simple approach. Customizing the status bar reveals numeric counts, aiding recognition. Certain formats, like American-style amounts, pose reformatting challenges. Visual examples showcase misleading numerical appearances due to text formatting. Handling dollar signs, commas, and decimals demands careful editing. Handling spaces after thousands involves replacing with nothing, followed by punctuation conversion. 'Text to column' aids segregating data for analysis. Delimited fields or fixed width options accommodate diverse cases. These methods empower efficient manipulation of complex numeric-text combinations.

Upload your course certificate on LinkedIn.

Read the article to learn how to share your course certificate on LinkedIn.

Certificates
Excel online
Linkedin

Cleaning data part 2 of 3 – Having numbers formated as text?

In this article, we'll be delving further into data cleansing and tackling the issue of handling numerical values presented in text format. It's not uncommon to come across numbers in text format, especially when dealing with exported data from sources like accounting systems or external data feeds. Such data might have numbers formatted as text or contain spaces between numerical values. In this session, we'll specifically focus on addressing the former scenario.

How to Clean Data in Excel and 4 examples of Absolute and Relative Cell Reference

Data cleaning – not the most exciting task, but it's essential to make use of the raw data we've gathered for our analysis or reports. In this and the upcoming posts, we'll explore this topic, and you'll discover that it doesn't have to be overly complicated or time-consuming if you're familiar with some helpful tricks.

We welcome Nora to Learnesy!

Learn more about our newest team member Nora in this article. Nora is Norwegian speaking, but has very good understanding of Swedish and talks English fluently. She will be a great asset this summer, and will mainly focus on the Norwegian courses. Throughout her studies, she has used Excel to solve data related problems, and know the tool well. We wish her welcome onboard!

Updates in Excel Essentials, Bas & Basis

Updates in Excel Essentials, Bas & Basis. Several new lessons have been added on functions, such as FILTER and logical functions. There is now a greater emphasis on functions in general, as well as data management and efficient work in Excel.

FIFO Calculation in Excel

The FIFO principle is an important principle in logistics, finance, and accounting. It stands for 'first in, first out', meaning that assets purchased first should also be sold first. It is applied to ensure older goods are used or sold first, reducing the risk of selling expired or obsolete items. In economic contexts, it is commonly used for assets like stocks, bonds, or currencies. Excel can be used to create a dynamic FIFO model for calculating costs, profits, and inventory values.

4 ways to use Correlation in Excel for a Business Controller

Discover the hidden connections within your data using Excel's correlation analysis. Gain valuable insights and make informed decisions with ease.

Run simulations using Excel

In this article, we are going to have a look at how we can make simple simulations in Excel using the Monte Carlo simulation method, which uses random sampling to simulate different scenarios.

Unlocking Excel: A Guide to Lookup and Reference Functions

Excel's lookup and reference functions, including VLOOKUP, HLOOKUP, INDEX, MATCH, CELL, INDIRECT, and OFFSET, are powerful tools for searching, retrieving, and manipulating data. Mastering these functions can greatly enhance your Excel skills and improve productivity in data management tasks.

Text Functions in Excel: Powerful Tools for Efficient Text Manipulation

While Excel is often associated with numbers and calculations, it also provides robust tools for working with text data. In this article you'll learn more about some of these tools.

8 visualizations for your dashboard in Excel, part 1

In this article you will find tips and visualizations for your next dashboard in Excel.