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

How to turn off PowerPoint Presenter Mode?

PowerPoint 2013 uses Presenter View by default when you project slides onto the projector or dual monitors. Follow below steps to turn off the Presenter View mode: To stop PowerPoint from automatically starting a slide show in Presenter View: On top menu bar, click on the [Slide Show] ribbon. In the Monitors group, uncheck [Use […]

Read More

How to Expand and Collapse parts of a Word 2013 document?

In Word 2013, you can collapse the contents except the part you want to focus on.  Or you think the contents might be overloading with too much information, you can display summaries and read the details if you want. Add an outline level The ability to collapse and expand content is based on the outline […]

Read More

How to use Recommended Charts to create charts in Excel 2013?

Recommended Charts can quickly analyze your data and suggest the most appropriate charts to you. Select the data for creating chart. Click [Insert] > [Recommended Charts]. On [Recommended Charts] tab, scroll down and select the chart suggested by Excel. Use the [Chart Element], [Chart Style] and [Filtering] button to create new chart item. (Such as […]

Read More

How to project PowerPoint slides on a projector in classroom?

Press the Windows key + P. (While holding down the Windows key, press and release the P key.) Click on the Display option you would like to use. Computer only – This shows your desktop only on your main display screen. Duplicate – This shows your desktop on both of your computer display screen(s) and […]

Read More