Tag Archives: MS Excel tricks

Tips for more comfortable use of MS Excel

Access keyboard shortcuts to help you work with the data in your spreadsheets without having to scroll through menus. These one-stop guides help you become familiar with the basic keyboard shortcuts for Excel 2010 and Excel 2007.

The ribbon, a graphical toolbar that makes it simple to build and use spreadsheets, is your key to creating useful spreadsheets. The ribbon saves you time and enables you access to a huge toolbox of visual and computational tricks. To learn more about the basic and advanced features it offers (including user customizability in Excel 2010), see the following 2010 edition video or this article on the function the Ribbon plays in Excel 2007.

Conditional formatting allows you to automatically change the appearance of cells that meet specific, user-defined criteria. Conditional formatting lets you quickly identify important data points such as top-performing students or salesmen. Here’s how to take advantage of it this feature in Excel 2010 and Excel 2007.

Using the Microsoft Excel Web App, you can access spreadsheets from anywhere with your web browser or easily share and collaborate in-real time with friends and colleagues. The Web App is a convenient solution to tackle group projects.

Power Pivot for Excel 2010, a free downloadable add-on, offers even more muscle for performing calculations that involve large amounts of data. Users can also easily share spreadsheets which can help with heavy workloads.

Creating charts and graphics

With Excel, you can create colorful pictures and graphs or generate eye-catching reports in minutes that help you identify usage or spending patterns at a glance.

From bar and pie charts to histograms and attention-grabbing sparklines, Excel provides a variety of practical ways to visually represent data, which makes it easier to understand at a glance. These images offer a fast and intuitive way to display information and illustrate points more effectively. Chart options include:

  • Area
  •  Bar
  •  Bubble
  •  Column
  •  Doughnut
  •  Line
  •  Organization
  •  Pie
  •  Radar
  •  Stock
  •  Surface
  •  Scatter Diagram

Detailed PivotTable and PivotChart reports can also help you quickly summarize large amounts of data so that you can browse and assess information in a more streamlined way. See step-by-step procedures for using PivotTables and Pivot Charts for Excel 2010 and Excel 2007. To jazz up your spreadsheets, you can also use pictures, clip art, and other custom graphics.



Leave a comment

Posted by on February 8, 2012 in MS Excel, My Home


Tags: , ,

Excel Blogs and Tip Sites

Tips sites and Excel blogs will usually send you a daily Excel tip. Many Excel professionals register to these sites and read the daily tips to keep their Excel skills sharp. They also serve as repositories for thousands of Excel case studies.

  • Chip Pearson Newsletter: A new service from Chip Pearson. Each issue of this newsletter contains a thorough examination of a technique or of an Excel function. For those of you that wish to gain deep knowledge of Excel, this is an excellent resource.
  • Daily Dose of Excel: A blog authored by many Excel Experts and MVPs. “Daily Dose” is updated several times a week and profiles tips, tricks and news from the excel Industry. You can learn lots of things from this blog.
  • Over the years ExcelTip amassed hundreds of tips and solutions to real world problems. You can either use the categories or the search function to find the information you want. You can also register to a tips newsletter.
  • Official Microsoft 2007 Blog: The Official Excel Blog. Written by the Excel product managers/programmers. It contains a lot of information and how-to articles about Excel. The level of articles on this blog varies from “useful to everyone” to “only for hardcore excel services programmers.”
  • Vital News Excel Tips: Very similar to ExcelTip, this site contains hundreds of tips sorted into categories and offers a weekly newsletter.
  • Excel User: Excel User contains a “Visitor Question” section and many high quality articles.
  • Andrew’s Excel Tips: Andrew Engwirda writes one of the best Excel blogs. What separates Andrew from the flock is his vast amount of Excel and programming experience.
  • Codswallop: Although we are not a strictly an Excel-centered blog, we plan to bring a lot of Excel goodies in near future.
  • Smurf On Spreadsheets: Simon Murphy is an Excel programming master. If you are into Excel Programming, this blog is perfect for you.
  • The Ken Puls Blog: Ken’s blog is neither Excel centered nor frequently updated. However, when Ken does blog about Excel, it’s pure gold. Definitely worth checking out.
  • Excel Hero: Daniel Ferry’s blog is full of Excel tips and advanced topics intended to inspire you and make you the Excel Hero at your workplace.

Hope this will direct your excel journey. Njoy the journey. Feel free to mail on                                                                                                                                                   

Leave a comment

Posted by on January 31, 2012 in My Home


Tags: , , ,

%d bloggers like this: