January 31st, 2012
Microsoft has begun the “Technical Preview” for Office 15, and plans to release a beta version of the latest Office suite sometime this summer. The “Technical Preview” is when a select group begins testing and using the software so they can provide feedback to Microsoft. You may feel like you just got used to all the new features in Office 2007 and 2010, but this latest release promises to be the most ambitious update of Office products — including updates in all the usual Office applications, as well as SharePoint, Visio, Project and more. There will be more focus on cloud computing and collaborating with others.
We’re excited about the upcoming changes and look forward to helping our clients quickly get up to speed with all the new features that are bound to appear. As soon as the new version is widely released, we will begin offering New Features classes at Executive Training Solutions in Phoenix, AZ. Until then, we are always teaching students how to be more productive using software and we are looking forward to helping you, too!
Tags: Office
Posted in Office | Comments Off
January 25th, 2012
New social media / sharing websites pop up on the Internet every day. One that has been around for a few months, but seems like it has great potential, is Clipboard. Clipboard allows you to surf the Web and quickly (and easily!) copy pieces from websites and save them to your Clipboard account. It’s similar to Pinterest, but seems to be filled with more tech-related clippings rather than crafts and recipes. It is also easier to use, and provides completely functional mini-windows into the websites that were clipped. When you choose to clip something, your mouse changes functionality and you are able to select anything from a website. The service maintains the HTML code, and then saves it to your account.
Right now, it’s an invite-only site, but you can easily request an invite from their main page. The time to receive an invitation varies, because they’re trying to grow slowly and keep up with the technical, behind-the-scenes magic. I think it’s going to prove to be very popular, and suggest you request an invite if you love to save information you find on the web.
If you love to learn about how to use computers productively, why not take a class at Executive Training Solutions? We offer all levels of classes — whether you’re a beginner or of the office guru. We are sure that our instructors can teach you some new tricks! Visit our website and check out our classes today.
Tags: Social Media
Posted in Social Media | Comments Off
January 19th, 2012
If you have been using Microsoft Excel for a while, you are probably familiar with the functions MIN and MAX that find the smallest and largest numbers in a range of data. You may not be aware of two other functions that do something similar, but with something added.
Using the SMALL and LARGE functions, you can choose where in the range you want to find your value. For instance, if you wanted to find the 3rd largest number in a range, you could type: =LARGE(A1:G35, 3). It would return the 3rd largest number in the range of cells A1 through G35.
SMALL will do just the opposite. =SMALL(A1:G35, 3) will return the 3rd smallest number in the range. With the added flexibility, you can begin using SMALL and LARGE in place of MIN and MAX.
If you would like to learn more about all the functions in Excel, consider taking the Excel Level 4 we offer at Executive Training Solutions. You will have the opportunity to learn about a wide variety of financial, statistical, text and more advanced functions.
Tags: Excel
Posted in Excel | Comments Off
January 17th, 2012
Most have been working with Microsoft Office 2010 for a while now. After a little time, most are used to the Ribbon and found ourselves navigating the different tabs and groups to find the items we need to create documents, spreadsheets and presentations. One thing that may still be confusing are the extra tabs that sometimes appear on the Ribbon.
These are contextual tabs. They appear when specific objects are being worked on in an application. For example, when you create a table in Excel, tabs appear on your Ribbon to make it easier to format and modify that table. As soon as you navigate away from the table, the extra tabs disappear.
There are six different types of contextual tabs:
- Format
- Design
- Layout
- Playback
- Arrange
- Page Setup
The next time one of these tabs appear, take a few minutes to explore the different commands they provide. You’ll probably find a new tool!
If you would like to take a class to learn more about Microsoft Office 2010, Executive Training Solutions would love to have you as a student. Check out the website and register for a class today!
Posted in Uncategorized | Comments Off
January 12th, 2012
This March (2012), Microsoft is having their Microsoft Project Conference here in Phoenix, AZ! You can get all the details from their conference website. It’s an excellent opportunity to spend a few days immersed in all the possibilities that Microsoft Project can create for your organization. There are a few different tracks available, and more details will continue to be posted on their site. If you’re already in Phoenix, you can save all the travel expenses.
If you’re unfamiliar with Microsoft Project, but know that it would be a useful tool, consider taking a 2 day class at our Phoenix training location. We would be happy to introduce you to the best project management software available.
Tags: Project
Posted in Project | Comments Off
January 12th, 2012
There are keys that you can press in Microsoft Excel to instantly do something on your worksheet. Here are a few of the most popular that we like to tell our students about:
- F11 will instantly create a chart on your worksheet
- ALT + + will instantly create an autosum function in the selected cell
- CTRL + ; will instantly record the current date
- CTRL + 1 will instantly open the FORMAT CELLS dialog box
To learn more useful tips, attend one of the 4 levels of Microsoft Excel classes offered by Executive Training Solutions in Phoenix. We have a seat waiting for you!
Tags: Excel
Posted in Excel | Comments Off
January 10th, 2012
Quickbooks is an excellent accounting software to help keep the books for small to medium sized businesses. One thing that accountants wonder about is what happens “behind the scenes” when transactions are created in Quickbooks. It’s easy to create invoices, pay bills, etc., but there are times when the accountant wants to make sure all the debits and credits are going to the correct accounts.
When you are in any transaction form screen, press CTRL + Y and you will see the Journal Entry. This is a great tool to verify that everything will show up in the proper accounts.
If you need to learn more about Quickbooks, Executive Training Solutions in Phoenix, AZ offers 2 levels of Quickbooks training. Visit our website today to find out when the next class is scheduled.
Tags: Quickbooks
Posted in Quickbooks | Comments Off
January 5th, 2012
You have probably noticed the Windows key on your keyboard, but did you know that it was useful for a variety of shortcuts?
- If you press the WINDOWS key, it will open your START menu
- Pressing WINDOWS + D will minimize all open windows on your screen and show you the desktop
- Pressing WINDOWS + M does the same thing (minimizes all open windows)
- Pressing WINDOWS + SHIFT + M opens all the windows you minimized with WINDOWS + M or + D
- Pressing WINDOWS + E will open your FILE EXPLORER
- Pressing WINDOWS + TAB will move through the icons in your task bar
Try some of these shortcuts today and save time searching for things on your computer!
If you would like to learn more shortcuts, we offer a variety of computer classes to help make you an expert. Visit our website to find a class, then visit our office in Phoenix, AZ to learn new skills. We look forward to seeing you soon!
Tags: Windows
Posted in Tips | Comments Off
January 3rd, 2012
Until January 31, 2012, you can take some of our Microsoft Office 2012, Level One courses for only $50/day! This is an amazing deal and saves you almost $200!
Right now, these classes are available at this amazing price:
PowerPoint Level 1 on January 16, 2012
Word Level 1 on January 18, 2012
Access Level 1 on January 19 & 20, 2012 (2 day class = $100 for the class)
If you are interested in other dates, or other classes, you can always check out our ALL CLASS CALENDAR by clicking to follow the link.
We had great turnout for our December special classes, and hope that you can make one of our January classes at our Phoenix location. Visit our website, or call 602-955-7787 to register today! If registering online, put the code OFFICE50 in the comments section to receive this great deal.
Posted in Classes, Office 2010 | Comments Off
September 21st, 2011
You have probably figured out how to change the font in messages that you send through Microsoft Outlook, but you may want to change the font size of the messages waiting in your inbox. In Microsoft Outlook 2007 and 2010, go to the VIEW tab and VIEW SETTINGS.
Click OTHER SETTINGS and you will see a ROW FONT button. Click that and you can change the size of the font in your Inbox rows.
If you want to learn more about Microsoft Outlook, attend one of the 3 levels of classes we offer! We look forward to seeing you at Executive Training Solutions.
Posted in Uncategorized | Comments Off
