How to use Flash Fill in Excel 2013?

Flash Fill You may need to separate first and last names (or product names and numbers, or any other data) into separate columns.  New Excel 2013 feature Flash Fill can help you quickly fill in all the data. Flash Fill can recognizes your data and follow its pattern, and then enters the rest of your data in […]

Read More

How to open and edit PDFs in Word 2013?

Word 2010 can convert the Word document into PDF files, Word 2013 now allows you to further edit PDF content, but also to retain the structure and style of a PDF file.  You do not need to install additional PDF editing software, you can easily use Word to edit and using a familiar way to […]

Read More

How to use PowerPoint 2013 Presenter View?

Presenter View allows you to see your notes on your monitor, you can see your notes as you present, while the audience sees only your slides. At the bottom of the slideshow window, click Slide Show View. If you are working with PowerPoint on a single monitor and you want to display Presenter View, click […]

Read More

How to use Recommended Charts in Excel 2013?

Recommended Charts will recommends the most suitable charts for your data.  You can get a quick view to see how your data looks in the different charts. Create a chart Select the data for which you want to create a chart. Click Insert > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that […]

Read More

How to use the Excel 2013 Quick Analysis?

It used to take a bit of work to analyze data using Excel, but now it only takes a few steps.  You can instantly create different types of charts, including line and column charts, or sparklines.  You can also apply a table style, create PivotTables, quickly insert totals, and apply conditional formatting. If you are […]

Read More

How to line-up and space objects equally in PowerPoint 2013?

You do not need to carefully measure whether the objects in Powerpoint slides are lined up or not, because Powerpoint Smart Guides automatically appear when your objects are close to even.  As shown below, Powerpoint will tell you when objects are spaced evenly. Turn on the snap-to options Click View, in the Show group, click […]

Read More

How to insert Online Pictures and Online Video in Word 2013?

To add richness to the file, we usually insert a picture, video.  Now Word 2013 allows direct insert of pictures or video from YouTube, Flickr, SkyDrive etc.  You do not need to open a browser to find those pictures or videos, or save them to your hard drive first and then paste to the file. […]

Read More

How to resize PowerPoint slides to 4:3 or a custom size?

Much of the world’s TVs and video have gone to 16:9 widescreen and HD formats and PowerPoint also has.  In additional to the 16:9 layout, more new themes are designed for you to take advantage of widescreen.  In earlier versions of PowerPoint, slides were 4:3.  The default slide size in PowerPoint 2013 is 16:9.  However, […]

Read More