Who needs all these decimal places? Rather have it display results to the nearest whole integer? Nearest tenth? Nearest Hundreth? Here’s how to apply the ROUND function for clearer numbers according to your specifications.

This video tutorial tip is brought to you by Log on to Learn. Log on to Learn has over a 1000 videos ranging from short tutorial clips to longer in-depth series. This video is part of larger series called Excel 2010 Functions. Other videos highlight, the CountIF, SumIF, NestedIf, PMT funtions to name only a few.

KnowledgeWave and Log on to Learn bring back one of our most popular webinar titles for March, Learn the Bells and Whistles of Calendars and Tasks. This month we’re even giving away a $25 Visa Gift Card with every paid registration! A $99 value, discounted to $59, but you get $25! That’s some March Madness.

Can’t make the date or can’t wait and want the topic now? Consider joining our Log on to Learn service and access the on-demand version of this event anytime you want!

Product(s): Microsoft Outlook
Audience(s): Business Professional
Duration: 60 Minutes
Start Date: March 28th, 2012
Start Time: 1:00 PM EDT (US)
Register Online for just $59. (a $99.00 Value!)
Every Paid Registration Receives a $25 Visa Card!

Event Overview: Whether you still rely on some form of paper calendar to get you through the day or you just need a better way to keep track of your appointments, have we got a webinar for you. From the ancient Chinese to the Aztecs to the Romans, a time-keeping mechanism like a calendar has always been an essential part of life. Now, in the 21st century, a trusty calendar is more important than ever. Outlook’s powerful yet user-friendly Calendar and Tasks list is the answer to staying organized. This personal information manager can do much more than just e-mail.

In this 60 minute webinar we will focus on calendar and tasks shortcuts and tips to make your day run more smoothly.
• Utilizing Tasks to keep you on track
• How to set up meetings with Outlook: Never be late!
• Ways of sharing your calendar
• Creating multiple calendars
• Multi-tasking musts: Coordinate multiple calendars and multiple time zones
• Keeping some of your calendar items private
• Color-coding and customizing calendar views
• Click and Drag techniques to take back hours of your day
• Improve the productivity of your teams – Using technology to take control •

And much more……

Watch a short trailer for this great event:

KnowledgeWave has added a few new classes to our schedule. We expect these to be popular courses so we are providing advance notice. Register early to secure your seat as these classes are available nationally. All of these new courses are running Live at KnowledgeWave in South Burlington, Vermont. You can attend at our South Burlington facility or remotely or from your home or office.

First up is a new course for the Excel 2010: Power User. You will use the advanced features of Microsoft Excel 2010 to attain proficiency as an Excel power user. This course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis including the fields of micro- and macro-economics.

Microsoft Excel 2010: Power User
Scheduled: Tuesday May 15th, 2012
Complete Outline: http://bit.ly/ynkCdt
Register: http://bit.ly/yKrXEQ

Massive data has met its match! Our second new class is Excel 2010: PowerPivot. PowerPivot lets users manipulate large data sets, streamline data integration, and effortlessly share analysis, using familiar tools and features. Take Excel Business Intelligence (BI) to the next level.
You will make use of the free PowerPivot add-in to import data from various sources and create a dynamic report. This course is for students with a sound working knowledge of Microsoft Excel 2010 and general computing proficiency, including those who will be using Excel to make business decisions.

Microsoft Excel 2010: PowerPivot
Scheduled: Friday May 18th, 2012
Complete Outline: http://bit.ly/AcoGIh
Register: http://bit.ly/wkMjgq
Download PowerPivot Plugin: http://bit.ly/jIFE0v

Keep tabs on your life with our third new class, Microsoft OneNote 2010. OneNote is now available on your PC, Mobile Phone, Tablet or via Office 365. A great tool for staying organized; OneNote is a tool we should all use.

You will create, edit, organize, and enhance notes and also integrate them with other applications using Microsoft OneNote 2010. This course is designed for users who take notes and use automated tools to organize and manage the notes.

Microsoft OneNote 2010
Scheduled: Wednesday May 2nd, 2012
Complete Outline: http://bit.ly/AvQqXH
Register: http://bit.ly/wxHc0G
Watch a Sample of OneNote: http://bit.ly/xxxvXS

Remember as a student of KnowledgeWave you can add an individual subscription to Log on to Learn for only $19.99! That’s a $40.00 savings!!! Learn on the go, learn when you want to. Anytime, anywhere!

You can find just about anything on your PC almost instantly with Windows 7 Search

It’s easy. Start typing in the Start menu search box, and you’ll instantly see a list of files on your PC. You can search by typing the name of the file, or based on its tags, file type, and even contents. To see even more matches, click a category in the results, like Documents or Pictures, or click See more results. Your search terms are highlighted to make it easier to scan the list.

Few people store all their files in one place these days. So Windows 7 is also designed to search external hard drives, networked PCs, and libraries. Overwhelmed by your search results? You can instantly narrow them by date, file type, and other useful categories.

This video is one of many in our Excel 2010 Warriror Series.

There are times when the data you wish to manipulate is not in an Excel workbook. The Excel Warrior needs to have knowledge of how to import data from external locations. This includes importing from an Access database, from a Web site, from a text file, or from sources such as an SQL server or XML data file. Learn how to not only import the data, but also how to change the properties of the connection. The Excel Warrior also needs to know how to edit the links between Excel workbooks. Understanding the edit links dialog box will make that process a breeze!

View a list of our other Log on to Learn Content: http://logontolearn.com/videolibrary.php

Styles are hugely important in Microsoft Word. Styles allow for consistency in formatting, ease in changing the look and feel of your document and access to naviagation and reference tools.

To help make formatting simple, there are many levels of Heading styles you can use to make your document look better and, at the same time, take advantage of the many other benefits of styles. To quickly apply heading styles to text in a Word document you can use the Styles gallery in your Home tab or simply click Ctrl+Alt+1 for the Heading 1 style, Ctrl+Alt+2 for Heading 2 and Ctrl+Alt+3 for Heading 3.

KnowledgeWave has an openning for a Webmaster / Website Designer.

Essential Duties and Responsibilities
KnowledgeWave is a Certified Learning Partner with Microsoft who seeks a Web Developer to work closely with our team to enhance the usability and functionality of our current websites, as well as design and develop new web solutions as we continue to grow.

The Web Designer will need to be able to utilize and implement best practices in user interface of our web experience as well as have the aptitude to understand the technical underpinnings of the web. This position will also be responsible for the maintenance of our social networking websites and other on-line marketing.

Superb grasp of space, color, typography and imagery, and the coding skills to bring designs to completion is required.

• Excellent verbal and written communication skills
• Ability to cleanly separate design logic from semantic structure using CSS
• Ability to make designs cross-browser compatible using standards compliant markup
• Ability to translate designer mockups into working code
• Design web pages for current offers and weekly promotional emails
• Design and produce optimized, web-ready graphics
• Optimize pages by using clear, semantic markup

Qualifications
We move fast, that means you have to as well! The ability to work in a collaborative team environment is a must. Most importantly, you need to be able to conceive and deliver clean, simple and well modularized code.

Education and Work Experience
• Applicant should be currently enrolled or have graduated from a two or four year college program, focusing on web development or web design.
• Excellent verbal and written communication skills
• Expert with CSS, HTML, and Adobe Creative Suite
• PHP and MySQL experience required
• Basic knowledge of relational databases
• Competency in Microsoft Office applications
• Experience with Flash is desirable
• JavaScript skills and experience helpful
• SEO experience helpful
• Extraordinary attention to detail

To Apply
Send your cover letter and résumé along with links to sample work or portfolio to: dsthilaire@knowledgewave.com

http://www.knowledgewave.com/opportunities_wm_02132012.php

We exist in a changing world. Software is updated frequently and companies have become more cautious about how and when they upgrade.  Because of this, we understand that you may have Office 365, the newest Office technology, or you could still be rocking Office 2003.  Whatever the case, we feel it’s important to meet you on your terms.  That’s why KnowledgeWave classrooms are run off Virtual PC setups.  This allows us to teach any version of Microsoft Office; 2003, 2007, 2010 or Office 365.

While KnowledgeWave’s scheduled classes are taught in the Office 2007/2010
environment, it is possible for us to teach in Office 2003 with ease. Furthermore, because we have multiple versions loaded on our machines, we can demonstrate the amazing benefits of upgrading to the newest version of Microsoft Office. It is our mission to always provide corporate clients with training in any version of Microsoft Office. Want to try Office 2010? Microsoft Office offers a 60 day free trial: http://office.microsoft.com/en-us/try/.

Video Tip: Autoformat command is one you may have remembered from using previous versions of Microsoft Word.  This time saver tool helps the user quickly format documents or emails making them easier to read. In this session we will show you how to locate and add the Autoformat command to the Quick Access Toolbar.

We are offering some solid webinars for February.  Our Microsoft Excel session will uncover some great features in Excel and is well worth your time.  Furthermore, Log On to Learn members will be able to access the event on our member site after the event runs.  Check it out, come join us and Happy Leap Year.

Event Overview:

Microsoft Excel is a powerful tool that can be used for a variety of functions. In this session we’re going to focus on using Excel as a tool for managing data. By sorting and filtering our data we can begin to dissect data and get useful information. We’ll also look at subtotals, sparklines and a bit of PivotTables. If you have raw data in Excel, let us show you how to get it to speak to you in a usable way.

Date: Thursday, February 16, 2012
Time: 3:00 PM EST (US)
Price:$99$0* (US) No fee register below!

*Use Code: FEB12 at checkout to attend for zero fee.