Free lesson package
Willekeurige letters aanmaken met Excel voor beginners
Misschien hebt u zich al afgevraagd, hoe u op een snelle manier letter en cijfers kunt genereren.
Voor bijvoorbeeld een productreferentie of misschien gewoon, net zoals ik het gebruik bepaalde voorbeeld documenten snel te kunnen aanmaken.
Tekst splitsen met functies Excel voor beginners
In deze video gaan we bekijken hoe we tekst kunnen splitsen met behulp van verschillende functies.
Excel info functie voor beginners
De Excel info functie is minder bekend bij de doorsnee Excel gebruikers.
In deze video gaan we alle mogelijkheden stap voor stap duidelijkheid overlopen.
Excel gegevens overbrengen naar Word voor beginners
In deze videoreeks laat ik je zien hoe je met VBA (Virtual Basic application) Excel gegevens met een grafiek kunt overdragen naar words en op verschillende manieren de nodige aanpassingen kan doen.
Hoe de Excel Som Functie dynamisch Maken?
De som functie is waarschijnlijk één van de meest gebruikte functies. Toch gebruiken veel gebruikers de standaard mogelijkheden van deze functie.
Maar wat als je deze waarde dynamisch zou kunnen maken, waardoor je niet onmiddellijk moet nadenken over je celbereik ?
Excel together with barcode scanner
​ Have you ever wondered whether it would be possible to start using barcode scanner in Excel?
Excel VBA for Beginners
Interested in speeding up Excel and automating time-consuming tasks? Learn the basics of coding Excel spreadsheets with this short video series.
How to use the Random and vertical search function together in Excel?
If you regularly have to make a certain presentation or possibly some kind of simulation, you can do all this manually.
However, Excel has a handy function that calls random.
Vertical search & compare function
The vertical search function and the compare function have already been discussed separately.
In this video we are going to combine these 2 functions.
How can you combine the comparison function and the shift function?
Combining these functions will ensure that you will quickly find a value in a large data list.
And this by using multiple selection criteria.
How to create dynamic main menu in Excel?
Maybe you didn't know it yet, but you can combine text and functions in 1 cell.
This technique is used a little less, but it can sometimes be very useful for certain applications.
How to create frames and lines in excel?
By small details you can make a worksheet or excel project even clearer, by a simple frame or a color indication. This also gives the user a better overview or draws attention to specific data.
Excel as Error Function
While creating certain formulas or functions, it may happen that the correct input is not always entered or the result is incorrect. At such a moment the user will receive an error message or the #n/a message.
How can you solve this?
How to remove duplicate values in an Excel tab
If you have a long list of data and you want to reuse it in another application.
It's handy that you can just copy the list, but what if it contains many of the same value?
Then it is handy that you can quickly remove the duplicate value.
How to define a name in Excel and why??
Naming a cell, range, formula or function is still unknown to many people.
Yet this offers many advantages and creates a clear overview.
Discogs Part 2 Format Text to Columns (Excel's Quick Tool)
In this video we are going to see how to divide text into different columns in a very fast way.
And what are the pros and cons of this method.
How to Export a Discogs Collection to Excel File
In this video I will mainly explain how to export your collection on the Discogs website.
In the further series, you will also learn how to use it further in Excel or what the possibilities can be.
It's mainly about how to export the collection on your Discogs account and what the first standard steps are to achieve this.
Excel vertical search function
This is a feature that many people don't understand or have a hard time with.
Excel number arg function
How can you find out how many filled cells there are in a range?
You can do this with the number arg function.
In this video we are going to look at this briefly with 2 examples.
Excel Shift Function vs Chart
The Excel Shift function is a great formula with unique capabilities. Yet this one gets little attention from Excel users and is overshadowed by its more glamorous cousins: the search functions.
Why is this?
The purpose of this video is to explore further possibilities and shed light on the capabilities of the feature.
Maybe it can inspire you to use it in your work.
Excel Shift Function
The Excel shift function is a great Excel formula with unique capabilities.
Still, the Excel shift function gets little attention from Excel users and is overshadowed by its more glamorous cousins: the search functions. Why is this?
Excel Compare Function
The Compare function is one of the useful Excel Functions that you should know.
Once you can implement these formulas, you can perform intensive tasks with your data.
The compare function locates a piece of data in a column or row.
Excel Dynamic Selection List (dropdown menu)
In this video we discuss how you can create a custom dropdown menu in a very simple way.
Excel Selection List
Want to create drop down list or selection list in Excel? You really should! Selection lists save time and make spreadsheets look cool. This video shows you how to create a basic or 'static' drop-down menu.
Transfer Excel data to labels in a Word file
In this video I explain how you can easily import and print a mailing list to Word.
Change a numeric date to weekday name in Excel
If you enter a date in Excel, it will be displayed as a numeric format.
But what if you want a simple way to display the day name in another cell?
In the file we use in the video, we are going to enter a date and display the weekday name below this cell.