5miles 5miles in 2021: What We Achieved This Year In starting a new tradition, I thought it would be nice to highlight some of the milestones and successes at 5miles in 2021. It is great to be able to share that 2021
Office skills An inspiring, convincing PowerPoint presentation: yes, it’s possible Learn from the bestWhen was the last time you gave a PowerPoint presentation that both inspired and convinced your audience? In our ever-changing, complex work environment, it isn’t always easy to define
5miles Why the professional in you wants to start online learning Your online learning journey In your professional career, there are some basic skills that will help your workday to be as productive and efficient as possible. They also make you a valuable employee
Data Analyses and dashboarding XLOOKUP in Excel: An improved VLOOKUP We can hook you up...with a better way to look for specific values in Excel: Xlookup!
Online learning Lifelong online 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.
Online learning The power of bite-sized online learning exercises 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!
Online learning Online 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.
Presentation and communication skills Create stunning PowerPoint slides: The 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.
Office skills How to start a meeting in Microsoft teams using Meet Now Learn about the different ways you can start an instant meeting in Microsoft Teams.
Office skills How to set up relationships in your Power BI dashboard Explore the interactions between visuals in your Power BI dashboard by establishing (in)active relationships between data points.
Office skills Manage your Excel spreadsheet: Quickly swap contents Discover how you can more efficiently swap the contents of one cell range with another in Excel.
Office skills Outlook Quick Parts: Save and reuse content in your mail Dive into Outlook's Quick Parts feature to learn how to save reusable content for more concise and efficient e-mailing.
Office skills How to use ActiveX controls in Excel using 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.
Office skills Create visually attractive PowerPoint slides with SmartArt 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.
Office skills VBA macros for Excel: How to improve structure and speed Navigate ways you can improve the structure and speed of your VBA macros.
Office skills Manage your Outlook inbox: Create rules and alerts Construct efficient rules using Outlook's Rules and Alerts option and automate the organization process of incoming e-mails.
Office skills Name Box: Keep your spreadsheet in Excel structured and clear 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.
Office skills Conditional formatting in Power BI: Turn 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.
Office skills How to change 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.
Office skills Ask Power BI to make a visual using the Q&A function Ask your Power BI data direct questions through the Q&A feature and see the answer to your questions revealed in a stunning visual.
Office skills How to improve VBA macros in Excel: Use Range instead of Select 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).
Office skills Design your PowerPoint slides faster with format painter Create a shape, apply the perfect format, repeat. PowerPoints Format Painter can speed up your slide design process with just three clicks.
Office skills How to use digital sticky notes in Microsoft Outlook Go paperless, but not noteless. Using Outlook's digital sticky notes can help you make note of important details without interrupting your workflow.
Office skills 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.
Office skills 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.
