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.
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.
Among Excel users there’s a degree of uncertainty about the difference between Office 365 and Office 2013 . It’s a relatively new area, and while most of us are clear about what Excel 2013 is, it’s Office 365 that’s causing the confusion. Some consider that Office 365 is just another name for Excel 2013 (which isn’t the case)...
An on-site Excel course provides a great opportunity for participants to jump ahead in their knowledge and understanding of the most popular electronic spreadsheet program in the world. When training on-site, consider . the difference between a standard software course and one which will really boost a participant’s ability to use Excel effectively.