This is the first in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In this blog post, you’ll learn how to save time by making certain cells equal to others instead of copy-pasting separate cells/ranges.
This is our third and last tip in this blog series about Access layout. Today, I'll teach you how to create split forms. Let's use the wine example in the first Access layout tip: imagine you'd like to keep track of a customer's information and order history in an organised way. A tabbed form could help tremendously.
I’m back with another Access tip. This time, I’ll explain how to require information in a field in your forms. There’s a lot of information that can be collected within a company. Not all details are equally important, though, so you’ll want to make sure you do get the most important information. That’s where required fields come in handy.
Do you have some experience using Access, but feel like you could still use some tips to handle formatting? Read on for three tips that are sure to help you – and keep an eye on our blog in the next two weeks as well. The first tip is about conditional formatting.
While attending a presentation or meeting, it can be a good idea to take notes. If you have the PowerPoint file, you can just type your notes in the slides or in the text pane below. But you can also take notes in OneNote and link them to your slides.
‘No storage space left’ is one of the most annoying problems you could be confronted with. Of course, you could just dump everything in the cloud – but sometimes, it’s easy to have your files saved locally as well. OneDrive and OneDrive for Business have two features that can help you save storage space. Here’s how to use them.
There are probably some people in (or outside of) your company with whom you communicate more than with others, be it via Skype, e-mail or another channel. But if you need to look up their contact information every time you need them, communicating becomes a bit of a pain. Of course, you could just save them as favourites, but what if I told you there’s a faster way to contact your favourite recipients?
You visited a website ages ago, made an account and saved your password. Every time you visit this website, you get logged in automatically. That’s great, but if you need to sign in on another computer, cleared your browser’s settings or accidentally logged out, you’re left scratching your head: what’s your password again?
In the past, a new version of Microsoft Office was released every few years. Office 365 is different: it only has one version, which is updated regularly. Whenever a new Office version came out, we – as trainers – were curious to see the new functionalities Microsoft had integrated into the software. It made us wonder: “What will Microsoft come up with next time?” Well, they’ve still got plenty of inspiration!
Imagine this: you’re at home or on vacation and suddenly, you have an epiphany about a project at work. Of course, you’d want to write it down ASAP so that you don’t forget it. But did you know you can also enter your idea directly into the work document? If your document is saved to OneDrive, you can access it anywhere – even on your smartphone...