Read the article to learn how to share your course certificate on LinkedIn.
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.
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.
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. 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.
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.
Discover the hidden connections within your data using Excel's correlation analysis. Gain valuable insights and make informed decisions with ease.
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.
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.
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.
In this article you will find tips and visualizations for your next dashboard in Excel.