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
Microsoft Excel is a wellspring of useful features for so many different purposes. That’s why this month we’re having an Excel-ent lunch with our Lunch Bites series. Two of this month’s topics will focus on varying aspects of Excel. The first will look at Excel charts while the second will look at headers, footers and printing options. Let’s be honest, we’ve all been flustered by the printing appearance of our spreadsheets in Excel.
These free sessions are just 15 minutes of your time, but will reward you with great time-saving tips and tricks that will save you hours. Come for one, sign up for both, it’s up to you. Just don’t miss them!
Excel- Exploring Charts Charts are a great way to display numerical data in a graphical way. Excel has many tools for creating charts of all kinds. This session will look at how to select the right data to create a chart that tells your story and uncover some of the tips and tricks to building eye-popping charts. We’ll also look at some of quick, easy formatting techniques to really make your chart stand out.
May 23, 2012, 2 PM
Duration: 15 minutes
Cost: FREE Register Here
Excel- Headers, Footers and Printing Options Once our data and formulas are in our spreadsheets, our work is still not complete. Just about everyone who’s worked in Excel has hit the print button only to realize their spreadsheet doesn’t look how they thought. Excel has tools for getting the results you want, but they’re spread out and, sometimes, not easy to find. In this tutorial we’ll look at how to add headers and footers to your spreadsheet as well as how to manipulate print settings to get the look you need when the paper rolls out of the printer.
May 23, 2012, 2 PM
Duration: 15 minutes
Cost: FREE Register Here
For the past few years we’ve brought quality training to your desktop through 30 minute and 60 minute webinars. Every month we offer free sessions on topics of interest to most users. Well, we’re going to keep on doing that. However, we’re mixing up the format to meet the needs of our customers, wherever they are.
In the past we’d do one, maybe two free webinars per month. Now, we’re going to bring you four topics, although, we’re hanging up the format to meet your busy schedule. This spring we are proud to announce, Lunch Bites. One day each month we will offer four separate 15 minute webinars. Each one will either tackle a specific function of a commonly used application or provide an overview of an application you may have but don’t use to its full potential. This month’s Lunch Bite sessions are April 17th.
Our topics this month are:
Adobe Photoshop
Adobe Illustrator
Microsoft OneNote
Microsoft Office Web Apps
The first session will begin at noon eastern time. Each successive session will begin at noon for each of the remaining time zones in the continental United States.
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.
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.
At this point most of us know how to add an image to a Word document. However, that’s not enough to create a truly memorable report. In this session we’ll cover how to create Smartart graphics, create or import charts, import and manipulate photos and use wrap options to flow your text around various graphics. We’ll also look at advanced text formatting options to liven up your reports.
Date: Thursday, February 16, 2012 Time: 1:00 PM EST (US) Price:$99$0* (US) No fee register below
*Use Code: FEB12 at checkout to attend for zero fee.
TIP: Many features for dealing with imported graphics can be found on contextual tabs at the top of your screen. These tabs will be color coded based on element type and are only visible when the item is selected.
Product: Crystal Reports Duration: 60 Minutes Date: January 26, 2011 Time: 3:00 PM EST (US) Price: Free, with code NEWYEAR
Many database users are familiar with Microsoft Access or some other desktop application. These applications are great for entering data and building queries, but don’t always do a good job of generating reports. Crystal Reports exists solely for creating powerful reports from single or multiple data sources. In this session we’ll look at how Crystal Reports works and discuss some of the benefits to using a dedicated report writing application.
Product: Adobe Illustrator Duration: 60 Minutes Date: January 26, 2011 Time: 1:00 PM EST (US) Price: Free, with code NEWYEAR
Charts and graphics are great for displaying one concept or relationship.
However, infographics, while more complicated, allow you to display information
on several topics in the same graphic. In this session we’ll go through the
process of creating a visually striking diagram that tells a story. We’ll look
at shape manipulation, gradients, transparency, colors and much more.
Product: Microsoft Excel Duration: 60 Minutes Date: December 21, 2011Time: 1:00 PM EST (US) Price: Free, with code LOB10
Our 60 minute Excel Tips and Tricks Webinar will help you eliminate the anxiety
of data analysis and will help you harness the true power of Excel! In this
Webinar, you will uncover incredible data analysis tools that were created
specifically to help you achieve your information goals. Microsoft Excel can
help you sift through data to find the information you need, but the process can
be time-consuming and frustrating. Let us help you achieve your goals, don’t sit
and stare at row upon row of numbers; join us for 60 minutes and we will show
you how to zip through your tasks and turn data drudgery into data done. In this
session you will learn how to create custom AutoFill list, use Auto Calculate,
add pop-up instructions for correctly entering data in a cell, use the format
painter, create time saving macros, and much more!
After one hour with our expert, you’ll be able to:
• Create time-saving macros
• Customize your Excel environment to match what you do
and how you work.
• Organize a spreadsheet so that you can see the data you
need
• Format cell data so that it appears as it should.
• Generate shared spreadsheets that collect data consistently and correctly.
• Achieve amazing results for yourself and your organization!
Do you want to learn to craft thrilling presentations with Microsoft PowerPoint 2010? Learn the skills you need to know with this live webinar!
Product: Microsoft PowerPoint Duration: 60 Minutes Date: December 21, 2011Time: 3:00 PM EST (US) Price: Free, with code LOB10
Microsoft PowerPoint is an effective tool for creating Organization Charts for presentations or print. In addition PowerPoint offers several other templates for creating diagrams that measure workflow and mapping processes. In this workshop we show users how to create diagrams and charts in PowerPoint, edit those diagrams to custom specifications and use the auto format options to make the diagrams visually appealing. We also cover how to customize the look of the diagrams using the object formatting tools within PowerPoint.
