How to Make Notes in the Sidebar of PDF Pages in OneNote?

Many books and documents we deal with today come in PDF format. Reading PDF files is pretty easy, but sometimes we want to make notes while reading. You can easily make notes directly in PDF with any of the readers. We have already explained how to do it in Adobe Reader. But, that would require making direct edits in the document itself. There is another way to do it, and it involves using OneNote. This program allows you to make notes right next to each page of your PDF document.

Here is how you can do it. Assuming that you already have OneNote installed, open your PDF, go to the Print option and choose Print to OneNote.

print to onenote

The document will be transferred to OneNote, and you’ll be able to choose which notebook section to transfer it to. Note that it might take a while for large documents. Once transferred, each page in the document will appear as a separate page in the chosen section.

note taking in pdf onenote

You can choose any page you want, and there will be an empty space in the sidebar where you’ll be able to make notes, as you see in the image.

After you’ve finished with your note taking, you can convert the whole document back to PDF along with your notes by going to File – Export – Section – and choosing the PDF format.

Export secton notebook to PDF

How to Comment/Uncomment Multiple Lines of VBA Code in Excel at Once?

Writing VBA code in Excel has many challenges. Sometimes we test and experiment with large blocks of code. In such cases it would be useful to have an option to comment or uncomment multiple lines at once. Otherwise, if we do it line by line, we can waste a lot of time.

This tip can actually save you a lot of time and energy. All you have to do is to select all lines of code you want to comment or uncomment.

To make this option visible go to View – Toolbars – and tick the Edit option.

edit toolbar

A new set of options will appear in the toolbar.

comment vba code
Among them you will find the Comment/Uncomment buttons, as you can see in the image.

This option can save you from hassle and wasting a lot of time when writing and experimenting with code, and many developers have overlooked it. It is always much easier to work with blocks of code, than having to comment or uncomment a single line by line.

Best Websites with Microsoft Word Templates

Microsoft Word is one of the most widely used textual editors for creating different types of documents, such as press releases, letters, books, resumes, reports and more. Many people use Word on a daily basis for work. Once they start working on a document, beside content, they also have to worry about its design and visual appearance, especially if the document needs to be forwarded to somebody. A nicely structured report, memo or CV will always make a better impression on a boss or colleague than a poorly structured one.

If you are not particularly skilled at designing the reports yourself, you can always use premade Word templates, which can save you time and help you create a professionally looking document in a second. The additional benefit of using templates is that you don’t have to start from scratch, because they provide basic elements you can work with.

Here are some websites that contain excellent templates for various purposes, from budget, educational and project to CV templates. There is a little bit of something for everybody, regardless of what type of documents you usually work with.

1) Microsoft Office 

search for online templates

The Microsoft Office website is probably the first place you should visit. In many cases you will immediately find what you need, because the choice is pretty wide. MS Word templates are divided into more than 30 categories ranging from Agendas, Invoices, Minutes and Photo Albums, through Timelines, Calendars, Maps and Menus, to Posters and Flyers. You can search for new templates right inside the Microsoft Word 2013 interface, as you can see from the image.

2) Hloom Templates

free microsoft office templates

Hloom is another site with a lot of free templates for Word. They are divided into categories and subcategories. All of these templates look pretty modern. We especially recommend the Resume and Flyers section.

3) Vertex Templates

word templates vertex

The Vertex website has a couple of completely free and pretty useful templates. All of them are mostly oriented towards business use and career improvement.

4) Powered Template

This website doesn’t have a big choice of free Word templates, but some templates are pretty interesting and it’s worth checking them out.

word

How to Record a Macro in Excel – a Step-by-Step Guide

Macros in Excel present automated steps that we can repeat whenever we want. They are often used for performing repetitive tasks, which significantly saves time, and also when learning VBA.
Here are some tips on how to start working with Excel macros. It might look hard at the beginning, but with more practice, you will be amazed with all the possibilities.

1) Enable the Developer tab

The Developer tab, from which all the developer and VBA functionalities are offered, is hidden by default. Here is how you can make it visible.
First go to File – Options.

excel options tab 2013
Choose the Customize Ribbon tab and check the Developer option in the main ribbon.

customize the ribbon in excel 2013
Now, the new Developer tab will appear in the main menu.

the developer tab in microsoft excel

2) Record a macro

In the new Developer tab there is a button Record a macro that starts the recording. Turn on the button and start recording.

record a macro

3) Use relative references

If you regularly use Excel, you are probably familiar with relative references that are often used in Excel. Macros can be better implemented in the future using relative references. So, in this case we suggest starting from the field A1 and turning the relative reference field on while recording.
Next time you want to repeat the macro steps, you don’t have to worry if you entered a value in the cell A1 or cell B2; the macro will perform all other steps relative to the first field.

relative references when recording macro

4) Name and description

It is of utmost importance to enter a good and detailed description of what a macro does, along with an appropriate name, because once the number of macros pile up, you won’t be sure which macro is for what. Prevent this by entering macro descriptions in great detail.
Also, if you plan to reuse it for other documents, make sure that the macro is saved in your personal space.

macro name and description

5) Edit a macro

how to edit an existing macro
Sometimes a macro needs to be edited after recording. This is easily done by going to the Macros section, choosing the relevant section and clicking on Edit. The Step into field is useful as well, because it allows you to see all the steps in the VBA code and analyze them if you need.
If you receive an error that a workbook is hidden, go to View – Unhide and choose the Personal macro workbook.

unhide excel macro edit

Now you will be able to edit or delete existing macros.

6) Run a macro

run a macro
To run a macro, all you need to do is to choose it from the list and click Run. Have in mind that whenever you record a macro, before closing the Excel completely, you need to save all changes made to the Personal workbook. This way all macros will be saved and available for later use.
There are other ways to run a macro, like using buttons or other features, but we will talk about it in our future articles.

How To Make Use of Podcasting

podcast

Podcasting has become the new trend of public informing and its popularity is growing each day. Something like the radio broadcasting of the future, nowadays you can follow your favorite podcast show directly from your mobile phone or your tablet. What is great is that you don’t actually have to follow the program live instead you can add the list of your favorite stations on your device and keep track of the last episodes or download them and listen offline.

 

This podcast fever doesn’t come as a surprise since one of the consequences of contemporary living is relying on digital media to an extent. What makes podcast exceptional is the fact that it is a digital medium that reaches and engages the audience via listening. That means, even if you are busy doing something else, you can still play your show and multitask like many of us are used to. Not only that, it is also scientifically proved that listening someone’s voice and absorbing information in this way improves learning and enables better memorising.

 

So, if you are looking for a free and easy way to pick up a new skill or broaden your knowledge, you will be happy to hear that podcasts are not all about fun and light-hearted content. There are also plenty of stations that offer useful, extensive information on pretty much everything that comes to your mind. Here is a quick overview on what you can learn:

 

History Lesson

 

Whether you were skipping history classes at school or you’re conducting a professional research, there are many great podcasts where you can find anything from answers to trivia quiz questions to an in-depth look into historical facts, literature critiques etc.

broadcasting

 

 

Learning a Foreign Language

 

You’ve always wanted to take up a new language but you never seem to have enough time? It is understandable, since language learning courses can be rather time consuming and also cost serious money. With podcasts, you can have fun on your way to work and listen the host portraying real life situations in both your native and target language, completely free of charge.

hearing

 

 

Technology and Professional Development

 

Learn how to overcome the fear of speaking in public, become proficient in Excel, try adding web design to your list of expertise or even take online piano lessons- all of this is possible once you start skimming through this comprehensive database of audio and video manuals.

technology development

 

Nutrition and Health

 

One doesn’t have to be a fitness buff to know how important physical health is. Sure, nowadays the idea of a perfect body is more emphasized than ever and although going extreme is never good, some little tricks like “shape your legs” exercises or “learn how to prepare a healthy, fat-free meal” are always welcomed, especially during summer season. Instead of paying a visit to a gym or nutritionist, visit your podcast application and subscribe to a channel that best fits your body sculpting needs.

 

Cooking

 

Back in the days, cooking used to be reserved for housewives and professional chefs only,  whilst now represents a trending virtue and a must have skill of modern men and women. Keep track of your latest cooking podcast episodes and learn how to prepare a gourmet meal, get familiar with international cuisines and ingredients, and peek into master chef recipes from around the globe.

 

This was just a close-up on all you can learn by listening a podcast. For those of you who want to find out more about it and see how it works, we suggest downloading Podcast app from the App Store (iOS users) or Stitcher app from Google Play (Android).

 

 

 

application, channel, cooking, development, e-learning, fitness, history, language, listening, mobile, online, podcast, radio, streaming, technology