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 Excel tutorial from ExcelIsFun, the 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditionally formatting duplicate values:
This video demonstrates how easy it is to take a screenshot with shortcuts in Mac OS X. Pressing Command-Shift-3 will take a screenshot of the entire screen, while Command-Shift-4 will let you take a screenshot of just a selected area of the screen instead. For the latter, once you use the shortcut, your mouse pointer will turn into crosshairs, and you would click on one point of the screen, then drag and release your mouse to take a capture of the selected area.
When you export an image from the Photos app in macOS, you may not be getting the whole deal. In the export menu, you need to select either JPEG, TIFF, or PNG, and if you don't make any adjustments to the quality settings, it'll likely be compressed. If you need the original full-resolution file or want to get the video that's attached to a Live Photo, there's a simple way to do it.
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.
Most diehard Mac users have used TinkerTool at some time or another, and if you haven't, it's time to start. Whether it's to change your system's font or to disable UI animations, it seems like anything you could ever think about tweaking in Mac OS X is doable through TinkerTool. And now, developer Marcel Bresink has updated his app to work with Yosemite, so let's see what it can do now.
How to format a USB thumb drive to NTFS in Windows XP Go to my computer, click to the USB flash drive properties, in that click on Hardware, click on SanDisk Cruzer USB device, and then to its properties, then click to policies, in that click on the optimize for performance button, click ok. Again click ok on the properties icon.
iTunes lets you use a variety of file formats for ripping CDs or converting music. Learn about each one: AIFF, WAV, MP3, AAC and Apple Lossless. Decide which format might work best for your music collection with this video guide from the folks at MacMost. For more information, and to get started mastering iTunes myriad file formats yourself, watch this video guide.
This clip demonstrates how to load an image into the Blender VSE and convert its format, both in size and in format (JPG->PNG) and space savings comparison. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!
Learn how to format a SD memory card using a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to format a memory card when it's in a G1 or GH1 camera. For more information, including detailed instructions, watch this digital camera user's guide.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this video, learn how to export reports to Word, PDF, Excel, and/or TXT formats. Learn step-by-step how to export your reports to any program or format in just a few easy steps.
In this video, learn how to convert audio file formats using iTunes. Changing file formats will come in handy if using two media players, or using audio software programs such as Final Cut Pro. Changing an audio files type is very easy in iTunes and made even easier with the help of this video!
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.
In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...
Watch this video to learn how to format your computer properly. It's not as hard as you think. All you need is your startup CD. This video will work for Windows XP. Just follow the simple steps, and you'll be well on your well to a properly formatted computer that runs smoothly. For more videos on computers, search WonderHowTo for computers.
If you work with the Adobe Air Collada format a lot, and have certain formats you want to bring into Collada and into Papervision through that Collada file format, you'll need to compare Collada files and graphics, which requires that you createa viewer. This video tutorial offers instructions on doing just that. For more information, and to get started making your own Collada Papervision3D viewer in Flex 3, take a look!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
In this Adobe Photoshop tutorial the instructor shows how to prepare pan and scan images. To prepare an image by panning and scanning is quite different than preparing an image normally for using in your video. These images should be extra sized as you would perform special effects on the image in your video. This is also called as "Ken Burns" effect. Now go to the file, new menu and select the video format that you want to use according to your requirement. Enable the correct pixel aspect ra...
You take a photo or video, send it to a friend, and they say, "Hey, I can't open this." More often than not, your friend won't be using an iPhone, iPad, iPod touch, or Mac. Instead, they're likely trying to open the file with a non-Apple device. But this problem can be avoided if you know what setting to change.
Although more and more smartphones are introducing portrait modes with their cameras, there are still plenty of devices out there — especially devices older than one or two years — that do not. While your particular smartphone might not offer you that bokeh effect, Instagram can, as it gives all smartphones software-based portrait modes.
If you have an iOS device, chances are you've spent a decent amount of time in the App Store—without at least a few apps, smartphones are pretty boring. There's an app to do just about anything you could ask for, but the problem is finding them. Searching the App Store sucks.
Sometimes it's necessary to format your memory card in your mobile phone or digital camera, just like you need to format a hard drive, because of virus problems or slower speeds. This video will show you the steps to formatting (or reformatting) the SD memory card for a cell phone, using a memory card reader. You'll also get details about a write protect error that could happen.
If you use Microsoft Word quite a bit and have never used the Format Painter tool, it's a technique you need to learn, and learn today, because it's a technique that will save you a lot of time and a lot of grief in the future. To learn how to use the Format Tool in Microsoft Office Word documents to streamline the formatting process, watch this how-to.
This video tutorial is in the Computers & Programming category which will show you how to install Windows XP from a USB flash disk drive. First download USB multiboot from 911cd. Insert the XP disk and plug in the USB flash disk into your PC. Format the USB flash disk. For this click on "RMPrepUSB" and the HP format tool should pop up. Do a quick format to USB drive with ntfs file system. Close HP format tool and click go. Now you have a Windows XP bootable USB flash disk drive.
If you want to convert video files to DVD format using DVD flick you first want to go to www.dvdflick.net. Go here and download the program DVD flick. You will also want a program that allows your to burn DVDs. You should first open up DVD flick. So, go to open and choose the files you want and drag them onto the screen. They should then appear on DVD flick and they will be compressed. You should try to keep the files you add under 3 hours of video. This will keep the quality good. Now you sh...
This video tutorial from bobby93macboy shows how to install Mac OS Leopard operating system and make it bootable.
Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
Being organized and using good formatting in your CSS files can save you lots of time and frustration during your development process and especially during troubleshooting. The multi-line format makes it easy to browse attributes but makes your file vertically very long. The single-line format keeps your file vertically short which is nice for browsing selectors, but it's harder to browse attributes. You can also choose how you want to group your CSS website statements. Do you do it by sectio...
There are plenty of third-party apps for scanning documents on your iPhone, but they can all be tossed out the door since iOS 11 includes one by default now. Instead of a dedicated app, it's included as part of the Notes app, and it's fairly easy to use. After scanning, you can save it, print it, turn it into a PDF, add markup, and more.
We live in a computer world full of file formats. Whether we are talking about images, videos, or text documents, there are dozens of file types for each, and there are new ones added every year to applications. Keeping in mind that many of these formats were created before the internet was widely available (at least, in infant form), the primary reason for this glut of often complex choices is competition.
In this tutorial, we learn how to use the Terminal to change the default file format of screengrabs taken on an Apple computer running the Mac OS X operating system. It's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
This tutorial will work on any Apple device running iOS 4. Besides finding books through the Apple store, you can also find unlocked epub-format books (such as through Google Books or the Gutenberg Project) and use the iBooks application to read them on your iPad, iPod Touch or iPhone. Even customize your covers!
Research papers, love them, hate them, either way, the standard for writing them are a pain in the butt if you haven't done it a lot, or at all, before. The standard is MLA style, and if you have no idea what this is or how to set up the settings in Microsoft Word, this video has everything you're looking for. You will learn how to set up the page for MLA style, add in works cited properly, page titles, and more.
Looking for a quick guide on how to apply formatting to your Windows 7 Stickies? It's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
If you use iBooks on your iPad or iPhone, you can only read books in EPUB format. If you have books in text or PDF format you may want to convert them to EPUB so you can read them in iBooks. You can do this with Calibre, a free open-source e-book library application. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about five minutes. For more information, including detailed, step-by-step instructions, watch this Apple lov...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selectively delete. Specifically, you'll se how to delete the cell contents only, formatting only, the entire cell, or formatting and content together.
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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.
