New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 160th installment in their series of digital spreadsheet magic tricks, you'll learn how to find all the occurrences of a word, number, format or formula and then change or replace all of them! See how to use the Find and Replace feature in Excel with this free video tutorial.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.
Scanning is an awesome, fast way to transport a document into your computer. But, what if you want to edit it once you've scanned it? Most scanner programs will import your document as a read-only PDF or image file. With this tutorial, learn how to use the program ClaroRead on a Mac to scan your document directly into Microsoft Word for editing. This will save you a lot of time and a lot of annoying formatting and copy and pastes!
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
How To Make Anything demonstrates how to upload YouTube videos in high definition. To upload your video so the HD button becomes available to YouTube viewers, go into your video editor and set your project properties to 1280 x 720 which is the high definition resolution YouTube looks for to give you the HD option. Then, when you render your project, set your rendering parameters to a format like WMV and check to make sure that you're getting the HD image size upon output. Once your video is r...
In this video you will learn how to insert the current time and date in MS Word 2007. In order to do that, just follow these easy and quick steps and instructions. The first thing you need to do is to click the Insert tab. Now, you need to select a space where your date and time will be placed. The next step is to click the Date & Time button, and select the format that you want. Click the OK button, and you are done. If you followed the simple steps correctly, then you won't have any problem...
Go to DJTUTOR computer where you can download the latest firmware for free. Once downloaded you need to either burn it to a CD-R or use a USB key. Unzip the file and download it to a fat formatted USB key with nothing else on it. The firmware upgrade consists of two files. Eject any disks from the MEP and remove any USBs and make sure the unit is turned off. Next insert your USB key and push and hold USB 1 and USB 2 and turn on your unit. The MEP will then tell you when the firmware is comple...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
This is a tutorial video on uploading HD quality video onto YouTube. The video is simply a screen shot view of the YouTube home page. As the narrator goes through the steps the cursor moves and clicks on what you should click on. He advises to click on upload; he clicks to choose a video. The video must have a certain resolution to be assigned HD video. He indicates that YouTube will accept a variety of file formats to upload. You must use the 44.1 kHz frequency rates to get the best resoluti...
This video will show you how to create a flow chart in MS Word 2007. First click on the Insert tab. You can see the smart art option, click on it. A "Smart Art Graphic" window will appear.
This video will demonstrate the process to implement page numbers in your Microsoft Word 2007 documents. The video starts out by showing the Insert Tab on the Microsoft Word 2007 Ribbon. On the Insert Ribbon, you will see an icon titled Page Number. All of the Page Number options are available when you click the down arrow directly beside the icon. The are many different position options such top of page, bottom of page, page margins, or current position. The customization options are as endl...
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
This video describes the process for inserting a 3D animation into a video clip. The video starts by outlining several software programs you will need to complete this project. Don't worry, the presenter gives web addresses and titles for all of the programs needed. After all software is loaded, the presenter beings inserting key frames and x, y coordinates to make the 3D animation move along the correct path. Finally, after the animation path is complete, the video shows how to render the fo...
In this video tutorial by Task Tutorial we learn how to create a YouTube subscribe button using Adobe Illustrator. The first step to creating a button is to select the rectangle tool and draw a bar and then select a gradient fill. Next create the first color in the gradient and then the second color in the gradient. After that you'll want to change the gradient angle and also change the stroke width. Then you'll want to edit the stroke color to 9.6%. Then select the text tool and create your ...
Do you want to compress your video files less than five times the size while keeping the same quality? If yes, then this video shows you how. By compressing video files you can save a lot of space. Then, it can be easily burned to a DVD or even uploaded to a file-sharing website. To do the compression, you need to use Windows Movie Maker software. Open the video file in Windows Movie Maker. Now, move all the clips into the story board. Open the option "Save to computer". Now, Windows Movie Ma...
In this video the tutor shows how to make an ISO image file on a Mac. He shows what the requirements are to get started. He points to the disk utility program from where he points to the option where we can open a disk image from a folder. Now he selects the folder to which he wants to save the image. Now he guides us through the rest of the settings on how to prepare the image. Now we end up with an image file which is in the .cdr format. Now he shows some commands on the terminal through wh...
This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the ...
In this online video training tutorial, Task Training shows us, how to create a web button using Adobe Illustrator. The 1st step is to select the rectangular tool in Illustrator and set the size you want your button to be. The 2nd step is holding the shift key you can re-size your shape. The 3rd step is to give the button some color such as a gradient. The 4th step is to add a drop shadow to the button by going to Styles and then selecting Drop Shadow. The 5th step is add text to the button t...
Need a way to convert your scanned documents back into text files? Check out this video tutorial on how to convert scanned documents (JPG, PDF) to text.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to split video files with MKVToolnix on Ubuntu Linux.
Check out this interesting video to make photorealistic stencils for t-shirts, bags, and other accessories. This video documents how to make a Nikola Tesla shirt. With Adobe Photoshop, it is possible to simplify a found image into a graphic format perfect for stenciling. You can then print out the altered image into mylar or another water resistant paper. After carefully cutting out the stencil, place the mylar over an ironed t-shirt. Complete the stenciling process by dabbing paint into all ...
At first glance there doesn’t look like a way to save your slideshows into a format that you can send to some one. If you look a little further you’ll see you can indeed export them though. It exports the whole slideshow into a PDF Presentation (much like Photoshop’s PDF presentation automation). However, it won’t include any music tracks you’ve added in Lightroom. Well there’s a workaround if you’ve got Acrobat Professional. You can go in after the fact and embed the music to the presentatio...
Since the day of the Xbox 360 release, storage space for the device has been overpriced beyond belief. OEM 250GB HDD models still cost $110 USD! A 250GB hard drive should not destroy my wallet, Microsoft. Storage space, especially on HDDs, is cheap. You can buy a removable 2TB external for only $100 USD, so it's a little beyond my comprehension to see how they calculate their MSRP to yield such a large profit. On the other hand, Xbox 360 had very impressive hardware specs back in the day, equ...
Adobe sets the standard for graphic design. Since launching its subscription-based Creative Cloud in 2011, Adobe has consistently updated its suite of applications to serve the needs of the modern designer.
To be honest, the Mail app for iPhone had always been somewhat forgettable. It lacked many of the features that made third-party clients like Spark and Edison better, but with iOS 13, the gap between Mail and its competitors is much smaller. Apple updated the layout and added many new features to its native emailing app, and that may be just enough to get you to switch back.
After building a tech empire on revenues from search advertising, Google is not about to sit back and let Snapchat, Facebook, 8th Wall, and others draw all the AR marketing attention to their platforms.
One of the things that sets a seasoned hacker apart from the script kiddies is the ability to effectively sneak past antivirus defenses when executing an attack. One way to do this is to use custom shellcode in an exploit. Not everyone is an expert at writing shellcode, but luckily there's an easy way to do this that is both quick and effective.
As penetration testers, we sometimes need to securely store customer data for prolonged periods. Bruteforce-resistant, vault-like containers can be created with just a few commands to protect ourselves from physical attacks and unintended data disclosures.
Android users have had access to live wallpapers since the Eclair days, but some newer apps have made this feature even more useful. Now, you have the ability to use GIFs as your wallpaper, and through the marvels of modern technology, you can even set a video as your home screen and lock screen background.
Not all remakes of video game classics turn out well, but a new augmented reality take on Super Mario is likely to draw in fans of the Nintendo hit.
Just days after the launch of Google Poly, the marketplace for 3D virtual objects that developers can use for augmented and virtual reality apps, SketchFab, the current leader in the space, is firing back with a major enhancement to its platform.
If giving truly is better than receiving, then The Box AR should be the best ARKit app available when iOS 11 releases next week.
The Raspberry Pi loads an operating system from whatever SD card you insert, allowing you to keep different operating systems on separate SD cards depending on which OS you wish to run. A tool called BerryBoot cuts down on the number of SD cards needed by providing the ability to boot multiple operating systems from a single SD card, similar to Boot Camp for Mac computers.
Snapchat accidentally—and then intentionally—announced their digital eyeglasses, known as Spectacles, over the weekend. While we'd hoped their augmented reality-heavy platform would result in related hardware, Spectacles unfortunately seek to "reinvent" little more than a video camera.
In usual Apple fashion, there are new wallpapers to go along with their new operating systems, iOS 10 and macOS Sierra. The background that's included in iOS 10 for iPad, iPhone, and iPod touch is a crashing aqua-colored wave with land just below its surface, and macOS Sierra's is a razor-sharp mountain ridge from the Sierra Nevada mountain range in California.
Welcome back, my greenhorn hackers! In many cases when a computer, phone, or mobile device is seized for evidence, the system will have graphic images that might be used as evidence. Obviously, in some cases these graphic images may be the evidence such as in child pornography cases. In other situations, the graphic images may tell us something about where and when the suspect was somewhere specific.
If you use Google Keep, you'll be happy to know that you can add items to lists and even start new ones with "OK Google" voice commands on Android, and it works fairly well. (Hat tip to Reddit user rambantu for finding this trick.)
Technology can move really fast. Just consider the format for which we consume videos and movies, which has transformed from film reels to VHS to DVD to Blu-ray to steaming with nothing physical at all. But for some odd reason—maybe because it strikes a nostalgic chord or it's just the new hipster trend—VHS is in again. Yes, shaky, grainy, low-quality videos with timestamps are cool again, and I dig it.
Notes on iOS has never been a particularly great app due to a lack of overall features compared to other note-taking apps like Evernote or Microsoft OneNote.
