Tag: Excel

Documents often contain hidden data and personal information that could be harmful to the author if distributed.  Here are instructions on how to remove hidden data and personal information from documents, spreadsheets, and presentations.

You can use the Find and Replace feature in Microsoft Office products to make quick and easy edits to text.  Wildcards are special characters you can use to make searching through your documents more efficient.  Here are some useful wildcard characters.

Looking to save time when setting up and editing spreadsheets in Excel?  Here are some shortcuts for quickly inserting or selecting entire rows or columns.

Locating and properly using the right formula in Excel can sometimes be a challenge. Learn how to use the “Insert Function” feature to simplify the task.

Have you ever tried copying/pasting an Excel chart or list to Outlook, Word or PowerPoint, only to find that the formatting is way off? Learn the perfect way to paste Excel content in this tip.

New to Microsoft Excel and not sure where to start? Check out Lynda’s Excel 2010 Essentials video series and learn how to use Excel’s major features and tools.

Are you getting the most out of Microsoft Excel? Do you use Excel for basic lists and record keeping, but would like to be able to do more with it? Have lunch and learn tips and tricks in Excel. Lunch will be served and water will be provided. Please bring your own cup or alternate drink.

When working with an Excel workbook that contains many tabs, in can be confusing to find your way around. Bring some order to your workbook by color coding and labeling tabs to make them easier to identify.

While Excel’s COUNT formula is very helpful, sometimes it doesn’t go far enough. Learn how to use more advanced functions like COUNTIF dig deeper into your data. COUNTIF can be used to count the number of “Yes” responses in a column containing a variety of answers.

The Office Ribbon was complete refresh of the traditional Microsoft Office interface. Menus and toolbars were removed and tabs with large icons took their place. While great in most situations, sometimes the ribbon just isn’t organized exactly like you need it. Now, in Office 2010, you can create your own custom ribbon tabs. Give it a try in Microsoft Excel.

Microsoft Excel brings many powerful functions right to your fingertips. Today’s tip takes a closer look at basic arithmetic and explores 5 ways of adding together information.

Find it hard sifting through endless rows and columns on excel documents? You are far from alone! Luckily there are ways to filter and sort your data in excel. Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table. By setting a filter, you can quickly show and hide data that you find relevant.