Apr
09
Use the chart feature of Microsoft® Excel® to turn data into a graphical illustration.
1. Select the data cells to chart.
2. On the Insert tab, in the Charts group, click the button for the chart type. In the drop-down gallery grid, click the appropriate choice.
Feb
25
Hyperlinks let you jump to other locations, such as a web page or picture, while presenting. Read More »
Feb
08
Prevent unauthorized use of an Access database by encrypting the database with a password. Read More »
Jan
09
Use the Signature option in Outlook 2010 and quickly add signature information at the end of every e-mail you send. Follow the steps below to create a new signature for your e-mails. Read More »
Dec
19
Within the Logical Function Library in Excel, you will find the “IF function”. This function allows you to provide different “Values” based on a condition.
Oct
23
As you manage projects, you may employ certain settings and elements repeatedly. Rather than having to apply these with every new project, create a permanent template. Follow the steps below to create a Project plan template in Microsoft Project 2010.
Sep
24
You may find that you frequently have related lists of data in multiple sheets or workbooks. Display a summary of the data by consolidating it onto one sheet.
Sep
10
Access 2010 provides several types of reports for sharing information from the database with other users. The report types available are: Standard Report, Labels, Blank Report, Report Wizard and Report Design. Review the chart below for the different form types and their description.
Aug
23
Within Excel, there are many keyboard shortcuts you can use to save time and avoid reaching for your mouse. If you need help recalling a shortcut, simply move your mouse pointer over the menu item and you will see the details for the equivalent keyboard commands if a shortcut is available. Review our helpful tips below for commonly used keyboard shortcuts within Excel 2010.
Read More »
Aug
15
Using the Charts feature in Excel is a great way to add appeal to your worksheets and to summarize data. You can choose from a variety of chart types to best represent your data such as Column, Line, Pie, Bar, Area, and Scatter. Review our tips below for creating a chart.
Aug
09
Did you know that you can put a bookmark in your Word document? You can add bookmarks to text or graphics in your document and assign a name to that bookmark. Using the bookmark feature allows you to quickly return to a specific location within your document. This feature can be extremely helpful as a navigation tool especially if you work with long documents. Follow the steps below to create and use the bookmark feature in Word 2010.
Jul
19
Microsoft Office 2013 has a brand new, clean look. While many of the features you are familiar with from Office 2010 are still there, there are many new features and functionality options we are excited to use. Here are just some of the features that you can look forward to in Office 2013:
Jul
05
Have you ever wanted to put a sticky note with comments on your Excel 2010 worksheets? Using the cell Comments feature in Excel, you can insert an electronic version of a sticky note to add your notes on items such as questions, thoughts, or specifics about the cell contents. Using the Comments feature, you can help users understand complex or detailed cell data more accurately. Follow the steps below to use the Comments features in Excel 2010. To learn more about Excel 2010, check out our full day training course outlines here.
Jun
20
Use shapes in your Excel worksheet to create an appealing illustration. Excel 2010 offers ready-made shapes such as arrows, callouts, circles, flowchart symbols, and lines. You can work with shapes by inserting, resizing, moving, grouping, and formatting shapes. Review our tips below on working with shapes. Click here to learn more about the features available in Excel 2010.
Jun
14
In Outlook 2010, a new view for your Calendar is available called the Schedule View. With this view you can display many calendars at the same time in a horizontal arrangement. This view is very useful when you need to schedule a meeting and you want to see multiple calendars at one time. In addition, creating Calendar Groups allows easy viewing of team or department calendars. To learn about more features in Outlook 2010, check out our Outlook 2010 Part One class or our Outlook Live Webinars.
Microsoft, Windows, Access, Aero, Excel, Outlook, PowerPoint, and Visio are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.