Often when working with a spreadsheet, it becomes nessesary to extract specific bits of information from a string of data (called a substring). This video highlights the LEFT, RIGHT and MID functions that make doing this a snap.
There are many ways to format text in Excel. The formatting text options allow you to put in dollar signs, add commas, remove decimals, or create custom number formatting parameters. The functions accomplish all this and convert your numbers to a text format.
KnowledgeWave is seeking a full or part-time desktop applications instructor with experience in Microsoft Office to enthusiastically share knowledge in training seminars to both corporate clients and individuals. The ideal candidate has a true passion for training and a desire to teach. He/she must have a strong understanding of technical concepts and be able to effectively communicate. Some travel is required.
KnowledgeWave Training located in South Burlington, has been providing computer training and consulting for over 30 years. Our experienced trainers are ready to help businesses reach their full potential. Our company deliver innovative computer training on multiple platforms including Microsoft, Adobe, CompTIA, Cisco and other state of the art web technologies.
Job Summary
We are expanding our training business and have position for contract instructors, part-time instructors and full-time instructors. We are looking for experienced instructors to teach computer applications and develop learning videos in our professional business to business environment in South Burlington, Vermont. In addition, we serve our clients throughout Vermont and New England on their site, a willingness for day travel is a must.
Essential Functions
• Conduct training sessions and develop criteria for evaluating effectiveness of training activities
• Continuously revise lesson plans to meet new training requirements and to keep technical information up to date
Requirement and Qualifications
• One to Three years experience in a skill-based training environment
• Experience in adult education with expertise in common software packages including: Microsoft Word, Excel, Access, PowerPoint.
• Strong knowledge of PC applications
• Experience working with end users in a support and/or training capacity
• Exceptional, proven presentation skills and a professional demeanor
If interested, please email your cover letter and resume to Careers@knowledgwave.com
We can’t always control the manner in which data is entered into a spreadsheet. The changing case function (LOWER, UPPER, PROPER) allows you to change the case of the text once it’s entered, so you can get the result you need.
This month’s lunch bite sessions include two events for Microsoft Excel and Two Events for Microsoft Outlook. They are being held on Wednesday, June 20, 2012. Simply click the register links and regiser online. All events are completly free!
Microsoft Excel: Get the Data You Want with Data Validation
Description: Often times we create perfect spreadsheets only to have them compromised by incorrect data entry. Data validation rules can guide users to put in the correct data type or even select values from a list of pre-entered responses
Date: June 20, 2012
Start Time: 12:00 PM EDT
Duration: 15 Minutes
Register Online by Clicking Here
Microsoft Excel: Protecting Your Work
Description: When it comes to data, protection can be very important. However, the protection options inside Excel can sometimes be confusing or misleading. In this session we’ll cover how to effectively protect your data so you can work in confidence.
Date: June 20, 2012
Start Time: 1:00 PM EDT
Duration: 15 Minutes
Register Online by Clicking Here
Microsoft Outlook: Tasks! Outlook’s Best Kept Secret
Description: Most of us use Outlook to manage our emails and our calendar, but far too few people take advantage of the Tasks function in Outlook. We’ll look at how to create and track tasks, how to assign tasks to others and how to view them throughout the Outlook environment. We’ll even show a few tricks along the way.
Date: June 20, 2012
Start Time: 2:00 PM EDT
Duration: 15 Minutes
Register Online by Clicking Here
Microsoft Outlook: Out of Office and Auto Signatures
Description: These nifty little tools of the Outlook world give us the ability to look professional and provide better communication with a minimum of effort. The updated Out of Office feature allows us to set multiple notifications for those in or outside the office and we can create several signatures for different uses.
Date: June 20, 2012
Start Time: 3:00 PM EDT
Duration: 15 Minutes
Register Online by Clicking Here
The repeat (REPT) function allows you to set a certain character or characters and have them repeated in a cell a specified number of times. It’s a great tool if you need to have a set number of characters in all cells.
When a part (or parts) of a data string need to be replaced with other data, the REPLACE function is you new best friend. Rather than re-enter all that data, Excel can do the work for you with this handy little gem from the function library.
