.jpg)
As Microsoft Excel has grown from its early versions, large numbers of functions have been added with each successive version. By the 2003 version of Excel, there were so many additional tools that the number of toolbars needed to hold them had started to become unworkable. In Excel 2007 the Ribbon was created and replaced the toolbar system that existed for all previous versions. While the Ribbon is a much more workable solution than the old toolbar structure, we still have to jump from tab to tab within the ribbon to access the individual tools we need. Given that we’ll seldom use most of the tools available within the ribbon, a handy tip is to create a new tab on the ribbon that contains those tools we use very frequently. So, instead of jumping from tab to tab looking for the tool we need, we can spend most of our time in one tab. It sounds like a small thing, but it’s a big boost to our productivity.
On each Ribbon tab (such as the Home tab selected below) we find both commands and groups, as shown below. In the Clipboardgroup we see the Paste, Cut, Copy, and Format Paintercommands. In the Fontgroup we see the Bold, Italics and Underlinecommands, among others. After using Excel 2013, we may find the need to add new groups to existing toolbars, or to create new Ribbon tabs. To Create a New Ribbon Tab
The Excel Options dialog box appears, as shown below: We’ll create a new Ribbon tab called My tools, and we’ll position it between the Home tab and the Insert tab. 2 On the right-hand column, click on Home and then select New Tab (both circled) A new tab has been created (New Tab) and a new group has been created within it (New Group). Our next task with be to rename the new tab and group. To rename the New Tab 1 Click on New Tab (Custom), click on Rename and the Rename dialog box appears, as shown below:
The next task is to populate the new tab with tools. Populating the new Ribbon tab with tools New tools (represented by icons) are entered into the groups that live within the tabs. At the moment, out group is called New Group. We’ll need a more descriptive name than this. Given that we’ll want to load some formatting tools into our group, we’ll rename the group Format. To rename a group
To enter tools into the new group Once we’ve renamed our group we can enter tools into the group.
Those tools have now been added to the Format group, as shown below: In the image above we have added 5 tools to the Format group – Format Cells, Format Object, Format Painter, Format Picture and Format Selection
As you can see from the image below, a new tab has been created called My Tools, and within it we can see the tools we added in the previous step. You can now go back into the Excel Options dialog box using the steps shown above, and more groups to your tab using the New Group button, and add tools to the new group.
The electronic spreadsheet has been in existence since 1978, but it was 1982 that Microsoft became involved. The first major leap occurred in 1978 when VisiCalc was created by Dan Bricklin, a student at Harvard Business School. It was basic software, capable of producing a spreadsheet of only 5 columns by 20 rows.
Participants in any work-related training course are never more excited than when they learn a technique or tool that has an immediate application in the work they’re doing. If we, as participants, recognise that a newly-learned tool will increase our productivity we’ll leap on it, especially in today’s work environment
We were working with a client in Melbourne recently, and a question came up (yet again) about how to manage some text that had been imported into Excel from an external database. This is becoming more common, as the number of people increases who use Excel to manipulate data originating from outside databases.
