Archive for July, 2009
Share | Bookmark | Print:
Grouping Objects
Grouping and Ungrouping Objects
1. Press and hold the SHIFT key and select the objects you want to group.
· To group:
Click the Home tab, in the Drawing gallery, click the Arrange drop-down arrow, and then click the Group option.
· To ungroup:
Click the Home tab, in the Drawing gallery, click the Arrange drop-down arrow, and then click the Ungroup option.
–
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office PowerPoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.
Posted in Company Blog, General, Tip of the Week | Comments Off
Share | Bookmark | Print:
What it is
Microsoft Excel is a spreadsheet program that allows users to create tables, charts, graphs, and formulas that can be shared with other users or programmers. It implements a spreadsheet program to design this information in an effective process, enabling users to input large amounts of information in an efficient manner. Microsoft Office Excel is a spreadsheet application designed by Microsoft for the intent of allowing businesses to retain pertinent data in a consistent manner and maximize profitability for Accounts Receivables. It has been used worldwide since the fifth edition was released in 1993.
As are many of the Microsoft Office suite of applications, Excel is conspicuously and frequently accepted for both personal and professional functions. Individuals use spreadsheets for school-related or calculative reasons and personal computations, while corporations actuate this application for a multitude of algorithmic and computative purposes. The initial edition of Microsoft Excel was in 1985, but the growing popularity of Lotus 1-2-3 programs obscured it. It wasn’t until the 1993 edition that Excel began to prevail in the microcomputer system caste and increase in usability as new editions were released comprised of more user-friendly icons and tools.
How it is used
Spreadsheet tools such as Microsoft Office Excel are used in a variety of ways, but their main goal is mathematical functions. Whether they are needed for private or business-related functions, it is relatively easy to master the tools and commands required in order to design professional-looking documents that errorlessly represent essential data. There are several tutoring programs that can be purchased to instruct students or employees as to the details of Microsoft Excel, both as e-learning courses and instructor-led. Many are either cost-efficient, and both schools and corporations use computer labs to train students or employees in greater numbers simultaneously.
This spreadsheet program is not limited to input; it is also used to store and organize the information at the same time. Spreadsheets can be designed or augmented using Microsoft Excel and can be saved to the computer and shared with other users, who can also make changes as necessary and return the spreadsheet or deliver it to the next user. Microsoft Office Excel can calculate basic mathematical equations, including mortgage or loan repayments, finding averages, calculating interest, and ascertaining the minimum and/or maximum values of charts or data input. Columns can be extended or minimized, giving the user almost unlimited control over the spreadsheet. Charts can be custom designed, and may be drafted as pie charts, bars, graphs, or other tabulations. X and Y points are locatable, with Z used as an axis when necessary.
Editions Available
Since Microsoft Office Excel was created in 1985, there have been many upgrades and additions. There have been only a handful of years that a new edition was not released in association with a new edition of Microsoft Office Suite, and thus 2007 saw the twelfth release of Microsoft Excel. Microsoft Office Excel is available for the Mac OS Platform as well. Microsoft Excel had used a VBA programming language since 1993, but the release of Excel for Mac OS introduced Mac OS X languages. Microsoft Excel was also designated for Apple Macintosh OS/2.
Ten different versions of Microsoft Office Excel have been published for Windows, eleven for Apple Macintosh OS, and three for OS/2. In early editions, it used a BIFF format, but the 2007 edition and subsequent editions employ an XML-spreadsheet format. Microsoft Office Excel’s newer versions are able to read legendary formats, unlike their geriatric counterparts. Microsoft Excel 2007 still retains a few of the easter eggs that Excel is known for, but has repaired many of the application or run-time errors that were noticed in previous editions. Nonetheless, Microsoft Office Excel is still criticized for date, code, and accuracy conundrums.
Posted in Company Blog, General | Comments Off
Share | Bookmark | Print:
1. On the Quick Access toolbar, click the Customize Quick Access Toolbar button, and then click the More Commands option.
2. In the Excel Options dialog box, in the Choose commands from drop-down list, click the Commands not in the Ribbon option.
3. Locate and click the Compare and Merge Workbook command, click the Add button and then click the OK button.
4. Open the copy of the shared workbook into which you want to merge changes.
5. On the Quick Access tool bar, click the Compare and Merge Workbooks button.
6. In the Select Files to Merge Into Current Workbook dialog box, select all copies of the shared workbook containing changes to be merged.
7. Click OK.
Note: Cells that have been modified are marked with a black triangle. Place the mouse over the cell to view the change.
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.
Posted in Company Blog, General, Tip of the Week | Comments Off
Share | Bookmark | Print:
Send a Calendar Via E-Mail
This feature allows for a snapshot of calendar items to be sent to an e-mail recipient.
1. In the Navigation Pane, click the Calendar button.
2. On the Calendar pane, click the Send a Calendar via E-mail link.
3. In the Send a Calendar via E-mail
dialog box, in the Calendar drop-down list, select the appropriate option.
4. In the Date Range drop-down list, select the appropriate dates.
5. In the Detail drop-down list, select the
appropriate option.
6. Click the Show button, and then select any additional options.
7. Click the OK button, and then complete and send the message.
Posted in Company Blog, General, Tip of the Week | Comments Off
Share | Bookmark | Print:
When your training budget is tight (and whose isn’t) what are your
options? Training continues, but sometimes on a shoestring. But
you don’t have to make concessions in your budget when it comes to
quality and effectiveness. Many companies operating on a shoestring
are incorporating e-Learning into their education mix. Simply put,
e-Learning delivers more training to more people, and can be very
cost effi cient, leaving more for your bottom line. e-Learning can be
used alone or coupled with instructor-led learning, which allows the
classroom learning experience to expand to day-to-day use. Since
learning isn’t an event, but an ongoing process, e-Learning supports
and augments each instructor-led learning experience. There are
other advantages, too:
- Employees learn when they have the time, increasing participation.
- A wide range of courses means employees receive all the training they need.
- When new training needs arise, they can be met immediately.
- Consistent training anywhere in the world.
Tags: Computer Bases Training, Virtual Campus
Posted in Company Blog, General | Comments Off
Share | Bookmark | Print:
Working with Styles
In Microsoft® Word, a style is a set of formatting options saved with a single name. Since applying a style applies the formatting to all associated text in the document, you can change the entire document by editing the style.
Creating a Style
1. On the Home tab, in the Styles gallery, click the More button.
2. In the Styles dialog box, click the New Style button .
3. In the Create New Style dialog box, in the Name text box, enter a name for the style.
4. In the Style Type list, click either the Paragraph or Character option.
5. In the Based on area, choose a style as a starting point.
6. Click the Format button, and click the available options to set the
corresponding properties.
7. Click the OK button.
Applying a Style
1. Select the desired text.
2. On the Home tab, in the Styles gallery, click the desired style.
Modifying a Style
1. Access the Styles dialog box.
2. Mouse over the desired style, click the drop-down arrow.
3. Click the Modify option.
4. Change the properties for the appropriate format option.
5. In the Styles dialog box, click the OK button
This Tip of the Week was brought to you by the learning professionals at ExecuTrain Houston. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.
Tags: Office 2007, weekly tip, Word 2007
Posted in Company Blog, General, Tip of the Week | Comments Off
