7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more

The bigger and uglier your Excel spreadsheet gets, the more you need to use certain features or tricks to keep a handle on the data. The seven features covered here will help you navigate, organize, and readjust your spreadsheet with as little hassle as possible. 

1. Split Screen

One of the most helpful features for large spreadsheets is the Split Screen command. The Split Screen allows you to view two, three, or four windows of your spreadsheet. Use this feature to work on one section of your spreadsheet while you view another section; or use it to compare (side by side) two sections of the spreadsheet. Once you try it, you'll find lots of reasons to use it.

Read more »

0

4 Google Translate features you'll use every day

Google Translate's knowledge of more than 100 languages can help you in your daily workflow as much as it can help you on your next trip. The features below show how it can help you with entire documents or websites, or even your native tongue.  

Translate websites to a different language

Google Translate can parse individual words and phrases, of course, but you can also translate entire websites into a chosen language.

Read more »

0

Word resume tips: Using style sheets, shapes and text boxes for a professional look

Updating your résumé means more than refreshing the information. You also need to reformat the document with new typefaces, graphical elements, and page design. Failure to modernize these elements can actually reveal as much about you as the biographical data.

Take the fonts, for instance. Times Roman and Helvetica were popular 1980s typefaces. Arial and Bookman Old Style dominated the early 1990s, which were then replaced by Verdana and Georgia (in the late 1990s to early 2000s). Office 2007 replaced the default "Normal" typefaces with the ClearType font families called Calibri (san serif) and Cambria (serif). Using any of these fonts will date you and your résumé. Try some new typefaces this time, keeping in mind that Serif typefaces are easier to read, but san serif typefaces look more avant-garde.

The best strategy for updating your résumé is to check the Internet. Searching on "résumé design," especially on sites like Pinterest, will help you find design layouts that that really pop. I've chosen a contemporary layout style that we'll try together in Word to create a résumé masterpiece.

Read more »

0

How to add video to Google Slides for a more powerful presentation

A snoozer slide deck can tank the best presentation no matter how strong your message. By including a short video in your slide deck, you can both clarify key points and spark an emotional response in your audience. Here are three ways to add video to a Google Slide.

YouTube

YouTube’s integration with other Google products makes it possible to find and add a video without leaving your slide deck. Here’s how:

Read more »

0

How Excel can help with metric and American Standard conversions

Let Excel do the currency and metric conversions you need for your global business or travel. The following Excel functions can be used in Europe with the metric system (officially called International System of Units or SI) and the euro currency. Once you calculate the spreadsheet functions, you can use the various Excel apps to run the programs on your smartphone or tablet.

Fahrenheit to Celsius

To convert temperatures from Fahrenheit to Celsius, subtract 32 from the Fahrenheit number, then divide the difference by 1.8. For example, 175 degrees Fahrenheit minus 32 equals 143, divided by 1.8 equals 79.44 degrees Celsius (close enough for a manual calculation). For Celsius to Fahrenheit, do the opposite: Multiply the temperature by 1.8 and then add 32 to the product.

Read more »

0

Use PowerPoint Photo Album to chronicle corporate or personal events

Those charming slideshows that people make for wedding couples to highlight their lives before the nuptials aren’t the only reason to use PowerPoint’s Photo Albums. Corporations create similar slideshows to celebrate or chronicle corporate events, then place them on the company’s Intranet for all the employees to enjoy. They also use Photo Album slideshows for kiosks, trade show booths, and other marketing events to showcase the company and its products.

PowerPoint makes this task super-easy with its intuitive menus and dialog screens that walk you through the process, prompting you for responses along the way. It all starts with the Photo Album button on the Ribbon menu under the Insert Tab. The following instructions explain this feature in detail.

Select photos

Read more »

0