Archive for the ‘Microsoft Excel Tips’ Category

Get In Touch With Your Creative Side Using Microsoft Office

February 23, 2011

[tweetmeme source=LANSystems only_single=false]Not that long ago, the only way to get high-quality, professional materials was through a graphic designer.  Printing was a complicated, expensive process that was left to the print shops.  Each project required assembling pictures, graphics and content that was camera-ready. 

Today, we have access to everything needed to make agency-quality marketing materials with full-color and amazing graphics. Brochures, mailers and newsletters can be printed on-demand or in the perfect quantity to reducing waste and keep the offering fresh.  To save more and reach the online audience, electronic files are brilliant and easy to distribute.  If you have an idea, a good eye and the right tools, you can make magic. 

Microsoft Office offers the right tools with its Office 2010 Suite of Applications.  Word, PowerPoint, Excel and Publisher provide improved and enhanced features for creating and publishing. Many of the features are cross-platform so you can learn a skill in one application and use it in another.  There are a host of classes for beginner, intermediate and advanced users that can be taken in a classroom environment or online depending on your best learning method.  Microsoft, Hewlett-Packard and others offer free, online classes that are perfect for the self-learner.

Word is the standard for creating and formatting documents of all types from simple letters to documents with a table of contents, index and glossary. It makes the task of creating and editing documents easy.  Tools like spell check and thesaurus make us look smart and polished. New and improved photo-editing tools let you transform pictures right in Word 2010 – no extra software needed. Change color saturation, temperature, brightness, and contrast to turn a simple Word document into a work of art.  Turn text into visual effects with enhanced text effects and SmartArt graphics. Change basic bullet-points into compelling visuals and add text effects like shadow, glow, reflection, and 3-D in just a few clicks.  With co-authoring, you can edit at the same time as others, even if you’re working from different locations, and keep versions in sync with version control. This is a great way to eliminate typos (ever used a there for their or your for you’re?) by having others review your work for content and correctness.

PowerPoint is not just for presentations, it also makes a great coordinating tri-fold or handout.  Use the same theme for marketing materials that you can leave with the prospect to reinforce your message and offering. Creating your presentation in PowerPoint allows you to gather all your thoughts and ideas in one tool.  You have many slide choices and can move, cut, paste and organize to create a coherent flow of information without leaving the program.  Adding graphics, diagrams, video and sound is easier than ever. 

Excel graphs, charts and sparklines explain trends and comparisons with strong visuals.  Whenever numbers are involved, visuals are powerful tools to simplify the message and give at-a-glance significance. Use sparklines to graphically display data in a single cell.  You can display data in line, column or win/loss format to highlight trends.

Publisher helps you create eye-catching brochures, newsletters, postcards, greeting cards and email messages.  With the built-in and online templates, you can find a style for any publication. The prebuilt building blocks give an assortment of page parts like sidebars, stories and columns for creating professional newsletters and case studies. Add calendars, borders and advertisement blocks for community or school newsletters. Stunning graphics and images are easily added and use OpenType typography for expert typesetting effects.

Get your creative juices flowing! Experiment with different looks and practice with different styles.  Start with a concept and use Microsoft Office 2010 to create brilliant, flawless materials for your home, school or business.

For more technical notes and information go to: www.lansystems.com/technotes.html

Advertisements

Managing Rows and Columns in Excel

January 27, 2011

Excel[tweetmeme source=LANSystems only_single=false]Guest author David H. Ringstrom, CPA, www.accountingadvisors.com

Users often hide rows or columns in a spreadsheet to conceal private data, or perhaps just to keep a large spreadsheet manageable. This is a helpful feature in Excel, but many users often go about managing rows the hard way:

Excel 2007 or later: In the Cells section of the Home tab choose Format, Hide & Hide, and then make a selection as to what to hide or unhide.

Excel 2003 and earlier: Choose Row or Column and then Hide or Unhide, respectively. 

Hiding rows is fairly straight forward, as you can select the rows or columns, and then carry out the aforementioned menu command. To unhide rows or columns, you must select rows above and below the hidden section, or columns to the left and right of the hidden section, and then carry out the menu command.

Constantly navigating the menus to hide and unhide rows or columns can put unnecessary wear-and-tear on your wrists, but there are some easier alternatives. For instance, these keyboard shortcuts work in all versions of Excel:

  • Press Ctrl-9 to hide a row or , as oppoCtrl-Shift-9 to unhide a row.
  • Press Ctrl-0 (zero) and Ctrl-Shift-0 (zero) to  hide or unhide columns.

In both cases, make sure to use the numbers at the top of your keyboardsed to the number pad at the right of your keyboard.

Many users are particularly bedeviled when they need to unhide selected rows or columns within a hidden area of a worksheet. Typically they unhide all rows and columns in the affected section, and then rehide what they don’t need. Consider this surgical approach in all versions of Excel instead:

  1. Press F5 to display the Go To dialog box.
  2. Enter the address of the cell or cells that you want to unhide, such as A1 if you want to unhide a single row or column, D1:G1 if you want to unhide several columns, or A5:A10 if you want to unhide several rows, and then click OK.
  3. Use the keyboard shortcuts or menu commands I mentioned above to unhide the desired portion of your worksheet.

If you need to frequently hide and unhide sections of a spreadsheet, try the Group and Outline feature instead. First, select one or more rows or columns, and then carry out these steps:

Excel 2007 and later: On the Data tab of the ribbon, choose Group in the Outline section.

Excel 2003 and earlier: Choose Data, Group and Outline, and then Group.

Once you do so, a button with a minus sign will appear outside the worksheet frame. Click this button to collapse (or hide) the rows or columns. The minus sign will change to a plus that allows you to expand that section. Or use the 1 and 2 buttons at the top left-hand corner of the screen to expand or collapse all grouped columns or rows in the spreadsheet. To remove the outlining, select the grouped rows or columns, and then choose the Ungroup command on the aforementioned menus.

David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting and training firm. Contact David at david@accountingadvisors.com or visit www.accountingadvisors.com.