Software / Web Services Archives - Page 2 of 124 - LAPTOP Magazine: The Pulse of Mobile Technology

How to Create a Pivot Table Based on Multiple Tables in Excel 2013

August 29th, 2013 by David Eitelbach, Laptopmag.com Contributor

how to create pivottable lead 675403

Up until recently, if you had data spread across several tables in Microsoft Excel that you wanted to consolidate in a single pivot table, you would have faced a headache-inducing process of manual formatting and data preparation. The most recent version of the software, Excel 2013, fixes this problem by allowing you to create a pivot table from multiple tables automatically — no manual formatting required. Just follow these steps to get started.

1. Click “Insert” at the top of the screen.

how to create pivottable 1 click insert 675403

2. Click the “PivotTable” button on the Ribbon.

how to create pivottable 2 click pivottable 675403

3. Select the first table you want to add to the pivot table.

how to create pivottable 3 select table 675403

4. Check the box labeled “Add this data to the Data Model” and press OK.

how to create pivottable 4 check add 675403

5. Click “All” in the PivotTable Fields window to view all of the tables. Excel automatically detects multiple tables, so you won’t need to repeat these steps for each additional table.

how to create pivottable 5 click all 675403

6. Check the boxes of the cells you wish to include in the pivot table.

how to create pivottable 6 check boxes 675403

Tags: Microsoft Excel 2013, Microsoft Excel, Microsoft Office 2013, Microsoft Office | 2 Comments »

How to Add Conditional Formatting in Excel 2013

August 28th, 2013 by David Eitelbach, Laptopmag.com Contributor

how to conditional formatting lead 675403

Microsoft Excel 2013 introduces a new feature that lets you differentiate data at a glance: Conditional formatting. This handy tool will apply colors to a cell’s font and background depending on the conditions you’ve set — if you want to highlight any cell that features a specific name or date, for instance, or differentiate high, medium and low numerical values. Follow these directions to set up your own conditional formatting in a few simple steps.

1. Select the cells you want to format.

how to conditional formatting 1 select cells 675403

2. Click “Conditional Formatting” on the Ribbon.

how to conditional formatting 2 click conditional formatting 675403

3. Hover over “Highlight Cells Rules” in the drop-down menu.

how to conditional formatting 3 click highlight 675403

4. Click on “Text that Contains” in the drop-down menu.

how to conditional formatting 4 text that contains 675403

5. Select the text you want formatted in the “Text that Contains” popup window.

how to conditional formatting 5 select text 675403

6. Choose the format in the “Text that Contains” popup window.

how to conditional formatting 6 select format 675403

Tags: Microsoft Excel 2013, Microsoft Excel, Microsoft Office 2013, Microsoft Office 365 | No Comments »

How to Add Online Video to a Document in Word 2013

August 28th, 2013 by David Eitelbach, Laptopmag.com Contributor

how to embed video lead 675403

A picture may be worth a thousand words, but sometimes a still image just doesn’t cut it. If you’ve wanted to add movies to your Word documents, you’re in luck — Microsoft Word 2013 now lets you embed online videos in your documents with a minimum of hassle. Just follow these steps to start adding videos to your documents.

1. Click “Insert” at the top of the screen.

how to embed video 1 click insert 675403

2. Click “Online Video” on the Ribbon.

how to embed video 2 click online video 675403

3. Click “YouTube” at the bottom of the popup window to add YouTube as a source. Other sources may also appear there.

how to embed video 3 click youtube 675403

4. Search for a video using the search bar.

how to embed video 4 search video 675403

5. Click “Insert” once you’ve selected a video from the search results.

how to embed video 5 select video 675403

6. Click the “Layout Options” Button at the top right corner of the embedded video to modify the video’s placement within the text.

how to embed video 6 layout options 675403

Tags: Microsoft Word 2013, Microsoft Word, Microsoft Office 2013, Microsoft Office 365 | No Comments »

Advertisement

How to Add Pictures from SkyDrive to a Document in Word 2013

August 28th, 2013 by David Eitelbach, Laptopmag.com Contributor

Penguins 675403

You’re working on a document while overseas on a business trip, when suddenly you realize that a critical chart isn’t saved on your laptop. If this sounds like a heart-stopping moment, don’t worry — Microsoft Word 2013 now boasts integration with SkyDrive, meaning that you can snatch documents and images straight from the cloud. Simply follow these steps to start adding pictures from your SkyDrive account directly into your Word documents.

1. Click “Insert” at the top of the screen.

how to add skydrive 1 click insert 675403

2. Click “Online Pictures” on the Ribbon.

how to add skydrive 2 click online pictures 675403

3. Click “Browse” on the right side of your SkyDrive in the popup window.

how to add skydrive 3 click browse 675403

4.  Click “Insert” when you’ve selected the picture you want to add.

how to add skydrive 4 select pic 675403

5. Click the “Layout Options” Button at the top right corner of the picture to modify the picture’s placement within the text.

how to add skydrive 5 set layout 675403

Tags: Microsoft Word 2013, Microsoft Word, Microsoft Office 2013, Microsoft Office 365 | No Comments »

How to Turn Off Automatic Hyperlinking in Word 2013

August 28th, 2013 by David Eitelbach, Laptopmag.com Contributor

how to turn off hyperlinking lead 675403

Nothing destroys the beautiful aesthetic of a clean document like a plethora of bright blue hyperlinks peppered throughout the text. Worse still, removing dozens of hyperlinks from a Word document one at a time can quickly become a monotonous chore. If you’d rather not have Word create a hyperlink every time you type a URL, you’re in luck — just follow these steps to disable automatic hyperlinking in Microsoft Word 2013.

1. Click “File” at the top left of the screen.

how to turn off hyperlinking 1 click file 675403

2. Click “Options” at the bottom of the left-hand menu.

how to turn off hyperlinking 2 click options 675403

3. Click “Proofing” on the left side of the popup window.

how to turn off hyperlinking 3 click proofing 675403

4. Click the “AutoCorrect Options” button.

how to turn off hyperlinking 4 click autocorrect 675403

5. Select the “AutoFormat as You Type” tab.

how to turn off hyperlinking 5 click autoformat as you type 675403

6. Uncheck the Box “Internet and Network Paths With Hyperlinks.”

how to turn off hyperlinking 6 uncheck internet 675403

7. Click the “AutoFormat” tab.

how to turn off hyperlinking 7 click autoformat 675403

8. Uncheck the Box “Internet and Network Paths With Hyperlinks.” 

how to turn off hyperlinking 8 uncheck internet 2 675403

Tags: Microsoft Word 2013, Microsoft Word, Microsoft Office 2013, Microsoft Office 365 | No Comments »

How to Recover Documents in Word 2013

August 28th, 2013 by David Eitelbach, Laptopmag.com Contributor

how to recover docs lead 675403

You’ve been pounding away at your keyboard for hours, having nearly finished a lengthy report for school or work, when Microsoft Word closes unexpectedly. Your pulse quickens when you suddenly realize that you haven’t saved your file. Panic rises in your throat. Sound familiar?

No need to fear — Word 2013 saves a temporary copy of your unsaved work that you can recover in a matter of seconds. Just follow these simple steps to pick up right where you left off.

1. Click “File” at the top left of the screen.

how to recover docs 1 click file 675403

2. Click “Info” at the top of the left-hand menu

how to recover docs 2 click info 675403

3. Click the “Manage Versions” button in the Info pane.

how to recover docs 3 click managed versions 675403

4. Select “Recover Unsaved Documents” from the drop-down menu.

how to recover docs 4 click recover 675403

5. Click “Open” when you’ve selected the document you want to recover.

how to recover docs 5 select document 675403

6. Click “Save As” at the top of the screen.

how to recover docs 5 click save as 675403

Tags: Microsoft Word 2013, Microsoft Word, Microsoft Office 2013, Microsoft Office 365 | 7 Comments »

Advertisement

How To Edit a PDF in Word 2013

August 27th, 2013 by David Eitelbach, Laptopmag.com Contributor

How To Office 2013 lead image (new) 675403If you’ve ever filled out a W-9, W-2 or any of the other myriad tax forms, you’ve undoubtedly wished you could input the required information directly into the attached PDF rather than having to print it off and fill it out by hand. Thankfully, Microsoft has made it easier than ever to edit PDFs in the latest edition of Word. Just follow these steps to start editing — and saving — PDFs directly from Word 2013.

1. Click “File” to open the File Menu.

 how to edit pdf 1 click file 675403

2. Click “Open” and select the PDF from either your SkyDrive or from your PC if the file is saved locally.

how to edit pdf 2 click open 675403

3. Click “Enable Editing” at the top of the screen to disable Protected View. This will convert the PDF into a new Word document.

how to edit pdf 3 enable editing 675403

4. Edit the Document as you see fit. Bear in mind that adding lots of text may cause images to displace.

how to edit pdf 4 edit PDF 675403

5. Click “File” and then “Save As.”

how to edit pdf 5 click save as 675403

6. Select “PDF” from the drop-down menu to save the document as a PDF.

how to edit pdf 6 save as PDF 675403

Tags: Microsoft Word 2013, Microsoft Word, Microsoft Office 2013, Microsoft Office 365 | 1 Comment »

Apple Updates App Store Rules For Kids Apps

August 15th, 2013 by Daniel P. Howley, LAPTOP Senior Writer

App-store-main

Apple has updated the guidelines for children’s apps available in its App Store. The new rules, according to MacRumors, ensure that app developers and apps comply with the Federal Trade Commission’s Children’s Online Privacy Protection Act. The act, which is focused on restricting the collection of personal information from children. The expanded COPPA rules limit a company’s ability to track items such including images, video and audio without receiving express parental consent. Read the rest of this entry »

Tags: Apple App Store, Apple, Apps, childrens online privacy protection | No Comments »

FreedomPop Adds 4G LTE to Free Wireless Service

August 6th, 2013 by Daniel P. Howley, LAPTOP Senior Writer

FreedomPop-SS-1

Free wireless Internet provider FreedomPop has announced that it is officially rolling out 4G LTE service to its customers via Sprint’s LTE network. The service provider, which launched in the U.S. in June, initially piggybacked on Sprint’s slower WiMAX network, but said LTE would follow later. However, Sprint’s LTE network reaches just 110 markets, compared to AT&T’s 335 markets and Verizon’s 500. T-Mobile, which just launched its LTE network, covers 116 markets.

FreedomPop provides users with 500MB of free data per month in addition to 200 free voice minutes and unlimited calls to other FreedomPop users. In addition to getting on Sprint’s LTE network, the company has also announced it’s now offering its own FreedomPop 5580 LTE mobile hotspot. The  hotspot offers connectivity for up to 10 devices, includes a 1.5-inch OLED display and can reportedly run on battery power for up to 8 hours. will cost users about $199. Pick it up now, however, and you’ll only have to fork over $149 as part of FreedomPop’s sale.  Read the rest of this entry »

Tags: freedompop mobile service, FreedomPop data, FreedomPop, FreedomPop 5580 LTE mobile hotspot | No Comments »

ISIS Mobile Wallet Finally Going Nationwide Later This Year

July 31st, 2013 by Daniel P. Howley, LAPTOP Senior Writer

ISIS-terminal

After nearly two years of fits and starts and a lengthy trial program, mobile wallet service ISIS has announced it will be rolling out to national retailers by the end of the year. ISIS, which counts AT&T, T-Mobile and Verizon among its backers, allows NFC-equipped smartphone users to pay for items in stores at NFC-enabled contactless checkout counters by simply tapping their phones against a payment terminal.

The system is similar in practice to Google Wallet and the RFID-equipped debit cards some banks provide their customers. To use their smartphones as wallets, users will download the ISIS app and create create ISIS profiles on their smartphones. The profiles then link directly to shoppers’ bank accounts or participating credit cards. Purchases made using ISIS are processed instantly.

Read the rest of this entry »

Tags: ISIS Mobile Wallet, ISIS, Google Wallet, mobile payment | No Comments »

FIND A REVIEW
Laptops
All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Brand
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating Editor's Choice 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
Resolution
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options
SUBSCRIBE