Artwinauto

 

 

Keyboard shortcuts are very useful in every program or application if you want to save time. Having to take your hands away from the keyboard, grabbing the mouse, using it, clicking on the item, drop the mouse and putting your hands back to the keyboard consumes much more time than just hitting a key combination or hotkey.

 

This is the turn for MS Excel, a very useful application with some very interesting shortcuts.

 

Microsoft Excel comes with many keyboard shortcuts and experienced users use them to get their work done faster. After using Excel for a long time, we realized that some commonly performed tasks and functions take a few more keystrokes or mouse-clicks than others to perform and they do not come with shortcuts. This problem is made worse in Excel 2007 where the ribbon interface has been introduced.An office productivity software is supposed to increase our productivity in the office. Yet the design of Excel 2007 has this shortcoming. If we stick with the original keyboard shortcut system, we find our speed being limited by the pre-defined set of keyboard shortcuts. So we decided to augment the system with an external program, AutoHotKey which we have introduced earlier, to create custom hotkeys and improve the usability of Excel.

 

 

Excel users often ask for formulae or functions to achieve certain task. Here are the "official" lists of all worksheet functions in Microsoft Excel:

Excel 2003: List of worksheet functions (by category)

Excel 2007: List of worksheet functions (by category)

 

The lists are very good references. Microsoft categorized the functions by their functionality, so you can do a search on the page if you know what you are looking for. Those who will constantly use various kinds of functions in Excel for their work would like to find out which functions are more commonly used than the others, so that they can learn to use them in the order of descending importance (This is good in Excel training). Here is a list of functions sorted by their frequency of appearance in Excel worksheets:

Charting in Microsoft Excel could become a time-consuming task especially when there is a lot of data. Adding, deleting, modifying data series or fomatting charts could keep you busy for hours. If working with Excel is your daily routine task, to save you some time, you might want to pick up the following tips about how to do certain things in Excel without opening or going through the charting dialogs.To illustrate, we use X Y (Scatter) chart to plot our sales data on Microsoft Excel 2007. Most of the tips are also applicable to other chart types or on other versions of Microsoft Excel. We suppose you already know the basics of charting.

We will show you a trick on how to import a large amount of data into Microsoft Excel or Access when

The data is not in a format that can be imported. The delimiters do not separate the data into columns or fields correctly. Some values are missing or incorrect. There are some unwanted garbage mixed in the data

 

Know yourself first. Are you a beginner just starting out to use Microsoft Office? Or an intermediate/experienced user wanting to improve more on your productivity?

 

If you are a beginner, all those menus, toolbars and buttons could seem mind-boggling and intimidating to you. There is no need for you to learn the meaning of every item and all the advanced features in the beginning. The best thing is to immediately get started and learn the basic operations, the most handy features first, familiarize yourself with the interface and improve yourself gradually by practice and experience.