Did you know that we regularly update our free video content on Log on to Learn? In addition to no-fee live webinars we offer several on-demand videos that are completely free. We hope that you’ll find great value in our free offerings. This week’s update included content for Microsoft Excel 2010!
Exploring Excel can be a daunting task. It’s a flexible application that can do so many different things. If your intimidated looking for things in Excel, let us provide some tips. This week’s selection of videos will unlock some functions and features of Excel 2010. Our full Log On To Learn video library has a complete set of videos around all these features and much more.
Available Videos Include:
Excel 2010:
Data Analysis Revealed! Forecasting, Analyzing and Creating Informative Reports
Getting External Data from Access, The Web, Text and Other Sources
Calculate Specific Results Under Two Different Conditions with the IF Function
Wrapping Text
Did you know that KnowledgeWave and Log on to Learn provides database design, support and reporting services for Microsoft Access and SQL? We bring decades of database experience to the table and have helped 100’s of individuals and companies across North America meet their need for data capture and custom reporting.
Our instructors are consultants, they provide great on-demand video and interactive sessions via our Log on to Learn content library, but they can also provide on-site, or live online consulting services to help you with your database needs.
We’ve helped hundreds of clients turn their assortment of spreadsheets, external mailing lists and other documents into a streamlined, organized database. The result is more time to work on the things their businesses need from them and less time creating reports. Let us know how we can help you!
Call 1-800-831-8449 for more information on our database services.
Access the Start Menu Properties by right clicking on your Start menu.
In Windows 7 the default option for shutting down your machine is Shut Down. However, the fly out arrow to the right of Shut Down gives us other options. It’s here that we can put our machine to sleep, log off or switch users.
If your daily routine regularly requires an action other than shutting down, it’s possible to change the default action in your Start menu. For instance, you can make it so that the button executes the Log Off function and you must click the fly out arrow to access Shut Down and the others.
To change the default action simply:
Right click on the Start menu.
Select Properties.
Confirm that you are in the Start Menu tab.
From the Power button action drop down, select the option you desire.
Click OK.
Once you’re done, you can click on the start menu to confirm the change. It’s that simple. For other hidden gems of Windows 7, check out the Log On to Learn webinar Windows 7: Tips, Tricks and Techniques on March 28th. The $99 event is free with the promo code MADNESS. Register Here.
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.
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/.
Let Us Warm You Up This Winter with a Little Fire.
For a limited time Log On to Learn is offering some warm comfort along with a great price. Sign up now for Log On to Learn and get a free Kindle Fire delivered to your door*. How’s that for a hot deal? Log On to Learn, a premier online training tool is now offered at the great price of $59 a month. This fee for a single license gives users access to nearly 1,000 video tutorials, our written courseware, Tips and Tricks sheets and free admittance into our monthly live webinars. In fact, with such a good deal, maybe winter just got a bit cool. Did we mention that our videos play on the Kindle?
The Deal! Sign up for an individual Log On to Learn Membership and receive a Kindle Fire. A membership is only $59/month and gives you access to our entire video library.*
Call 1-800-831-8449 and request the Kindle promotion.
*Must be new memberships to Log On to Learn with upfront payment for the full year. The individual license allows any single person access to the full Log On to Learn library. Corporate pricing and promotions available contact us for details. Shipping to USA only. Offer valid through Feburary 29th, 2012.
Date(s): December 12–16, 2011 Duration: 5 days Format: Live Instructor-led, Classroom training, Attend Live or Remotely from your Location
KnowledgeWave is pleased to introduce MS2310 Developing Web Applications Using Microsoft Visual Studio 2008. This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio. This class is confirmed to run in-house at KnowledgeWave in South Burlington, Vermont.
Location: 30 Community Drive, Suite 5, South Burlington VT 05403 Remote Attend: Yes Contact us for information To Register: Click here or call 800.831.8449
Objectives:
Module 1: Exploring ASP.NET Web Applications in Microsoft Visual Studio 2008 SP1
Module 2: Creating Web Applications by Using Microsoft Visual Studio 2008 SP1 and Microsoft .NET–Based Languages
Module 3: Creating a Microsoft ASP.NET Web FormThis module explains how to create Web Forms and populate them with server controls.Lessons
Module 4: Adding Functionality to a Microsoft ASP.NET Web Form
Module 5: Implementing Master Pages and User Controls
Module 6: Validating User Input
Module 7: Debugging Microsoft ASP.NET Web Applications
Module 8: Managing Data in an ASP.NET 3.5 Web Application
Module 9: Managing Data Access Tasks by Using LINQ
Module 10: Managing Data by Using ASP.NET Dynamic Data
Module 11: Creating a Microsoft ASP.NET AJAX Application
Module 12: Consuming XML Web Services and Windows Communication Foundation Services
Module 13: Managing State in Web Applications
Module 14: Configuring and Deploying a Microsoft ASP.NET Web Application
Module 15: Securing a Microsoft ASP.NET Web ApplicationThis module explains the various Web application security functionalities.
Date(s): November 7th– November 11th, 2012 Duration: 5 days Format: Live Instructor-led, Classroom training, Attend Live or Remotely from your Location.
KnowledgeWave is pleased to introduce MS10174 Configuring and Administering Microsoft SharePoint 2010. This course teaches students how to install, configure and administer SharePoint, and also manage and monitor sites and users by using SharePoint 2010
Location: 30 Community Drive, Suite 5, South Burlington VT 05403 Remote Attend: Yes Contact us for information on how you can attend from your home or office. To Register: Click here or call 800.831.8449
Objectives:
Module 1: Introducing SharePoint 2010
Module 2: Creating a SharePoint 2010 Intranet
Module 3: Administering and Automating SharePoint
Module 4: Configuring Content Management
Module 5: Configuring Authentication
Module 6: Securing Content
Module 7: Managing SharePoint Customizations
Module 8: Configuring and Securing SharePoint Services and Applications
Module 9: User Profiles and Social Networking
Module 10: Administering and Configuring SharePoint Search
Module 11: Implementing Office Web Apps
Module 12: Installing and Upgrading to SharePoint 2010
Module 13: Implementing Business Continuity
Module 14: Monitoring and Optimizing SharePoint Performance
Date(s): January 9th–13th, 2012 Duration: 5 days Format: Live Instructor-led, Classroom training, Attend Live or Remotely from your Location
KnowledgeWave is pleased to introduce MS6419 Configuring, Managing and Maintaining Windows Server 2008 Servers. This five-day instructor-led course combines five days worth of instructor-led training content from the Network Infrastructure Technology Specialist, Active Directory Technology Specialist, and IT Professional Server Administrator courses of Windows Server 2008 to provide students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server 2008 environment. This course covers the core skills required by anyone working with Windows Server 2008 Servers.
Location: 30 Community Drive, Suite 5, South Burlington VT 05403 Remote Attend: Yes Contact us for information on how you can attend from your home or office. To Register: Click here or call 800.831.8449
Objectives:
Module 1: Introduction to Managing Microsoft Windows Server 2008 Environment
Module 2: Creating Active Directory Domain Services User and Computer Objects
Module 3: Creating Groups and Organizational Units
Module 4: Managing Access to Resources in Active Directory Domain Services
Module 5: Configuring Active Directory Objects and Trusts
Module 6: Creating and Configuring Group Policy
Module 7: Configuring User and Computer Environments Using Group Policy
Module 8: Implementing Security Using Group Policy
Module 9: Configuring Server Security Compliance
Module 10: Configuring and Managing Storage Technologies
Module 11: Configuring and Managing Distributed File System
Module 12: Configuring Network Access Protection
Module 13: Configuring Availability of Network Resources
Module 14: Monitoring and Maintaining Windows Server 2008 Servers
Module 15: Managing Windows Server 2008 Backup and Restore
You can now attend any level 2 or higher class, LIVE from your desk! Attend from your home or office!
In our ongoing support of green training solutions we bring you a remote option to attend our classes. Save travel time and help the environment by attending remotely. Classes are 100% LIVE and include interaction with our instructor. You are receiving the same instruction and content that you would in-house at our South Burlington, Vermont location. Online Live, Live from your desk!
Watch the short video below to learn more.
Contact KnowledgeWave for more information or to register for a class.
