Excel Xlookup in Excel We can hook you up...with a better way to look for specific values in Excel: Xlookup!
E-learning Lifelong learning with the right mindset I’m sure we can all agree that learning & development is becoming increasingly important. This vision is once again confirmed by prof. dr. Nick van Dam who puts effort into sustainable employment and lifelong learning, and stresses that people make the difference.
E-learning Improve learning in small chunks Do you remember, around 30 years ago, when you needed to learn the telephone numbers of your friends and parents by heart? You probably did so by cutting this into small groups of two to three numbers. This is a method that wasn’t only relevant back then, but still is!
E-learning Learning & Development trends in 2021 In 2020, a clear growth was seen in online trainings and in learning interventions focused on mental and physical health. Will this continue in 2021? Check out an overview of the predicted 2021 trends in this post.
Excel Online Microsoft Excel training Looking for an online microsoft Excel training? 5miles offers trainings in Excel through engaging 5 minute bite-sized learning. A Microsoft Excel course for beginners to advanced learnersAre you ready to learn all about
PowerPoint PowerPoint's broken mirror effect Uncover the broken mirror effect in PowerPoint. Learn how to create a unique visual effect that projects a single image across multiple shapes in a slide.
Microsoft Teams Instant meetings in Microsoft Teams Learn about the different ways you can start an instant meeting in Microsoft Teams.
Power BI Relationships in Power BI Explore the interactions between visuals in your Power BI dashboard by establishing (in)active relationships between data points.
Excel Quickly swap contents in Excel Discover how you can more efficiently swap the contents of one cell range with another in Excel.
Outlook Saved and reuse content in Outlook Dive into Outlook's Quick Parts feature to learn how to save reusable content for more concise and efficient e-mailing.
VBA ActiveX controls for VBA Check out the use of ActiveX Controls for your VBA model and see how you can link macros to ActiveX Control buttons to improve the overall appearance of your model.
PowerPoint Convert to SmartArt in PowerPoint Learn how to use SmartArt to construct dynamic PowerPoint slides by changing the bullet point list into a proper infographic that engages your audience's attention.
VBA Improve VBA macro structure and speed Navigate ways you can improve the structure and speed of your VBA macros.
Outlook Create rules and alerts in Outlook Construct efficient rules using Outlook's Rules and Alerts option and automate the organization process of incoming e-mails.
Excel Navigate Excel using the Name Box Would a rose, by any other name, smell as sweet? Learn how you can use Excel's Name box to more effectively work in your workbook and spreadsheets.
Power BI Turn Power BI icons On/Off In the eye of the beholder: Power BI visuals can be improved through the use of icons. Check out how you can turn your Power BI icons On/Off and adjust the conditional formatting to create more impressive and visually appealing icons.
Microsoft Teams Your Microsoft Teams Status Hi, how are you? Hey, what's up? Hello??? Adjusting your status in Microsoft Teams can improve your communication with your colleagues. Learn how to adjust your Microsoft Teams status.
Power BI Ask Power BI to make a visual Ask your Power BI data direct questions through the Q&A feature and see the answer to your questions revealed in a stunning visual.
5miles Remove unnecessary Selects in VBA Don't litter your VBA code with Select, know when to remove it. By simplifying your VBA code, you can see an increase in their performance (runtime).
5miles Format Painter in PowerPoint Create a shape, apply the perfect format, repeat. PowerPoints Format Painter can speed up your slide design process with just three clicks.
5miles Outlook’s digital sticky notes Go paperless, but not noteless. Using Outlook's digital sticky notes can help you make note of important details without interrupting your workflow.
5miles Countif function with comparison operators in Excel Discover Excel's Countif feature and the other comparison operators you can use to better analyse your data.
5miles Where's the mute button?! Don't be the one who distracts everyone from a Microsoft Teams' meeting with strange background noises. Instead, learn the precise actions to adjust your microphone and the keyboard shortcuts that can speed up the process.
E-learning Beat the (forgetting) curve Did you know that the two recent movies that most accurately depict Amnesia are 1) Memento (2001) and 2) Finding Nemo (2003)? Most movies depict retrograde amnesia (losing the ability to recollect past
E-learning Good things come to those who are active learners ‘It’s not me, it’s you.’ Whoops. That doesn’t sound nice, but it might be true. Think about the last time you were at a training or workshop. How much of
