How to use Excel VLOOKUP : Learn with Examples

 How to     5 months ago     TILS Education     0     556
Image

VLOOKUP (V stands for ‘Vertical’) is an in-built function in excel for looking up a piece of information in a table or data set and extracting some corresponding data/information.

Read More

How To Create Folders Quickly Based On Cell Values In Excel?

 How to     April 14, 2021     BlogzBite Team     2     4.77K
Image

Sometimes we need to create many folders and we create them one by one but it takes long time. Supposing you have a list of various courses in a range of a worksheet, and now you want to create some folders for each of them in the cells to record their information. If you create the folders one by one, it will waste a lot of time. But how could you quickly create these folders? Today, I will introduce you some quick tricks.

Read More

How to insert Audio in PowerPoint 365 for Windows

 How to     March 21, 2021     BlogzBite Team     2     693
Image

Adding different forms of media to a PowerPoint presentation (PPT) can make it more engaging for your followership, as well as appealing to different types of learning. Although there may be any number of reasons, from adding a voice-over to just add some background music. PowerPoint can add audio clips of different types of files. MP3, WMA, or WAV extension files are the common types that you can fit in PowerPoint slides (PPT). These audios automatically embed into PPT File. Indeed also, it's a good practice to place your audio in the same computer folder or Path in which you save your PPT indeed before you insert them.

Read More