This month we bring you a couple great events on September 27th.
Introduction to Excel PowerPivot
What is Excel PowerPivot? It’s a free add-on in Excel 2010 designed by Microsoft. It adds a lot of power to Excel by extending the capabilities of PivotTable and data summarization. Having the ability to import data from multiple sources has never been easier. Designed to add and integrate large amounts of data in Excel workbooks, this wonderful tool can create remarkably dynamic reports. If rumor has it correctly, you will see this feature built into the next version of Excel. Join us for this 30 minute introduction to this incredibly powerful (and free) tool.
Access 2010: Explore the Interface
Access 2010 features a user interface with significant changes from prior versions, especially versions prior to Access 2007. Two main components of the user interface are the ribbon and the Navigation Pane which were introduced in Access 2007. In this 15 minute “lunch bite” webinar, you will learn about several of the changes that have been made to the ribbon since the prior version, as well as a good overview of the third user interface component, the Office Backstage view.
Excel has great tools for creating beautiful charts, but what about a quick and easy trick for a simple graphical representation of your data? Here’s how the REPT function can be applied to whip up a quick and snappy looking chart.
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.
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.
The TRIM function is a great tool to help clean up your data. The function looks at your data and removes all excess spaces at the beginning, middle or end of your data.
Watch as our Excel expert takes you into the function library and reveals the usefulness of the IF function. Need specific results under two different conditions? Learn how to apply true or false statements to your formula and generate results baised on your criteria.
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
Fridays just feel like a day for rewards. It’s the end of the week, we’ve put in a good effort and we’re looking ahead to the weekend. Well, we’d like to give you something else on Fridays. That’s why we’re introducing, Function Fridays. Every Friday we’re going to post a new video tip on an Excel function… for free. These short tutorials get right at the heart of how to use the functions that can make your Excel life easier. Now, that sounds perfect for a Friday.
Our first tutorial is a quick tip on how to put the most recent revision date and time into a spreadsheet. Enjoy!
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.
